Uploaded image for project: 'Couchbase Gateway'
  1. Couchbase Gateway
  2. CBG-673

Include USE INDEX hint with channel queries

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Major
    • 2.8.0
    • None
    • SyncGateway
    • Security Level: Public
    • CBG Sprint 40, CBG Sprint 41
    • 3

    Description

      The channel queries rely on the channel index being picked by the query service, but we should specify a USE INDEX hint, which forces the index to be used, or fail if it doesn't exist.

      If a primary index happens to be defined on the bucket (maybe for dev-time purposes), the query service will randomly pick between the channel index and the primary index when issuing a channel query, which will impact performance non-deterministically.

      This can be reproduced sporadically by running TestCoveringQueries when a primary index is defined on the bucket.

      Attachments

        Issue Links

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

          Activity

            People

              ben.brooks Ben Brooks
              ben.brooks Ben Brooks
              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