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

refresh_cluster_map fails with ERROR 199 :  N1QL: Invalid query service endpoint

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • Morpheus
    • 7.1.0
    • query
    • None
    • 7.1.0-2551
    • Untriaged
    • 1
    • Unknown

    Description

      refresh_cluster_map command returns ERROR 199

      # /opt/couchbase/bin/cbq -u Administrator -p password -e couchbase://172.23.104.90
       Connected to : http://172.23.104.90:8091/. Type Ctrl-D or \QUIT to exit. Path to history file for the shell : /root/.cbq_history 
      cbq> \refresh_cluster_map;
       ERROR 199 :  N1QL: Invalid query service endpoint. 
      
      

      Note that issue above is on first attempt. If I run one query first the refresh_map will work

      cbq> select 1;
      {
          "requestID": "0937aa90-0f23-4be1-8660-353823f30dab",
          "signature": {
              "$1": "number"
          },
          "results": [
          {
              "$1": 1
          }
          ],
          "status": "success",
          "metrics": {
              "elapsedTime": "1.165093ms",
              "executionTime": "971.268µs",
              "resultCount": 1,
              "resultSize": 23,
              "serviceLoad": 6
          },
          "profile": {
      ...
              "requestTime": "2022-04-19T14:48:09.718-07:00",
              "servicingHost": "172.23.104.90:8091",
      ...
          }
      }
      cbq> \refresh_cluster_map;
      cbq> select 1;
      {
          "requestID": "8b7e4cbb-774b-4e04-82e0-33a64a601021",
          "signature": {
              "$1": "number"
          },
          "results": [
          {
              "$1": 1
          }
          ],
          "status": "success",
          "metrics": {
              "elapsedTime": "1.115136ms",
              "executionTime": "912.802µs",
              "resultCount": 1,
              "resultSize": 23,
              "serviceLoad": 6
          },
          "profile": {
      ...
              "requestTime": "2022-04-19T14:48:32.449-07:00",
              "servicingHost": "172.23.104.92:8091",
      ...
          }
      }
       

       

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty