[COUCHDB-1279] Deleted documents persist in View results

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Cannot Reproduce
• Affects Version/s: 1.0.3
• Component/s: Database Core

Environment

CouchDB 1.0.3, Centos 64 bit

• Skill Level: Dont Know
• Assignee: Unassigned
• Reporter: Chris Gomez
• Created: 13/Sep/11 08:51
• Updated: 13/Dec/13 14:46
• Resolved: 13/Dec/13 14:46

Description

Previously deleted documents are returned as results in a View.

View results yield

{ error: not_found, reason: deleted }

when queried by id and are not returned in _all_docs.

Compacting the database does not fix the issue. Deleting the View and rebuilding did not fix the issue. Deleting the view then compacting, then rebuilding the view did not fix the issue. Currently, the only way I know how to get around it is to delete/rebuild the database.

These documents would have been deleted programmatically, so I can't be certain about the exact create/update/delete scenario the have gone through. These particular documents could have been around for a long while before I even noticed them. The biggest issue I have with this bug is that it means I can't bulk delete any documents when this bug occurs because of the update conflict it creates.

May be related: http://stackoverflow.com/questions/7323285/couchdb-views-not-being-updated-after-delete