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
- relates to
-
MB-30931 [CLONE of MB-28636] - query with OrderedIntersect scan returns empty result set intermittently
- Closed