Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of marcello.nuccio@gmail.com
 designates 209.85.220.180 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAMWZAjmtO1S=XT3jpakdQejfLk+SCbVKxt8wjXcNJfML4tWpMg@mail.gmail.com>
References: 
 <CAMWZAjn2e6Ai8tDSpk9sifeZ8hkb_i7M0f_pT=WZdLPSQDByEg@mail.gmail.com>
	<CABvT1DGsmZbEiWkUTF7+8F5zFENaGTFz2PuQt=-7Mz4Jjrr7yg@mail.gmail.com>
	<CAMWZAjnB0pT=xAH4SEgo6224TEN_TyhRPYw7wjNKt1Pbo5G4pQ@mail.gmail.com>
	<CABvT1DE3p8p9OznfeniGuwmnhj7jntS6vMCP=53KvJzuxMZ7Hw@mail.gmail.com>
	<CAMWZAjmtO1S=XT3jpakdQejfLk+SCbVKxt8wjXcNJfML4tWpMg@mail.gmail.com>
Date: Tue, 15 Nov 2011 14:32:29 +0100
Message-ID: 
 <CAMWZAjmPQX2mqxgk1ihyzMcp9xfetnbct3i-mHQM_Nz6oMhOWw@mail.gmail.com>
Subject: Re: View row with doc==null
From: Marcello Nuccio <marcello.nuccio@gmail.com>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

2011/11/15 Marcello Nuccio <marcello.nuccio@gmail.com>:
> I've done some more testing:
>
> 1. I've restored the original db and view files (before compaction and cl=
eanup)
> 2. I've made a clone of the db and view with new name
> 3. Verified that everything works as expected, i.e. both db return
> identical results and all files are identical (done using curl and
> cmp).
>
> Here the tests:
>
> 1. Compacting the clone the row with doc=3D=3Dnull disappears.
> 2. Compacting the master the row is still here.

Ops sorry, I did those two tests with Futon and forcing reload did not
show the row in test 1. After clearing the cache completely, the row
with doc=3D=3Dnull is here.

I verified with curl and both dbs return the row with doc=3D=3Dnull.

The only way I have found to delete it, is to delete the view file.

Marcello


> 3. Comparing with cmp *.couch and *.view, they are identical.
> 4. Restarting couchdb does not help.
>
> What am I missing?
>
> Marcello
>
> 2011/11/15 Robert Newson <rnewson@apache.org>:
>> That does sound wrong but not sure what steps to suggest next.
>>
>> B.
>>
>> On 15 November 2011 12:22, Marcello Nuccio <marcello.nuccio@gmail.com> w=
rote:
>>> No.
>>>
>>> Marcello
>>>
>>> 2011/11/15 Robert Newson <rnewson@apache.org>:
>>>> Did you query with stale=3Dok?
>>>>
>>>> B.
>>>>
>>>> On 15 November 2011 11:10, Marcello Nuccio <marcello.nuccio@gmail.com>=
 wrote:
>>>>> Don't know how, but I have a view that returns the following row:
>>>>>
>>>>> =C2=A0 =C2=A0{"id":"510427_2011_1","key":["510427",2011,1],"value":1,=
"doc":null}
>>>>>
>>>>> i.e. it has doc=3D=3Dnull when queried with include_docs=3Dtrue. The =
doc
>>>>> with the given _id is deleted. The database is compacted. The views
>>>>> are compacted and cleaned (done via Futon). CouchDB is version 1.1.1
>>>>> built with build-couchdb on Ubuntu 11.10.
>>>>>
>>>>> Is this normal behaviour?
>>>>>
>>>>> Thanks,
>>>>> =C2=A0Marcello
>>>>>
>>>>
>>>
>>
>