org.jboss.mq.SpyJMSException: Could not delete the message from the database: delete affected 0 rows)

sourceforge.net | 4 months ago
  1. 0

    JBoss Community / Mailing Lists

    sourceforge.net | 1 year ago
    org.jboss.mq.SpyJMSException: Could not delete the message from the database: delete affected 0 rows)
  2. 0

    JBoss Community / Mailing Lists

    sourceforge.net | 4 months ago
    org.jboss.mq.SpyJMSException: Could not delete the message from the database: delete affected 0 rows)
  3. 0

    Mule Developer List

    gmane.org | 5 months ago
    org.jboss.mq.SpyJMSException: Could not mark the message as deleted in the database: update affected 0 rows)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    I am new to mule. Can someone put some light on the error below. I don't know how to find the cause of this error. Also, if someone can provide a solution for the same. Message : Failed to create and dispatch response event over Jms destination "QUEUE.JMS_TQ2570". Failed to route event via endpoint: null. Message payload is of type: SpyObjectMessage Type : org.mule.api.transport.DispatchException Code : MULE_ERROR-42999 JMS Code : null JavaDoc : http://mule.mulesource.org/docs/apidocs/org/mule/api/transport/DispatchException.html Payload : org.jboss.mq.SpyObjectMessage { Header { jmsDestination : QUEUE.JMS_TQ2570 jmsDeliveryMode : 1 jmsExpiration : 0 jmsPriority : 4 jmsMessageID : ID:1956-1244602615578615 jmsTimeStamp : 1244602615578 jmsCorrelationID: ID:2572-12446025792181 jmsReplyTo : null jmsType : null jmsRedelivered : false jmsProperties : {MULE_ORIGINATING_ENDPOINT=endpoint.jms.InboundPayloadQueue} jmsPropReadWrite: true msgReadOnly : false producerClientId: ID:1956 } } ******************************************************************************** Exception stack is: 1. File input/output errorerror java.io.IOException closing file - file C:\airliquideRoot\jboss-4.0.5.GA\server\default\data\hypersonic\localDB.data in statement [INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB, TXID, TXOP) VALUES(?,?,?,?,?)] (java.sql.SQLException) org.hsqldb.jdbc.Util:-1 (http://java.sun.com/j2se/1.5.0/docs/api/java/sql/SQLException.html) 2. Could not store message: 5136 msg=0 hard NOT_STORED NON_PERSISTENT queue=QUEUE.JMS_TQ2568 priority=4 lateClone=false hashCode=14591519; - nested throwable: (java.sql.SQLException: File input/output errorerror java.io.IOException closing file - file C:\airliquideRoot\jboss-4.0.5.GA\server\default\data\hypersonic\localDB.data in statement [INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB, TXID, TXOP) VALUES(?,?,?,?,?)])(JMS Code: null) (org.jboss.mq.SpyJMSException) org.jboss.mq.pm.jdbc2.PersistenceManager:1646 (null) 3. Failed to create and dispatch response event over Jms destination "QUEUE.JMS_TQ2570". Failed to route event via endpoint: null. Message payload is of type: SpyObjectMessage (org.mule.api.transport.DispatchException) org.mule.transport.jms.JmsReplyToHandler:150 (http://mule.mulesource.org/docs/apidocs/org/mule/api/transport/DispatchException.html) ******************************************************************************** Root Exception stack trace: java.sql.SQLException: File input/output errorerror java.io.IOException closing file - file C:\airliquideRoot\jboss-4.0.5.GA\server\default\data\hypersonic\localDB.data in statement [INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB, TXID, TXOP) VALUES(?,?,?,?,?)] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:251) at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:1136) at org.jboss.mq.pm.jdbc2.PersistenceManager.saveToStorage(PersistenceManager.java:1632) at org.jboss.mq.server.MessageCache.saveToStorage(MessageCache.java:420) at org.jboss.mq.server.MessageReference.makeSoft(MessageReference.java:312) at org.jboss.mq.server.MessageCache.validateSoftReferenceDepth(MessageCache.java:367) at org.jboss.mq.server.MessageCache.addInternal(MessageCache.java:158) at org.jboss.mq.server.MessageCache.add(MessageCache.java:128) at org.jboss.mq.server.JMSQueue.addMessage(JMSQueue.java:179) at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:415) at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:399) at org.jboss.mq.server.JMSServerInterceptorSupport.addMessage(JMSServerInterceptorSupport.java:106) at org.jboss.mq.security.ServerSecurityInterceptor.addMessage(ServerSecurityInterceptor.java:168) at org.jboss.mq.server.TracingInterceptor.addMessage(TracingInterceptor.java:226) at org.jboss.mq.server.JMSServerInvoker.addMessage(JMSServerInvoker.java:112) at org.jboss.mq.il.uil2.ServerSocketManagerHandler.handleMsg(ServerSocketManagerHandler.java:111) at org.jboss.mq.il.uil2.SocketManager$ReadTask.handleMsg(SocketManager.java:395) at org.jboss.mq.il.uil2.msgs.BaseMsg.run(BaseMsg.java:398) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:743) at java.lang.Thread.run(Thread.java:619) ******************************************************************************** WARN 2009-06-09 21:56:57,968 [MessageListenerThread - InboundPayloadQueue] org.mule.config.ExceptionHelper: Failed to load error mappings from: META-INF/services/org/mule/config/jms-exception-mappings.properties This may be because there are no error code mappings for protocol: jms WARN 2009-06-09 21:56:58,375 [MessageListenerThread - InboundPayloadQueue] org.jboss.mq.SpyMessageConsumer: Message consumer closing due to error in listening thread. org.jboss.mq.SpyJMSException: Could not remove message: 5134 msg=6373 soft REMOVED PERSISTENT queue=QUEUE.InboundPayloadQueue priority=4 lateClone=false hashCode=91227; - nested throwable: (org.jboss.mq.SpyJMSException: Could not mark the message as deleted in the database: update affected 0 rows) at org.jboss.mq.pm.jdbc2.PersistenceManager.remove(PersistenceManager.java:1435) at org.jboss.mq.server.BasicQueue.acknowledge(BasicQueue.java:749) at org.jboss.mq.server.JMSQueue.acknowledge(JMSQueue.java:172) at org.jboss.mq.server.ClientConsumer.acknowledge(ClientConsumer.java:334) at org.jboss.mq.server.JMSDestinationManager.acknowledge(JMSDestinationManager.java:514) at org.jboss.mq.server.JMSDestinationManager.acknowledge(JMSDestinationManager.java:507) at org.jboss.mq.server.JMSServerInterceptorSupport.acknowledge(JMSServerInterceptorSupport.java:131) at org.jboss.mq.server.TracingInterceptor.acknowledge(TracingInterceptor.java:385) at org.jboss.mq.server.JMSServerInvoker.acknowledge(JMSServerInvoker.java:137) at org.jboss.mq.il.uil2.ServerSocketManagerHandler.handleMsg(ServerSocketManagerHandler.java:105) at org.jboss.mq.il.uil2.SocketManager$ReadTask.handleMsg(SocketManager.java:395) at org.jboss.mq.il.uil2.msgs.BaseMsg.run(BaseMsg.java:398) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:748) at java.lang.Thread.run(Thread.java:619) Caused by: org.jboss.mq.SpyJMSException: Could not mark the message as deleted in the database: update affected 0 rows at org.jboss.mq.pm.jdbc2.PersistenceManager.remove(PersistenceManager.java:1406)

    MuleSoft JIRA | 7 years ago | Qasim Mavani
    org.jboss.mq.SpyJMSException: Could not remove message: 5134 msg=6373 soft REMOVED PERSISTENT queue=QUEUE.InboundPayloadQueue priority=4 lateClone=false hashCode=91227; - nested throwable: (org.jboss.mq.SpyJMSException: Could not mark the message as deleted in the database: update affected 0 rows)
  6. 0

    Mule Developer List

    gmane.org | 5 months ago
    org.jboss.mq.SpyJMSException: Could not mark the message as deleted in the database: update affected 0 rows)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.jboss.mq.SpyJMSException

      Could not delete the message from the database: delete affected 0 rows)

      at org.jboss.mq.Connection.send()
    2. JBossMQ
      Connection.send
      1. org.jboss.mq.Connection.send(Connection.java:907)
      1 frame