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

2004-09-13 Thread Tucker, Gabriel
cause 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 tran

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

2004-09-13 Thread Dathan Vance Pattishall
t; To: Mysql 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

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