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
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