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

stale index data?

    XMLWordPrintable

Details

    • Bug
    • Resolution: Incomplete
    • Major
    • 4.5.0
    • 4.5.0
    • secondary-index
    • None
    • Untriaged
    • Unknown

    Description

      Build 2009

      I'm not sure how best to diagnose this, but I am seeing some odd issues with the query workbench and cbq.

      I created an index (defer=true if it matters) and then when I tried to drop that same index a few seconds later, it said that it could not be found:
      [

      { "code": 5000, "msg": "GSI index table2 not found.", "query_from_user": "drop index default.table2;" }

      ]

      The indexes are present in the UI as well as system:indexes.

      There don't seem to be any errors in the query.log on the node of the workbench:
      2016-04-08T20:55:40.319+00:00 [Info] CreateIndex 16530289148314509367 test/table2 using:GSI exprType:N1QL partnExpr: whereExpr`type` = "table1") secExprs:[`uid` `update_time` `deleted` `datauuid`] isPrimary:false with:

      {"defer_build":true}

      - elapsed(66.889399ms) err(<nil>)
      2016-04-08T20:55:41.523+00:00 [Info] serviceChangeNotifier: received PoolChangeNotification
      2016-04-08T20:55:41.554+00:00 [Info] Refreshing indexer list due to cluster changes or auto-refresh.
      2016-04-08T20:55:41.554+00:00 [Info] Refreshed Indexer List: [ec2-54-219-64-21.us-west-1.compute.amazonaws.com:9100]

      Attachments

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

        Activity

          People

            perry Perry Krug
            perry Perry Krug
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty