Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-5707

View index with a big int fails badly at some value threshold

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 2.0
    • 2.0-developer-preview-4
    • 3rd-party, view-engine
    • Security Level: Public
    • None
    • This is all assuming DP4 on CentOS 5.8:

    Description

      Given sample doc structure:

      { "_id": "0830c075-2a81-448a-80d6-85214ee3ad64", "_rev": "1-0015b2c01f0a39310000023f00000000", "$flags": 0, "$expiration": 0, "docId": "0830c075-2a81-448a-80d6-85214ee3ad64", "conversationId": "0c872a9ba58143119d477850a5c02ac3", "timeStamp": 13403751757202, "msg": "\r\nvery clearly revealed something unexpectedly coarse and unpleasant.\r\n\r\n\"And why are children born to such men as you? If you were not a father\r\nthere would be", "status": "If you don't have a nasty obituary you probably didn't matter.\n\t\t-- Freeman Dyson\n", }

      Also note there are a bunch of records milliseconds later than this one.

      Given view function:

      function (doc) {
      emit([doc.conversationId, doc.timeStamp], doc);

      With the following two "filter results":
      ?endkey=["0c872a9ba58143119d477850a5c02ac3",13990000000000]&startkey=["0c872a9ba58143119d477850a5c02ac3",13403751757202]&limit=10&skip=0
      ?endkey=["0c872a9ba58143119d477850a5c02ac3",13900000000000]&startkey=["0c872a9ba58143119d477850a5c02ac3",13403751757202]&limit=10&skip=0

      With the first filter result I get my 10 records back. In the second case I get this result:

      {"error":"query_parse_error","reason":"No rows can match your key range, reverse your start_key and end_key or set descending=true"}

      Note the only change in the two filter results is changing the one '9' to a '0' in the endkey timeStamp value. With all the stored documents for this conversationId crowded around the startkey timeStamp, both these should have returned the same thing.

      Attachments

        For Gerrit Dashboard: MB-5707
        # Subject Branch Project Status CR V

        Activity

          People

            deepkaran.salooja Deepkaran Salooja
            wryder William Ryder
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty