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!