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

[BP of MB-31336] - unstable result set

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • 5.5.2
    • 5.5.3
    • query
    • Untriaged
    • Centos 64-bit
    • No

    Description

      steps to repro:

      1. create standard bucket `temp_bucket`
      2. CREATE primary index ON temp_bucket
      3. INSERT INTO temp_bucket VALUES(UUID(), {"CUSTOMER_ID":551,"MSISDN":UUID(), "ICCID":UUID()})
      4. INSERT INTO temp_bucket (KEY UUID(), VALUE d) SELECT {"CUSTOMER_ID":551,"MSISDN":UUID(),"ICCID":UUID()} AS d FROM temp_bucket WHERE CUSTOMER_ID == 551;
      5. repeat step 4 9 times
      6. CREATE INDEX `xi1` ON `temp_bucket`(`CUSTOMER_ID`,`MSISDN`);
      7. CREATE INDEX `ai_SIM` ON `temp_bucket`(distinct pairs({`CUSTOMER_ID`, `ICCID`, `MSISDN` }));
      8. select TIM_ID, MSISDN from temp_bucket WHERE CUSTOMER_ID = 551 ORDER BY MSISDN ASC LIMIT 2 OFFSET 0

      Last query returns 2 results which is correct, but sometimes it returns 0 results. Just run it several times from web interface.

      Attachments

        Issue Links

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

          Activity

            Build couchbase-server-5.5.3-4037 contains query commit 892e3d9 with commit message:
            MB-32195 defensively disable first scan optimization

            build-team Couchbase Build Team added a comment - Build couchbase-server-5.5.3-4037 contains query commit 892e3d9 with commit message: MB-32195 defensively disable first scan optimization

            Verified against 5.5.3-4037

            evgeny.makarenko Evgeny Makarenko (Inactive) added a comment - Verified against 5.5.3-4037

            People

              evgeny.makarenko Evgeny Makarenko (Inactive)
              evgeny.makarenko Evgeny Makarenko (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty