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

[Yong Hao Gao (JIRA)]

    [ https://issues.jboss.org/browse/JBMESSAGING-1934?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12722128#comment-12722128 ] 

Yong Hao Gao commented on JBMESSAGING-1934:
-------------------------------------------

Hi Asawari,

1.4.3.GA is a fairly old version. Can you try the later version? Just let you know, JBM is not in active development. You can have a look at HornetQ, which has improvements in many ways.

Howard

                
> 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