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 that I was inserting into.
R. -----Original Message----- From: Heikki Tuuri [mailto:[EMAIL PROTECTED] Sent: Monday, February 20, 2006 1:18 PM 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 level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs 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 inserts (there also may be concurrent reads going on) are > intermittently causing: > > java.sql.SQLException: Lock wait timeout exceeded; try restarting > transaction=20 > > I noticed that adding innodb_table_locks=3D0 in my.ini fixes the = > problem. > Looking through the manual however, this should only be a problem when > I am using LOCK_TABLE, but there is no where in my code that I use this. > Do some queries implicitly add LOCK_TABLE? Is there a way to disable > innodb_table_locks when I create my database or in some JDBC property > so I don't require users to modify their my.ini files? > > FWIW, I'm guessing this is a bug; i.e. hat innodb_table_locks > controls=20 more than just the locking behavior of an explicit LOCK TABLE. > > R. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
