I'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 View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3890090#3890090 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3890090 ------------------------------------------------------- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
