1 Reply Latest reply on Jan 29, 2009 5:44 PM by Jay Howell

    regarding JBM_MSG_REF table

    senthil kumar Newbie

      Hi,

      We have deployed jboss-4.2.3.GA with jboss-messaging-1.4.0.SP3 in our production environment.

      Currently we are facing an issue as 'java.lang.IllegalStateException: Didn't load expected number of references, loaded: 12 expected: 50'.

      If we face this problem, as a temporary solution we will update the page_ord column to null in JBM_MSG_REF table for that particular channel id. Then that issue will get resolved.

      Can anyone please let me know, What is the significance of the page_ord column in JBM_MSG_REF table and also please let me know if any problem will occur if we set that value to null.


      Thanks in advance

        • 1. Re: regarding JBM_MSG_REF table
          Jay Howell Apprentice

          When you get alot of messages in memory, we begin to page them to disk. This is a safeguard so we don't consume all the memory in the box. As consumers pull messages out of the queues, we pull messages out of the db and load them back in to memory.

          The page ord is the order in which messages get pushed and pulled form the DB.


          SELECT MESSAGE_ID, DELIVERY_COUNT, PAGE_ORD, SCHED_DELIVERY FROM JBM_MSG_REF WHERE CHANNEL_ID = ? AND PAGE_ORD BETWEEN ? AND ? ORDER BY PAGE_ORD

          So we get the minimum page ord and we start from there. Each batch of page_refs we load, we add that many to the page ord we start with.

          This error looks like the messages were removed somehow and made the ord numbes get out of sequence. Deleting the ord numbers are fine, they will renumber themselves.

          Jay:)