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 operating system, a sql statement you use. Can you reproduce a problem on the latest release (4.1.9 now)? "Jim McAtee" <[EMAIL PROTECTED]> wrote: > 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 an auto_increment > ID field of 779239. When a new record is added, MySQL attempts to give it > an ID of 779240, but then throws the error that this ID is a duplicate. > > How to fix? > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
