[jboss-jira] [JBoss JIRA] (JBMESSAGING-1934) Messages in JBM_MSG and JBM_MSG_REF tables grows toa a huge number causing performance issue

[Asawari Pawar (JIRA)]

Asawari Pawar created JBMESSAGING-1934:
------------------------------------------

             Summary: Messages in JBM_MSG and JBM_MSG_REF tables grows toa a huge number causing performance issue
                 Key: JBMESSAGING-1934
                 URL: https://issues.jboss.org/browse/JBMESSAGING-1934
             Project: JBoss Messaging
          Issue Type: Bug
          Components: Messaging Core Persistence
    Affects Versions: 1.4.3.GA
         Environment: JBOSS AS 5.1.0 GA cluster.
JBoss Messaging 1.4.3.GA

            Reporter: Asawari Pawar


I have a JBOSS AS 5.1.0 GA cluster environment.

I am running JBoss Messaging 1.4.3.GA as HASingleton hence this server is started only on the primary JBOSS AS server.

If there is some database connection issue with the primary server, then there are many messages growing in the JBM tables.
This impacts performance and after some time the application stops working.

When I try to find out which messages are these by using below query 

SELECT COND, COUNT(*) as "Number of Messages" FROM JBM_POSTOFFICE JBM_POST, JBM_MSG_REF MSG_REF, JBM_MSG MSG where MSG_REF.MESSAGE_ID = MSG.MESSAGE_ID and MSG_REF.CHANNEL_ID=JBM_POST.CHANNEL_ID GROUP BY COND

then I get count as '0' indicating that these messages does not belong to any Topic or Queue.

What are these messages?
How can I stop these messages from growing?
Why these messages are not getting processed by any message listener.

Thanks,
Asawari






--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira