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

Scan consistency queries not working on system events seq advances

    XMLWordPrintable

Details

    • Untriaged
    • 1
    • Yes
    • CX Sprint 265

    Description

      Queries using scan consistency (request_plus) on collections will never get to the required DCP state if a vbucket has its latest sequence number advanced due to a system event (e.g. some collection created/dropped).
      To reproduce:
      1. Create a bucket, scope, and a collection c1.
      2. Insert a single record in c1.
      3. Create Analytics collection on c1.
      4. Run scan consistency query (request_plus) on c1.
      The query will wait indefinitely if no scan_wait is specified.

      Attachments

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

        Activity

          Ascending order - Click to sort in descending order
          build-team Couchbase Build Team added a comment -

          Build couchbase-server-7.0.2-6698 contains cbas-core commit 80f0c3b with commit message:
          MB-48673: Advance storage DCP state on system events

          build-team Couchbase Build Team added a comment - Build couchbase-server-7.0.2-6698 contains cbas-core commit 80f0c3b with commit message: MB-48673 : Advance storage DCP state on system events
          build-team Couchbase Build Team added a comment -

          Build couchbase-server-7.1.0-1392 contains cbas-core commit 80f0c3b with commit message:
          MB-48673: Advance storage DCP state on system events

          build-team Couchbase Build Team added a comment - Build couchbase-server-7.1.0-1392 contains cbas-core commit 80f0c3b with commit message: MB-48673 : Advance storage DCP state on system events
          umang.agrawal Umang added a comment -

          As per Ali Alsuliman comment -
          1. Make sure you disable OSO
          PUT to /analytics/config/service and set enableOutOfOrderSnapshots to false
           
          2. Another way is to create an ephemeral bucket instead of disabling OSO. both should reproduce the issue.
          For Automation use step 1.

          umang.agrawal Umang added a comment - As per Ali Alsuliman  comment - 1. Make sure you disable OSO PUT to /analytics/config/service and set  enableOutOfOrderSnapshots  to false   2. Another way is to create an ephemeral bucket instead of disabling OSO. both should reproduce the issue. For Automation use step 1.
          umang.agrawal Umang added a comment -

          Verified with build 7.0.2-6698

          umang.agrawal Umang added a comment - Verified with build 7.0.2-6698

          People

            umang.agrawal Umang
            murtadha.hubail Murtadha Hubail
            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