JMS unusable when DB is unavailable at JBoss startup

[kwinterm]

When the database server that JMS is configured to use is unavailable at JBoss startup, JMS remains in an unusable state even after the database is available again. The MBeans under "jboss.mq" remain in state "Created" or "Failed" and trying to start them through the JMX console has no effect.

I would expect JMS to be usable as soon as the database becomes available, like it does when the database becomes available after a temporary failure or outage.

I have verified this for JBoss 4.0.3SP1 with MySQL, and JBoss 3.2.7 with Solid DB.

To my knowledge, the only fix is to restart JBoss or redeploy the JMS service. For my client this means they have to boot their servers in a certain order just because of JMS.

Does anyone hit this problem before or have a solution?

Cheers, Karsten

[genman]

JMS won't come up if the DB isn't available, true.

But you can use the start operation on the MBean to start the service that failed, likely the DestinationManager. You could write a service that could try to start the service every 10 seconds or something.

[kwinterm]

Thank you genman, but as I wrote, trying to start any services with MBeans under "jboss.mq" has no effect. I have to redeploy JMS or restart the server.

[kwinterm]

OK, now I got it: So I need to invoke
- destroy
- create
- start
on both the PersistenceManager and the StateManager. Then everything is back to normal.

But wouldn't it be a lot easier if the JMS services could connect themselves automatically to the database when it becomes available? Why is the number of retry attempts limited in PersistenceManager.getConnection()?

Cheers, Karsten

[adrian.brock]

"kwinterm" wrote:
Why is the number of retry attempts limited in PersistenceManager.getConnection()?

That code shouldn't even be there. It is only there to workaround
the stupid way that hypersonic starts.
http://jira.jboss.com/jira/browse/JBAS-1942

[adrian.brock]

Failure monitoring/recovery belongs in the mangement layer not the implementation.