Details
-
Bug
-
Resolution: Fixed
-
Critical
-
5.0.0
-
5.0.0-2759
-
Untriaged
-
No
Description
Test which shows the bug:
./testrunner -i rqg.ini -p gsi_type=forestdb -t rqg.test_rqg.RQGTests.test_rqg_concurrent,test_file_path=b/resources/rqg/multiple_table_db/query_test_using_templates/query_10000_subqueries.txt.zip,password=password,database=multiple_table_db,reset_database=True,concurreny_count=10,index_quota_percent=30,use_mysql=True,replicas=0,nodes_init=1,total_queries=2000,password=password,subquery=True
rqg.ini:
[global]
port:8091
username:root
password:couchbase
index_port:9102
[servers]
1:SERVER_1
[SERVER_1]
ip:172.23.109.38
services=n1ql,kv,index
[membase]
rest_username:Administrator
rest_password:password
[tuq_client]
goroot:/root/n1ql/go
sherlock_path=/opt/couchbase/bin
Please feel free to use this cluster.
What the test does?
1.creates primary index.
2.Runs long running subqueries with different combination of datatypes (subqueries created after subquery enhancement feature)
3.Compares results with same query run against mysql.
After the test runs 100 queries, run this query through UI or through cbq:
SELECT tb_G615.* FROM (SELECT tb_N615.* FROM (SELECT tb_W615.* FROM (SELECT tb_H615.* FROM ( SELECT t_5.*,(SELECT sum(t_1.qty) FROM t_5.simple_table_2 t_1 WHERE t_1.primary_key_id=t_5.primary_key_id GROUP BY t_1.price ORDER BY t_1.price limit 1) ABC FROM multiple_table_db_1780_simple_table_1 t_5 WHERE EXISTS (SELECT * FROM t_5.simple_table_2 t_2 WHERE t_2.qty < 5113 ) ) tb_H615) tb_W615) tb_N615) tb_G615 order by meta().id limit 5; |
This query takes more than 15 mins to complete, but does not show up in active requests.
Adding a screenshot of active requests at the time when above query is running.