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

2.7.4 Backport CBG-882 - Align channels query ORDER BY with index

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.8.0, 2.7.1, 2.7.2
    • Fix Version/s: 2.7.4
    • Component/s: SyncGateway
    • Security Level: Public
    • Labels:
      None
    • Sprint:
      CBG Sprint 57
    • Story Points:
      3

      Description

      The channels query ORDER BY that was added for safety results in performance degradation for very large channels. It should be rewritten to align with the index definition:

      ORDER BY [op.name, LEAST(meta(`write`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)]

      Also need to review performance scenarios to understand why this degradation wasn't identified there.

        Attachments

          Issue Links

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

            Activity

            Hide
            build-team Couchbase Build Team added a comment -

            Build sync_gateway-2.7.4-4 contains sync_gateway commit b47a4ee with commit message:
            CBG-885: Backport CBG-882 (#4780)

            Show
            build-team Couchbase Build Team added a comment - Build sync_gateway-2.7.4-4 contains sync_gateway commit b47a4ee with commit message: CBG-885 : Backport CBG-882 (#4780)

              People

              Assignee:
              jacques.rascagneres Jacques Rascagneres
              Reporter:
              adamf Adam Fraser
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Gerrit Reviews

                  There are no open Gerrit changes

                    PagerDuty