MySQL Forums
Forum List  »  InnoDB

Re: innodb update locks table...
Posted by: Heikki Tuuri
Date: February 27, 2006 05:45AM


which MySQL version you are using and on which operating system?

You are using prepared statement. It could be this bug:

The threads are 'declared inside InnoDB', but really they have already exited InnoDB, and the MySQL state for them is 'end':

---TRANSACTION 0 16906511, ACTIVE 157674 sec, process no 19752, OS thread id 12397488, thread declared inside InnoDB 500
mysql tables in use 1, locked 1
2 lock struct(s), heap size 320
MySQL thread id 78, query id 31856311 rts_user end
update tn_data_repository set object_data = '??\0t\0@testing...ABCDEFGHIGKLMNOPQRSTUVWXYZ--ABCDEFGHIGKLMNOPQRSTUVWXYZ' where min = '1010'

Can you do the same test without prepared statements? If it does not hang then, we could be fairly sure the problem is in prepared statements, and I could assign the bug to Konstantin.

Best regards,

Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL

InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables

Options: ReplyQuote

Written By
February 26, 2006 04:23PM
Re: innodb update locks table...
February 27, 2006 05:45AM
February 27, 2006 01:58PM
February 28, 2006 04:41PM
February 28, 2006 05:57PM
February 28, 2006 06:28PM
March 01, 2006 08:26AM
March 10, 2006 04:41PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.