0 Replies Latest reply on May 13, 2014 2:09 PM by joe_boy12

    Urgent - orphan channels in JBM_MSG_REF

    joe_boy12 Novice

      Hello guys - we are on EAP5.2 with JBoss Messaging 1.4.8SP9 with 2 node cluster. I am seeing a a rather unusual (?) behavior in JBM tables after a force kill on one of the nodes in cluster. I am trying to find out how many lost messages we have and below query gives variable count - it started with 33 (distinct channels which dont have corresponding channels in jbm postoffice ) and total 166K messages from those 33 - it went down to 8 distinct channels and message count to 33K - its still fluctuting between 8 to 15 but message count going down. Not sure whats happening. is it re-attaching the orphans to true channels? Never saw this before.


      select count( distinct channel_id ) from jbm_msg_ref where channel_id not in ( select channel_id from jbm_postoffice )