mySQL JDBC Persistance Error

[kenshin0]

Hi all,

I've been trying for a long time to use the JDBC Persistance Manager to store messages to mySQL tables, but to no avail. I use Jboss 2.4.4.

Having set up Jboss.jcml and the two required schemas ("jms_messages" and "jms_transactions"), messages DO get stored into the "jms_messages" table. However, upon restarting JBoss, the following was dumped to the console:


[ERROR,PersistenceManager] Stopped
org.jboss.mq.SpyJMSException: Could not rebuild the queue from the queue's tranaction log.
at org.jboss.mq.pm.jdbc.MessageLog.throwJMSException(MessageLog.java:206
)
at org.jboss.mq.pm.jdbc.MessageLog.restore(MessageLog.java:96)
at org.jboss.mq.pm.jdbc.PersistenceManager.restore(PersistenceManager.ja
va:291)
at org.jboss.mq.pm.jdbc.PersistenceManager.startService(PersistenceManag
er.java:133)
at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103
)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces....


The affected queue becomes UNUSABLE when JBoss did start up. Whenever a new message is published to the queue, JBossMQ would complain of duplicate message key exceptions.

Please would anyone who might have the slightest idea of how to go round this problem shed some light and put me out of my misery!

Thanks a great deal in advance.

kenshin

[abhati]

Kenshin,

I am encountering a very similar problem. Somehow the message queue has gotten corrupted. JBoss will not startup with the error, "SpyJMSException: Could not rebuild the queue from the transaction log."

If you found any answer to your question, or know of some way to purge the queue kindly let me know.

Thanks,

-amit

[joelvogt]

There have been a few jms fixes lately. Try updating to jboss 2.4.7