When 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.
anonymous wrote : 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: anonymous wrote : | <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> | | | Any hint appreciated Thanks Stefan View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3867745#3867745 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3867745 ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
