Autoincrement problem with mysql abrupt shutdown

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!


I'm facing a strange intermittent problem. I've my mySQL server running
& another process updating a table continuously. One of the field in
the table is Auto-Increment.

When my PC is abruptly shutwown(power trip), and next time when my PC
is started it fails to insert record in to the table saying that
"Duplicate record" for the auto-increment field.

This is an intermittent problem, but has occured quite a number of
times for me.
Have anyone come across this problem.Appreciate your inputs

Site Timeline