Return-Path: X-Original-To: apmail-activemq-dev-archive@www.apache.org Delivered-To: apmail-activemq-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 2F90B18B4D for ; Thu, 6 Aug 2015 10:48:45 +0000 (UTC) Received: (qmail 67955 invoked by uid 500); 6 Aug 2015 10:48:45 -0000 Delivered-To: apmail-activemq-dev-archive@activemq.apache.org Received: (qmail 67896 invoked by uid 500); 6 Aug 2015 10:48:45 -0000 Mailing-List: contact dev-help@activemq.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@activemq.apache.org Delivered-To: mailing list dev@activemq.apache.org Received: (qmail 67878 invoked by uid 99); 6 Aug 2015 10:48:44 -0000 Received: from Unknown (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 06 Aug 2015 10:48:44 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 53FE319C881 for ; Thu, 6 Aug 2015 10:48:44 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 4.279 X-Spam-Level: **** X-Spam-Status: No, score=4.279 tagged_above=-999 required=6.31 tests=[DKIM_ADSP_CUSTOM_MED=0.001, NML_ADSP_CUSTOM_MED=1.2, SPF_SOFTFAIL=0.972, UPPERCASE_50_75=0.791, URIBL_BLOCKED=0.001, URI_HEX=1.313, URI_TRY_3LD=0.001] autolearn=disabled Received: from mx1-eu-west.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id gx9JotAlYw9C for ; Thu, 6 Aug 2015 10:48:32 +0000 (UTC) Received: from mwork.nabble.com (mwork.nabble.com [162.253.133.43]) by mx1-eu-west.apache.org (ASF Mail Server at mx1-eu-west.apache.org) with ESMTP id 28FC124DBC for ; Thu, 6 Aug 2015 10:48:31 +0000 (UTC) Received: from mjoe.nabble.com (unknown [162.253.133.57]) by mwork.nabble.com (Postfix) with ESMTP id E334F256D79C for ; Thu, 6 Aug 2015 03:48:13 -0700 (PDT) Date: Thu, 6 Aug 2015 03:45:21 -0700 (PDT) From: sreekumara To: dev@activemq.apache.org Message-ID: <1438857921881-4700486.post@n4.nabble.com> Subject: Continuous update on ACTIVEMQ_ACKS when no message is published MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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.