Bug #20726 auto_increment flags disappear
Submitted: 27 Jun 2006 14:14 Modified: 27 Jun 2006 14:46
Reporter: Brecht Yperman Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.16 OS:Windows (Windows Server 2003 SP1)
Assigned to: CPU Architecture:Any

[27 Jun 2006 14:14] Brecht Yperman 
Description:
Every now and then, the auto_increment flags on all tables disappear, which is critical for our application. I have no idea how to repeat it, neither am I aware of any causes, ...

How to repeat:
Don't know

Suggested fix:
Don't know
[27 Jun 2006 14:17] Brecht Yperman 
Additionally, when trying to set back the auto_increment flag, the error: "Duplicate entry '1' for key 1" appears (1062).

This is due to an id '0' in the database, which came there after adding a row when the auto_increment was gone.

After replacing the 0 with an value larger than 0, the error disappeared.
[27 Jun 2006 14:46] MySQL Verification Team 
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.