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

[BP To 7.1.5/7.2.1 MB-56914 ] SELECT on system:functions_cache in a multi query node cluster yields incomplete results with warnings

    XMLWordPrintable

Details

    • Untriaged
    • 0
    • Yes

    Description

      1. Set up a cluster with more than 1 query node 
      2. Create a function on each query node
      3. Query system:functions_cache - 

      SELECT * FROM system:functions_cache;

            4. The query will return only those function cache entries on the query node that the query was fired to. And does not return all function cache entries across all query nodes. The query also returns a warning: 

       

      "warnings": [
              {
                  "code": 11008,
                  "msg": "System datastore : scan on /admin/indexes/functions_cache failed - cause: object not found"
              }
          ]
      

      Issue Resolution
      Querying system:functions_cache in a multi query node cluster returned incomplete results with warnings. The query result included entries in the local query node, but none from remote query nodes. This was due to a typographical error. The typographical error has been corrected.

      Attachments

        Activity

          People

            pierre.regazzoni Pierre Regazzoni
            Sitaram.Vemulapalli Sitaram Vemulapalli
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              PagerDuty