2011/11/15 Marcello Nuccio <[email protected]>: > I've done some more testing: > > 1. I've restored the original db and view files (before compaction and > cleanup) > 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==null 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==null is here. I verified with curl and both dbs return the row with doc==null. 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 <[email protected]>: >> That does sound wrong but not sure what steps to suggest next. >> >> B. >> >> On 15 November 2011 12:22, Marcello Nuccio <[email protected]> wrote: >>> No. >>> >>> Marcello >>> >>> 2011/11/15 Robert Newson <[email protected]>: >>>> Did you query with stale=ok? >>>> >>>> B. >>>> >>>> On 15 November 2011 11:10, Marcello Nuccio <[email protected]> >>>> wrote: >>>>> Don't know how, but I have a view that returns the following row: >>>>> >>>>> {"id":"510427_2011_1","key":["510427",2011,1],"value":1,"doc":null} >>>>> >>>>> i.e. it has doc==null when queried with include_docs=true. 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, >>>>> Marcello >>>>> >>>> >>> >> >
