DVP - Thanks... I created a cron job to run show innodb status every minute and dump it to a file. In additional I turned on innodb_lock_monitor. Hopefully, if this happens again, I will have a snapshot of the situation.
It's still a bit frustrating not being able to see what was the 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 transaction" Basically the application can get this message because another process has a lock on the rows that the delete needs to cover for a time period then your lock_wait_timeout. Is there some cron process? Is the table index properly? What your average query transaction? Active your slow query log to see what queries are taking a long time to execute and are covering many rows-look for table scans. DVP ---- Dathan Vance Pattishall http://www.friendster.com > -----Original Message----- > From: Tucker, Gabriel [mailto:[EMAIL PROTECTED] > Sent: Monday, September 13, 2004 9:35 AM > 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 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 was unable to find anything that I thought could help. > > Any ideas of troubleshooting this problem would be appreciated. > > Thanks - Gabe > > > <><><><><><><><><><><><><><><><><><><><><> > "There are no problems, only solutions." > > Gabe Tucker > Bloomberg LP > (609) 750 6668 - P > (646) 268 5681 - F > > <><><><><><><><><><><><><><><><><><><><><> > > > -- > 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]
