I'm sure this exception I'm getting is related to my db configuration.
But I don't have a clue where to start. I'm running MySQL. Can someone
explain what this error is really telling me? What is happening with
MySQL, and what parameter(s) do I need to look at and possibly tweak on
MySQL to prevent these problems in the future? The CPU is nowhere near
capacity. So I don't believe this is simply a load problem.
javax.mail.MessagingException: Exception caught while storing mail
Container: ;
nested exception is:
java.sql.SQLException: Lock wait timeout exceeded; try
restarting transaction
at
org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepository.java:764)
at
org.apache.james.transport.mailets.ToMultiRepository.storeMail(ToMultiRepository.java:230)
at
org.apache.james.transport.mailets.ToMultiRepository.service(ToMultiRepository.java:154)
at
org.apache.james.transport.mailets.LocalDelivery.service(LocalDelivery.java:66)
at
org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:424)
at
org.apache.james.transport.JamesSpoolManager.process(JamesSpoolManager.java:405)
at
org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:309)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try
restarting transaction
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
at
com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:874)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at
org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepository.java:752)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
