No data to read from socket (3.2.1 & 3.0.5)
jbossuser Jul 18, 2003 6:18 PMBelow 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)