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]