[jboss-user] [JBoss Messaging] - recovering from invalid messages, selectively deleting from db

[Tim Coninx]

Tim Coninx [http://community.jboss.org/people/timconinxrvp] created the discussion

"recovering from invalid messages, selectively deleting from db"

To view the discussion, visit: http://community.jboss.org/message/567157#567157

--------------------------------------------------------------
We use Jboss 5.0 with an oracle db and a standard jboss-messaging deployment.

Irregularly, a queue is unable to start and (therefore) bind itself in JNDI. This has something to do with (I think) corrupt messages which prevent the queue from starting: the exception we see is
java.sql.SQLException: Invalid column index

The error happens very irregularly (like I said), and we haven't been able to really reproduce it yet. However, it seems to happen when a jboss server is killed dirty while messages are being processed.

Deleting all messages directly in the db (delete from jbm_msg / delete from jbm_msg_ref) resolves the problem, but unfortunately it also removes other queue's messages.

So the question is, either:
- is there a way to sql-delete only the offending queue's messages, or
- is there a more elegant way to recover from corrupt messages (remember, the queue does not even start)
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/567157#567157]

Start a new discussion in JBoss Messaging at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2042]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20101019/82e576ce/attachment.html