Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-15143

[system test] UI contains stale index information - continues to display dropped indexes as still a part of the system

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 4.0.0
    • 4.0.0
    • UI
    • 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"}

        ],
        "status": "success",
        "metrics":

        { "elapsedTime": "1.466690496s", "executionTime": "1.466390323s", "resultCount": 3, "resultSize": 1348 }

        }

      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.

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            pavel Pavel Blagodov
            ketaki Ketaki Gangal (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty