Details
-
Bug
-
Resolution: Unresolved
-
Major
-
7.6.2
-
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 -