Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-18485

RQG : ERROR:{u'msg': u'queryport.connPoolTimeout from 127.0.0.1:9101 - cause: queryport.connPoolTimeout

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Test Blocker
    • 4.5.0
    • 4.5.0
    • query
    • 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'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.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.

      Attachments

        1. 18485logs.zip
          3.46 MB
        2. goroutine.4
          42 kB
        3. logs3.zip
          48.71 MB
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            johan.larson Johan Larson (Inactive)
            Prerna.Manaktala Prerna Manaktala (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty