Return-Path: X-Original-To: apmail-couchdb-user-archive@www.apache.org Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 7A56E9545 for ; Wed, 18 Apr 2012 08:48:31 +0000 (UTC) Received: (qmail 87394 invoked by uid 500); 18 Apr 2012 08:48:29 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 87363 invoked by uid 500); 18 Apr 2012 08:48:29 -0000 Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@couchdb.apache.org Delivered-To: mailing list user@couchdb.apache.org Received: (qmail 87345 invoked by uid 99); 18 Apr 2012 08:48:29 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 18 Apr 2012 08:48:29 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of dave@muse.net.nz designates 209.85.212.52 as permitted sender) Received: from [209.85.212.52] (HELO mail-vb0-f52.google.com) (209.85.212.52) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 18 Apr 2012 08:48:21 +0000 Received: by vbzb23 with SMTP id b23so6756814vbz.11 for ; Wed, 18 Apr 2012 01:48:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=muse.net.nz; s=google; h=mime-version:x-originating-ip:in-reply-to:references:date :message-id:subject:from:to:content-type:content-transfer-encoding; bh=YDlabCX2sp9dOpgd8OzQnc1J0733X2Kes6qrh+jvHUU=; b=PmjcANVFLPktNjL7Qfci21YItjDG40JlOV+trjojWQpEJEMRKoVME5HRiH3i6GydFL 3B9YMqLC9k61xhwV9uS2Ux6FfaCZ+fPbnhRUpL74yD5HlYuPEFq+5dYmGK55xe66wRJb HiBOWMxercUYOtGo9aYBoyN4QCghK8RO0EIzg= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=mime-version:x-originating-ip:in-reply-to:references:date :message-id:subject:from:to:content-type:content-transfer-encoding :x-gm-message-state; bh=YDlabCX2sp9dOpgd8OzQnc1J0733X2Kes6qrh+jvHUU=; b=Ly7UMhPCo5WrcekkygXDmHFciNCdaujw2VM4lKoZuPRs4bmudzrdotf4M8LWBIx7KV 2ndXI9Ml+BMezyuww02f4p9E/5G0+JAELDcE77ylQSE+g0VmmpHHFsKWpTqXO6xk1Jqb jnzCdW/kd5E24vPiUF38k7Iz+HFsMW1dcgChelNMmn7RKgVt5oDUChp5X1Au6NTpB4Co k36R3ZM2Vci6DBDPsIm1lOZUY3TZj4JUaNQgzc7dLepW0suqbLeF7En+q346apeF2ONl hBkmjUKZgAOT5Uy3I4mT3b/y3wmN5apBEXo/gkATvNhtR6Dx8aMKRgbMNmDE53gUBGpk qhVg== MIME-Version: 1.0 Received: by 10.52.33.67 with SMTP id p3mr609136vdi.18.1334738880530; Wed, 18 Apr 2012 01:48:00 -0700 (PDT) Received: by 10.52.107.233 with HTTP; Wed, 18 Apr 2012 01:48:00 -0700 (PDT) X-Originating-IP: [84.112.19.176] In-Reply-To: References: Date: Wed, 18 Apr 2012 10:48:00 +0200 Message-ID: Subject: Re: view_duplicated_id on CouchDB 1.2 From: Dave Cottlehuber To: user@couchdb.apache.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Gm-Message-State: ALoCoQk9Rq0d6Ph63ZIL8eioacgYbGNo+2YXE5DBGiCwwpFLMIB2W5b/vvVkHqqklKBzZzj++Nwl On 18 April 2012 08:52, Stefan K=F6gl wrote: > Hi, > > Compaction of one of my views stopped with the following error > {"error":"view_duplicated_id","reason":"8c40fc1a160920a958b95e8d111aabb0"= } > (full log at https://friendpaste.com/6n5skP4QKfAGZNGMcYPHAR). The view > and underlying database have been built and compacted with CouchDB > 1.2. > > As discussed with dch in IRC yesterday, I'm trying to fix the problem > temporarily by making a whitespace change to one of the views in the > group (to change its sig), upload it with another name and index it. > After it is built, I'll copy it over the broken view. However the view > rebuild takes a few days and I'm afraid I will run out of disk space > in the meantime because of the growing view. Is there any other way to > get rid of the duplicate in the view? > > > Thanks, > > Stefan Hi Stefan, There's some background reading[1],[2],[3] where the issue of duplicate docs and revision limits is discussed in some depth, although these specific issues were resolved prior to 1.2.0 & I can't replicate those specific issues again in 1.2.0. [1]: https://issues.apache.org/jira/browse/COUCHDB-999 [2]: https://issues.apache.org/jira/browse/COUCHDB-968 [3]: https://issues.apache.org/jira/browse/COUCHDB-888 BTW what is the rev_limit on that db, any chance of having gone over it for some docs, and subsequently replicated between nodes? $COUCH/db/_revs_limit to query the per-db limit. A+ Dave