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 joh...@pixelated.net
