CouchDB
  1. CouchDB
  2. COUCHDB-1279

Deleted documents persist in View results

    Details

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

      CouchDB 1.0.3, Centos 64 bit

    • Skill Level:
      Dont Know

      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

        Activity

        Dave Cottlehuber made changes -
        Status Reopened [ 4 ] Closed [ 6 ]
        Resolution Cannot Reproduce [ 5 ]
        Jan Lehnardt made changes -
        Affects Version/s 1.0.3 [ 12316107 ]
        Affects Version/s 1.2 [ 12315198 ]
        Jan Lehnardt made changes -
        Environment OS X 10.6.8, Couchbase Server 2.0.0-dev4 CouchDB 1.0.3, Centos 64 bit
        Jan Lehnardt made changes -
        Resolution Not A Problem [ 8 ]
        Status Resolved [ 5 ] Reopened [ 4 ]
        Jan Lehnardt made changes -
        Field Original Value New Value
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Not A Problem [ 8 ]
        Chris Gomez created issue -

          People

          • Assignee:
            Unassigned
            Reporter:
            Chris Gomez
          • Votes:
            2 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development