Details
-
Bug
-
Resolution: Fixed
-
Major
-
4.0.0
-
Security Level: Public
-
None
-
400-1637
-
Untriaged
-
Unknown
Description
1. create index with defer_build=true - success
cbq> CREATE INDEX ind2 ON default(SequenceNumber) USING GSI WITH `
`;
{
"requestID": "0b2e42f0-aa11-4989-9f90-23536c135829",
"signature": null,
"results": [
],
"status": "success",
"metrics":
}
2. build index =-- success
cbq> BUILD INDEX ON default(ind2) USING GSI;
{
"requestID": "275e2ffb-8dbf-476a-bb7b-948e026aa49c",
"signature": null,
"results": [
],
"status": "success",
"metrics":
}
3. select * from system:indexes – shows the index is online
cbq> select * from system:indexes;
...
{
"indexes":
},
4. accidentally issue build index again,the error message should be "index already online/built" or so, instead it displays the index is not in Ready state.
cbq> BUILD INDEX ON default(ind2) USING GSI;
{
"requestID": "7cb10bf6-c117-4d8a-b902-71fdd782a493",
"signature": null,
"results": [
],
"errors": [
],
"status": "errors",
"metrics":
}
I assume this is a incorrect error and not actual state of index, since I get the right results on further queries using the same index. example below.
cbq> explain select * from default where SequenceNumber=252;
{
"requestID": "6f2b5509-ff4d-451e-8a22-9c9bf0077f8a",
"signature": "json",
"results": [
{
"#operator": "Sequence",
"~children": [
{
"#operator": "IndexScan",
"index": "ind2",
"keyspace": "default",
"limit": 9.223372036854776e+18,
"namespace": "default",
"spans": [
{
"Range":
,
"Seek": null
}
],
"using": "gsi"
},
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
,
,
{
"#operator": "InitialProject",
"result_terms": [
]
},
]
}
}
]
}
],
"status": "success",
"metrics":
}