Details
-
Bug
-
Resolution: Fixed
-
Critical
-
4.0.0
-
Security Level: Public
-
Untriaged
-
-
Unknown
Description
Build
4.0.0-3321
System test- KV + XDCR + TPCC
Setup
8 node cluster
4 index nodes - 3 dedicated index nodes, one kv+index node
Index RAM quota 1GB
Dropping old index returns success, when we try to create a new index with same name, "GSI CreateIndex() - cause: Duplicate Index Instance" error is thrown. However when build index is issued immediately after, it says index not found. Is this due to a lag in broadcasting index create/drop across index nodes?
|
|
Pls note: before drop index was issued, all buckets were deleted and recreated. Ideally that should have deleted the index.
|
|
|
>drop index CUSTOMER.CU_ID_D_ID_W_ID USING GSI
|
{u'status': u'success', u'metrics': {u'elapsedTime': u'439.728517ms', u'executionTime': u'438.808184ms', u'resultSize': 0, u'resultCount': 0}, u'results': [], u'requestID': u'9c445f4d-f31d-42ec-98cc-53f6bf471f7f', u'signature': None}
|
|
|
> drop index CUSTOMER.CU_W_ID_D_ID_LAST USING GSI
|
{u'status': u'success', u'metrics': {u'elapsedTime': u'116.345713ms', u'executionTime': u'115.470899ms', u'resultSize': 0, u'resultCount': 0}, u'results': [], u'requestID': u'd055e5fd-9d28-4b4e-8660-c393beeb9868', u'signature': None}
|
|
|
> create index CU_ID_D_ID_W_ID on CUSTOMER(C_ID, C_D_ID, C_W_ID) using gsi WITH {"defer_build":true}
|
{u'status': u'errors', u'errors': [{u'msg': u'GSI CreateIndex() - cause: Duplicate Index Instance', u'code': 5000}], u'results': [], u'metrics': {u'elapsedTime': u'8.863847338s', u'executionTime': u'8.863263517s', u'resultSize': 0, u'resultCount': 0, u'errorCount': 1}, u'requestID': u'4a3e821b-de8e-4690-9e35-326462af9608', u'signature': None}
|
|
|
> create index CU_W_ID_D_ID_LAST on CUSTOMER(C_W_ID, C_D_ID, C_LAST) using gsi WITH {"defer_build":true}
|
{u'status': u'success', u'metrics': {u'elapsedTime': u'606.030943ms', u'executionTime': u'605.107476ms', u'resultSize': 0, u'resultCount': 0}, u'results': [], u'requestID': u'aa0d914d-4e26-4ac7-b62b-35ca4a45734c', u'signature': None}
|
|
|
> build index on CUSTOMER(CU_ID_D_ID_W_ID, CU_W_ID_D_ID_LAST) using gsi
|
{u'status': u'errors', u'errors': [{u'msg': u'GSI index CU_ID_D_ID_W_ID not found.', u'code': 5000}], u'results': [], u'metrics': {u'elapsedTime': u'50.904849ms', u'executionTime': u'47.631712ms', u'resultSize': 0, u'resultCount': 0, u'errorCount': 1}, u'requestID': u'680f476a-e03f-4aaa-ae3e-49ed597322f2', u'signature': None}
|
|