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

query with OrderedIntersect scan returns empty result set intermittently

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 5.5.0
    • 5.1.0
    • query
    • None
    • Untriaged
    • Unknown

    Description

      Install the 5.1.0-MP1 (build #5555)  from following links
       
      CREATE bucket with c
      INSERT INTO c VALUES(UUID(), {"CUSTOMER_ID":551,"MSISDN":UUID(), "ICCID":UUID()});
      INSERT INTO c (KEY UUID(), VALUE d) SELECT {"CUSTOMER_ID":551,"MSISDN":UUID(),"ICCID":UUID()} AS d  FROM c WHERE CUSTOMER_ID == 551;
       
      Repeat INSERT INTO SELECT such that bucket has around ~256 rows ( did not tried less)
       
      CREATE INDEX `xi1` ON `c`(`CUSTOMER_ID`,`MSISDN`);
      CREATE INDEX `ai_SIM` ON `c`(distinct pairs({`CUSTOMER_ID`, `ICCID`, `MSISDN` }));
       
      select TIM_ID, MSISDN from c WHERE CUSTOMER_ID = 551 ORDER BY MSISDN ASC LIMIT 2 OFFSET 0 ;
       
      --repeat select many times occasionally it returns 0 results.
       
      5.1.0-MP1 (build #5555) binaries are available on S3:
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise-5.1.0-MP1-centos6.x86_64.rpm
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise-5.1.0-MP1-centos6.x86_64.rpm.sha256
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise-5.1.0-MP1-centos7.x86_64.rpm
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise-5.1.0-MP1-centos7.x86_64.rpm.sha256
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise-5.1.0-MP1-oel6.x86_64.rpm
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise-5.1.0-MP1-oel6.x86_64.rpm.sha256
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise-5.1.0-MP1-oel7.x86_64.rpm
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise-5.1.0-MP1-oel7.x86_64.rpm.sha256
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise-5.1.0-MP1-suse11.x86_64.rpm
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise-5.1.0-MP1-suse11.x86_64.rpm.sha256
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise-5.1.0-MP1-suse12.x86_64.rpm
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise-5.1.0-MP1-suse12.x86_64.rpm.sha256
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise_5.1.0-MP1-debian8_amd64.deb
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise_5.1.0-MP1-debian8_amd64.deb.sha256
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise_5.1.0-MP1-debian9_amd64.deb
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise_5.1.0-MP1-debian9_amd64.deb.sha256
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise_5.1.0-MP1-macos_x86_64.zip
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise_5.1.0-MP1-macos_x86_64.zip.sha256
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise_5.1.0-MP1-ubuntu14.04_amd64.deb
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise_5.1.0-MP1-ubuntu14.04_amd64.deb.sha256
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise_5.1.0-MP1-ubuntu16.04_amd64.deb
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise_5.1.0-MP1-ubuntu16.04_amd64.deb.sha256
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise_5.1.0-MP1-windows_amd64-PDB.zip
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise_5.1.0-MP1-windows_amd64-PDB.zip.sha256
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise_5.1.0-MP1-windows_amd64.msi
      https://packages.couchbase.com/releases/5.1.0-MP1/couchbase-server-enterprise_5.1.0-MP1-windows_amd64.msi.sha256

      Attachments

        Issue Links

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

          Activity

            People

              Sitaram.Vemulapalli Sitaram Vemulapalli
              tai.tran Tai Tran (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              12 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty