search

eclipse-ee4j / openmq

OpenMQ
https://projects.eclipse.org/projects/ee4j.openmq/
Other
51 stars 34 forks source link

Retry on JDBC4.0 SQLRecoverableException for JDBCStore.storeInterestStates() #153

Open glassfishrobot opened 12 years ago

glassfishrobot commented 12 years ago

The JDBC store should try to recover SQLRecoverableException on JDBCStore.storeInterestStates()

java.sql.SQLRecoverableException: No more data to read from socket^M [23/Feb/2012:01:42:10 PST] ERROR [B4080]: Database rollback failed.:^M java.sql.SQLRecoverableException: No more data to read from socket^M [23/Feb/2012:01:42:10 PST] ERROR [B2011]: Storing of JMS message from 134447621-10.155.152.29(c0:8:78:10:24:60)-15780-1329990126513 failed:^ M com.sun.messaging.jmq.jmsserver.util.BrokerException: [B4107]: Failed to load message 134447621-10.155.152.29(c0:8:78:10:24:60)-15780-132999 0126513 from store^M at com.sun.messaging.jmq.jmsserver.persist.jdbc.MessageDAOImpl.hasMessage(MessageDAOImpl.java:1330)^M at com.sun.messaging.jmq.jmsserver.persist.jdbc.MessageDAOImpl.checkMessage(MessageDAOImpl.java:1354)^M at com.sun.messaging.jmq.jmsserver.persist.jdbc.ConsumerStateDAOImpl.insert(ConsumerStateDAOImpl.java:308)^M at com.sun.messaging.jmq.jmsserver.persist.jdbc.JDBCStore.storeInterestStates(JDBCStore.java:736)^M at com.sun.messaging.jmq.jmsserver.core.PacketReference.store(PacketReference.java:1259)^M at com.sun.messaging.jmq.jmsserver.core.Queue.routeNewMessage(Queue.java:542)^M at com.sun.messaging.jmq.jmsserver.data.handlers.TransactionHandler.doCommit(TransactionHandler.java:1121)^M at com.sun.messaging.jmq.jmsserver.data.handlers.TransactionHandler.doCommit(TransactionHandler.java:939)^M at com.sun.messaging.jmq.jmsserver.data.handlers.TransactionHandler.handle(TransactionHandler.java:705)^M at com.sun.messaging.jmq.jmsserver.data.PacketRouter.handleMessage(PacketRouter.java:181)^M at com.sun.messaging.jmq.jmsserver.service.imq.IMQIPConnection.readData(IMQIPConnection.java:1355)^M at com.sun.messaging.jmq.jmsserver.service.imq.IMQIPConnection.process(IMQIPConnection.java:542)^M at com.sun.messaging.jmq.jmsserver.service.imq.OperationRunnable.process(OperationRunnable.java:170)^M at com.sun.messaging.jmq.jmsserver.util.pool.BasicRunnable.run(BasicRunnable.java:493)^M at java.lang.Thread.run(Thread.java:662)^M Caused by: java.sql.SQLException: [SELECT ID FROM MQMSG41C_PRDBIO WHERE ID = ?]: No more data to read from socket[08000, 17410]^M at com.sun.messaging.jmq.jmsserver.persist.jdbc.DBManager.wrapSQLException(DBManager.java:1018)^M at com.sun.messaging.jmq.jmsserver.persist.jdbc.MessageDAOImpl.hasMessage(MessageDAOImpl.java:1325)^M ... 14 more^M

glassfishrobot commented 6 years ago
glassfishrobot commented 12 years ago

@glassfishrobot Commented Reported by @amykang2020

glassfishrobot commented 12 years ago

@glassfishrobot Commented @amykang2020 said: fixed in 5.0

glassfishrobot commented 7 years ago

@glassfishrobot Commented This issue was imported from java.net JIRA MQ-153