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
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
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.
|• Lock wait timeout||Johnny Withers||15 Jun|