MySQL Forums
Forum List  »  InnoDB

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

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

Options: ReplyQuote


Subject
Views
Written By
Posted
6107
February 26, 2006 04:23PM
Re: innodb update locks table...
3346
February 27, 2006 05:45AM
2732
February 27, 2006 01:58PM
2858
February 28, 2006 04:41PM
2644
February 28, 2006 05:57PM
2564
February 28, 2006 06:28PM
2436
March 01, 2006 08:26AM
5150
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.