…Rows matched: 1 Changed: 1 Warnings: 0 node1 mysql> SHOW ENGINE INNODB STATUS\G … ———— TRANSACTIONS ———— … —TRANSACTION 83B, ACTIVE 50 sec… happened: node1 mysql> commit; ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction node1 mysql> select *…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
…: mysql> begin; mysql> update test2 set names=’Solid’ where id=2; Session 1: mysql> update test2 set names=’solid1′ where id=2; ERROR 1213 (40001… be locked. With Innodb we would get “SolidDB2″ as result. mysql> update test2 set names=’SolidDB3′ where id=2; ERROR 1213 (40001): Deadlock found…
Post: Pitfalls of converting to InnoDB
February 25, 2007 By 16 Comments
… broken by new unexpected errors 1205 (ER_LOCK_WAIT_TIMEOUT) Lock wait timeout expired. Transaction was rolled back. 1213 (ER_LOCK_DEADLOCK… “alter table $t type=InnoDB” $DBNAME; done There is the standard script mysql_convert_table_format in the MySQL distribution, but it requires…
Post: READ-COMMITED vs REPETABLE-READ in tpcc-like load
February 11, 2010 By 6 Comments
… poping up again and again. Recently it was discussed in InnoDB : Any real performance improvement when using READ COMMITED isolation level… InnoDB . Serge in his post explains why READ COMMITED is better for TPCC load, so why don’t we take tpcc-mysql… case. However, however. For 10w run I got 60 Deadlock errors “1213, Deadlock found when trying to get lock; try restarting transaction…
Comment: Pitfalls of converting to InnoDB
March 8, 2007 By 16 Comments
…I’ve found. I’m using PHP 5.1.6, MySQL 5.0.24a default installs from Ubuntu 6.10, …PHP mysqli API and doing a basic insert into an InnoDB table. My database class starts a transaction with a “$…your code above has a loop on the 1205 (and 1213) error. In my case, each attempt take 50 seconds to time…
