…: — session 1 start transaction; select * from t1 where id=3 for update; — session 2 set innodb_lock_wait_timeout=1; alter table t1 engine=innodb; And the alter will timeout after approximately a second with the following error: ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
…Lock wait timeout exceeded; try restarting transaction transaction2 > INSERT INTO t VALUES(29); ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction transaction2 > INSERT INTO t VALUES(23); ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
…expect deadlock here – but not – just waiting… In 30 sec Session1: ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction So as we can see Solid does…test2 set names=’SolidDB’ where id=2; … waiting… in 30 sec: ERROR 1031 (HY000): Table storage engine for ‘test2′ doesn’t have…
Comment: InnoDB's gap locks
May 7, 2012 By 15 Comments
…): Lock wait timeout exceeded; try restarting transaction root@localhost:test 14:55:29>insert into t values(33); ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction Here I tried…inserting mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1216, 1 row lock(s) …
Comment: Pitfalls of converting to InnoDB
March 8, 2007 By 16 Comments
…and doing a basic insert into an InnoDB table. My database class starts a transaction with a “$mysqli->autocommit(false)”, then …time-out with a “1205 – Lock wait timeout exceeded; try restarting transaction“. The 1205 error won’t go away until I restart Apache. For whatever reason, the resources…
Comment: Pitfalls of converting to InnoDB
July 11, 2008 By 16 Comments
… Innodb and transactions where i would get a ‘[1205] Lock wait timeout exceeded; try restarting transaction‘. To resolve it I had to mysql dump the offending table, add an…
