java.sql.SQLException: File input/output errorerror java.io.IOException closing file - file C:\Program Files\sylob\jboss-4.2.0.GA\server\default\data\hypersonic\localDB.data in statement \[UPDATE JMS\_MESSAGES SET TXID=?, TXOP=? WHERE MESSAGEID=? AND DESTINATION=?\] INFO   | jvm 1    | 2008/06/19 14:32:06 |     at org.hsqldb.jdbc.Util.throwError(Unknown Source) INFO   | jvm 1    | 2008/06/19 14:32:06 |     at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source) INFO   | jvm 1    | 2008/06/19 14:32:06 |     at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:95)

hsqldb | grouvignac | 8 years ago
  1. 0

    IOException closing file localDB.data

    hsqldb | 8 years ago | grouvignac
    java.sql.SQLException: File input/output errorerror java.io.IOException closing file - file C:\Program Files\sylob\jboss-4.2.0.GA\server\default\data\hypersonic\localDB.data in statement \[UPDATE JMS\_MESSAGES SET TXID=?, TXOP=? WHERE MESSAGEID=? AND DESTINATION=?\] INFO   | jvm 1    | 2008/06/19 14:32:06 |     at org.hsqldb.jdbc.Util.throwError(Unknown Source) INFO   | jvm 1    | 2008/06/19 14:32:06 |     at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source) INFO   | jvm 1    | 2008/06/19 14:32:06 |     at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:95)
  2. 0

    No Active Application Scope

    wpthm.com | 1 year ago
    java.sql.SQLException: Table already exists: JMS_MESSAGES in statement [CREATE CACHED TABLE JMS_MESSAGES] at org.hsqldb.jdbc.Util.throwError(Lorg.hsqldb.Result;)V(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate()I(Unknown Source)
  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

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

    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:\Program Files\sylob\jboss-4.2.0.GA\server\default\data\hypersonic\localDB.data in statement \[UPDATE JMS\_MESSAGES SET TXID=?, TXOP=? WHERE MESSAGEID=? AND DESTINATION=?\] INFO   | jvm 1    | 2008/06/19 14:32:06 |     at org.hsqldb.jdbc.Util.throwError(Unknown Source) INFO   | jvm 1    | 2008/06/19 14:32:06 |     at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source) INFO   | jvm 1    | 2008/06/19 14:32:06 |     at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:95)

      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate()
    2. JBoss Application Server Connector
      WrappedPreparedStatement.executeUpdate
      1. org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:251)
      1 frame
    3. JBossMQ
      SpyXAResource.commit
      1. org.jboss.mq.pm.jdbc2.PersistenceManager.remove(PersistenceManager.java:1404)
      2. org.jboss.mq.server.BasicQueue.acknowledge(BasicQueue.java:750)
      3. org.jboss.mq.server.JMSQueue.acknowledge(JMSQueue.java:172)
      4. org.jboss.mq.server.ClientConsumer.acknowledge(ClientConsumer.java:334)
      5. org.jboss.mq.server.JMSDestinationManager.acknowledge(JMSDestinationManager.java:514)
      6. org.jboss.mq.server.JMSDestinationManager.transact(JMSDestinationManager.java:441)
      7. org.jboss.mq.server.JMSServerInterceptorSupport.transact(JMSServerInterceptorSupport.java:126)
      8. org.jboss.mq.security.ServerSecurityInterceptor.transact(ServerSecurityInterceptor.java:197)
      9. org.jboss.mq.server.TracingInterceptor.transact(TracingInterceptor.java:352)
      10. org.jboss.mq.server.JMSServerInvoker.transact(JMSServerInvoker.java:132)
      11. org.jboss.mq.il.jvm.JVMServerIL.transact(JVMServerIL.java:175)
      12. org.jboss.mq.Connection.send(Connection.java:1112)
      13. org.jboss.mq.SpyXAResourceManager.commit(SpyXAResourceManager.java:166)
      14. org.jboss.mq.SpyXAResource.commit(SpyXAResource.java:88)
      14 frames
    4. JBoss Application Server Connector
      JcaXAResourceWrapper.commit
      1. org.jboss.resource.connectionmanager.xa.JcaXAResourceWrapper.commit(JcaXAResourceWrapper.java:53)
      1 frame
    5. JBossTS jbossjta
      BaseTransaction.commit
      1. com.arjuna.ats.internal.jta.resources.arjunacore.XAResourceRecord.topLevelOnePhaseCommit(XAResourceRecord.java:636)
      2. com.arjuna.ats.arjuna.coordinator.BasicAction.onePhaseCommit(BasicAction.java:2619)
      3. com.arjuna.ats.arjuna.coordinator.BasicAction.End(BasicAction.java:1779)
      4. com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:90)
      5. com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)
      6. com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1256)
      7. com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:135)
      7 frames
    6. Narayana: ArjunaJTS integration
      BaseTransactionManagerDelegate.commit
      1. com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:87)
      1 frame
    7. JBoss Application Server Connector
      WorkWrapper.execute
      1. org.jboss.resource.adapter.jms.inflow.JmsServerSession$XATransactionDemarcationStrategy.end(JmsServerSession.java:494)
      2. org.jboss.resource.adapter.jms.inflow.JmsServerSession.run(JmsServerSession.java:248)
      3. org.jboss.resource.work.WorkWrapper.execute(WorkWrapper.java:204)
      3 frames
    8. JBoss Common Classes
      BasicTaskWrapper.run
      1. org.jboss.util.threadpool.BasicTaskWrapper.run(BasicTaskWrapper.java:275)
      1 frame
    9. Dough Lea's util.concurrent package
      PooledExecutor$Worker.run
      1. EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:743)
      1 frame