Details
-
Bug
-
Resolution: Fixed
-
Test Blocker
-
4.0.0
-
Security Level: Public
-
None
-
4.0.0-2212, (first reported w/ 4.0.0-2210)
-
Untriaged
-
Yes
Description
Attached screenshot - The index tab shows zero indexes, when actually there are all the indexes created and present on the system
cbq> select * from system:indexes;
{
"requestID": "dafeb87e-d993-4c49-99bd-1fe610b053a5",
"signature":
,
"results": [
{
"indexes":
},
{
"indexes":
},
{
"indexes":
},
{
"indexes":
},
{
"indexes":
},
{
"indexes":
},
{
"indexes":
},
{
"indexes":
},
{
"indexes":
},
{
"indexes":
},
{
"indexes":
},
{
"indexes":
},
{
"indexes":
},
{
"indexes":
},
{
"indexes":
},
{
"indexes":
},
{
"indexes":
},
{
"indexes":
},
{
"indexes":
},
{
"indexes":
},
{
"indexes":
}
],
"status": "success",
"metrics":
}
Ketakis-MacBook-Pro:~ ketaki$ curl -v -u Administrator:password 10.6.2.167:9102/getIndexStatus | jq '.'
- About to connect() to 10.6.2.167 port 9102 (#0)
- Trying 10.6.2.167...
- Adding handle: conn: 0x7ff072803000
- Adding handle: send: 0
- Adding handle: recv: 0
- Curl_addHandleToPipeline: length: 1
- - Conn 0 (0x7ff072803000) send_pipe: 1, recv_pipe: 0
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
0 0 0 0 0 0 0 0 -::- -::- -::- 0* Connected to 10.6.2.167 (10.6.2.167) port 9102 (#0) - Server auth using Basic with user 'Administrator'
> GET /getIndexStatus HTTP/1.1
> Authorization: Basic QWRtaW5pc3RyYXRvcjpwYXNzd29yZA==
> User-Agent: curl/7.30.0
> Host: 10.6.2.167:9102
> Accept: /
>
< HTTP/1.1 200 OK
< Content-Type: application/json
< Date: Thu, 21 May 2015 20:27:34 GMT
< Transfer-Encoding: chunked
<
{ [data not shown]
100 5054 0 5054 0 0 8950 0 -::- -::- -::- 8945 - Connection #0 to host 10.6.2.167 left intact
{
"code": "success",
"status": [
{ "defnId": 2948788576932524000, "name": "PX_DISTRICT", "bucket": "DISTRICT", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX PX_DISTRICT ON DISTRICT USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 },
{ "defnId": 16514549499724260000, "name": "IT_ID", "bucket": "ITEM", "secExprs": [ "`I_ID`" ], "status": "Created", "definition": "CREATE INDEX IT_ID ON ITEM(`I_ID`) USING GSI", "hosts": [ "10.6.2.164:8091" ] }
,
{ "defnId": 6347745770254066000, "name": "CU_ID_D_ID_W_ID", "bucket": "CUSTOMER", "secExprs": [ "`C_ID`", "`C_D_ID`", "`C_W_ID`" ], "status": "Ready", "definition": "CREATE INDEX CU_ID_D_ID_W_ID ON CUSTOMER(`C_ID`,`C_D_ID`,`C_W_ID`) USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }
,
{ "defnId": 7388454981199029000, "name": "px_history", "bucket": "HISTORY", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX px_history ON HISTORY USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }
,
{ "defnId": 16057076511480343000, "name": "PX_NEW_ORDER", "bucket": "NEW_ORDER", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX PX_NEW_ORDER ON NEW_ORDER USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }
,
{ "defnId": 742446641166899300, "name": "OR_O_ID_D_ID_W_ID", "bucket": "ORDERS", "secExprs": [ "`O_ID`", "`O_D_ID`", "`O_W_ID`", "`O_C_ID`" ], "status": "Ready", "definition": "CREATE INDEX OR_O_ID_D_ID_W_ID ON ORDERS(`O_ID`,`O_D_ID`,`O_W_ID`,`O_C_ID`) USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }
,
{ "defnId": 14930033748487664000, "name": "PX_ORDER_LINE", "bucket": "ORDER_LINE", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX PX_ORDER_LINE ON ORDER_LINE USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }
,
{ "defnId": 7130809708697467000, "name": "PX_STOCK", "bucket": "STOCK", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX PX_STOCK ON STOCK USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }
,
{ "defnId": 1914246229383967500, "name": "PX_WAREHOUSE", "bucket": "WAREHOUSE", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX PX_WAREHOUSE ON WAREHOUSE USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }
,
{ "defnId": 1947175649914730500, "name": "seq_num", "bucket": "default", "secExprs": [ "`SequenceNumber`" ], "status": "Ready", "definition": "CREATE INDEX seq_num ON default(`SequenceNumber`) USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }
,
{ "defnId": 14714050097088166000, "name": "PX_ORDERS", "bucket": "ORDERS", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX PX_ORDERS ON ORDERS USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }
,
{ "defnId": 8818315269599462000, "name": "OL_O_ID_D_ID_W_ID", "bucket": "ORDER_LINE", "secExprs": [ "`OL_O_ID`", "`OL_D_ID`", "`OL_W_ID`" ], "status": "Ready", "definition": "CREATE INDEX OL_O_ID_D_ID_W_ID ON ORDER_LINE(`OL_O_ID`,`OL_D_ID`,`OL_W_ID`) USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }
,
{ "defnId": 2310287351459228000, "name": "ST_W_ID_I_ID1", "bucket": "STOCK", "secExprs": [ "`S_W_ID`", "`S_I_ID`" ], "status": "Ready", "definition": "CREATE INDEX ST_W_ID_I_ID1 ON STOCK(`S_W_ID`,`S_I_ID`) USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }
,
{ "defnId": 5343469794527548000, "name": "PX_ITEM", "bucket": "ITEM", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX PX_ITEM ON ITEM USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }
,
{ "defnId": 9786892988415705000, "name": "NO_D_ID_W_ID", "bucket": "NEW_ORDER", "secExprs": [ "`NO_O_ID`", "`NO_D_ID`", "`NO_W_ID`" ], "status": "Ready", "definition": "CREATE INDEX NO_D_ID_W_ID ON NEW_ORDER(`NO_O_ID`,`NO_D_ID`,`NO_W_ID`) USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }
,
{ "defnId": 10877996760542466000, "name": "OR_W_ID_D_ID_C_ID", "bucket": "ORDERS", "secExprs": [ "`O_W_ID`", "`O_D_ID`", "`O_C_ID`" ], "status": "Ready", "definition": "CREATE INDEX OR_W_ID_D_ID_C_ID ON ORDERS(`O_W_ID`,`O_D_ID`,`O_C_ID`) USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }
,
{ "defnId": 18060261279731250000, "name": "WH_ID", "bucket": "WAREHOUSE", "secExprs": [ "`W_ID`" ], "status": "Ready", "definition": "CREATE INDEX WH_ID ON WAREHOUSE(`W_ID`) USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }
,
{ "defnId": 6488449869761483000, "name": "px_default", "bucket": "default", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX px_default ON default USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }
,
{ "defnId": 18445874003306080000, "name": "PX_CUSTOMER", "bucket": "CUSTOMER", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX PX_CUSTOMER ON CUSTOMER USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }
,
{ "defnId": 16984861669742903000, "name": "CU_W_ID_D_ID_LAST", "bucket": "CUSTOMER", "secExprs": [ "`C_W_ID`", "`C_D_ID`", "`C_LAST`" ], "status": "Ready", "definition": "CREATE INDEX CU_W_ID_D_ID_LAST ON CUSTOMER(`C_W_ID`,`C_D_ID`,`C_LAST`) USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }
,
{ "defnId": 13524412555528772000, "name": "DI_ID_W_ID", "bucket": "DISTRICT", "secExprs": [ "`D_ID`", "`D_W_ID`" ], "status": "Ready", "definition": "CREATE INDEX DI_ID_W_ID ON DISTRICT(`D_ID`,`D_W_ID`) USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }]
}
Attachments
| For Gerrit Dashboard: MB-15101 | ||||||
|---|---|---|---|---|---|---|
| # | Subject | Branch | Project | Status | CR | V |
| 51344,1 | MB-15101: missing completion percentage on deferred index | unstable | indexing | Status: MERGED | +2 | +1 |
| 51352,1 | MB-15101: missing completion percentage on deferred index | sherlock-beta | indexing | Status: MERGED | +2 | +1 |