Details
-
Bug
-
Resolution: Fixed
-
Major
-
5.5.0
-
5.1.0-1202
-
Untriaged
-
Yes
Description
Some of the rqg jobs are failing intermittently due to the following error:
Example failure:
http://qa.sc.couchbase.com/job/cen006-n1ql-vset03-02-rqg-fields-union-simple-table-primary-secondary-tests/524/console
How to run this test:
./testrunner -i <ini file> -p gsi_type=plasma -t rqg.test_rqg.RQGTests.test_rqg_concurrent,test_file_path=b/resources/rqg/simple_table_db/query_tests_using_templates/query_50000_unions.txt.zip,database=simple_table_db,reset_database=True,gsi_type=plasma,concurreny_count=10,index_quota_percent=30,password=password,use_mysql=True,replicas=0,create_secondary_indexes=True,number_of_buckets=1,total_queries=${total_queries},record_failure=False,failure_record_path=/tmp,skip_cleanup=${skip_cleanup},subquery=False,create_primary_index=True |
|
Example ini file:
[global]
port:8091
username:root
password:couchbase
index_port:9102
[servers]
1:SERVER_1
[SERVER_1]
ip:172.23.106.34
services=n1ql,kv,index
[membase]
rest_username:Administrator
rest_password:password
[tuq_client]
goroot:/root/n1ql/go
sherlock_path=/opt/couchbase/bin
____________________________________________________
Scenario :: run_query_without_index_hint
*
Reason :: CBQError: host 172.23.106.34: ERROR:{u'status': u'errors', u'errors': [{u'msg': u'queryport.connPoolTimeout from 127.0.0.1:9101 - cause: queryport.connPoolTimeout from 127.0.0.1:9101', u'code': 5000}, {u'msg': u'queryport.connPoolTimeout from 127.0.0.1:9101 - cause: queryport.connPoolTimeout from 127.0.0.1:9101', u'code': 5000}, {u'msg': u'queryport.connPoolTimeout from 127.0.0.1:9101 - cause: queryport.connPoolTimeout from 127.0.0.1:9101', u'code': 5000}, {u'msg': u'queryport.connPoolTimeout from 127.0.0.1:9101 - cause: queryport |
*
An example query which fails:
sql_query :: (SELECT * FROM simple_table WHERE ((varchar_field1 IN ( "AAmvQSAnny" , "ADhHqyCkdM" , "AHtJolpoVU" , "AHtyCWtSli" , "AKrYZBdhcp" ) AND NOT (int_field1 > 4747))) AND ((NOT (bool_field1) AND int_field1 IS NULL)) OR (((int_field1 >= 4747) OR (int_field1 <= 4747) OR primary_key_id IN ( "1" , "10" , "100" , "1000" , "101" ))) AND (NOT (int_field1 != 4747)) ORDER BY int_field1 , decimal_field1 ASC) UNION (SELECT * FROM simple_table WHERE (bool_field1 AND (int_field1 <= 4747) OR (int_field1 > 4747)) ORDER BY int_field1 , decimal_field1 , primary_key_id , varchar_field1 ) UNION ALL (SELECT * FROM simple_table WHERE ((primary_key_id > "549" AND ((int_field1 IS NOT NULL) AND ((decimal_field1 != 4696) OR (int_field1 = 4747))) OR ((int_field1 BETWEEN 7 and 9976) AND (int_field1 < 4747)))) AND ((bool_field1 != false AND NOT ((char_field1 IN ( "A" , "B" , "C" , "D" , "E" )) OR (varchar_field1 = "aSnTvPRbSv")))) ORDER BY int_field1 ) UNION ALL (SELECT * FROM simple_table WHERE char_field1 <= "N" ORDER BY int_field1 , decimal_field1 , primary_key_id , bool_field1 DESC) |
n1ql_query :: (SELECT * FROM simple_table_db_8212_simple_table WHERE ((varchar_field1 IN [ "AAmvQSAnny" , "ADhHqyCkdM" , "AHtJolpoVU" , "AHtyCWtSli" , "AKrYZBdhcp" ] AND NOT (int_field1 > 4747))) AND ((NOT (bool_field1) AND int_field1 IS NULL)) OR (((int_field1 >= 4747) OR (int_field1 <= 4747) OR primary_key_id IN [ "1" , "10" , "100" , "1000" , "101" ])) AND (NOT (int_field1 != 4747)) ORDER BY int_field1 , decimal_field1 ASC) UNION (SELECT * FROM simple_table_db_8212_simple_table WHERE (bool_field1 AND (int_field1 <= 4747) OR (int_field1 > 4747)) ORDER BY int_field1 , decimal_field1 , primary_key_id , varchar_field1 ) UNION ALL (SELECT * FROM simple_table_db_8212_simple_table WHERE ((primary_key_id > "549" AND ((int_field1 IS NOT NULL) AND ((decimal_field1 != 4696) OR (int_field1 = 4747))) OR ((int_field1 BETWEEN 7 and 9976) AND (int_field1 < 4747)))) AND ((bool_field1 != false AND NOT ((char_field1 IN [ "A" , "B" , "C" , "D" , "E" ]) OR (varchar_field1 = "aSnTvPRbSv")))) ORDER BY int_field1 ) UNION ALL (SELECT * FROM simple_table_db_8212_simple_table WHERE char_field1 <= "N" ORDER BY int_field1 , decimal_field1 , primary_key_id , bool_field1 DESC) |
|
|
Collecting logs.
We did not see this issue in 5.0
Rerun of the jobs succeed.