XAException: tx=TransactionImpl:XidImpl [FormatId=257, Globa
sheckler Feb 24, 2005 7:33 AMWhen running high volumes of messages using JBossMQ and JDBC2 (Oracle oci 9.2.0.5, JBoss 3.2.7) persistence the following warning appears. What does it mean? The problem does not occur until the application has been running for an extended period of time. JBoss might slow down and even stop processing.
2005-02-23 17:05:08,063 10050427 WARN [org.jboss.tm.TransactionImpl] (JMS SessionPool Worker-8:) XAException: tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=rwco_as3//26429, BranchQual=] errorCode=XAER_RMERR
org.jboss.mq.SpyXAException: - nested throwable: (org.jboss.mq.SpyTransactionRolledBackException: Transaction was rolled back.; - nested throwable: (org.jboss.mq.SpyJMSException: Could not mark the message as deleted in the database: update affected 0 rows))
at org.jboss.mq.SpyXAResource.commit(SpyXAResource.java:88)
at org.jboss.tm.TransactionImpl.commitResources(TransactionImpl.java:1656)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:375)
at org.jboss.tm.TxManager.commit(TxManager.java:142)
at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:361)
at org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMessageConsumer.java:904)
at org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:159)
at org.jboss.mq.SpySession.run(SpySession.java:351)
at org.jboss.jms.asf.StdServerSession.run0(StdServerSession.java:200)
at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:180)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:748)
at java.lang.Thread.run(Thread.java:534)
Caused by: org.jboss.mq.SpyTransactionRolledBackException: Transaction was rolled back.; - nested throwable: (org.jboss.mq.SpyJMSException: Could not mark the message as deleted in the database: update affected 0 rows)
at org.jboss.mq.server.JMSDestinationManager.transact(JMSDestinationManager.java:459)
at org.jboss.mq.server.JMSServerInterceptorSupport.transact(JMSServerInterceptorSupport.java:186)
at org.jboss.mq.security.ServerSecurityInterceptor.transact(ServerSecurityInterceptor.java:182)
at org.jboss.mq.server.TracingInterceptor.transact(TracingInterceptor.java:438)
at org.jboss.mq.server.JMSServerInvoker.transact(JMSServerInvoker.java:186)
at org.jboss.mq.il.jvm.JVMServerIL.transact(JVMServerIL.java:327)
at org.jboss.mq.Connection.send(Connection.java:1213)
at org.jboss.mq.SpyXAResourceManager.commit(SpyXAResourceManager.java:150)
at org.jboss.mq.SpyXAResource.commit(SpyXAResource.java:84)
... 11 more
Caused by: org.jboss.mq.SpyJMSException: Could not mark the message as deleted in the database: update affected 0 rows
at org.jboss.mq.pm.jdbc2.PersistenceManager.remove(PersistenceManager.java:1062)
at org.jboss.mq.server.BasicQueue.acknowledge(BasicQueue.java:536)
at org.jboss.mq.server.JMSQueue.acknowledge(JMSQueue.java:123)
at org.jboss.mq.server.ClientConsumer.acknowledge(ClientConsumer.java:328)
at org.jboss.mq.server.JMSDestinationManager.acknowledge(JMSDestinationManager.java:536)
at org.jboss.mq.server.JMSDestinationManager.transact(JMSDestinationManager.java:448)
... 19 more
2005-02-23 17:05:08,070 10050434 WARN [org.jboss.tm.TransactionImpl] (JMS SessionPool Worker-8:) XAException: tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=rwco_as3//26429, BranchQual=] errorCode=XAER_NOTA
javax.transaction.xa.XAException
at org.jboss.mq.SpyXAResourceManager.rollback(SpyXAResourceManager.java:230)
at org.jboss.mq.SpyXAResource.rollback(SpyXAResource.java:154)
at org.jboss.tm.TransactionImpl.rollbackResources(TransactionImpl.java:1732)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:405)
at org.jboss.tm.TxManager.commit(TxManager.java:142)
at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:361)
at org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMessa2stefan.txtgeConsumer.java:904)
at org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:159)
at org.jboss.mq.SpySession.run(SpySession.java:351)
at org.jboss.jms.asf.StdServerSession.run0(StdServerSession.java:200)
at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:180)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:748)
at java.lang.Thread.run(Thread.java:534)
2005-02-23 17:05:08,084 10050448 WARN [org.jboss.tm.TransactionImpl] (JMS SessionPool Worker-8:) Lock contention, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=rwco_as3//26429, BranchQual=]
Oracle data source:
<datasources>
<local-tx-datasource>
<jndi-name>OracleJMSDS</jndi-name>
<connection-url>jdbc:oracle:oci8:@mmi_cmd</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<security-domain>OracleDbRealm</security-domain>
<check-valid-connection-sql>select table_name from all_tables where owner = 'RWCO_HAJMS'</check-valid-connection-sql>
<new-connection-sql>select table_name from all_tables where owner = 'RWCO_HAJMS'</new-connection-sql>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<track-statements>nowarn</track-statements>
<set-tx-query-timeout>false</set-tx-query-timeout>
<!--pooling parameters-->
<min-pool-size>1</min-pool-size>
<max-pool-size>10</max-pool-size>
<blocking-timeout-millis>30000</blocking-timeout-millis>
<idle-timeout-minutes>10</idle-timeout-minutes>
</local-tx-datasource>
</datasources>
Any hint appreciated
Thanks
Stefan