Bridge Status inconsistent when JDBC Connections are recreat
rogerdudler Dec 5, 2007 5:27 AMWe are using JBoss Messaging 1.4.0.GA on JBoss 4.0.5 with all the prerequisites needed by JBoss Messaging. Everything works fine, except some issues on the messaging bridge, when the underlying database connections became invalid.
The source destination of the bridge is located on a remote messaging server (also JBoss Messaging 1.4.0.GA, but on JBoss 4.2.2.GA) and the destination exists locally.
If a JDBC connection becomes invalid (in the following example, during the messaging reaper is running) and the pool creates a new one and the reaper updates properly, but after this, it seems that the Messaging Bridge has an inconsistent state. JMX Console shows that bridge is "Started", but it does not consume the remote queue anymore. After invoking "stop" and "start" on the bridge (JMX Console), the bridge begins to work as expected.
Any ideas?
.... before, there are connections which are unavailable, while reaper is running... <->:<anonym>: 2007-12-05 09:23:33,937 [Timer-3] WARN jboss.messaging.core.impl.JDBCSupport - SQLException caught, SQLState null code:0- assuming deadlock detected, try:22 org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1035, SQLSTATE: 57019, SQLERRMC: null); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1035, SQLSTATE: 57019, SQLERRMC: null)) at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94) at org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner.execute(JDBCSupport.java:383) at org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner.executeWithRetry(JDBCSupport.java:407) at org.jboss.messaging.core.impl.JDBCPersistenceManager.reapUnreferencedMessages(JDBCPersistenceManager.java:2357) at org.jboss.messaging.core.impl.JDBCPersistenceManager.access$1000(JDBCPersistenceManager.java:78) at org.jboss.messaging.core.impl.JDBCPersistenceManager$Reaper.run(JDBCPersistenceManager.java:2381) at java.util.TimerThread.mainLoop(Timer.java:512) at java.util.TimerThread.run(Timer.java:462) Caused by: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1035, SQLSTATE: 57019, SQLERRMC: null) at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:179) at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:565) at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:250) at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:529) at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:341) at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:301) at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396) at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842) at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88) ... 7 more Caused by: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1035, SQLSTATE: 57019, SQLERRMC: null at com.ibm.db2.jcc.c.p.a(p.java:3493) at com.ibm.db2.jcc.b.hb.q(hb.java:709) at com.ibm.db2.jcc.b.hb.p(hb.java:583) at com.ibm.db2.jcc.b.hb.l(hb.java:408) at com.ibm.db2.jcc.b.hb.d(hb.java:147) at com.ibm.db2.jcc.b.b.cc(b.java:1418) at com.ibm.db2.jcc.b.b.a(b.java:1342) at com.ibm.db2.jcc.b.b.s(b.java:1040) at com.ibm.db2.jcc.b.b.b(b.java:746) at com.ibm.db2.jcc.b.b.a(b.java:732) at com.ibm.db2.jcc.b.b.<init>(b.java:333) at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:165) at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:171) ... 15 more <->:<anonym>: 2007-12-05 09:23:33,937 [Timer-3] WARN jboss.messaging.core.impl.JDBCSupport - Trying again after a pause <->:<anonym>: 2007-12-05 09:23:34,583 [Timer-3] WARN jboss.messaging.core.impl.JDBCSupport - Update worked after retry