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

[N1QL][INTERMITTENT]PANIC IN indexer.log Query reports:{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}

    XMLWordPrintable

Details

    • 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.

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            ajay.bhullar Ajay Bhullar
            Prerna.Manaktala Prerna Manaktala (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty