Details
-
Bug
-
Resolution: Fixed
-
Critical
-
4.0.0
-
Security Level: Public
-
Untriaged
-
Centos 64-bit
-
-
Unknown
Description
Build
4.0.0-3465
Seen in KV + XDCR + tpcc system test
Steps
1. bucket ram quota: 12.5 GB, indexer ram quota: 256MB, 8 node cluster, 1 index node, 2 query nodes, all nodes have data services enabled.
2. Create 9 tpcc buckets of total size 11gb
3. Create secondary indexes on all buckets, one at a time.
Live cluster - http://172.23.105.44:8091/index.html
> 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'success', u'metrics': {u'elapsedTime': u'199.22469ms', u'executionTime': u'199.153461ms', u'resultSize': 0, u'resultCount': 0}, u'results': [], u'requestID': u'748dfbec-6065-4333-98dd-5e8a76d85831', 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'152.757701ms', u'executionTime': u'152.689254ms', u'resultSize': 0, u'resultCount': 0}, u'results': [], u'requestID': u'e44e8179-af26-46ae-bff7-a4a1246f2ffd', 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'BuildIndexes - cause: Error Connecting KV 127.0.0.1:8091 Err BucketSeqnos(): got ts only for 0 vbs', u'code': 5000}], u'results': [], u'metrics': {u'elapsedTime': u'176.526108ms', u'executionTime': u'176.386873ms', u'resultSize': 0, u'resultCount': 0, u'errorCount': 1}, u'requestID': u'42c15ac8-d104-469f-a09f-449245151820', u'signature': None}
|
|
|
> create index DI_ID_W_ID on DISTRICT(D_ID, D_W_ID) using gsi WITH {"defer_build":true}
|
{u'status': u'success', u'metrics': {u'elapsedTime': u'276.142233ms', u'executionTime': u'276.034797ms', u'resultSize': 0, u'resultCount': 0}, u'results': [], u'requestID': u'be719a9d-02c9-46ce-8739-ce550fd92720', u'signature': None}
|
|
|
> build index on DISTRICT(DI_ID_W_ID) using gsi
|
{u'status': u'errors', u'errors': [{u'msg': u'BuildIndexes - cause: Error Connecting KV 127.0.0.1:8091 Err BucketSeqnos(): got ts only for 0 vbs', u'code': 5000}], u'results': [], u'metrics': {u'elapsedTime': u'344.166213ms', u'executionTime': u'344.036881ms', u'resultSize': 0, u'resultCount': 0, u'errorCount': 1}, u'requestID': u'ae50e0bf-2cd5-4ed0-b135-472142c57bc1', u'signature': None}
|
Could not build any indexes. Pls see screenshot showing Error against all indexes.
Including log from .50, the index node.
