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(?,?,?,?,?)]

MuleSoft JIRA | Qasim Mavani | 8 years ago
  1. 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 | 8 years ago | Qasim Mavani
    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(?,?,?,?,?)]
  2. 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 | 8 years ago | Qasim Mavani
    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(?,?,?,?,?)]
  3. 0

    Mule Developer List

    gmane.org | 5 months ago
    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(?,?,?,?,?)]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java.sql.SQLException: Table already exists: JMS_MESSAGES in statement [CREATE CACHED TABLE JMS_MESSAGES]

    Stack Overflow | 3 years ago | user3269787
    java.sql.SQLException: Table already exists: JMS_MESSAGES in statement [CREATE CACHED TABLE JMS_MESSAGES]
  6. 0

    When I Start Jboss I Got The Following Exception I, Struts Strutsdatasourcemanagerontomcat5

    roseindia.net | 1 year ago
    java.sql.SQLException: Table already exists: JMS_MESSAGES in statement [CREATE CACHED TABLE JMS_MESSAGES]

    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. 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()
    2. HSQLDB
      jdbcPreparedStatement.executeUpdate
      1. org.hsqldb.jdbc.Util.throwError(Unknown Source)
      2. org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
      2 frames
    3. JBoss Application Server Connector
      WrappedPreparedStatement.executeUpdate
      1. org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:251)
      1 frame
    4. JBossMQ
      BaseMsg.run
      1. org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:1136)
      2. org.jboss.mq.pm.jdbc2.PersistenceManager.saveToStorage(PersistenceManager.java:1632)
      3. org.jboss.mq.server.MessageCache.saveToStorage(MessageCache.java:420)
      4. org.jboss.mq.server.MessageReference.makeSoft(MessageReference.java:312)
      5. org.jboss.mq.server.MessageCache.validateSoftReferenceDepth(MessageCache.java:367)
      6. org.jboss.mq.server.MessageCache.addInternal(MessageCache.java:158)
      7. org.jboss.mq.server.MessageCache.add(MessageCache.java:128)
      8. org.jboss.mq.server.JMSQueue.addMessage(JMSQueue.java:179)
      9. org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:415)
      10. org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:399)
      11. org.jboss.mq.server.JMSServerInterceptorSupport.addMessage(JMSServerInterceptorSupport.java:106)
      12. org.jboss.mq.security.ServerSecurityInterceptor.addMessage(ServerSecurityInterceptor.java:168)
      13. org.jboss.mq.server.TracingInterceptor.addMessage(TracingInterceptor.java:226)
      14. org.jboss.mq.server.JMSServerInvoker.addMessage(JMSServerInvoker.java:112)
      15. org.jboss.mq.il.uil2.ServerSocketManagerHandler.handleMsg(ServerSocketManagerHandler.java:111)
      16. org.jboss.mq.il.uil2.SocketManager$ReadTask.handleMsg(SocketManager.java:395)
      17. org.jboss.mq.il.uil2.msgs.BaseMsg.run(BaseMsg.java:398)
      17 frames
    5. Dough Lea's util.concurrent package
      PooledExecutor$Worker.run
      1. EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:743)
      1 frame
    6. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame