Details
-
Bug
-
Resolution: Fixed
-
Critical
-
4.0.0
-
Security Level: Public
-
400-2213
-
Untriaged
-
Unknown
Description
created an index default(p2) before loading all the bucket data.
create index p2 on default(name) using gsi
- after all the data was loaded, decided to drop the index p2.
Drop index stmt goes through successfully.
- select * from system:indexes where keyspace_id="default" - shows this index no longer exists
cbq> select * from system:indexes where keyspace_id="default";
{
"requestID": "c488f72e-45f8-47f8-b753-ca10d3900c63",
"signature": { "*": "*" },
"results": [
Unknown macro: { "indexes"},
Unknown macro: { "indexes"},
Unknown macro: { "indexes"}],
{ "elapsedTime": "1.466690496s", "executionTime": "1.466390323s", "resultCount": 3, "resultSize": 1348 }
"status": "success",
"metrics":}
The UI ( attached screenhot) continues to display the dropped index -
I waited for over an hour, did multiple other server operations like - restart couchbase service, issue queries - waiting for the index UI to eventually catchup
But it never does - Both the Index page and the main UI continues to display stale p2 index data.