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

Upgraded environment - indexes loses data and new index creation stalled

    XMLWordPrintable

Details

    Description

      Build : 6.5.0-4926
      Last known good build : 6.5.0-4924

      Steps to reproduce :
      1. 2 node cluster with kv+index+query on all nodes running 5.1.0 release
      2. Install all 3 sample buckets
      3. Run query - select city from `travel-sample` where city is not null; - should return 7341 docs
      4. Do an offline upgrade on both the nodes to 6.5.0-4926 build.
      5. Post upgrade, observe that the indexes do not have all the docs as before the upgrade.
      6. Running query in step#3 returns fewer docs - 19 in my environment. This is data loss post upgrade.
      7. Create index - create index idx1 on `travel-sample`(name,city) partition by hash(meta().id) with

      {"num_replica":1}

      - never completes, is stalled.

      Performed the same test with different combinations:
      1. 5.1.0 -> 6.5.0-4926 = issue is seen
      2. 5.1.0 -> 6.5.0-4924 = issue is not seen.
      3. 5.0.1 -> 6.5.0-4926 = issue is seen

      This means this issue is directly related to the fix that went in 6.5.0-4925 for MB-36948.
      http://172.23.120.24/builds/latestbuilds/couchbase-server/mad-hatter/4925/CHANGELOG

      Attachments

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

        Activity

          mihir.kamdar Mihir Kamdar (Inactive) created issue -
          owend Daniel Owen made changes -
          Field Original Value New Value
          Assignee Daniel Owen [ owend ] Jim Walker [ jwalker ]
          deepkaran.salooja Deepkaran Salooja made changes -
          Component/s secondary-index [ 11211 ]
          owend Daniel Owen made changes -
          Sprint KV Sprint 2019-12 [ 939 ]
          owend Daniel Owen made changes -
          Rank Ranked higher
          jwalker Jim Walker made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          owend Daniel Owen made changes -
          Triage Untriaged [ 10351 ] Triaged [ 10350 ]
          lynn.straus Lynn Straus made changes -
          Labels functional-test approved-for-mad-hatter functional-test
          lynn.straus Lynn Straus made changes -
          Due Date 11/Dec/19
          drigby Dave Rigby made changes -
          Link This issue blocks MB-36676 [ MB-36676 ]
          drigby Dave Rigby made changes -
          Assignee Jim Walker [ jwalker ] Mihir Kamdar [ mihir.kamdar ]
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          ritam.sharma Ritam Sharma made changes -
          VERIFICATION STEPS Verified and closed for build - 6.5.0-4947. Upgrade testing with and without durability is looking good, closing the issue.
          Status Resolved [ 5 ] Closed [ 6 ]

          People

            mihir.kamdar Mihir Kamdar (Inactive)
            mihir.kamdar Mihir Kamdar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            10 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty