[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 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