Concurrent inserts (there also may be concurrent reads going on) are
intermittently causing:
java.sql.SQLException: Lock wait timeout exceeded; try
restarting transaction
I noticed that adding innodb_table_locks=0 in my.ini fixes the problem.
Looking through the manual however, this
up MyISAM
tables
http://www.innodb.com/order.php
- Original Message -
From: Robert DiFalco [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, February 20, 2006 8:00 PM
Subject: Lock wait timeout exceeded during concurrent inserts on an InnoDB
table
Concurrent
To: mysql@lists.mysql.com
Subject: Re: Lock wait timeout exceeded during concurrent inserts on an
InnoDB table
Robert,
please post SHOW INNODB STATUS\G during such lock wait, so that we see
what lock it is waiting for.
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row
: mailing.database.myodbc
Sent: Monday, February 20, 2006 11:20 PM
Subject: RE: Lock wait timeout exceeded during concurrent inserts on an
InnoDB table
Ok, I will do that during my next test run. But in the meantime, when I
did it previously, it was oddly enough waiting for a table lock on the
table
Roberts
How many concurreent inserts you've done?
What MySQL version you use?
Concurrent inserts (there also may be concurrent reads going on) are
intermittently causing:
java.sql.SQLException: Lock wait timeout exceeded; try
restarting transaction
I noticed that adding
: Lock wait timeout exceeded during concurrent inserts on an
InnoDB table
Roberts
How many concurreent inserts you've done?
What MySQL version you use?
Concurrent inserts (there also may be concurrent reads going on) are
intermittently causing:
java.sql.SQLException: Lock wait
: Monday, February 20, 2006 8:36 PM
To: Robert DiFalco
Cc: mysql@lists.mysql.com
Subject: Re: Lock wait timeout exceeded during concurrent inserts on an
InnoDB table
Roberts
How many concurreent inserts you've done?
What MySQL version you use?
Concurrent inserts (there also may