RE: Intermittent deadlock/InnoDB

2006-05-11 Thread Robert DiFalco
EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: Intermittent deadlock/InnoDB On Wed, 2006-05-10 at 16:26 -0700, Robert DiFalco wrote: > Version 5.0.19. > > We have no autogenerate keys. We perform a single insert and get a > lock timeout. The insert is done with a stored procedure w

Re: Intermittent deadlock/InnoDB

2006-05-10 Thread Stewart Smith
On Wed, 2006-05-10 at 16:26 -0700, Robert DiFalco wrote: > Version 5.0.19. > > We have no autogenerate keys. We perform a single insert and get a lock > timeout. The insert is done with a stored procedure with a single line. > The lockup happens VERY rarely and we have no idea how to reproduce it.

Intermittent deadlock/InnoDB

2006-05-10 Thread Robert DiFalco
Version 5.0.19. We have no autogenerate keys. We perform a single insert and get a lock timeout. The insert is done with a stored procedure with a single line. The lockup happens VERY rarely and we have no idea how to reproduce it. Here's the hostname.err data: Alarm status: Active alarms: