3 messages in com.mysql.lists.javadeadlocks/Innodb tables
FromSent OnAttachments
Hollerman Geralyn M25 Aug 2004 12:33 
Mark Matthews25 Aug 2004 12:47 
Mark Matthews25 Aug 2004 14:25 
Subject:deadlocks/Innodb tables
From:Hollerman Geralyn M (gmh2@louisiana.edu)
Date:08/25/2004 12:33:31 PM
List:com.mysql.lists.java

I have a MySQL 4.0.17 system, using Connector/J 3.0.9 with a Java application. Under high load, I often get a message about a deadlock - "java.sql.SQLException: General error, message from server: "Lock wait timeout exceeded; Try restarting transaction" - usually, there are 2 of these lines, saying exactly the same thing, followed by a lengthy stack trace. I know where the problem is coming from, I'm working on fixing it, but in the meantime, is there any way to get rid of the stack trace, as in a parameter to add to the connection string or something like that? I can live with the mention of the error in the log, but right now, since we have a large # of people all trying to access the application at the same time, I get several deadlock errors all at once, filling up the logs, running me out of disk space, and it's happened that I missed something in the log simply because it was only one line and in between 2(of many) stack traces that all said the same thing!

Thanks!