Return-Path: X-Original-To: apmail-activemq-users-archive@www.apache.org Delivered-To: apmail-activemq-users-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 6BD9CD7FF for ; Tue, 13 Nov 2012 11:50:06 +0000 (UTC) Received: (qmail 6008 invoked by uid 500); 13 Nov 2012 11:50:06 -0000 Delivered-To: apmail-activemq-users-archive@activemq.apache.org Received: (qmail 5777 invoked by uid 500); 13 Nov 2012 11:50:03 -0000 Mailing-List: contact users-help@activemq.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@activemq.apache.org Delivered-To: mailing list users@activemq.apache.org Received: (qmail 5729 invoked by uid 99); 13 Nov 2012 11:50:01 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 13 Nov 2012 11:50:01 +0000 X-ASF-Spam-Status: No, hits=0.6 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS,URI_HEX X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of torsten@fusesource.com designates 209.85.214.43 as permitted sender) Received: from [209.85.214.43] (HELO mail-bk0-f43.google.com) (209.85.214.43) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 13 Nov 2012 11:49:54 +0000 Received: by mail-bk0-f43.google.com with SMTP id jf20so233858bkc.2 for ; Tue, 13 Nov 2012 03:49:33 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=content-type:mime-version:subject:from:in-reply-to:date :content-transfer-encoding:message-id:references:to:x-mailer :x-gm-message-state; bh=bgYaeZh+ms/Ewn5KvHuP3rZJcctmq+ZTbLf9U5s6RmA=; b=fSoQ4nc3Cuk4Vx4TirVIVcfbKBS8FFA2Z1F3uoX8+StSTcTLF5MJ709ikWUTiNuspv a+Y9EXQpV/80cUtPsd4zypBEgJwAJhUccBwzOi3cy0ZcawRJ4oAagGN0UFoxh5vCFcFG 8pogRQaAmlFBguSgnBi3e1cIM9VpUslMNX7CQYMiDAUZ0kwdZ0BxfSVjVuyM06RkbhN1 qa6O/M6UaN7lIeOC6yDhZjD1WkUdZ5XPNx6fGO+gLA98mVEgvdAiaIQ9Z6KkU65nV37U KbohOTtmPBc3uFtIfY92C0YyuNRyIxw6oc2FjUkY2sU+C8ddsgEaUCLDQbIjoSmILaVC 929A== Received: by 10.204.156.81 with SMTP id v17mr7885735bkw.49.1352807372483; Tue, 13 Nov 2012 03:49:32 -0800 (PST) Received: from [192.168.178.31] (p57BD614F.dip0.t-ipconnect.de. [87.189.97.79]) by mx.google.com with ESMTPS id 9sm5265665bkq.13.2012.11.13.03.49.31 (version=TLSv1/SSLv3 cipher=OTHER); Tue, 13 Nov 2012 03:49:31 -0800 (PST) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Apple Message framework v1085) Subject: Re: Mass-moving messages From: Torsten Mielke In-Reply-To: <1352797144071-4659228.post@n4.nabble.com> Date: Tue, 13 Nov 2012 12:49:29 +0100 Content-Transfer-Encoding: quoted-printable Message-Id: <90DE2FB1-6045-4BE6-89CE-9F531064F252@fusesource.com> References: <1352797144071-4659228.post@n4.nabble.com> To: users@activemq.apache.org X-Mailer: Apple Mail (2.1085) X-Gm-Message-State: ALoCoQlisRS5f5go+JQ/16sVlqkTZRe1X1skrj8XKU4v+Mu0qUzbWbHaGPKehqBPk8a680Py7nIk X-Virus-Checked: Checked by ClamAV on apache.org I don't think its recommended to simply move the files in your database. = This would bring the journal out of sync. Perhaps it worked in 5.3 but I = don't think thats a good way to do.=20 If you really need to move msgs from one queue to another you should use = some external tool. The broker exposes a number of JMX operations which also allows you to = move messages to different destinations. So using jconsole you can move = messages.=20 Alternatively it is very simple to write a little Camel route that moves = all msgs from the DLQ to the messages original destination.=20 Please note that messages on DLQ can have different origins. There is a = message header that specifies the original destination name. The Camel = route could route messages based on this header.=20 Hope this helps. Torsten Mielke torsten@fusesource.com tmielke.blogspot.com On Nov 13, 2012, at 9:59 AM, Tobb wrote: > Hi, >=20 > We recently updated from AMQ 5.3.0 to AMQ 5.6.0. We are using a = database for > storing persistent messages, with journaled mode (in AMQ 5.3.0 it was > JournaledPersistenceAdapter, in 5.6.0 = JournaledPersistenceAdapterFactory). > We recently had a problem with 4000 messages ending up in a = dead-letter > queue, and because of the number of messages we moved them in the = database. > But then, a problem occured: ActiveMQ wouldn't restart, due to some = error > with the journal-files (i'm guessing because of a mismatch between the > journal and the database). So, we had to remove the journal files to = get AMQ > up and running again. This was not the case with AMQ 5.3.0, we could = move > messages in the database without having trouble with journals. >=20 > So, my question is: What is the recommended way of moving a lot of = messages > at once when using a journaled persistence adapter with a = SQL-database? >=20 > -Tobb >=20 >=20 >=20 > -- > View this message in context: = http://activemq.2283324.n4.nabble.com/Mass-moving-messages-tp4659228.html > Sent from the ActiveMQ - User mailing list archive at Nabble.com.