Re: Corrupted auto_increment?

2005-01-31 Thread Gleb Paharenko
Hello. Not enough information to make a conlusion. For example this can be a bug: http://bugs.mysql.com/bug.php?id=6784 Which is fixed in 4.1.8. Send us information about exact version of MySQL that you use, an output of SHOW CREATE TABLE on your tables, a config file, a version of

Corrupted auto_increment?

2005-01-30 Thread Jim McAtee
A server running MySQL 3.23 crashed yesterday. Since bringing it back online, doing inserts into a particular table will throw an error regarding a duplicate key value in an auto_increment field. I assume that something is corrupted. There are 779239 records, the most recently added having