Details
-
Bug
-
Resolution: Duplicate
-
Critical
-
4.0.0
-
Security Level: Public
-
None
-
400-2213
bucket -default
items 13M
3 gsi indexes
-
Untriaged
-
Unknown
Description
create indexes - primary, SeqNum on default prior to loading data
load 13M items
create another index on Amount on default after the data is loaded
The system:indexes shows presence of this index in pending state
cbq> select * from system:indexes where keyspace_id="default";
{
"requestID": "c488f72e-45f8-47f8-b753-ca10d3900c63",
"signature":
,
"results": [
{
"indexes":
},
{
"indexes":
},
{
"indexes":
}
],
"status": "success",
"metrics":
}
The UI does not capture this as an index present and is possibly in "Building" or "created" state.
Attached screenshot
We should display indexes once defined on the bucket on the Indexes page - while it is still under "Building/Created" state?
Logs
https://s3.amazonaws.com/cb-customers/query/3/collectinfo-2015-05-26T180444-ns_1%4010.6.2.164.zip
https://s3.amazonaws.com/cb-customers/query/3/collectinfo-2015-05-26T180444-ns_1%4010.6.2.167.zip
https://s3.amazonaws.com/cb-customers/query/3/collectinfo-2015-05-26T180444-ns_1%4010.6.2.168.zip
https://s3.amazonaws.com/cb-customers/query/3/collectinfo-2015-05-26T180444-ns_1%4010.6.2.194.zip
https://s3.amazonaws.com/cb-customers/query/3/collectinfo-2015-05-26T180444-ns_1%4010.6.2.195.zip
https://s3.amazonaws.com/bugdb/15145/10_232_4.tar
The getIndexStatus shows the newly created index at completion of 83%
{ "defnId": 17501865627472710000, "name": "amt", "bucket": "default", "secExprs": [ "(((((`AirItineraryPricingInfo`.`PTC_FareBreakdowns`).`PTC_FareBreakdown`).`PassengerFare`).`TotalFare`).`Amount`)" ], "status": "Building", "definition": "CREATE INDEX amt ON default((((((`AirItineraryPricingInfo`.`PTC_FareBreakdowns`).`PTC_FareBreakdown`).`PassengerFare`).`TotalFare`).`Amount`)) USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 83 } ]
}