couchdb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sebastian Cohnen (JIRA)" <j...@apache.org>
Subject [jira] Created: (COUCHDB-968) Duplicated IDs in _all_docs
Date Fri, 26 Nov 2010 11:04:13 GMT
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.


Mime
View raw message