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

cbq : Unable to connect to cluster using 8091 port

    XMLWordPrintable

Details

    • Untriaged
    • Yes

    Description

      Build : 6.5.0-4218
      Last known good build : 6.5.0-4169
      Possible change that could have caused the regression :

      Commit: ab6d8e9af451b140e00365492554e744a0689334 in build: 6.5.0-4189
         MB-35490, MB-35237 - Add support for the following 1. Auto discovery of Analytics nodes (along with N1QL) for cbq using option --analytics. and 2. Alternate address support for the same using --networkconfig.
         
         Change-Id: I1f1b86a37d139706579157b0ead529476eac9855
         Reviewed-on: http://review.couchbase.org/113666
         Reviewed-by: Sitaram Vemulapalli <sitaram.vemulapalli@couchbase.com>
         Reviewed-by: Johan Larson <johan.larson@couchbase.com>
         Tested-by: Isha Kandaswamy <isha@couchbase.com>
      

      On a single node cluster, connecting to cluster using cbq via 8091 port results in an error - ERROR 100 : N1QL: Alternate Addresses required. Using port 8093, it works fine.

      root@deb91-qe:/opt/couchbase/bin# /opt/couchbase/bin/cbq  -engine=http://172.23.96.55:8091/ -q -u Administrator -p password -s="SELECT * FROM system:keyspaces"
       ERROR 100 : N1QL: Alternate Addresses required.
       
       ERROR 107 : Not connected to any cluster. Use \CONNECT command.
       
      root@deb91-qe:/opt/couchbase/bin# /opt/couchbase/bin/cbq  -engine=http://127.0.0.1:8093^C
      root@deb91-qe:/opt/couchbase/bin# /opt/couchbase/bin/cbq  -engine=http://172.23.96.55:8093/ -q -u Administrator -p password -s="SELECT * FROM system:keyspaces"
      {
          "requestID": "6619402e-da0b-480c-b12d-ad6ec3a18cc8",
          "signature": {
              "*": "*"
          },
          "results": [
          ],
          "status": "success",
          "metrics": {
              "elapsedTime": "4.658701ms",
              "executionTime": "4.581223ms",
              "resultCount": 0,
              "resultSize": 0
          }
      }
      root@deb91-qe:/opt/couchbase/bin# /opt/couchbase/bin/cbq  -engine=http://172.23.96.55:8093 -q -u Administrator -p password -s="SELECT * FROM system:keyspaces"
      {
          "requestID": "0f4f44d9-63f9-415c-8978-2e4753a436b0",
          "signature": {
              "*": "*"
          },
          "results": [
          ],
          "status": "success",
          "metrics": {
              "elapsedTime": "5.095207ms",
              "executionTime": "5.019844ms",
              "resultCount": 0,
              "resultSize": 0
          }
      }
      

      On build 6.5.0-4169, this used to work fine with either ports - 8091/8093.

      root@deb91-qe:/tmp# /opt/couchbase/bin/cbq  -engine=http://172.23.96.55:8093 -q -u Administrator -p password -s="SELECT * FROM system:keyspaces"
      {
          "requestID": "947a3e56-be34-41a4-9eb9-84a335bb152f",
          "signature": {
              "*": "*"
          },
          "results": [
          ],
          "status": "success",
          "metrics": {
              "elapsedTime": "5.589239ms",
              "executionTime": "5.486449ms",
              "resultCount": 0,
              "resultSize": 0
          }
      }
      root@deb91-qe:/tmp# /opt/couchbase/bin/cbq  -engine=http://172.23.96.55:8091/ -q -u Administrator -p password -s="SELECT * FROM system:keyspaces"
      {
          "requestID": "74a191da-4bbe-4dc3-9d16-e74f539be771",
          "signature": {
              "*": "*"
          },
          "results": [
          ],
          "status": "success",
          "metrics": {
              "elapsedTime": "5.131577ms",
              "executionTime": "5.040666ms",
              "resultCount": 0,
              "resultSize": 0
          }
      }
      

      This was tested on a VM where alternate addr is not configured.

      Attachments

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

        Activity

          People

            hemant.rajput Hemant Rajput
            mihir.kamdar Mihir Kamdar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty