MySQL 5.7 InnoDB AUTO_INCREMENT Counters Get Reset After MySQL Service Restart

added by JavaScript Kicks
8/26/2018 6:40:24 AM

298 Views

The other day, while writing some "archiving" logic in a data-driven ColdFusion application, I started getting errors that I didn't quite understand. As I was moving records from an "active" table to an "archive" table, the database started throwing "Duplicate entry for key 'PRIMARY'" constraint violations.


0 comments