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

          murtadha.hubail Murtadha Hubail created issue -
          murtadha.hubail Murtadha Hubail made changes -
          Field Original Value New Value
          Labels candidate-for-7.0.2
          till Till Westmann made changes -
          Assignee Till Westmann [ till ] Murtadha Hubail [ murtadha.hubail ]
          murtadha.hubail Murtadha Hubail made changes -
          Sprint CX Sprint 265 [ 1813 ]
          murtadha.hubail Murtadha Hubail made changes -
          Rank Ranked higher
          murtadha.hubail Murtadha Hubail made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          dmitry.lychagin Dmitry Lychagin made changes -
          Labels candidate-for-7.0.2 candidate-for-7.0.2 triaged
          wayne Wayne Siu made changes -
          Link This issue blocks MB-46308 [ MB-46308 ]
          wayne Wayne Siu made changes -
          Labels candidate-for-7.0.2 triaged approved-for-7.0.2 candidate-for-7.0.2 triaged

          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 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
          murtadha.hubail Murtadha Hubail made changes -
          Assignee Murtadha Hubail [ murtadha.hubail ] Umang [ JIRAUSER24787 ]
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          umang.agrawal Umang made changes -
          Labels approved-for-7.0.2 candidate-for-7.0.2 triaged approved-for-7.0.2 candidate-for-7.0.2 needs_automation triaged
          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
          umang.agrawal Umang made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          till Till Westmann made changes -
          Labels approved-for-7.0.2 candidate-for-7.0.2 needs_automation triaged approved-for-7.0.2 needs_automation triaged

          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