Duplicated IDs in _all_docs --------------------------- Key: COUCHDB-968 URL: https://issues.apache.org/jira/browse/COUCHDB-968 Project: CouchDB Issue Type: Bug Components: Database Core Affects Versions: 1.0.1, 1.0.2 Environment: Ubuntu 10.04. Reporter: Sebastian Cohnen
We have a database, which is causing serious trouble with compaction and replication (huge memory and cpu usage, often causing couchdb to crash b/c all system memory is exhausted). Yesterday we discovered that db/_all_docs is reporting duplicated IDs (see [1]). Until a few minutes ago we thought that there are only few duplicates but today I took a closer look and I found 10 IDs which sum up to a total of 922 duplicates. Some of them have only 1 duplicate, others have hundreds. Some facts about the database in question: * ~13k documents, with 3-5k revs each * compaction is run on a daily bases * several thousands updates per hour * multi-master setup with pull replication from each other Unfortunately the database's contents are confidential and I'm not allowed to publish it. [1]: Part of http://localhost:5984/DBNAME/_all_docs ... {"id":"9997","key":"9997","value":{"rev":"6096-603c68c1fa90ac3f56cf53771337ac9f"}}, {"id":"9999","key":"9999","value":{"rev":"6097-3c873ccf6875ff3c4e2c6fa264c6a180"}}, {"id":"9999","key":"9999","value":{"rev":"6097-3c873ccf6875ff3c4e2c6fa264c6a180"}}, ... -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.