[COUCHDB-999] Detect view indexes with duplicates in them

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.11.2, 1.0.1
• Fix Version/s: 1.0.2, 1.1
• Component/s: Database Core
• Assignee: Unassigned
• Reporter: Adam Kocoloski
• Created: 29/Dec/10 03:53
• Updated: 28/May/13 14:52
• Resolved: 03/Jan/11 21:46

Description

In COUCHDB-968 we discovered and fixed a bug that could introduce duplicate documents in a database. Under certain circumstances these duplicate documents would introduce duplicate entries in view indexes.

We can detect duplicates in the view group by looking for duplicate entries in the docid => view key btree. We can try to repair the view indexes by removing the extra keys from the views, or we can just report that duplicates exist in the view group and direct the user to rebuild that group. We might incorporate this code into the view compactor, or we might release it as a separate standalone tool.

I think my personal preference is to include any repair functionality in the view compactor. A separate standalone tool that simply reports the presence of duplicates would also be a nice thing to have.

Issue Links

• is related to: COUCHDB-968 Duplicated IDs in _all_docs
• relates to: COUCHDB-1769 Duplicates in View indexes