List:General Discussion« Previous MessageNext Message »
From:Johnny Withers Date:June 15 2011 7:53pm
Subject:Lock wait timeout
View as plain text  
I'm getting a Lock wait timeout exceeded error and I'm not sure why. I've
been trying to read this SHOW ENGINE INNODB STATUS output, but I don't
understand what it's trying to tell me.

Can someone give me a hand here?

---TRANSACTION 1942A27B, ACTIVE 124 sec, process no 4849, OS thread id
1311476032 starting index read
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 376, 1 row lock(s)
MySQL thread id 992511, query id 903933959 192.168.100.41 ecash Updating
UPDATE trans_item SET is_void=1,void_bus_date='2011-06-15
00:00:00',void_actual_dt='2011-06-15
19:46:57',void_store_id=0,void_user_id=1,void_drawer_id=0,void_hdr_new_status_id=12
WHERE company_id=30 AND id=47077
Trx read view will not see trx with id >= 1942A27C, sees < 19428B97
------- TRX HAS BEEN WAITING 124 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 233406 page no 2296 n bits 136 index `PRIMARY` of
table `745cash_ecash`.`trans_item` trx id 1942A27B lock_mode X locks rec but
not gap waiting
Record lock, heap no 63 PHYSICAL RECORD: n_fields 45; compact format; info
bits 0

This is the very first statement in a series of statements, so i'm not quite
sure why it would fail. I could understand a later statement failing due to
this one having the table locked or something.

MySQL v5.5.9-log

-- 
-----------------------------
Johnny Withers
601.209.4985
johnny@stripped

Thread
Lock wait timeoutJohnny Withers15 Jun