can plugged-in persistance recover after db crash?
I don't see any settings for the plugged-in persistance related to db connection pools. Is there any way for IMQ 3.5 to recover if the database crashes?
The broker just logs the following:
[10/Jun/2004:14:21:11 PDT] ERROR [B4080]: Database rollback failed.:
java.sql.SQLException: Io exception: Broken pipe
[10/Jun/2004:14:21:11 PDT] ERROR [B4004]: Failed to persist message 15-AAA.BBB.CCC.DDD(xxx)-40113-1086902471062:
java.sql.SQLException: [INSERT INTO IMQMSG35 (MID, DID, MSGSIZE, MSG) VALUES ( ?,?,?,? )]: Io exception: Broken pipe
[10/Jun/2004:14:21:11 PDT] ERROR [B2011]: Storing of JMS message from 15-AAA.BBB.CCC.DDD(xxx)-40113-1086902471062 failed:
com.sun.messaging.jmq.jmsserver.util.BrokerException: Failed to persist message 15-AAA.BBB.CCC.DDD(xxx)-40113-1086902471062
at com.sun.messaging.jmq.jmsserver.persist.jdbc.MsgTable.storeMessage(MsgTable.java:288)
at com.sun.messaging.jmq.jmsserver.persist.jdbc.JDBCStore.storeMessage(JDBCStore.java:192)
at com.sun.messaging.jmq.jmsserver.core.PacketReference.store(PacketReference.java:801)
at com.sun.messaging.jmq.jmsserver.core.Topic.routeNewMessage(Topic.java:265)
at com.sun.messaging.jmq.jmsserver.data.handlers.DataHandler.handle(DataHandler.java:146)
at com.sun.messaging.jmq.jmsserver.data.handlers.DataHandler.handle(DataHandler.java:59)
at com.sun.messaging.jmq.jmsserver.data.PacketRouter.handleMessage(PacketRouter.java:146)
at com.sun.messaging.jmq.jmsserver.service.imq.IMQConnection.readData(IMQConnection.java:1747)
at com.sun.messaging.jmq.jmsserver.service.imq.IMQConnection.process(IMQConnection.java:791)
at com.sun.messaging.jmq.jmsserver.service.imq.OperationRunnable.process(OperationRunnable.java:135)
at com.sun.messaging.jmq.jmsserver.util.pool.BasicRunnable.run(BasicRunnable.java:455)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: [INSERT INTO IMQMSG35 (MID, DID, MSGSIZE, MSG) VALUES ( ?,?,?,? )]: Io exception: Broken pipe
at com.sun.messaging.jmq.jmsserver.persist.jdbc.DBManager.wrapSQLException(DBManager.java:355)
at com.sun.messaging.jmq.jmsserver.persist.jdbc.MsgTable.storeMessage(MsgTable.java:239)
... 11 more
