java.sql.SQLException: Io exception: Broken pipe

[lee_yuki2000]

Hi,
Does anyone know why i have this problem: Broken pipe , No more data to read from socket and Connection handle has been closed and is unusable

2004-05-15 19:32:56,742 INFO [org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener] Unregistered handle that was not registered! null for managedConnection: org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@1a819d
2004-05-15 19:32:56,743 INFO [org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener] Unregistered handle that was not registered! null for managedConnection: org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@1a819d
2004-05-15 19:32:56,743 INFO [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Exception destroying ManagedConnection
org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: Io 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:648)
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.WrappedConnection.checkException(WrappedConnection.java:819)
at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:225)
at sqlj.runtime.profile.ref.JDBCProfile.prepareCachedStatement(JDBCProfile.java:334)
at sqlj.runtime.profile.ref.JDBCProfile.getCachedStatement(JDBCProfile.java:192)


2004-05-15 17:38:39,641 INFO [org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener] Unregistered handle that was not registered! null for managedConnection: org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@3c27d9
2004-05-15 17:38:39,641 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] ResourceException cleaning up ManagedConnection:org.jboss.resource.JBossResourceException: Could not cleanup: ; - nested throwable: (java.sql.SQLException: Io exception: Broken pipe)
2004-05-15 17:38:39,642 INFO [org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener] Unregistered handle that was not registered! null for managedConnection: org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@3c27d9
2004-05-15 17:38:39,642 INFO [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Exception destroying ManagedConnection
org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: Io 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:648)



2004-05-15 19:32:56,747 ERROR [STDERR] java.sql.SQLException: No more data to read from socket
2004-05-15 19:32:56,747 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
2004-05-15 19:32:56,747 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
2004-05-15 19:32:56,747 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:944)
2004-05-15 19:32:56,748 ERROR [STDERR] at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java:741)
2004-05-15 19:32:56,748 ERROR [STDERR] at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java:700)
2004-05-15 19:32:56,748 ERROR [STDERR] at oracle.jdbc.ttc7.Oopen.receive(Oopen.java:103)
2004-05-15 19:32:56,748 ERROR [STDERR] at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java:472)
2004-05-15 19:32:56,748 ERROR [STDERR] at oracle.jdbc.driver.OracleStatement.(OracleStatement.java:499)
2004-05-15 19:32:56,748 ERROR [STDERR] at oracle.jdbc.driver.OracleStatement.(OracleStatement.java:518)
2004-05-15 19:32:56,748 ERROR [STDERR] at oracle.jdbc.driver.OraclePreparedStatement.(OraclePreparedStatement.java:210)
2004-05-15 19:32:56,748 ERROR [STDERR] at oracle.jdbc.driver.OraclePreparedStatement.(OraclePreparedStatement.java:193)


As i know, it is because of the connection is closed but why is it the connection close?

Pls Help. Thanks in advance

yuki

[lee_yuki2000]

I m using jboss 3.2.1 and oracle 9.1i

[adrian.brock]

Either:

1) You had a transaction timeout
2) The network broke the connection
3) Oracle closed the connection (jdbc driver or db)

None of the logging you report is an ERROR, it is just warning you that a connection
was closed unexpectedly.

3.2.1 had a "bug" where it would try to close the connection twice
1) When it discovered the connection was broken
2) When the wrapper connection was closed by the application after receiving the
sql exception about the oriignal error
It doesn't cause any problems, just messy logs.

[georgewinner]

Adrian I have the same "error" in my application,

So it's not a "real error" but and wrong message thrown ??????


12037157 INFO 10 Jan 2005 23:04:28,401 connectionmanager.TxConnectionManager$TxConnectionEventListener - Unregistered handle that was not registered! null for managedConnection: org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@1d1b44b
12037158 INFO 10 Jan 2005 23:04:28,402 connectionmanager.TxConnectionManager$TxConnectionEventListener - Unregistered handle that was not registered! null for managedConnection: org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@1d1b44b
12037159 INFO 10 Jan 2005 23:04:28,403 connectionmanager.JBossManagedConnectionPool - Exception destroying ManagedConnection
org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: Io 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:648)
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.WrappedConnection.checkException(WrappedConnection.java:819)
at org.jboss.resource.adapter.jdbc.WrappedConnection.createStatement(WrappedConnection.java:156)
at com.eurodyn.dimitra2.util.scheduling.XMLTask.getLastExecution(XMLTask.java:219)
at com.eurodyn.dimitra2.util.scheduling.XMLTask.needExecution(XMLTask.java:307)
at com.eurodyn.dimitra2.util.scheduling.XMLTask.execute(XMLTask.java:295)
at com.eurodyn.dimitra2.util.scheduling.ScheduledTask.run(ScheduledTask.java:53)
at java.util.TimerThread.mainLoop(Timer.java:432)
at java.util.TimerThread.run(Timer.java:382)
Caused by: java.sql.SQLException: Io exception: Broken pipe
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at oracle.jdbc.driver.OracleConnection.close(OracleConnection.java:1442)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:225)
... 16 more