2 Replies Latest reply: Jun 5, 2003 2:01 AM by Bernhard Löwenstein RSS

JBossMQ with Oracle - Broken pipe

Bernhard Löwenstein Newbie

Hello!

I am using JBossMQ with Oracle 8.1.7 (as backend for the JDBC persistence manager).
When I send a message to a queue, then the following exception is thrown:

2003-06-04 18:14:21,803 DEBUG [org.jboss.resource.adapter.jms.JmsSession] Closing session
2003-06-04 18:14:21,803 DEBUG [org.jboss.resource.adapter.jms.JmsManagedConnection] Sending connection event: 1
2003-06-04 18:14:24,558 INFO [org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener] Unregistered handle that was not registered! null for managedConnection: org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@c713d2
2003-06-04 18:14:24,563 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.parentTraceEnabled=true
2003-06-04 18:14:24,565 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.nestedTraceEnabled=false
2003-06-04 18:14:24,565 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.detectDuplicateNesting=true
2003-06-04 18:14:24,565 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] ResourceException cleaning up ManagedConnection:org.jboss.resource.JBossResourceException: Could not cleanup: ; - nested throwable: (java.sql.SQLException: E/A-Exception: Broken pipe)
2003-06-04 18:14:24,566 INFO [org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener] Unregistered handle that was not registered! null for managedConnection: org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@c713d2
2003-06-04 18:14:24,567 INFO [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Exception destroying ManagedConnection
org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: E/A-Exception: Broken pipe)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkException(BaseWrapperManagedConnection.java:445)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:229)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.doDestroy(InternalManagedConnectionPool.java:374)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.returnConnection(InternalManagedConnectionPool.java:250)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool.returnConnection(JBossManagedConnectionPool.java:653)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.returnManagedConnection(BaseConnectionManager2.java:451)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$BaseConnectionEventListener.connectionErrorOccurred(BaseConnectionManager2.java:762)
at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.connectionErrorOccurred(TxConnectionManager.java:629)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.broadcastConnectionError(BaseWrapperManagedConnection.java:309)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.connectionError(BaseWrapperManagedConnection.java:294)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkException(BaseWrapperManagedConnection.java:444)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.commit(LocalManagedConnection.java:95)
at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.commit(TxConnectionManager.java:773)
at org.jboss.tm.TransactionImpl.commitResources(TransactionImpl.java:1580)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:366)
at org.jboss.mq.pm.jdbc2.PersistenceManager$TransactionManagerStrategy.endTX(PersistenceManager.java:183)
at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:696)
at org.jboss.mq.server.PersistentQueue.addMessage(PersistentQueue.java:39)
at org.jboss.mq.server.JMSQueue.addMessage(JMSQueue.java:124)
at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:404)
at org.jboss.mq.server.JMSDestinationManager.transact(JMSDestinationManager.java:430)
at org.jboss.mq.server.JMSServerInterceptorSupport.transact(JMSServerInterceptorSupport.java:185)
at org.jboss.mq.server.TracingInterceptor.transact(TracingInterceptor.java:370)
at org.jboss.mq.server.JMSServerInvoker.transact(JMSServerInvoker.java:187)
at org.jboss.mq.il.jvm.JVMServerIL.transact(JVMServerIL.java:328)
at org.jboss.mq.Connection.send(Connection.java:928)
at org.jboss.mq.SpyXAResourceManager.commit(SpyXAResourceManager.java:127)
at org.jboss.mq.SpyXAResource.commit(SpyXAResource.java:103)
at org.jboss.tm.TransactionImpl.commitResources(TransactionImpl.java:1580)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:366)
at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:369)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:253)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:104)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:117)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:322)
at org.jboss.ejb.Container.invoke(Container.java:674)
at sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:88)
at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:77)
at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80)
at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:109)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:82)
at $Proxy82.sendEntireTrafficMessageToQueue(Unknown Source)
at at.intervista.pvm.managed.TrafficMessageListenerThread.run(TrafficMessageListenerThread.java:88)
at java.lang.Thread.run(Thread.java:536)
Caused by: java.sql.SQLException: E/A-Exception: Broken pipe
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:323)
at oracle.jdbc.driver.OracleConnection.close(OracleConnection.java:930)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:225)
... 50 more
2003-06-04 18:14:24,572 WARN [org.jboss.tm.TransactionImpl] XAException: tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=dev.intern.vmzberlin.de//83, BranchQual=] errorCode=XA_UNKNOWN(0)
org.jboss.resource.connectionmanager.JBossLocalXAException: could not commit local tx; - nested throwable: (org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: E/A-Exception: Broken pipe))
at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.commit(TxConnectionManager.java:782)
at org.jboss.tm.TransactionImpl.commitResources(TransactionImpl.java:1580)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:366)
at org.jboss.mq.pm.jdbc2.PersistenceManager$TransactionManagerStrategy.endTX(PersistenceManager.java:183)
at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:696)
at org.jboss.mq.server.PersistentQueue.addMessage(PersistentQueue.java:39)
at org.jboss.mq.server.JMSQueue.addMessage(JMSQueue.java:124)
at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:404)
at org.jboss.mq.server.JMSDestinationManager.transact(JMSDestinationManager.java:430)
at org.jboss.mq.server.JMSServerInterceptorSupport.transact(JMSServerInterceptorSupport.java:185)
at org.jboss.mq.server.TracingInterceptor.transact(TracingInterceptor.java:370)
at org.jboss.mq.server.JMSServerInvoker.transact(JMSServerInvoker.java:187)
at org.jboss.mq.il.jvm.JVMServerIL.transact(JVMServerIL.java:328)
at org.jboss.mq.Connection.send(Connection.java:928)
at org.jboss.mq.SpyXAResourceManager.commit(SpyXAResourceManager.java:127)
at org.jboss.mq.SpyXAResource.commit(SpyXAResource.java:103)
at org.jboss.tm.TransactionImpl.commitResources(TransactionImpl.java:1580)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:366)
at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:369)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:253)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:104)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:117)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:322)
at org.jboss.ejb.Container.invoke(Container.java:674)
at sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:88)
at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:77)
at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80)
at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:109)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:82)
at $Proxy82.sendEntireTrafficMessageToQueue(Unknown Source)
at at.intervista.pvm.managed.TrafficMessageListenerThread.run(TrafficMessageListenerThread.java:88)
at java.lang.Thread.run(Thread.java:536)
Caused by: org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: E/A-Exception: Broken pipe)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkException(BaseWrapperManagedConnection.java:445)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.commit(LocalManagedConnection.java:95)
at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.commit(TxConnectionManager.java:773)
... 39 more
Caused by: java.sql.SQLException: E/A-Exception: Broken pipe
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:323)
at oracle.jdbc.driver.OracleConnection.commit(OracleConnection.java:851)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.commit(LocalManagedConnection.java:91)
... 40 more
2003-06-04 18:14:24,576 WARN [org.jboss.tm.TransactionImpl] XAException: tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=dev.intern.vmzberlin.de//83, BranchQual=] errorCode=XA_UNKNOWN(0)
org.jboss.resource.connectionmanager.JBossLocalXAException: wrong xid in rollback: expected: null, got: XidImpl [FormatId=257, GlobalId=dev.intern.vmzberlin.de//83, BranchQual=1]
at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.rollback(TxConnectionManager.java:854)
at org.jboss.tm.TransactionImpl.rollbackResources(TransactionImpl.java:1648)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:394)
at org.jboss.mq.pm.jdbc2.PersistenceManager$TransactionManagerStrategy.endTX(PersistenceManager.java:183)
at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:696)
at org.jboss.mq.server.PersistentQueue.addMessage(PersistentQueue.java:39)
at org.jboss.mq.server.JMSQueue.addMessage(JMSQueue.java:124)
at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:404)
at org.jboss.mq.server.JMSDestinationManager.transact(JMSDestinationManager.java:430)
at org.jboss.mq.server.JMSServerInterceptorSupport.transact(JMSServerInterceptorSupport.java:185)
at org.jboss.mq.server.TracingInterceptor.transact(TracingInterceptor.java:370)
at org.jboss.mq.server.JMSServerInvoker.transact(JMSServerInvoker.java:187)
at org.jboss.mq.il.jvm.JVMServerIL.transact(JVMServerIL.java:328)
at org.jboss.mq.Connection.send(Connection.java:928)
at org.jboss.mq.SpyXAResourceManager.commit(SpyXAResourceManager.java:127)
at org.jboss.mq.SpyXAResource.commit(SpyXAResource.java:103)
at org.jboss.tm.TransactionImpl.commitResources(TransactionImpl.java:1580)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:366)
at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:369)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:253)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:104)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:117)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:322)
at org.jboss.ejb.Container.invoke(Container.java:674)
at sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:88)
at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:77)
at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80)
at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:109)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:82)
at $Proxy82.sendEntireTrafficMessageToQueue(Unknown Source)
at at.intervista.pvm.managed.TrafficMessageListenerThread.run(TrafficMessageListenerThread.java:88)
at java.lang.Thread.run(Thread.java:536)


Any idea what to do?

Kind regards,
Bernhard

PS: The same JBoss configuration and apps work fine in an other test network.