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

Index is not selected for range updates

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 5.5.0
    • 5.5.0
    • query
    • None

    Description

      Our UP4 benchmarks stopped working in the latest weekly build 5.1.0-1511. Last known good build is 5.1.0-1480.

      Index:

      CREATE INDEX by_capped_small ON `bucket-1`(capped_small);
      

      Queries:

      UPDATE `bucket-1` SET name = name||'_UPDATED' WHERE capped_small=$1;
      

      Failure:

      {'status': 'fatal', 'metrics': {'executionTime': '694.41µs', 'resultCount': 0, 'elapsedTime': '716.125µs', 'resultSize': 0, 'errorCount': 1}, 'errors': [{'code': 4000, 'msg': 'No index available on keyspace bucket-1 that matches your query. Use CREATE INDEX or CREATE PRIMARY INDEX to create an index, or check that your expected index is online.'}]}
      

      Attachments

        Issue Links

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

          Activity

            People

              pavelpaulau Pavel Paulau (Inactive)
              pavelpaulau Pavel Paulau (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty