[jboss-user] [JBoss Messaging] - JBoss Messaging database backend deadlock

[boniek]

2007-08-31 17:14:40,393 WARN  [org.jboss.messaging.core.impl.JDBCPersistenceManager] SQLException caught, SQLState 40001 code:1213- assuming deadlock detected, try:1
  | com.mysql.jdbc.exceptions.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
  |         at com.mysql.jdbc.SQLError.createSQLException(Unknown Source)
  |         at com.mysql.jdbc.MysqlIO.checkErrorPacket(Unknown Source)
  |         at com.mysql.jdbc.MysqlIO.sendCommand(Unknown Source)
  |         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(Unknown Source)
  |         at com.mysql.jdbc.Connection.execSQL(Unknown Source)
  |         at com.mysql.jdbc.PreparedStatement.executeInternal(Unknown Source)
  |         at com.mysql.jdbc.PreparedStatement.executeUpdate(Unknown Source)
  |         at com.mysql.jdbc.PreparedStatement.executeUpdate(Unknown Source)
  |         at com.mysql.jdbc.PreparedStatement.executeUpdate(Unknown Source)
  |         at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:251)
  |         at org.jboss.messaging.core.impl.JDBCPersistenceManager$1HandleBeforeCommit2PCRunner.doTransaction(JDBCPersistenceManager.java:1464)
  |         at org.jboss.messaging.core.impl.JDBCPersistenceManager$JDBCTxRunner.execute(JDBCPersistenceManager.java:2418)
  |         at org.jboss.messaging.core.impl.JDBCPersistenceManager$JDBCTxRunner.executeWithRetry(JDBCPersistenceManager.java:2440)
  |         at org.jboss.messaging.core.impl.JDBCPersistenceManager.handleBeforeCommit2PC(JDBCPersistenceManager.java:1479)
  |         at org.jboss.messaging.core.impl.JDBCPersistenceManager$TransactionCallback.beforeCommit(JDBCPersistenceManager.java:2380)
  |         at org.jboss.messaging.core.impl.tx.Transaction.commit(Transaction.java:208)
  |         at org.jboss.jms.server.endpoint.ServerConnectionEndpoint.sendTransaction(ServerConnectionEndpoint.java:467)
  |         at org.jboss.jms.server.endpoint.advised.ConnectionAdvised.org$jboss$jms$server$endpoint$advised$ConnectionAdvised$sendTransaction$aop(ConnectionAdvised.java:101)
  |         at org.jboss.jms.server.endpoint.advised.ConnectionAdvised$sendTransaction_N3268650789275322226.invokeNext(ConnectionAdvised$sendTransaction_N3268650789275322226.java)
  |         at org.jboss.jms.server.container.SecurityAspect.handleSendTransaction(SecurityAspect.java:195)
  |         at sun.reflect.GeneratedMethodAccessor850.invoke(Unknown Source)
  |         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  |         at java.lang.reflect.Method.invoke(Method.java:597)
  |         at org.jboss.aop.advice.PerInstanceAdvice.invoke(PerInstanceAdvice.java:121)
  |         at org.jboss.jms.server.endpoint.advised.ConnectionAdvised$sendTransaction_N3268650789275322226.invokeNext(ConnectionAdvised$sendTransaction_N3268650789275322226.java)
  |         at org.jboss.jms.server.container.ServerLogInterceptor.invoke(ServerLogInterceptor.java:105)
  |         at org.jboss.jms.server.endpoint.advised.ConnectionAdvised$sendTransaction_N3268650789275322226.invokeNext(ConnectionAdvised$sendTransaction_N3268650789275322226.java)
  |         at org.jboss.jms.server.endpoint.advised.ConnectionAdvised.sendTransaction(ConnectionAdvised.java)
  |         at org.jboss.jms.wireformat.ConnectionSendTransactionRequest.serverInvoke(ConnectionSendTransactionRequest.java:82)
  |         at org.jboss.jms.server.remoting.JMSServerInvocationHandler.invoke(JMSServerInvocationHandler.java:144)
  |         at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:734)
  |         at org.jboss.remoting.transport.local.LocalClientInvoker.invoke(LocalClientInvoker.java:101)
  |         at org.jboss.remoting.Client.invoke(Client.java:1550)
  |         at org.jboss.remoting.Client.invoke(Client.java:530)
  |         at org.jboss.remoting.Client.invoke(Client.java:518)
  |         at org.jboss.jms.client.delegate.DelegateSupport.doInvoke(DelegateSupport.java:186)
  |         at org.jboss.jms.client.delegate.DelegateSupport.doInvoke(DelegateSupport.java:157)
  |         at org.jboss.jms.client.delegate.ClientConnectionDelegate.org$jboss$jms$client$delegate$ClientConnectionDelegate$sendTransaction$aop(ClientConnectionDelegate.java:221)
  |         at org.jboss.jms.client.delegate.ClientConnectionDelegate$sendTransaction_N3268650789275322226.invokeNext(ClientConnectionDelegate$sendTransaction_N3268650789275322226.java)
  |         at org.jboss.jms.client.container.FailoverValveInterceptor.invoke(FailoverValveInterceptor.java:91)
  |         at org.jboss.aop.advice.PerInstanceInterceptor.invoke(PerInstanceInterceptor.java:105)
  |         at org.jboss.jms.client.delegate.ClientConnectionDelegate$sendTransaction_N3268650789275322226.invokeNext(ClientConnectionDelegate$sendTransaction_N3268650789275322226.java)
  |         at org.jboss.jms.client.container.ClosedInterceptor.invoke(ClosedInterceptor.java:170)
  |         at org.jboss.aop.advice.PerInstanceInterceptor.invoke(PerInstanceInterceptor.java:105)
  |         at org.jboss.jms.client.delegate.ClientConnectionDelegate$sendTransaction_N3268650789275322226.invokeNext(ClientConnectionDelegate$sendTransaction_N3268650789275322226.java)
  |         at org.jboss.jms.client.delegate.ClientConnectionDelegate.sendTransaction(ClientConnectionDelegate.java)
  |         at org.jboss.jms.tx.ResourceManager.sendTransactionXA(ResourceManager.java:637)
  |         at org.jboss.jms.tx.ResourceManager.commit(ResourceManager.java:393)
  |         at org.jboss.jms.tx.MessagingXAResource.commit(MessagingXAResource.java:238)
  |         at com.arjuna.ats.internal.jta.resources.arjunacore.XAResourceRecord.topLevelCommit(XAResourceRecord.java:487)
  |         at com.arjuna.ats.arjuna.coordinator.BasicAction.doCommit(BasicAction.java:3107)
  |         at com.arjuna.ats.arjuna.coordinator.BasicAction.doCommit(BasicAction.java:3022)
  |         at com.arjuna.ats.arjuna.coordinator.BasicAction.phase2Commit(BasicAction.java:2126)
  |         at com.arjuna.ats.arjuna.coordinator.BasicAction.End(BasicAction.java:1819)
  |         at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:88)
  |         at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)
  |         at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1382)
  |         at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:135)
  |         at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:87)
  |         at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:351)
  |         at org.jboss.jms.client.container.ClientConsumer.callOnMessage(ClientConsumer.java:157)
  |         at org.jboss.jms.client.container.SessionAspect.handleRun(SessionAspect.java:801)
  |         at org.jboss.aop.advice.org.jboss.jms.client.container.SessionAspect14.invoke(SessionAspect14.java)
  |         at org.jboss.jms.client.delegate.ClientSessionDelegate$run_N8003352271541955702.invokeNext(ClientSessionDelegate$run_N8003352271541955702.java)
  |         at org.jboss.jms.client.container.ClosedInterceptor.invoke(ClosedInterceptor.java:170)
  |         at org.jboss.aop.advice.PerInstanceInterceptor.invoke(PerInstanceInterceptor.java:105)
  |         at org.jboss.jms.client.delegate.ClientSessionDelegate$run_N8003352271541955702.invokeNext(ClientSessionDelegate$run_N8003352271541955702.java)
  |         at org.jboss.jms.client.delegate.ClientSessionDelegate.run(ClientSessionDelegate.java)
  |         at org.jboss.jms.client.JBossSession.run(JBossSession.java:199)
  |         at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:194)
  |         at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:748)
  |         at java.lang.Thread.run(Thread.java:619)
  | 2007-08-31 17:14:40,437 WARN  [org.jboss.messaging.core.impl.JDBCPersistenceManager] Trying again after a pause
  | 2007-08-31 17:14:40,580 WARN  [org.jboss.messaging.core.impl.JDBCPersistenceManager] Update worked after retry

Surprising because the traffic to the database is small.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4080048#4080048

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4080048