[COUCHDB-1769] Duplicates in View indexes

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 1.3, 1.4.0
• Component/s: JavaScript View Server
• Assignee: Unassigned
• Reporter: Stefan Kögl
• Created: 13/Apr/13 18:59
• Updated: 02/Sep/18 06:42
• Resolved: 02/Sep/18 06:42

Description

The compaction of a view (created with CouchDB 1.3) failed due to view_duplicate_id. The database to which the view belongs was created with 1.2.x but compacted (with the 0-byte-compact-file trick) with 1.3.

A full log of the failed compaction can be found at

https://friendpaste.com/1AL050bzwyLCa9KJUKJw1u

I experienced the same behaviour already with previous versions but assumed it might be gone with 1.3, but this seems not to be the case.

When such duplicates happen (and appear during compaction), they seem to be at the beginning of the view index. The view in question has the following _info:

{"name":"listeners","view_index":{"signature":"854a8065b438b3e53fcdbbe0a79a8e80","language":"javascript","disk_size":2679632207,"data_size":1026614011,"update_seq":58353111,"purge_seq":0,"updater_running":false,"compact_running":false,"waiting_commit":false,"waiting_clients":0}}

Compaction stopped with a 39M large .compact.view file.

Also the problem seems to happen only one some machines.

Issue Links

• is related to: COUCHDB-968 Duplicated IDs in _all_docs
• is related to: COUCHDB-999 Detect view indexes with duplicates in them