Return-Path: Delivered-To: apmail-geronimo-activemq-users-archive@www.apache.org Received: (qmail 97224 invoked from network); 9 Sep 2006 07:09:46 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 9 Sep 2006 07:09:46 -0000 Received: (qmail 94305 invoked by uid 500); 9 Sep 2006 07:09:46 -0000 Delivered-To: apmail-geronimo-activemq-users-archive@geronimo.apache.org Received: (qmail 94285 invoked by uid 500); 9 Sep 2006 07:09:45 -0000 Mailing-List: contact activemq-users-help@geronimo.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: activemq-users@geronimo.apache.org Delivered-To: mailing list activemq-users@geronimo.apache.org Received: (qmail 94276 invoked by uid 99); 9 Sep 2006 07:09:45 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 09 Sep 2006 00:09:45 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of lists@nabble.com designates 72.21.53.35 as permitted sender) Received: from [72.21.53.35] (HELO talk.nabble.com) (72.21.53.35) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 09 Sep 2006 00:09:44 -0700 Received: from [72.21.53.38] (helo=jubjub.nabble.com) by talk.nabble.com with esmtp (Exim 4.50) id 1GLwxv-0000cC-J4 for activemq-users@geronimo.apache.org; Sat, 09 Sep 2006 00:09:23 -0700 Message-ID: <6221179.post@talk.nabble.com> Date: Sat, 9 Sep 2006 00:09:23 -0700 (PDT) From: kentdorsey To: activemq-users@geronimo.apache.org Subject: Re: JDBC persistence and slow scanning of removal of old messages In-Reply-To: <6795174F-9C10-4137-9D16-5518BBC5AEE4@aconex.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: kentdorsey@gmail.com References: <6795174F-9C10-4137-9D16-5518BBC5AEE4@aconex.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Paul Smith-2 wrote: > > We had a producer-consumer across the network using a topic, not > durable, but no TTL set on the messages, and I can't see anywhere > where it would set this as persistent, but somehow the messages are > appearing in the ACTIVEMQ_MSGS table, and are set with an expiration > value of 0, which means they never get deleted by the periodic task > in activemq that deals with that. Now, as it turns out we don't need > this producer-consumer anymore, so we're removing the code, but why > would a Topic message not explicitly set for persistence or durable > subscription be put in the DB in the first place? > Taken from javax.jms.Message: DEFAULT_DELIVERY_MODE The message producer's default delivery mode is PERSISTENT. Running into a similar problem with 3.2.1 on a client's project with the messages not being removed in a network of brokers on topics with non-durable subscriptions. Several related JIRA issues and forum messages recommend an upgrade to 4.x, but the project may not be able to do this, due to JMS version issues, if J2EE 1.4 is required. I notice that in related JIRA issues that the _consequences_ of persistent messages not being removed for topics and queues are addressed, but not the underlying issue of why they were not being removed in the first place. Trying to track down the issue in the source, but the logic for acknowledging and removing persisted non-durable topic messages is taking some time to trace. Kent -- View this message in context: http://www.nabble.com/JDBC-persistence-and-slow-scanning-of-removal-of-old-messages-tf1123353.html#a6221179 Sent from the ActiveMQ - User forum at Nabble.com.