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
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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 | 10 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

    First Root Login doesn't work

    opencrx | 1 decade ago | bischof_ulfilas
    java.sql.SQLException: Table already exists: JMS_MESSAGES in statement [CREATE CACHED TABLE JMS_MESSAGES]
  6. 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]

    1 unregistered visitors
    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