Re: innodb update locks table...
Anda,
which MySQL version you are using and on which operating system?
You are using prepared statement. It could be this bug:
http://bugs.mysql.com/bug.php?id=15868
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 eng56.telenav.com 192.168.101.139 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,
Heikki
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
http://www.innodb.com/order.php