Locking issues with JMS
clebert.suconic Aug 15, 2005 6:16 PMI'm running Specj, and I'm having locking issues on JMS. I'm using MySQL as the database.
Caused by: org.jboss.mq.SpyJMSException: Could not remove message: 144 msg=6 hard STORED PERSISTENT queue=QUEUE.FulfillOrderQueue priority=4 lateClone=false hashCode=28033160; - nested throwable: (java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction) at org.jboss.mq.pm.jdbc2.PersistenceManager.remove(PersistenceManager.java:1136) at org.jboss.mq.server.BasicQueue.acknowledge(BasicQueue.java:564) at org.jboss.mq.server.JMSQueue.acknowledge(JMSQueue.java:156) at org.jboss.mq.server.ClientConsumer.acknowledge(ClientConsumer.java:328) at org.jboss.mq.server.JMSDestinationManager.acknowledge(JMSDestinationManager.java:519) at org.jboss.mq.server.JMSDestinationManager.transact(JMSDestinationManager.java:464) ... 19 more Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531) at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1366) at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:952) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1974) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1897) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1758) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:227) at org.jboss.mq.pm.jdbc2.PersistenceManager.remove(PersistenceManager.java:1124) ... 24 more
I'm looking for two possibilities now:
I - If this is a know issue
II - I'm looking also for some possible misconfiguration on MySQL
Anyone here know if there is any know issue on locking issues on JMS and MySQL?
I'm using READ_COMMITED as the option for my datasource. I'm also using JBOSS-4.0.3-rc2 and I have applied the changes from http://jira.jboss.org/jira/browse/JBAS-1842 just in case.
Clebert