I'm using Jboss Messaging 1.0.1.GA, and I'm running a test-setup where I send 3
concurrant messages every 10 seconds over a XAConnection. I'm using persistent
messages and ms sql 2005 as a persistent store. After about 12 hours i get the
following error once, and I don't have a clue how to investigate it, any help
appreciated. The message causing the exception is lost.
Stacktrace:
04:15:05,968 ERROR [org.jboss.jms.server.endpoint.ServerConnectionEndpoint]
Exception occured
com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 58)
was deadlocked on lock resources with another process and has been chosen as
the deadlock victim. Rerun the transaction.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown
Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown
Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(Unknown
Source)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:251)
at
org.jboss.messaging.core.plugin.JDBCPersistenceManager.commitPreparedTransaction(JDBCPersistenceManager.java:3895)
...
04:15:06,031 ERROR [org.jboss.jms.util.ExceptionUtil]
ConnectionEndpoint[-2147483549] sendTransaction
[5c4o05-vxggw-euvg861g-1-euw0ugfj-7b]
org.jboss.jms.util.MessagingJMSException: Failed to commit transaction
at
org.jboss.jms.server.endpoint.ServerConnectionEndpoint.sendTransaction(ServerConnectionEndpoint.java:422)
at
org.jboss.jms.server.endpoint.advised.ConnectionAdvised.org$jboss$jms$server$endpoint$advised$ConnectionAdvised$sendTransaction$aop(ConnectionAdvised.java:104)
at sun.reflect.GeneratedMethodAccessor84.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
...
04:15:06,046 ERROR [org.jboss.jms.client.container.ExceptionInterceptor] Linked
exception is:
com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 58)
was deadlocked on lock resources with another process and has been chosen as
the deadlock victim. Rerun the transaction.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown
Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown
Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(Unknown
Source)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:251)
...
04:15:06,062 WARN [org.jboss.tm.TransactionImpl] XAException:
tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=Manga-L/253607, BranchQual=,
localId=253607] errorCode=XAER_RMERR
org.jboss.jms.util.MessagingXAException: A Throwable was caught in sending the
transaction
at
org.jboss.jms.tx.ResourceManager.sendTransactionXA(ResourceManager.java:486)
at org.jboss.jms.tx.ResourceManager.commit(ResourceManager.java:226)
at
org.jboss.jms.tx.MessagingXAResource.commit(MessagingXAResource.java:116)
at
org.jboss.tm.TransactionImpl$Resource.commit(TransactionImpl.java:2253)
at
org.jboss.tm.TransactionImpl.commitResources(TransactionImpl.java:1784)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:358)
at org.jboss.tm.TxManager.commit(TxManager.java:240)
at org.jboss.aspects.tx.TxPolicy.endTransaction(TxPolicy.java:175)
...
Caused by: org.jboss.jms.util.MessagingJMSException: Failed to commit
transaction
at
org.jboss.jms.server.endpoint.ServerConnectionEndpoint.sendTransaction(ServerConnectionEndpoint.java:422)
at
org.jboss.jms.server.endpoint.advised.ConnectionAdvised.org$jboss$jms$server$endpoint$advised$ConnectionAdvised$sendTransaction$aop(ConnectionAdvised.java:104)
at sun.reflect.GeneratedMethodAccessor84.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3988375#3988375
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3988375
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
