Autoincrement problem with mysql abrupt shutdown

Autoincrement problem with mysql abrupt shutdown

am 29.11.2006 09:32:45 von vanisathish

Hi,

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