activemq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sreekumara <sreekum...@gmail.com>
Subject Continuous update on ACTIVEMQ_ACKS when no message is published
Date Thu, 06 Aug 2015 10:45:21 GMT
I am using jdbcPersistenceAdapter and MySQL database. In my test scenario
some of the durable subscribers are offline for long hours (<24hrs). The
tests shows continuous update queries are fired to database to update
"LAST_ACKED_ID" for pending messages even when no more messages are
published. 

Why so many updates are repeatedly fired for every few seconds? Is there any
parameter to control the frequency for these updates. How
"expireMessagesPeriod" work , does it has any impact on these updates? 

repeated queries from database general log are given below. 

Query,UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=25026\, XID = NULL WHERE
CONTAINER='topic://testTopic' AND CLIENT_ID='AP8DA27' AND SUB_NAME='test3' 
Query,UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=25026\, XID = NULL WHERE
CONTAINER='topic://testTopic' AND CLIENT_ID='AP8DA26' AND SUB_NAME='test2' 
Query,UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=25026\, XID = NULL WHERE
CONTAINER='topic://testTopic' AND CLIENT_ID='AP8DA29' AND SUB_NAME='test5' 
Query,UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=25026\, XID = NULL WHERE
CONTAINER='topic://testTopic' AND CLIENT_ID='AP8DA28' AND SUB_NAME='test4' 
Query,UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=25026\, XID = NULL WHERE
CONTAINER='topic://testTopic' AND CLIENT_ID='AP8DA23' AND SUB_NAME='test1' 
Query,UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=25027\, XID = NULL WHERE
CONTAINER='topic://testTopic' AND CLIENT_ID='AP8DA27' AND SUB_NAME='test3' 
Query,UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=25027\, XID = NULL WHERE
CONTAINER='topic://testTopic' AND CLIENT_ID='AP8DA26' AND SUB_NAME='test2' 
Query,UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=25027\, XID = NULL WHERE
CONTAINER='topic://testTopic' AND CLIENT_ID='AP8DA29' AND SUB_NAME='test5' 
Query,UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=25027\, XID = NULL WHERE
CONTAINER='topic://testTopic' AND CLIENT_ID='AP8DA28' AND SUB_NAME='test4' 
Query,UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=25027\, XID = NULL WHERE
CONTAINER='topic://testTopic' AND CLIENT_ID='AP8DA23' AND SUB_NAME='test1' 
Query,UPDATE ACTIVEMQ_LOCK SET TIME = 1438705485091 WHERE ID = 1 
Query,SELECT ID\, MSG FROM ACTIVEMQ_MSGS WHERE CONTAINER='topic://testTopic'
ORDER BY ID 
Query,UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=25026\, XID = NULL WHERE
CONTAINER='topic://testTopic' AND CLIENT_ID='AP8DA27' AND SUB_NAME='test3' 
Query,UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=25026\, XID = NULL WHERE
CONTAINER='topic://testTopic' AND CLIENT_ID='AP8DA26' AND SUB_NAME='test2' 
Query,UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=25026\, XID = NULL WHERE
CONTAINER='topic://testTopic' AND CLIENT_ID='AP8DA29' AND SUB_NAME='test5' 
Query,UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=25026\, XID = NULL WHERE
CONTAINER='topic://testTopic' AND CLIENT_ID='AP8DA28' AND SUB_NAME='test4' 
Query,UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=25026\, XID = NULL WHERE
CONTAINER='topic://testTopic' AND CLIENT_ID='AP8DA23' AND SUB_NAME='test1' 
Query,UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=25027\, XID = NULL WHERE
CONTAINER='topic://testTopic' AND CLIENT_ID='AP8DA27' AND SUB_NAME='test3' 
Query,UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=25027\, XID = NULL WHERE
CONTAINER='topic://testTopic' AND CLIENT_ID='AP8DA26' AND SUB_NAME='test2' 
Query,UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=25027\, XID = NULL WHERE
CONTAINER='topic://testTopic' AND CLIENT_ID='AP8DA29' AND SUB_NAME='test5' 
Query,UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=25027\, XID = NULL WHERE
CONTAINER='topic://testTopic' AND CLIENT_ID='AP8DA28' AND SUB_NAME='test4' 
Query,UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=25027\, XID = NULL WHERE
CONTAINER='topic://testTopic' AND CLIENT_ID='AP8DA23' AND SUB_NAME='test1' 

Thanks in advance 
sreekumar



--
View this message in context: http://activemq.2283324.n4.nabble.com/Continuous-update-on-ACTIVEMQ-ACKS-when-no-message-is-published-tp4700486.html
Sent from the ActiveMQ - Dev mailing list archive at Nabble.com.

Mime
View raw message