2 Replies Latest reply on Nov 24, 2004 10:11 PM by cheenu78

    Error While Publiching message to Topic

    cheenu78 Newbie

      Hi all,

      When I am publishing message to topic i am getting the following stacktrace on the jboss console.

      When the number of messages are less this is working fine, when I have more messages I have this problem.

      Can any one help me.

      Thanks in advance
      Srinivas


      Stacktrace:

      12:32:52,499 INFO [JBossManagedConnectionPool] Exception destroying ManagedConnection
      org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: No more data to read from socket)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkException(BaseWrapperManagedConnection.java:452)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:232)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.doDestroy(InternalManagedConnectionPool.java:394)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.returnConnection(InternalManagedConnectionPool.java:270)
      at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool.returnConnection(JBossManagedConnectionPool.java:701)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.returnManagedConnection(BaseConnectionManager2.java:464)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$BaseConnectionEventListener.connectionErrorOccurred(BaseConnectionManager2.java:803)
      at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.connectionErrorOccurred(TxConnectionManager.java:629)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.broadcastConnectionError(BaseWrapperManagedConnection.java:316)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.connectionError(BaseWrapperManagedConnection.java:301)
      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:742)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.saveToStorage(PersistenceManager.java:1169)
      at org.jboss.mq.server.MessageCache.saveToStorage(MessageCache.java:414)
      at org.jboss.mq.server.MessageReference.makeSoft(MessageReference.java:252)
      at org.jboss.mq.server.MessageCache.validateSoftReferenceDepth(MessageCache.java:354)
      at org.jboss.mq.server.MessageCache.addInternal(MessageCache.java:133)
      at org.jboss.mq.server.MessageCache.add(MessageCache.java:102)
      at org.jboss.mq.server.JMSTopic.addMessage(JMSTopic.java:299)
      at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:409)
      at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:385)
      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:253)
      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:180)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
      at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:944)
      at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java:741)
      at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java:700)
      at oracle.jdbc.ttc7.Oclose.receive(Oclose.java:105)
      at oracle.jdbc.ttc7.TTC7Protocol.close(TTC7Protocol.java:539)
      at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:699)
      at oracle.jdbc.driver.OraclePreparedStatement.privateClose(OraclePreparedStatement.java:335)
      at oracle.jdbc.driver.OraclePreparedStatement.close(OraclePreparedStatement.java:270)
      at oracle.jdbc.driver.OracleConnection.close_statements(OracleConnection.java:2003)
      at oracle.jdbc.driver.OracleConnection.close(OracleConnection.java:1227)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:228)
      ... 27 more
      12:32:52,509 ERROR [STDERR] java.sql.SQLException: Io exception: Broken pipe
      12:32:52,509 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
      12:32:52,510 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
      12:32:52,510 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335)
      12:32:52,510 ERROR [STDERR] at oracle.jdbc.driver.OracleConnection.rollback(OracleConnection.java:1200)
      12:32:52,510 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.rollback(LocalManagedConnection.java:116)
      12:32:52,510 ERROR [STDERR] at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.rollback(TxConnectionManager.java:859)
      12:32:52,510 ERROR [STDERR] at org.jboss.tm.TransactionImpl.rollbackResources(TransactionImpl.java:1647)
      12:32:52,510 ERROR [STDERR] at org.jboss.tm.TransactionImpl.rollback(TransactionImpl.java:449)
      12:32:52,510 ERROR [STDERR] at org.jboss.tm.TxManager.rollback(TxManager.java:263)
      12:32:52,510 ERROR [STDERR] at org.jboss.mq.pm.jdbc2.PersistenceManager$TransactionManagerStrategy.endTX(PersistenceManager.java:174)
      12:32:52,510 ERROR [STDERR] at org.jboss.mq.pm.jdbc2.PersistenceManager.saveToStorage(PersistenceManager.java:1194)
      12:32:52,511 ERROR [STDERR] at org.jboss.mq.server.MessageCache.saveToStorage(MessageCache.java:414)
      12:32:52,511 ERROR [STDERR] at org.jboss.mq.server.MessageReference.makeSoft(MessageReference.java:252)
      12:32:52,511 ERROR [STDERR] at org.jboss.mq.server.MessageCache.validateSoftReferenceDepth(MessageCache.java:354)
      12:32:52,511 ERROR [STDERR] at org.jboss.mq.server.MessageCache.addInternal(MessageCache.java:133)
      12:32:52,511 ERROR [STDERR] at org.jboss.mq.server.MessageCache.add(MessageCache.java:102)
      12:32:52,511 ERROR [STDERR] at org.jboss.mq.server.JMSTopic.addMessage(JMSTopic.java:299)
      12:32:52,511 ERROR [STDERR] at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:409)
      12:32:52,511 ERROR [STDERR] at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:385)
      12:32:52,511 ERROR [STDERR] at org.jboss.mq.server.JMSServerInterceptorSupport.addMessage(JMSServerInterceptorSupport.java:135)
      12:32:52,512 ERROR [STDERR] at org.jboss.mq.security.ServerSecurityInterceptor.addMessage(ServerSecurityInterceptor.java:162)
      12:32:52,512 ERROR [STDERR] at org.jboss.mq.server.TracingInterceptor.addMessage(TracingInterceptor.java:234)
      12:32:52,512 ERROR [STDERR] at org.jboss.mq.server.JMSServerInvoker.addMessage(JMSServerInvoker.java:137)
      12:32:52,512 ERROR [STDERR] at org.jboss.mq.il.oil.OILServerILService$Client.run(OILServerILService.java:253)
      12:32:52,520 ERROR [STDERR] at java.lang.Thread.run(Thread.java:536)
      12:32:52,520 WARN [OILServerILService] Client request resulted in a server exception:
      org.jboss.mq.SpyJMSException: Could not store message: 18 msg=7 hard NOT_STORED PERSISTENT queue=TOPIC.testTopic.ID:1.-2147483648 priority=4 hashCode=21462897; - nested throwable: (java.sql.SQLException: No more data to read from socket)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.saveToStorage(PersistenceManager.java:1183)
      at org.jboss.mq.server.MessageCache.saveToStorage(MessageCache.java:414)
      at org.jboss.mq.server.MessageReference.makeSoft(MessageReference.java:252)
      at org.jboss.mq.server.MessageCache.validateSoftReferenceDepth(MessageCache.java:354)
      at org.jboss.mq.server.MessageCache.addInternal(MessageCache.java:133)
      at org.jboss.mq.server.MessageCache.add(MessageCache.java:102)
      at org.jboss.mq.server.JMSTopic.addMessage(JMSTopic.java:299)
      at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:409)
      at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:385)
      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:253)
      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:180)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
      at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:944)
      at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java:741)
      at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java:700)
      at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:373)
      at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
      at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:862)
      at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1846)
      at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1771)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2361)
      at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:422)
      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:308)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:742)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.saveToStorage(PersistenceManager.java:1169)
      ... 14 more