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

Not able to create indexes with "with nodes" clause when encryption mode is set to strict and tls is enforced

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • Morpheus
    • 7.6.2
    • secondary-index
    • None
    • Untriaged
    • 0
    • Unknown

    Description

      Build - 7.6.2-3622

      Steps to repro

      • Cluster config - kv-index:n1ql-index:n1ql-index:n1ql
      • Set cluster encryption mode to strict and enforce tls
      • Create a bucket and load both default and named namespace
      • Create indexes with the "with node" clause 
      • The index creation fails with below error
      • The query does work when it is run in the cluster ui

      Query :

      CREATE INDEX `hotel1c27ccbff13a40b2b8e87fc6d26a5e38price` ON default:test_bucket.test_scope_1.test_collection_1(price) USING GSI  WITH {'nodes': ['172.23.217.217:18091', '172.23.217.216:18091', '172.23.107.26:18091'], 'defer_build': False, 'num_replica': 2} 

      Error and the curl call for the query

       

      Curl request 
       
      POST https://172.23.107.26:18093/query?statement=CREATE+INDEX+%60hotel1c27ccbff13a40b2b8e87fc6d26a5e38price%60+ON+default%3Atest_bucket.test_scope_1.test_collection_1%28price%29+USING+GSI++WITH+%7B%27nodes%27%3A+%5B%27172.23.217.217%3A18091%27%2C+%27172.23.217.216%3A18091%27%2C+%27172.23.107.26%3A18091%27%5D%2C+%27defer_build%27%3A+False%2C+%27num_replica%27%3A+2%7D body:  headers: {'Content-Type': 'application/x-www-form-urlencoded', 'Authorization': 'Basic QWRtaW5pc3RyYXRvcjpwYXNzd29yZA==', 'Accept': '*/*'} 
       
      error
       
      error: 500 reason: unknown b'{\n"requestID": "6e303958-48cc-4511-bf77-9c0286a3d3e5",\n"signature": null,\n"results": [\n],\n"errors": [{"code":5000,"msg":"GSI CreateIndex() - cause: Index creation for index hotel1c27ccbff13a40b2b8e87fc6d26a5e38price, bucket test_bucket, scope test_scope_1, collection test_collection_1 cannot start. Reason: Create index or Alter replica cannot proceed due to another concurrent create index request.. Could not schedule index creation in the background. Reason: Indexer node (172.23.217.217:18091) not found. The node may be failed or under rebalance or network partitioned from query process.","reason":{"_level":"exception","caller":"secondary_index:605","cause":{"error":"Index creation for index hotel1c27ccbff13a40b2b8e87fc6d26a5e38price, bucket test_bucket, scope test_scope_1, collection test_collection_1 cannot start. Reason: Create index or Alter replica cannot proceed due to another concurrent create index request.. Could not schedule index creation in the background.","reason":"Indexer node (172.23.217.217:18091) not found. The node may be failed or under rebalance or network partitioned from query process.","source":"CreateIndex()"},"code":4350,"icause":"Index creation for index hotel1c27ccbff13a40b2b8e87fc6d26a5e38price, bucket test_bucket, scope test_scope_1, collection test_collection_1 cannot start. Reason: Create index or Alter replica cannot proceed due to another concurrent create index request.. Could not schedule index creation in the background. Reason: Indexer node (172.23.217.217:18091) not found. The node may be failed or under rebalance or network partitioned from query process.","key":"indexing.error","message":"GSI CreateIndex()"}}],\n"status": "fatal",\n"metrics": {"elapsedTime": "294.038976ms","executionTime": "293.89411ms","resultCount": 0,"resultSize": 0,"serviceLoad": 62,"errorCount": 1}\n}\n' auth: Administrator:password

       

      Logs -

      test_1 10.zip

       

      Attachments

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

        Activity

          People

            dhananjay.kshirsagar Dhananjay Kshirsagar
            yash.dodderi Yash Dodderi
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty