Re: Question: How to fix TABLE LOCK table and lock mode AUTO-INC waiting ?

[Sunny Bains]

Mariella,


Mariella Petrini wrote:
> Hi,
> 
> 
> I have been using 5.0.32 MySQL on Debian.
> Everything worked properly.
> DRBD has been added and configure with MySQL and
> restarted.
> The tables used are InnoDB type and use
> auto_increment.
> 
> After that during INSERTs and UPDATEs innodb started
> to roll back
> for table lock on AUTO_INC

The behavior observed is most likely related to this bug report:

  http://bugs.mysql.com/bug.php?id=16979

Regards,
-sunny

Oracle/Innobase.