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

query service fails to see a collection

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 7.0.0
    • Cheshire-Cat
    • query
    • Untriaged
    • 1
    • Unknown

    Description

      Intermittently, the query service will fail to see a collection that exists. 

      In this test, 1000 collections are created and loaded with 20,000 docs and then the following query is run for different random keys and different random collections: 

      SELECT * FROM default:`bucket-1`.`scope-1`.`collection-1` USE KEYS[$1]

      The sdk attempts to prepare this query for each collection. Query service returns an error for one of the queries:

      SELECT * FROM default:`bucket-1`.`scope-1`.`collection-521` USE KEYS[$1];

      {
      "errors": [

      { "code": 12003, "msg": "Keyspace not found in CB datastore: default:bucket-1.scope-1.collection-521", "query_from_user": "explain SELECT * FROM default:`bucket-1`.`scope-1`.`collection-521` USE KEYS[$1];" }

      ]
      }

      However, collection-521 exists and all other queries on different collections work fine.

       

      https://cb-jira.s3.us-east-2.amazonaws.com/logs/qe/collectinfo-2020-08-20T190143-ns_1%40172.23.100.45.zip
      https://cb-jira.s3.us-east-2.amazonaws.com/logs/qe/collectinfo-2020-08-20T190143-ns_1%40172.23.100.55.zip
      https://cb-jira.s3.us-east-2.amazonaws.com/logs/qe/collectinfo-2020-08-20T190143-ns_1%40172.23.100.70.zip
      https://cb-jira.s3.us-east-2.amazonaws.com/logs/qe/collectinfo-2020-08-20T190143-ns_1%40172.23.100.71.zip
      https://cb-jira.s3.us-east-2.amazonaws.com/logs/qe/collectinfo-2020-08-20T190143-ns_1%40172.23.100.72.zip
      https://cb-jira.s3.us-east-2.amazonaws.com/logs/qe/collectinfo-2020-08-20T190143-ns_1%40172.23.100.73.zip

      Attachments

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

        Activity

          People

            marco.greco Marco Greco (Inactive)
            korrigan.clark Korrigan Clark (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty