Full Innodb Table Locks deadlocking with AUTO_INC locks.

2007-10-02 Thread William Newton
Hello List, I discovered an unusual problem with the way Innodb handles the AUTO_INC lock with a full table lock. I was wondering if this is a known issue, or I'm doing something completely wrong. I'm working with MYSQL Server version: 5.0.42-debug-log on Gentoo Linux. So lets say I have

Re: Full Innodb Table Locks deadlocking with AUTO_INC locks.

2007-10-02 Thread Baron Schwartz
Hi William, William Newton wrote: Hello List, I discovered an unusual problem with the way Innodb handles the AUTO_INC lock with a full table lock. I was wondering if this is a known issue, or I'm doing something completely wrong. I'm working with MYSQL Server version: 5.0.42-debug-log on

Re: Full Innodb Table Locks deadlocking with AUTO_INC locks.

2007-10-02 Thread William Newton
From: Baron Schwartz [EMAIL PROTECTED] To: William Newton [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Tuesday, October 2, 2007 12:05:41 PM Subject: Re: Full Innodb Table Locks deadlocking with AUTO_INC locks. Hi William, William Newton wrote: Hello List, I discovered an unusual problem

Re: Full Innodb Table Locks deadlocking with AUTO_INC locks.

2007-10-02 Thread Baron Schwartz
From: Baron Schwartz [EMAIL PROTECTED] To: William Newton [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Tuesday, October 2, 2007 12:05:41 PM Subject: Re: Full Innodb Table Locks deadlocking with AUTO_INC locks. Hi William, William Newton wrote: Hello List, I discovered an unusual problem