Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (athena.apache.org: domain of paul.joseph.davis@gmail.com
 designates 209.85.161.180 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <8D5C952F-D0AA-4DCF-AD61-275203F79241@sri.com>
References: 
 <CAGxYWpZt_Joi-j2Jh+c4Fr3WsYdUXXgJJJOvXu4D_cBXbdZCsA@mail.gmail.com>
 <CAGxYWpY=bjxer2H3vChqRg0ZfqjiUg5wvr2X-_neem5VesoRPw@mail.gmail.com>
 <8D5C952F-D0AA-4DCF-AD61-275203F79241@sri.com>
From: Paul Davis <paul.joseph.davis@gmail.com>
Date: Sun, 20 May 2012 23:03:42 -0500
Message-ID: 
 <CAJ_m3YBEDSV=6VUZsu979H7CMSDZE3zFW3CUjQhHZffDASBrXg@mail.gmail.com>
Subject: Re: purging documents?
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Yeah, likely the best way to undo this would be to use filtered
replication to a local db and then rename the .couch files and reboot
to get it swapped over.

On Fri, May 18, 2012 at 1:02 PM, Jim Klo <jim.klo@sri.com> wrote:
> Not sure how many docs you have, but can you filter replicate the good do=
cs
> into a new db?
>
>
> Jim Klo
> Senior Software Engineer
> Center for Software Engineering
> SRI International
>
> On May 18, 2012, at 10:39 AM, Tim Tisdall wrote:
>
> After further reading it seems like I could use _purge ... =A0However, I
> still need to query the DB to fetch all the revisions.
>
> On Fri, May 18, 2012 at 12:12 PM, Tim Tisdall <tisdall@gmail.com> wrote:
>
> I accidentally created several million documents in my DB which I'd like
>
> to undo. =A0^_^ =A0I know I can query each document to get the revision a=
nd
>
> then issue a DELETE, but that seems like a lot of additional work. =A0Als=
o,
>
> the wiki says "Deleted documents remain in the database forever, even aft=
er
>
> compaction, to allow eventual consistency when replicating." and that's a
>
> lot of dead space. =A0Is there a way that I can purge all of those docume=
nts
>
> given that I have the _ids that they were saved under? =A0I essentially w=
ould
>
> like to return the DB to a state before I inserted all of those documents=
.
>
>
> I'm also going to be inserting updated documents to the DB with those sam=
e
>
> _ids, so another alternative is to post updates to each (but that would
>
> also require getting the revision ids) and then clearing out old revision=
s.
>
> However, this would require fetching several million revision ids and the=
n
>
> figuring out how to force the DB to clear out all old revisions.
>
>
> -Tim
>
>
>