I haven't compacted the database. When I get the document, I am
specifying the revision that appears in the output from _changes. This
output includes many deleted documents. Most of these I am able to
retrieve in this way but there are a few exceptions for which I get the
404 error. Those for which I get the 404 error appear only once in the
output from _changes, so I assume the revision is the latest. In any
case, something makes these few documents different from the other
deleted documents. I don't yet know what has caused them to be
different, which is what I would like to know.
After compacting a database, is it normal for revisions of documents to
appear in the output of _changes despite them having been removed from
the database and unavailable to get, even with the revision specified?
Other than a continuous changes feed, in which a document may appear
repeatedly, my observation (not very thorough but I haven't yet seen an
exception) has been that each document appears only once and the
latest/winning revision appears. It seems odd that an unavailable
revision would appear.
On 26/12/2016 13:35, Robert Newson wrote:
Deleted docs return 404 when fetched, that's normal. If you're fetching an
older revision than the latest, it will also be missing if you've compacted the
database.
Sent from my iPhone
On 24 Dec 2016, at 17:32, Ian Goodacre <ian.gooda...@xtra.co.nz> wrote:
Hi all,
I am running CouchDB 1.6.1 on Linux.
I have a database that has many deleted documents and I am able to retrieve
most of these but there are a few that I am unable to retrieve. When I attempt
to retrieve these, I get 404 with error 'not_found' and reason 'missing'.
I would like to understand why these few documents are different - why am I
unable to retrieve these deleted documents?
For example, _changes response includes:
{
"deleted": true,
"changes": [
{
"rev": "2-338d783957e141566caf3662cc0726bb"
}
],
"id": "assets_0000245",
"seq": 2355
},
When I attempt to retrieve this with:
http://localhost:5984/dcm_assets_tp/assets_0000245?rev=2-338d783957e141566caf3662cc0726bb
I get a 404 response.
I am expecting to get the deleted document, even it if only contains _id, _rev
and _deleted.
Also, I don't understand the response to
curl --noproxy '*' -X GET
'http://localhost:5984/dcm_assets_tp/assets_0000245?open_revs=all'
which is
--a341c8902ae323bd6ea7d938bc0c2ac5--
And I get the same in response to
http://localhost:5984/dcm_assets_tp/assets_0000245?revs=true&open_revs=all
But, if I add -H 'Accept: application/json' then I get an empty array ([]):
curl --noproxy '*' -X GET -H 'Accept: application/json'
'http://localhost:5984/dcm_assets_tp/assets_0000245?open_revs=all'
I must be misunderstanding something (or a lot of things). Any help would be
appreciated.
Regards,
Ian
