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

Index build is failing when specifying secure port

    XMLWordPrintable

Details

    • Triaged
    • Unknown

    Description

      Problem

      Index is failed to be built when specifying secure admin port 18091 on the nodes.

      Background

      Sometimes Sysadmin block port 8091 due to security reasons.

      Hence this issue is not allowing this systems to create an index on a specific node.

      steps to reproduce

      1. make sure port 18091 is accessible 
      2. make sure you have query and index service on that node
      3. try to create an index while specifying the secure port

      create index ix_foo on `travel-sample` (field_xx) 
      WITH { "nodes":[ "cb001.localdomain:18091" ]}
      

      1. Index create fails

      [
        {
          "code": 5000,
          "msg": "GSI CreateIndex() - cause: Indexer node (cb001.localdomain:18091) not found. The node may be failed or under rebalance or network partitioned from query process.",
          "query": "create index ix_foo on `travel-sample` (field_xx) \nWITH { \"nodes\":[ \"cb001.localdomain:18091\" ] }"
        }
      ]
      

      5. it works with specifying port 8091.

      It is failing with 6.5.0 and 6.0.3, I haven't checked for earlier releases but I guess it is failing as well.

       

      Attachments

        Issue Links

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

          Activity

            Build couchbase-server-7.0.2-6530 contains indexing commit 5f19427 with commit message:
            MB-37671 : [BP to 7.0.2] Allow specifying secure port in query

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.0.2-6530 contains indexing commit 5f19427 with commit message: MB-37671 : [BP to 7.0.2] Allow specifying secure port in query
            sai.teja Sai Krishna Teja added a comment - - edited

            Steps to Verify

            1. Create a 3 node cluster with KV,Index,Index
            2. Disable Auto Failover, Enable node to node encryption, Set Cluster Encryption level to Strict
            3. Try to create index with specify the node and name should contain the tls port in it
            > CREATE INDEX `idx_name` ON `default`(`name`) WITH

            { "nodes":[ "127.0.0.1:19001" ] }

            Note: Due to MB-47916 the changes cannot be verified on cluster_run we will need to verify using vagrant.

            sai.teja Sai Krishna Teja added a comment - - edited Steps to Verify 1. Create a 3 node cluster with KV,Index,Index 2. Disable Auto Failover, Enable node to node encryption, Set Cluster Encryption level to Strict 3. Try to create index with specify the node and name should contain the tls port in it > CREATE INDEX `idx_name` ON `default`(`name`) WITH { "nodes":[ "127.0.0.1:19001" ] } Note: Due to MB-47916 the changes cannot be verified on cluster_run we will need to verify using vagrant.

            Build couchbase-server-7.0.2-6530 contains indexing commit 5f19427 with commit message:
            MB-37671 : [BP to 7.0.2] Allow specifying secure port in query

            sai.teja Sai Krishna Teja added a comment - Build couchbase-server-7.0.2-6530 contains indexing commit 5f19427 with commit message: MB-37671 : [BP to 7.0.2] Allow specifying secure port in query

            Build couchbase-server-7.1.0-1162 contains indexing commit 5d8d6f1 with commit message:
            MB-37671 : Allow specifying secure port in query

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.1.0-1162 contains indexing commit 5d8d6f1 with commit message: MB-37671 : Allow specifying secure port in query

            Validated on 7.0.2-6620

            create index idx3 on test.test_scope_1.test_collection_1(test) with {"nodes": ["172.23.136.198:18091"]};
             
            {
              "results": []
            }

             

            hemant.rajput Hemant Rajput added a comment - Validated on 7.0.2-6620 create index idx3 on test.test_scope_1.test_collection_1(test) with {"nodes": ["172.23.136.198:18091"]};   { "results": [] }  

            People

              sai.teja Sai Krishna Teja
              roi.katz Roi Katz
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty