Hi, we are using mysql 4.1.4-gamma and a few days ago we started to receive lock wait timeout messages from within our application also on other connections via tcp/ip ( from mysql clients ) the same thing happens
While we are trying to discover what is causing these errors I've noted this in the output of SHOW ENGINE INNODB STATUS this is the text: ---TRANSACTION 0 735105891, ACTIVE 1812 sec, process no 24059, OS thread id 1741492237 225 lock struct(s), heap size 27968, undo log entries 12427 Question #1. Can I identify the query that was running in that transaction? I Think it may not be inside the binary log as we had to stop the server and start it again . Question #2. What does the " 225 lock struct(s) " mean Thanks Mauricio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
