2 Replies Latest reply on Jan 17, 2005 4:15 AM by kala praveen v

    org.jboss.mq.SpyJMSException in JBoss

    kala praveen v Newbie


      Hi,

      I am using jboss-4.0.0 and running a stateless session bean which puts some data into a queue which later will be comsumed by an MDB. After a couple of hours of proper functionality the JBOSS is crashed showing the following stack one per each message generated. I am using the default configuration of Jboss and did not change anything. I also observe that the files under Hypersonic are growing to big sizes. Please help me with this issue.



      org.jboss.mq.SpyJMSException: Could not store message: 323184 msg=323183 hard NOT_STORED PERSISTENT queue=QUEUE.LogQueue priority=4 lateClone=false hashCode=23244597; - nes
      ted throwable: (java.sql.SQLException: S1000 General error java.lang.NullPointerException in statement [INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB, TXID, TXOP) VALUES(?,?,?,?,?)])
      06:33:32,528 INFO [STDOUT] at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:802)
      06:33:32,559 INFO [STDOUT] at org.jboss.mq.server.PersistentQueue.addMessage(PersistentQueue.java:38)
      06:33:32,559 INFO [STDOUT] at org.jboss.mq.server.JMSQueue.addMessage(JMSQueue.java:131)
      06:33:32,559 INFO [STDOUT] at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:402)
      06:33:32,559 INFO [STDOUT] at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:378)
      06:33:32,559 INFO [STDOUT] at org.jboss.mq.server.JMSServerInterceptorSupport.addMessage(JMSServerInterceptorSupport.java:136)
      06:33:32,559 INFO [STDOUT] at org.jboss.mq.security.ServerSecurityInterceptor.addMessage(ServerSecurityInterceptor.java:153)
      06:33:32,590 INFO [STDOUT] at org.jboss.mq.server.TracingInterceptor.addMessage(TracingInterceptor.java:270)
      06:33:32,590 INFO [STDOUT] at org.jboss.mq.server.JMSServerInvoker.addMessage(JMSServerInvoker.java:136)
      06:33:32,590 INFO [STDOUT] at org.jboss.mq.il.jvm.JVMServerIL.addMessage(JVMServerIL.java:136)
      06:33:32,590 INFO [STDOUT] at org.jboss.mq.Connection.sendToServer(Connection.java:1020)
      06:33:32,590 INFO [STDOUT] at org.jboss.mq.SpySession.sendMessage(SpySession.java:1005)
      06:33:32,590 INFO [STDOUT] at org.jboss.mq.SpyMessageProducer.send(SpyMessageProducer.java:265)
      06:33:32,621 INFO [STDOUT] at org.jboss.mq.SpyMessageProducer.send(SpyMessageProducer.java:199)
      06:33:32,621 INFO [STDOUT] at org.mirapoint.LogCollectorSessionBean.insertLog(Unknown Source)
      06:33:32,621 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor74.invoke(Unknown Source)
      06:33:32,621 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      06:33:32,621 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
      06:33:32,621 INFO [STDOUT] at org.jboss.invocation.Invocation.performCall(Invocation.java:345)
      06:33:32,653 INFO [STDOUT] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)
      06:33:32,653 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
      06:33:32,653 INFO [STDOUT] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:113)
      06:33:32,653 INFO [STDOUT] at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:51)
      06:33:32,653 INFO [STDOUT] at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)
      06:33:32,653 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:105)
      06:33:32,684 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:316)
      06:33:32,684 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:149)
      06:33:32,684 INFO [STDOUT] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:128)
      06:33:32,684 INFO [STDOUT] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
      06:33:32,684 INFO [STDOUT] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
      06:33:32,684 INFO [STDOUT] at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)
      06:33:32,715 INFO [STDOUT] at org.jboss.ejb.Container.invoke(Container.java:854)
      06:33:32,715 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor72.invoke(Unknown Source)
      06:33:32,715 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      06:33:32,715 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
      06:33:32,715 INFO [STDOUT] at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      06:33:32,715 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      06:33:32,746 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      06:33:32,746 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:242)
      06:33:32,746 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
      06:33:32,746 INFO [STDOUT] at org.jboss.invocation.jrmp.server.JRMPInvoker$MBeanServerAction.invoke(JRMPInvoker.java:775)
      06:33:32,746 INFO [STDOUT] at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:382)
      06:33:32,746 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown Source)
      06:33:32,778 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      06:33:32,778 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
      06:33:32,778 INFO [STDOUT] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
      06:33:32,778 INFO [STDOUT] at sun.rmi.transport.Transport$1.run(Transport.java:148)
      06:33:32,778 INFO [STDOUT] at java.security.AccessController.doPrivileged(Native Method)
      06:33:32,778 INFO [STDOUT] at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
      06:33:32,809 INFO [STDOUT] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
      06:33:32,809 INFO [STDOUT] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
      06:33:32,809 INFO [STDOUT] at java.lang.Thread.run(Thread.java:534)
      06:33:32,809 INFO [STDOUT] Caused by: java.sql.SQLException: S1000 General error java.lang.NullPointerException in statement [INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB, TXID, TXOP
      ) VALUES(?,?,?,?,?)]
      06:33:32,809 INFO [STDOUT] at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
      06:33:32,809 INFO [STDOUT] at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
      06:33:32,840 INFO [STDOUT] at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:316)
      06:33:32,840 INFO [STDOUT] at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:840)
      06:33:32,840 INFO [STDOUT] at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:787)
      06:33:32,840 INFO [STDOUT] ... 51 more
      06:33:34,481 INFO [STDOUT] org.jboss.mq.SpyJMSException: Could not store message: 323185 msg=323184 hard NOT_STORED PERSISTENT queue=QUEUE.LogQueue priority=4 lateClone=false hashCode=8952366; - nest
      ed throwable: (java.sql.SQLException: S1000 General error java.lang.NullPointerException in statement [INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB, TXID, TXOP) VALUES(?,?,?,?,?)])
      06:33:34,481 INFO [STDOUT] at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:802)
      06:33:34,481 INFO [STDOUT] at org.jboss.mq.server.PersistentQueue.addMessage(PersistentQueue.java:38)
      06:33:34,481 INFO [STDOUT] at org.jboss.mq.server.JMSQueue.addMessage(JMSQueue.java:131)
      06:33:34,481 INFO [STDOUT] at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:402)
      06:33:34,481 INFO [STDOUT] at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:378)
      06:33:34,481 INFO [STDOUT] at org.jboss.mq.server.JMSServerInterceptorSupport.addMessage(JMSServerInterceptorSupport.java:136)
      06:33:34,481 INFO [STDOUT] at org.jboss.mq.security.ServerSecurityInterceptor.addMessage(ServerSecurityInterceptor.java:153)
      06:33:34,481 INFO [STDOUT] at org.jboss.mq.server.TracingInterceptor.addMessage(TracingInterceptor.java:270)
      06:33:34,481 INFO [STDOUT] at org.jboss.mq.server.JMSServerInvoker.addMessage(JMSServerInvoker.java:136)
      06:33:34,481 INFO [STDOUT] at org.jboss.mq.il.jvm.JVMServerIL.addMessage(JVMServerIL.java:136)
      06:33:34,481 INFO [STDOUT] at org.jboss.mq.Connection.sendToServer(Connection.java:1020)
      06:33:34,481 INFO [STDOUT] at org.jboss.mq.SpySession.sendMessage(SpySession.java:1005)
      06:33:34,481 INFO [STDOUT] at org.jboss.mq.SpyMessageProducer.send(SpyMessageProducer.java:265)
      06:33:34,481 INFO [STDOUT] at org.jboss.mq.SpyMessageProducer.send(SpyMessageProducer.java:199)
      06:33:34,481 INFO [STDOUT] at org.mirapoint.LogCollectorSessionBean.insertLog(Unknown Source)
      06:33:34,481 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor74.invoke(Unknown Source)
      06:33:34,481 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      06:33:34,481 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
      06:33:34,481 INFO [STDOUT] at org.jboss.invocation.Invocation.performCall(Invocation.java:345)
      06:33:34,481 INFO [STDOUT] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)
      06:33:34,481 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
      06:33:34,481 INFO [STDOUT] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:113)
      06:33:34,481 INFO [STDOUT] at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:51)
      06:33:34,481 INFO [STDOUT] at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)
      06:33:34,481 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:105)
      06:33:34,481 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:316)
      06:33:34,481 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:149)
      06:33:34,481 INFO [STDOUT] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:128)
      06:33:34,481 INFO [STDOUT] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
      06:33:34,481 INFO [STDOUT] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
      06:33:34,481 INFO [STDOUT] at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)
      06:33:34,481 INFO [STDOUT] at org.jboss.ejb.Container.invoke(Container.java:854)
      06:33:34,481 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor72.invoke(Unknown Source)
      06:33:34,481 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      06:33:34,481 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
      06:33:34,481 INFO [STDOUT] at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      06:33:34,481 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      06:33:34,481 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      06:33:34,481 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:242)
      06:33:34,481 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
      06:33:34,481 INFO [STDOUT] at org.jboss.invocation.jrmp.server.JRMPInvoker$MBeanServerAction.invoke(JRMPInvoker.java:775)
      06:33:34,481 INFO [STDOUT] at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:382)
      06:33:34,481 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown Source)
      06:33:34,481 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      06:33:34,481 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
      06:33:34,481 INFO [STDOUT] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
      06:33:34,481 INFO [STDOUT] at sun.rmi.transport.Transport$1.run(Transport.java:148)
      06:33:34,481 INFO [STDOUT] at java.security.AccessController.doPrivileged(Native Method)
      06:33:34,481 INFO [STDOUT] at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
      06:33:34,481 INFO [STDOUT] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
      06:33:34,481 INFO [STDOUT] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
      06:33:34,481 INFO [STDOUT] at java.lang.Thread.run(Thread.java:534)
      06:33:34,481 INFO [STDOUT] Caused by: java.sql.SQLException: S1000 General error java.lang.NullPointerException in statement [INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB, TXID, TXOP
      ) VALUES(?,?,?,?,?)]
      06:33:34,481 INFO [STDOUT] at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
      06:33:34,481 INFO [STDOUT] at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
      06:33:34,481 INFO [STDOUT] at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:316)
      06:33:34,481 INFO [STDOUT] at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:840)
      06:33:34,481 INFO [STDOUT] at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:787)
      06:33:34,481 INFO [STDOUT] ... 51 more


      Thank you,
      kala.