Innodb Message Lock wait timeout exceeded; Try restarting transaction

2004-09-13 Thread Tucker, Gabriel
Hello All V4.0.16 on Sun Sparc 5.8 Innodb_lock_wait_timeout = 50. A application using jboss got this error a few days ago. The SQL being used, AFAIK, was a simple delete from table where date = {date}. I am trying to determine why this happened. Searching back in the MySQL lists archives, I

RE: Innodb Message Lock wait timeout exceeded; Try restarting transaction

2004-09-13 Thread Dathan Vance Pattishall
General (E-mail) Subject: Innodb Message Lock wait timeout exceeded; Try restarting transaction Hello All V4.0.16 on Sun Sparc 5.8 Innodb_lock_wait_timeout = 50. A application using jboss got this error a few days ago. The SQL being used, AFAIK, was a simple delete from table where date

RE: Innodb Message Lock wait timeout exceeded; Try restarting transaction

2004-09-13 Thread Tucker, Gabriel
when it happened originally. -Original Message- From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 2:49 PM To: Tucker, Gabriel; 'Mysql General (E-mail)' Subject: RE: Innodb Message Lock wait timeout exceeded; Try restarting transaction Basically