Return-Path: Delivered-To: apmail-jackrabbit-users-archive@locus.apache.org Received: (qmail 54644 invoked from network); 28 Oct 2008 18:37:46 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 28 Oct 2008 18:37:46 -0000 Received: (qmail 16250 invoked by uid 500); 28 Oct 2008 18:37:49 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 16235 invoked by uid 500); 28 Oct 2008 18:37:49 -0000 Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@jackrabbit.apache.org Delivered-To: mailing list users@jackrabbit.apache.org Received: (qmail 16214 invoked by uid 99); 28 Oct 2008 18:37:49 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 28 Oct 2008 11:37:49 -0700 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [143.209.238.162] (HELO audl953.usa.alcatel.com) (143.209.238.162) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 28 Oct 2008 18:36:37 +0000 Received: from usdalsbhs02.ad3.ad.alcatel.com (usdalsbhs02.usa.alcatel.com [172.22.216.13]) by audl953.usa.alcatel.com (ALCANET) with ESMTP id m9SIaEME012674 for ; Tue, 28 Oct 2008 12:36:14 -0600 Received: from USDALSMBS02.ad3.ad.alcatel.com ([172.22.216.7]) by usdalsbhs02.ad3.ad.alcatel.com with Microsoft SMTPSVC(6.0.3790.2499); Tue, 28 Oct 2008 13:36:14 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: RE: Snapshot of local data (in sync with DB) Date: Tue, 28 Oct 2008 13:36:19 -0500 Message-ID: <01E8A990E317A1409EEC9E6858B09B9502416AE1@USDALSMBS02.ad3.ad.alcatel.com> In-Reply-To: <91f3b2650810200759u37aeb2c6k5957af070b875644@mail.gmail.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Snapshot of local data (in sync with DB) Thread-Index: AckyyMUITOBBV+lITxiNrPhUrIRvuwGYiuwA From: "MARTINEZ Antonio" To: X-OriginalArrivalTime: 28 Oct 2008 18:36:14.0616 (UTC) FILETIME=[0EC8E180:01C9392C] X-Scanned-By: MIMEDefang 2.64 on 143.209.238.34 X-Virus-Checked: Checked by ClamAV on apache.org Hello, I have a follow up question. Currently we lock the MySql DB before taking backup with FLUSH TABLES = WITH READ LOCK, which closes all open tables and locks all tables for = all databases with a read lock until you explicitly release the lock by = executing UNLOCK TABLES. Can we guarantee that while we have this lock in the DB, JackRabbit will = not update the local index files, even if the application tries to save = something in the repository? If so we could use that lock to safely copy = as well the local indexing (which would be in sync with the DB) Thanks, Antonio =20 -----Original Message----- From: Thomas M=FCller [mailto:thomas.mueller@day.com]=20 Sent: Monday, October 20, 2008 8:00 AM To: users@jackrabbit.apache.org Subject: Re: Snapshot of local data (in sync with DB) Hi, > Do you think I will ALWAYS be able to start JackRabbit using that = DB+index data (that might not be consistent). Yes, I believe you will always be able to starting the repository. > I do not care about having some inconsistent data, my concern is if = there is a possibility that JackRabbit would not be able to start and = fix the index. In many cases, inconsistent data is a problem. Currently, fixing the = index means re-building the index. If the index is quite small, that's = not a problem. Regards, Thomas