Uploaded image for project: 'JBoss Enterprise Application Platform'
  1. JBoss Enterprise Application Platform
  2. JBEAP-24334

[GSS](7.4.z) commit records are leaking on JDBC journal after the whole data is consumed

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Not a Bug
    • Icon: Major Major
    • None
    • 7.4.7.GA
    • A-MQ7, ActiveMQ
    • None
    • False
    • None
    • False

      AMQ broker with JDBC persistence store leaks records in messaging table. When I send 1000 messages to the broker I can see 400 rows in the table:

      jbossdb=# select count from message_tbl ;
      count
      -------
      4000
      (1 row)
      jbossdb=#
      

      After consuming all message I would expect to see the table empty but this is not the case. I see 2000 rows:

       

      jbossdb=# select count from message_tbl ;
      count
      -------
      2000
      (1 row)
      jbossdb=# 
      

       
      If I repeat the above I see another 200 rows after all messages have been consumed. It looks to me like for each consumed message two rows are added to the table. As far as I can tell those rows are never deleted.

              rchakrab Ranabir Chakraborty
              rhn-support-toross Tom Ross
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: