[jboss-user] [JBoss Messaging] - Help on MessagingXAException

[busawreck]

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