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

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.

-- 
MySQL Internals Mailing List
For list archives: 
http://lists.mysql.com/internals
To unsubscribe:    
http://lists.mysql.com/internals?unsub=lists@pantek.com