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

NEST query hanging

    XMLWordPrintable

Details

    • Untriaged
    • Yes

    Description

      In 6.5.0-2715 and up.

      Create default bucket

      Create primary index on default

      CREATE INDEX ix1 ON default(docid,name)
      CREATE INDEX ix2 ON default(docid,name) where type = "wdoc"
      CREATE INDEX ix3 ON default(altid, name, DISTINCT ARRAY p FOR p IN phones END)

       

      INSERT into default (key , value) VALUES ("w001",

      {'docid': 'x001', 'altid': 'x001', 'type': 'wdoc', 'name': 'wdoc', 'phones': ['123-456-7890', '123-456-7891']}

      )
      INSERT into default (key , value) VALUES ("pdoc1",

      {'docid': 'x001', 'altid': 'x001', 'type': 'pdoc', 'name': 'pdoc', 'phones': ['123-456-7890', '123-456-7891']}

      )
      INSERT into default (key , value) VALUES ("pdoc2",

      {'docid': 'w001', 'altid': 'w001', 'type': 'pdoc', 'name': 'pdoc', 'phones': ['123-456-7890', '123-456-7891']}

      )

       

      Then run: 
      SELECT meta(b1).id b1id from default b1 NEST default b2 ON KEY b2.docid FOR b1 WHERE meta(b1).id > ""

      This query will hang forever even though there are only 3 documents.

       

      Logs are attached

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            korrigan.clark Korrigan Clark (Inactive)
            korrigan.clark Korrigan Clark (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty