Here is what we found: # 2010-11-18T16:47:51 Message: InnoDB: Error: unlock row could not find a 2 mode lock on the record detected after executing query SELECT ( SELECT `col_int_key` FROM `bb` WHERE `pk` = 238 ) FROM `cc` AS X WHERE X . `col_enum_key` < 'l' LIMIT 6 LOCK IN SHARE MODE /*Generated by THREAD_ID 2*/
Now, this is in a concurrent testing scenario, but the randgen output doesn't indicate that anything else was working on those tables during this time. Also there was no indication that the query failed for any reason, but this error message cropped up in the log. Bug? Seems off to me - logged error message on a 'successful' query, but I'm not the expert on this. The other message turned out to be tied to a DML query that was operating on a moderately complicated table with a complex (all columns) ORDER BY and a WHERE that had an invalid enum value - char_enum > 42. I wrote up a bug on that one - https://bugs.launchpad.net/drizzle/+bug/676770 Thanks, Patrick On Sun, Nov 14, 2010 at 8:36 PM, Stewart Smith <[email protected]>wrote: > On Fri, 12 Nov 2010 10:05:38 -0500, David Shrewsbury < > [email protected]> wrote: > > I'm trying to find a bug with the transaction log when run with > > several concurrent queries, and I noticed a lot of these errors > > from the server: > > > > > /mnt/disk2/shrews/Devel/repos/drizzle/bug673105/drizzled/.libs/lt-drizzled: > > Sort aborted > > > /mnt/disk2/shrews/Devel/repos/drizzle/bug673105/drizzled/.libs/lt-drizzled: > > Deadlock found when trying to get lock; try restarting transaction > > 101112 17:56:53 InnoDB: Error: unlock row could not find a 2 mode lock > on > > the record > > > > The deadlocks I would expect, but the InnoDB error about not finding > > a 2 mode lock looks suspicious. And it happens frequently. Is > > this a bug, or something to be expected from high concurrency? > > Not sure off the top of my head... we should probably investigate > > -- > Stewart Smith > > _______________________________________________ > Mailing list: > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> > Post to : [email protected] > Unsubscribe : > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
