activemq-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krishnan (JIRA)" <j...@apache.org>
Subject [jira] [Created] (AMQ-6025) Activemq ACTIVEMQ_ACKS table gets double updates
Date Wed, 28 Oct 2015 10:35:28 GMT
Krishnan created AMQ-6025:
-----------------------------

             Summary: Activemq ACTIVEMQ_ACKS table gets double updates
                 Key: AMQ-6025
                 URL: https://issues.apache.org/jira/browse/AMQ-6025
             Project: ActiveMQ
          Issue Type: Bug
          Components: OSGi/Karaf
    Affects Versions: 5.10.1
            Reporter: Krishnan




Customer feedback:

Issue's on ActiveMQ 5.10

We have 290 offline durable clients in Active MQ broker and which have 50 pending messages
for each offline durable client. When the messages exceeds their TTL time for those messages,
LAST_ACK_ID will be updated twice for each subscriber(e.g.: again 290 set of updates it is
firing). why is the updates being duplicated and Is there any possibility to tune or remove
second set of transactions.

Following configuration made in activemq.xml file for this.
cleanupPeriod:
<persistenceAdapter>
<jdbcPersistenceAdapter dataSource="#mysql-ds" cleanupPeriod="300000"/>
</persistenceAdapter>
expireMessagesPeriod
<policyEntry topic="<<topic name>>" expireMessagesPeriod=" 86400000 ">

And also attached the general Db log for the updates.

Support Note: Checked Customer log 215MB . And there's lots of updates on the ACK table. Just
a snippet of the logs..

4171969 Query
UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=378703, XID = NULL WHERE CONTAINER='topic://bmrsTopic'
AND CLIENT_ID='300CLNT149' AND SUB_NAME='300SUBS149'
4171969 Query
UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=378703, XID = NULL WHERE CONTAINER='topic://bmrsTopic'
AND CLIENT_ID='300CLNT142' AND SUB_NAME='300SUBS142'
4171969 Query
UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=378703, XID = NULL WHERE CONTAINER='topic://bmrsTopic'
AND CLIENT_ID='300CLNT141' AND SUB_NAME='300SUBS141'
4171969 Query
UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=378704, XID = NULL WHERE CONTAINER='topic://bmrsTopic'
AND CLIENT_ID='300CLNT140' AND SUB_NAME='300SUBS140'
4171969 Query
UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=378704, XID = NULL WHERE CONTAINER='topic://bmrsTopic'
AND CLIENT_ID='300CLNT14' AND SUB_NAME='300SUBS14'
4171969 Query
UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=378704, XID = NULL WHERE CONTAINER='topic://bmrsTopic'
AND CLIENT_ID='300CLNT146' AND SUB_NAME='300SUBS146'
4171969 Query
UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=378704, XID = NULL WHERE CONTAINER='topic://bmrsTopic'
AND CLIENT_ID='300CLNT147' AND SUB_NAME='300SUBS147'
4171969 Query
UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=378704, XID = NULL WHERE CONTAINER='topic://bmrsTopic'
AND CLIENT_ID='300CLNT145' AND SUB_NAME='300SUBS145'
4171969 Query
UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=378704, XID = NULL WHERE CONTAINER='topic://bmrsTopic'
AND CLIENT_ID='300CLNT148' AND SUB_NAME='300SUBS148'
4171969 Query
UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=378704, XID = NULL WHERE CONTAINER='topic://bmrsTopic'
AND CLIENT_ID='300CLNT143' AND SUB_NAME='300SUBS143'
4171969 Query
UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=378704, XID = NULL WHERE CONTAINER='topic://bmrsTopic'
AND CLIENT_ID='300CLNT144' AND SUB_NAME='300SUBS144'
4171969 Query
UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=378704, XID = NULL WHERE CONTAINER='topic://bmrsTopic'
AND CLIENT_ID='300CLNT149' AND SUB_NAME='300SUBS149'
4171969 Query
UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=378704, XID = NULL WHERE CONTAINER='topic://bmrsTopic'
AND CLIENT_ID='300CLNT142' AND SUB_NAME='300SUBS142'
4171969 Query
UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=378704, XID = NULL WHERE CONTAINER='topic://bmrsTopic'
AND CLIENT_ID='300CLNT141' AND SUB_NAME='300SUBS141'
4171969 Query
UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=378705, XID = NULL WHERE CONTAINER='topic://bmrsTopic'
AND CLIENT_ID='300CLNT140' AND SUB_NAME='300SUBS140'
4171969 Query
UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=378705, XID = NULL WHERE CONTAINER='topic://bmrsTopic'
AND CLIENT_ID='300CLNT14' AND SUB_NAME='300SUBS14'
4171969 Query
UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=378705, XID = NULL WHERE CONTAINER='topic://bmrsTopic'
AND CLIENT_ID='300CLNT146' AND SUB_NAME='300SUBS146'
4171969 Query
UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=378705, XID = NULL WHERE CONTAINER='topic://bmrsTopic'
AND CLIENT_ID='300CLNT147' AND SUB_NAME='300SUBS147'
4171969 Query
UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=378705, XID = NULL WHERE CONTAINER='topic://bmrsTopic'
AND CLIENT_ID='300CLNT145' AND SUB_NAME='300SUBS145'

There is also similar forum discussion on the same
http://activemq.2283324.n4.nabble.com/Too-many-updates-in-MySQL-td4700512.html


A related TalendESB Ticket is available at 

https://jira.talendforge.org/browse/TESB-16693




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message