Details
-
Bug
-
Resolution: Fixed
-
Test Blocker
-
4.5.0
-
4.5.0-1586 , 4.5.0-1599,4.5.0-1655, 4.5.0-1626,4.5.0-1640,4.5.0-1649,4.5.0-1662
-
Untriaged
-
Yes
Description
RQG job which fails:
|
cen006-n1ql-vset02-02-rqg-having-simple-table-primary-secondary-tests
|
|
Following Test succeeds with 5000 queries but fails with 10000 queries:
|
It was run with foresdb indexer storage mode.
|
|
./testrunner -i ${resource_tuq} -p gsi_type=${gsi_type} -t rqg.test_rqg.RQGTests.test_rqg_concurrent_new,test_file_path=b/resources/rqg/simple_table_db/query_tests_using_templates/query_50000_having.txt.zip,database=simple_table_db,reset_database=True,concurreny_count=10,index_quota_percent=30,total_queries=10000,password=password,use_mysql=True,replicas=0,create_secondary_indexes=True,run_query_with_primary=True,record_failure=True,build_index_batch_size=10,number_of_buckets=2,skip_cleanup=True,failure_record_path=/tmp
|
|
|
Multiple queries fail with following error:
|
Error reported:
Reason :: CBQError: host 172.23.107.87: 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'results': [], u'metrics':
{u'elapsedTime': u'2.502885352s', u'executionTime': u'2.502534452s', u'resultSize': 0, u'resultCount': 0, u'errorCount': 1}, u'requestID': u'ed665fc8-43cd-4a12-86c5-619baf1f800e', u'signature': {u'primary_key_id': u'json', u'char_field1': u'json', u'varchar_field1': u'json'}}
Scenario :: run_query_with_primary
Reason :: CBQError: host 172.23.107.87: ERROR:{u'status': u'errors', u'errors': [
], u'results': [], u'metrics':
{u'elapsedTime': u'2.038031426s', u'executionTime': u'2.037878712s', u'resultSize': 0, u'resultCount': 0, u'errorCount': 1}, u'requestID': u'97500f10-3765-4434-bc2d-4c5c19f80c1b', u'signature': {u'primary_key_id': u'json', u'char_field1': u'json', u'varchar_field1': u'json'}}
n1ql_query :: SELECT primary_key_id , varchar_field1 , char_field1 FROM simple_table WHERE ((NOT (bool_field1) AND primary_key_id IS NULL)) OR (((int_field1 BETWEEN 1 and 9993) OR (int_field1 BETWEEN 1 and 9993) AND varchar_field1 NOT LIKE '%bEiPpgPBLv' AND bool_field1 = false)) GROUP BY primary_key_id , varchar_field1 , char_field1 HAVING varchar_field1 IN [ "AANeRoKmwh" , "AAkXefoxFI" , "ADOCffPzpx" , "AEoYstoHQn" , "AHlymsBqIE" ]
|
Uploading logs.