[jboss-user] [JBoss Messaging] - Re: java.lang.IllegalStateException: Didn't load expected nu

[karianna]

We just ran across this as well (hence my separate post).

I know Tim Fox talked about this in JIRA 908 and he was pretty sure that it was due to usages of a non JBM supported DB (e.g MySQL ISAM tables).

Anyhow, try running the following SQL on your DB:


  | SELECT count(*) FROM JBM_MSG_REF
  | WHERE JBM_MSG_REF.MESSAGE_ID NOT IN (SELECT MESSAGE_ID FROM JBM_MSG);
  | 

Do you get more than 0 results?

Also try the reverse case of this:


  | SELECT count(*) FROM JBM_MSG
  | WHERE JBM_MSG.MESSAGE_ID NOT IN (SELECT MESSAGE_ID FROM JBM_MSG_REF);
  | 

Do you get more than 0 results?



View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4186094#4186094

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4186094