Details
-
Bug
-
Resolution: Fixed
-
Major
-
5.0.0
-
4.7.0-1505 with MOI Indexes
-
Untriaged
-
Yes
Description
{noformat}
This is a regression from 4.6 and it the mismatch in results for this query is seen only with MOI indexes.With gsi the test passes.
Queries which give mismatch:
sql_query :: SELECT COUNT( varchar_field1 ) FROM simple_table WHERE bool_field1 != false
n1ql_query :: SELECT COUNT( varchar_field1 ) FROM simple_table_db_6839_simple_table WHERE bool_field1 != false
How to run the test?
./testrunner.py -i local.ini -p gsi_type=memory_optimized -t rqg.test_rqg.RQGTests.test_rqg_concurrent_with_secondary,test_file_path=b/resources/rqg/simple_table_db/query_tests_using_templates/query_50000_aggregate_functions.txt.zip,database=simple_table_db,reset_database=True,concurreny_count=5,index_quota_percent=30,password=password,use_mysql=True,replicas=0,run_query_with_secondary=True,run_explain_with_hints=True,total_queries=2000,record_failure=True,check_covering_index=True,failure_record_path=/tmp,
skip_cleanup=False,ram_quota=8000,indexer_memQuota=5000
Example ini file:
[global]
port:8091
username:root
password:couchbase
index_port:9102
index_path:/data/indexer
[servers]
1:SERVER_1
[SERVER_1]
ip:172.23.107.165
index_port:9102
port:8091
services=n1ql,kv,index
[membase]
rest_username:Administrator
rest_password:password
Please do change the memory settings before you run the test using following steps:
python27 scripts/install.py -i ${resource_tuq} -p vbuckets=${vbucket_number},version=${version_number},product=cb,parallel=True,init_nodes=False
echo "Sleeping for 10 secs post installation...."
sleep 10
curl -X POST http://172.23.107.165:8091/pools/default -d memoryQuota=21000 -d indexMemoryQuota=5000
curl http://172.23.107.165:8091/node/controller/setupServices -d "services=kv,n1ql,index"
curl -X POST http://172.23.107.165:8091/settings/web -d port=8091 -d username=Administrator -d password=password
sleep 10
This test succeeded in 4.6
Warning msg in UI and Logs after the test finished:
Warning: approaching max index RAM. Indexer RAM on node "127.0.0.1" is 88%, which is at or above the threshold of 75%. (repeated 18 times)
Total number of indexes created on the machine: 1014
Memory usage of machine:
[root@slv-s20301_c ~]# free -m
total used free shared buffers cached
Mem: 31981 11423 20557 0 264 1293
-/+ buffers/cache: 9865 22115
Swap: 10575 74 10501
[root@slv-s20301_c ~]# df -k .
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/VolGroup00-lv_root
35146488 7722772 25631716 24% /
{noformat}