1 Reply Latest reply on Jul 18, 2003 6:25 PM by F Zemen

    No data to read from socket (3.2.1 & 3.0.5)

    F Zemen Newbie

      Below is the stack trace in 3.2.1. Similar issue in 3.0.5.

      When sending a persistent message to Oracle, it appears there is an issue with the connection not being closed (because of the INFO message). This code executes within a transacted EJB.



      19:12:02,441 INFO [TxConnectionManager$TxConnectionEventListener] Unregistered handle that was not registered! null for
      managedConnection: org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@1497b1
      19:12:02,441 INFO [TxConnectionManager$TxConnectionEventListener] Unregistered handle that was not registered! null for
      managedConnection: org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@1497b1
      19:12:02,441 INFO [JBossManagedConnectionPool] Exception destroying ManagedConnection
      org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: No more data to rea
      d from socket)
      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.ja
      va:374)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.returnConnection(InternalManagedConnection
      Pool.java:250)
      at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool.returnConnection(JBossManagedConnecti
      onPool.java:648)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.returnManagedConnection(BaseConnectionManager2.ja
      va:451)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$BaseConnectionEventListener.connectionErrorOccurr
      ed(BaseConnectionManager2.java:762)
      at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.connectionErrorOccurred(Tx
      ConnectionManager.java:629)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.broadcastConnectionError(BaseWrapperManagedConne
      ction.java:309)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.connectionError(BaseWrapperManagedConnection.jav
      a:294)
      at org.jboss.resource.adapter.jdbc.WrappedConnection.checkException(WrappedConnection.java:819)
      at org.jboss.resource.adapter.jdbc.WrappedStatement.checkException(WrappedStatement.java:767)
      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:312)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:723)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:670)
      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.addMessage(JMSDestinationManager.java:384)
      at org.jboss.mq.server.JMSServerInterceptorSupport.addMessage(JMSServerInterceptorSupport.java:135)
      at org.jboss.mq.security.ServerSecurityInterceptor.addMessage(ServerSecurityInterceptor.java:162)
      at org.jboss.mq.server.TracingInterceptor.addMessage(TracingInterceptor.java:234)
      at org.jboss.mq.server.JMSServerInvoker.addMessage(JMSServerInvoker.java:137)
      at org.jboss.mq.il.oil.OILServerILService$Client.run(OILServerILService.java:248)
      at java.lang.Thread.run(Thread.java:536)
      Caused by: java.sql.SQLException: No more data to read from socket
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
      at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)
      at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java:963)
      at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java:893)
      at oracle.jdbc.ttc7.Oclose.receive(Oclose.java:101)
      at oracle.jdbc.ttc7.TTC7Protocol.close(TTC7Protocol.java:683)
      at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:644)
      at oracle.jdbc.driver.OraclePreparedStatement.privateClose(OraclePreparedStatement.java:485)
      at oracle.jdbc.driver.OraclePreparedStatement.close(OraclePreparedStatement.java:393)
      at oracle.jdbc.driver.OracleConnection.close_statements(OracleConnection.java:2333)
      at oracle.jdbc.driver.OracleConnection.close(OracleConnection.java:1412)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:225)
      ... 23 more
      19:12:02,457 ERROR [STDERR] java.sql.SQLException: Io exception: Software caused connection abort: socket write error
      19:12:02,457 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
      19:12:02,457 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
      19:12:02,457 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
      19:12:02,457 ERROR [STDERR] at oracle.jdbc.driver.OracleConnection.rollback(OracleConnection.java:1380)
      19:12:02,457 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.rollback(LocalManagedCon
      nection.java:116)
      19:12:02,457 ERROR [STDERR] at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.rollback(TxC
      onnectionManager.java:859)
      19:12:02,457 ERROR [STDERR] at org.jboss.tm.TransactionImpl.rollbackResources(TransactionImpl.java:1648)
      19:12:02,457 ERROR [STDERR] at org.jboss.tm.TransactionImpl.rollback(TransactionImpl.java:448)
      19:12:02,457 ERROR [STDERR] at org.jboss.mq.pm.jdbc2.PersistenceManager$TransactionManagerStrategy.endTX(Persistence
      Manager.java:179)
      19:12:02,457 ERROR [STDERR] at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:696)
      19:12:02,457 ERROR [STDERR] at org.jboss.mq.server.PersistentQueue.addMessage(PersistentQueue.java:39)
      19:12:02,457 ERROR [STDERR] at org.jboss.mq.server.JMSQueue.addMessage(JMSQueue.java:124)
      19:12:02,457 ERROR [STDERR] at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:404)
      19:12:02,457 ERROR [STDERR] at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:384)
      19:12:02,457 ERROR [STDERR] at org.jboss.mq.server.JMSServerInterceptorSupport.addMessage(JMSServerInterceptorSuppor
      t.java:135)
      19:12:02,457 ERROR [STDERR] at org.jboss.mq.security.ServerSecurityInterceptor.addMessage(ServerSecurityInterceptor.
      java:162)
      19:12:02,457 ERROR [STDERR] at org.jboss.mq.server.TracingInterceptor.addMessage(TracingInterceptor.java:234)
      19:12:02,473 ERROR [STDERR] at org.jboss.mq.server.JMSServerInvoker.addMessage(JMSServerInvoker.java:137)
      19:12:02,473 ERROR [STDERR] at org.jboss.mq.il.oil.OILServerILService$Client.run(OILServerILService.java:248)