3 Replies Latest reply on Jan 11, 2005 12:18 PM by VANGELIS VANGELIS

    java.sql.SQLException: Io exception: Broken pipe

    lee_yuki2000 Newbie

      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

        • 1. Re: java.sql.SQLException: Io exception: Broken pipe
          lee_yuki2000 Newbie

          I m using jboss 3.2.1 and oracle 9.1i

          • 2. Re: java.sql.SQLException: Io exception: Broken pipe
            Adrian Brock Master

            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.

            • 3. Re: java.sql.SQLException: Io exception: Broken pipe
              VANGELIS VANGELIS Newbie

              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