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

go_n1ql : Cannot connect to cluster when the cluster contains multiple nodes and cannot connect to a VM

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Test Blocker
    • 4.5.0
    • 4.5.0
    • query
    • Security Level: Public
    • None
    • Untriaged
    • Unknown

    Description

      go_cbq> \CONNECT http://127.0.0.1:9000;

      Couchbase query shell connected to http://127.0.0.1:9000 . Type Ctrl-D / \exit / \quit to exit.
      go_cbq> select * from system:keyspaces;
       Error in sql Ping 
       ERROR 5000 : N1QL: Failed to execute query {"caller":"clustering_cb:323","code":2080,"key":"admin.clustering.no_such_node","message":"No such  node "} 
      

      However when I failover one node and then rerun the above query :

      go_cbq> select * from system:keyspaces;
       
      {
      "requestID": "5353bd43-1313-4f7c-9c6d-2c3e21380597",
      "signature": [*],
      "results" : [
                      {
        "keyspaces": {
          "datastore_id": "http://127.0.0.1:9000",
          "id": "b1",
          "name": "b1",
          "namespace_id": "default"
        }
      }, 
                      {
        "keyspaces": {
          "datastore_id": "http://127.0.0.1:9000",
          "id": "b2",
          "name": "b2",
          "namespace_id": "default"
        }
      }, 
                      {
        "keyspaces": {
          "datastore_id": "http://127.0.0.1:9000",
          "id": "beer-sample",
          "name": "beer-sample",
          "namespace_id": "default"
        }
      }, 
                      {
        "keyspaces": {
          "datastore_id": "http://127.0.0.1:9000",
          "id": "default",
          "name": "default",
          "namespace_id": "default"
        }
      }
              ],
              
      "status": success,
      "metrics":      {
        "elapsedTime": "132.973871ms",
        "executionTime": "132.954073ms",
        "resultCount": 4,
        "resultSize": 864
      }
      }
       
      go_cbq> 
      

      Attachments

        1. Fail3.png
          Fail3.png
          1.45 MB
        2. Fail2.png
          Fail2.png
          1.46 MB
        3. Fail1.png
          Fail1.png
          1.43 MB
        For Gerrit Dashboard: MB-16956
        # Subject Branch Project Status CR V

        Activity

          People

            manik Manik Taneja (Inactive)
            isha Isha Kandaswamy (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