RQG:Intermittent issue: ERROR:{u'status': u'errors', u'errors': [{u'msg': u'dial tcp 127.0.0.1:9101: connection refused from 127.0.0.1:9101 - cause: dial tcp 127.0.0.1:9101: connection refused from 127.0.0.1:9101', u'code': 5000

Test which fails:

./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=100000,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

Job  which fails:

cen006-n1ql-vset02-02-rqg-having-simple-table-primary-secondary-tests

Same test passes with forestdb.

Uploading logs for this particular test now.

There are other RQG tests which fail with same error.

I can upload logs for them too if needed.

Also I confirmed that indexer RAM quota is set to 1254MB.

Error reported:

  Scenario ::  run_query_without_index_hint 

 Reason :: CBQError: host 172.23.107.87: ERROR:{u'status': u'errors', u'errors': [{u'msg': u'dial tcp 127.0.0.1:9101: connection refused from 127.0.0.1:9101 - cause: dial tcp 127.0.0.1:9101: connection refused from 127.0.0.1:9101', u'code': 5000}], u'results': [], u'metrics': {u'elapsedTime': u'652.935635ms', u'executionTime': u'652.804331ms', u'resultSize': 0, u'resultCount': 0, u'errorCount': 1}, u'requestID': u'8cfa12e3-0213-468b-a08b-65e3d2d5149b', u'signature': {u'primary_key_id': u'json'}}

 Scenario ::  run_query_with_primary 

 Reason :: CBQError: host 172.23.107.87: ERROR:{u'status': u'errors', u'errors': [{u'msg': u'dial tcp 127.0.0.1:9101: connection refused from 127.0.0.1:9101 - cause: dial tcp 127.0.0.1:9101: connection refused from 127.0.0.1:9101', u'code': 5000}], u'results': [], u'metrics': {u'elapsedTime': u'46.185616ms', u'executionTime': u'46.058101ms', u'resultSize': 0, u'resultCount': 0, u'errorCount': 1}, u'requestID': u'ef42c360-62d7-426c-871b-f892d402d81a', u'signature': {u'primary_key_id': u'json'}}

sql_query :: SELECT   primary_key_id   FROM  simple_table   WHERE  (NOT (int_field1 BETWEEN 5 and 9988) OR varchar_field1 NOT BETWEEN "ABAyadkHLt" and "zzVGyNdECo")    GROUP BY   primary_key_id    HAVING  primary_key_id NOT LIKE '%549'    

n1ql_query :: SELECT   primary_key_id   FROM  simple_table   WHERE  (NOT (int_field1 BETWEEN 5 and 9988) OR varchar_field1 NOT BETWEEN "ABAyadkHLt" and "zzVGyNdECo")    GROUP BY   primary_key_id    HAVING  primary_key_id NOT LIKE '%549'      

<<<<<<<<<< TEST 47632 >>>>>>>>>>> 

keyword_list :: [' = ', 'AND', 'BY', 'HAVING', 'IN', 'KEY', 'NOT', 'TRUE'] 

run_result ::