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

[INTERMITTENT]Adaptive indexes: ERROR:{u'status': u'errors', u'errors': [{u'msg': u'queryport.connPoolTimeout from 127.0.0.1:9101

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Do
    • Critical
    • bug-backlog
    • 5.1.0, 5.5.0
    • query
    • 5.1.0-1241
      5.0.1-4700
    • Untriaged
    • Yes

    Description

      Seeing this issue consistently after removing not like and like queries with string predicates in dynamic indexing job with aggregates.

      Job which failed:
      http://qa.sc.couchbase.com/job/cen006-n1ql-vset02-01-rqg-aggregate-methods-DynamicIndexing-primary-secondary-tests/

      How to run the 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/aggregate_dynamic_indexing.txt.zip,database=multiple_table_db,reset_database=True,concurreny_count=10,index_quota_percent=30,password=password,use_mysql=True,replicas=0,create_secondary_indexes=True,run_query_with_primary=True,record_failure=True,failure_record_path=/tmp,nodes_init=1,build_index_batch_size=1000,build_secondary_index_in_seq=True,nodes_init=1,number_of_buckets=1,total_queries=10000,dynamic_indexing=True,create_primary_index=False

      Error reported by test:

      Reason :: CBQError: host 172.23.99.234: 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

      Logs are attached.

      Number of queries which fail:
      Total Queries Run = 10000, Pass = 9996, Fail = 4, Pass Pecentage = 99 %

      Queries which fail:

      sql_query :: SELECT MIN( decimal_field1 ) FROM  simple_table_1   WHERE  NOT (bool_field1)    
      n1ql_query :: SELECT MIN( decimal_field1 ) FROM  multiple_table_db_6145_simple_table_1   WHERE  NOT (bool_field1)  
       
      		 
      sql_query :: SELECT COUNT( decimal_field1 ) FROM  simple_table_1   WHERE  NOT ((NOT (bool_field1) OR (decimal_field1 IN (  0 , 6 , 15 , 24 , 26  )) OR ((decimal_field1 >= 4871) OR (int_field1 IN (  13 , 35 , 49 , 50 , 55  )))))    
      n1ql_query :: SELECT COUNT( decimal_field1 ) FROM  multiple_table_db_6145_simple_table_1   WHERE  NOT ((NOT (bool_field1) OR (decimal_field1  IN [  0 , 6 , 15 , 24 , 26  ]) OR ((decimal_field1 >= 4871) OR (int_field1  IN [  13 , 35 , 49 , 50 , 55  ])))) 
       
      		 
      sql_query :: SELECT COUNT( decimal_field1 ) FROM  simple_table_1   WHERE  ((NOT (bool_field1) OR decimal_field1 >= 4871)) AND ((bool_field1 = false AND primary_key_id IS NULL)) OR (int_field1 < 5001) AND ((bool_field1 = false AND decimal_field1 <= 4871))    ORDER BY  SUM(DISTINCT decimal_field1 )   
      n1ql_query :: SELECT COUNT( decimal_field1 ) FROM  multiple_table_db_6145_simple_table_1   WHERE  ((NOT (bool_field1) OR decimal_field1 >= 4871)) AND ((bool_field1 = false AND primary_key_id IS NULL)) OR (int_field1 < 5001) AND ((bool_field1 = false AND decimal_field1 <= 4871))    ORDER BY  SUM(DISTINCT decimal_field1 )  
       
      		 
      sql_query :: SELECT COUNT( int_field1 ) FROM  simple_table_1   WHERE  NOT ((varchar_field1 IN (  "AFxyDjJVcw" , "AHrRpFNkbj" , "AUhFdkrlAR" , "AVnUzugMbH" , "AWoUwMiEah"  )) OR (char_field1 IN (  "A" , "B" , "C" , "D" , "E"  )))    
      n1ql_query :: SELECT COUNT( int_field1 ) FROM  multiple_table_db_6145_simple_table_1   WHERE  NOT ((varchar_field1  IN [  "AFxyDjJVcw" , "AHrRpFNkbj" , "AUhFdkrlAR" , "AVnUzugMbH" , "AWoUwMiEah"  ]) OR (char_field1  IN [  "A" , "B" , "C" , "D" , "E"  ]))

      Query log shows:

      2017-09-28T22:50:01.596-07:00 [Info] GSIC[default/multiple_table_db_6145_simple_table_1-1506663663885140581] Scan(c2505d6a-4ec7-4bc2-a584-6480222d77c7) removing backfill file /tmp/scan-results14068496340239 ...
      		 
      2017-09-28T22:50:01.610-07:00 [Info] GSIC[default/multiple_table_db_6145_simple_table_1-1506663663885140581] 172a5dc1-fa9c-4b80-a454-31a28cb5abb1 new backfill file ... /tmp/scan-results14068431101730
      		 
      2017-09-28T22:50:01.612-07:00 [Info] GSIC[default/multiple_table_db_6145_simple_table_1-1506663663885140581] Scan(172a5dc1-fa9c-4b80-a454-31a28cb5abb1) removing backfill file /tmp/scan-results14068431101730 ...
      		 
      2017-09-28T22:50:01.630-07:00 [Info] GSIC[default/multiple_table_db_6145_simple_table_1-1506663663885140581] 172a5dc1-fa9c-4b80-a454-31a28cb5abb1 new backfill file ... /tmp/scan-results14068255020569
      		 
      2017-09-28T22:50:01.630-07:00 [Info] GSIC[default/multiple_table_db_6145_simple_table_1-1506663663885140581] 172a5dc1-fa9c-4b80-a454-31a28cb5abb1 new backfill file ... /tmp/scan-results14068537320612
      		 
      2017-09-28T22:50:01.633-07:00 [Info] GSIC[default/multiple_table_db_6145_simple_table_1-1506663663885140581] Scan(172a5dc1-fa9c-4b80-a454-31a28cb5abb1) removing backfill file /tmp/scan-results14068255020569 ...
      		 
      2017-09-28T22:50:01.633-07:00 [Info] GSIC[default/multiple_table_db_6145_simple_table_1-1506663663885140581] Scan(172a5dc1-fa9c-4b80-a454-31a28cb5abb1) removing backfill file /tmp/scan-results14068537320612 ...
      		 
      2017-09-28T22:50:01.633-07:00 [Info] GSIC[default/multiple_table_db_6145_simple_table_1-1506663663885140581] b4a5fc0c-881b-4342-8dbd-09fa5782496d new backfill file ... /tmp/scan-results14068450375091
      		 
      2017-09-28T22:50:01.636-07:00 [Info] GSIC[default/multiple_table_db_6145_simple_table_1-1506663663885140581] Scan(b4a5fc0c-881b-4342-8dbd-09fa5782496d) removing backfill file /tmp/scan-results14068450375091 ...
      		 
      2017-09-28T22:50:01.650-07:00 [Info] GSIC[default/multiple_table_db_6145_simple_table_1-1506663663885140581] 172a5dc1-fa9c-4b80-a454-31a28cb5abb1 new backfill file ... /tmp/scan-results14068214571894
      		 
      2017-09-28T22:50:01.653-07:00 [Info] GSIC[default/multiple_table_db_6145_simple_table_1-1506663663885140581] Scan(172a5dc1-fa9c-4b80-a454-31a28cb5abb1) removing backfill file /tmp/scan-results14068214571894 ...
      		 
      2017-09-28T22:50:01.655-07:00 [Info] GSIC[default/multiple_table_db_6145_simple_table_1-1506663663885140581] 172a5dc1-fa9c-4b80-a454-31a28cb5abb1 new backfill file ... /tmp/scan-results14068405363805
      		 
      2017-09-28T22:50:01.658-07:00 [Info] GSIC[default/multiple_table_db_6145_simple_table_1-1506663663885140581] Scan(172a5dc1-fa9c-4b80-a454-31a28cb5abb1) removing backfill file /tmp/scan-results14068405363805 ...
      		 
      2017-09-28T22:50:01.680-07:00 [Info] GSIC[default/multiple_table_db_6145_simple_table_1-1506663663885140581] 172a5dc1-fa9c-4b80-a454-31a28cb5abb1 new backfill file ... /tmp/scan-results14068134187544
      		 
      2017-09-28T22:50:01.683-07:00 [Info] GSIC[default/multiple_table_db_6145_simple_table_1-1506663663885140581] Scan(172a5dc1-fa9c-4b80-a454-31a28cb5abb1) removing backfill file /tmp/scan-results14068134187544 ...
      		 
      2017-09-28T22:50:01.683-07:00 [Info] GSIC[default/multiple_table_db_6145_simple_table_1-1506663663885140581] 172a5dc1-fa9c-4b80-a454-31a28cb5abb1 new backfill file ... /tmp/scan-results14068804387479
      		 
      2017-09-28T22:50:01.686-07:00 [Info] GSIC[default/multiple_table_db_6145_simple_table_1-1506663663885140581] Scan(172a5dc1-fa9c-4b80-a454-31a28cb5abb1) removing backfill file /tmp/scan-results14068804387479 ...
      		 
      2017-09-28T22:50:01.690-07:00 [Info] GSIC[default/multiple_table_db_6145_simple_table_1-1506663663885140581] c2831dc4-29f0-4d34-b5bb-b4cdf76705c8 new backfill file ... /tmp/scan-results14068761630986
      		 
      2017-09-28T22:50:01.691-07:00 [Info] GSIC[default/multiple_table_db_6145_simple_table_1-1506663663885140581] 172a5dc1-fa9c-4b80-a454-31a28cb5abb1 new backfill file ... /tmp/scan-results14068578681569
      		 
      2017-09-28T22:50:01.693-07:00 [Info] GSIC[default/multiple_table_db_6145_simple_table_1-1506663663885140581] Scan(172a5dc1-fa9c-4b80-a454-31a28cb5abb1) removing backfill file /tmp/scan-results14068578681569 ...
      		 
      2017-09-28T22:50:01.694-07:00 [Info] GSIC[default/multiple_table_db_6145_simple_table_1-1506663663885140581] Scan(c2831dc4-29f0-4d34-b5bb-b4cdf76705c8) removing backfill file /tmp/scan-results14068761630986 ...
      		 
      2017-09-28T22:50:01.694-07:00 [Info] GSIC[default/multiple_table_db_6145_simple_table_1-1506663663885140581] c2831dc4-29f0-4d34-b5bb-b4cdf76705c8 new backfill file ... /tmp/scan-results14068306071244
      		 
      2017-09-28T22:50:01.697-07:00 [Info] GSIC[default/multiple_table_db_6145_simple_table_1-1506663663885140581] Scan(c2831dc4-29f0-4d34-b5bb-b4cdf76705c8) removing backfill file /tmp/scan-results14068306071244 ...
      		 
      2017-09-28T22:50:01.705-07:00 [Info] GSIC[default/multiple_table_db_6145_simple_table_1-1506663663885140581] 172a5dc1-fa9c-4b80-a454-31a28cb5abb1 new backfill file ... /tmp/scan-results14068194640315
      		 
      2017-09-28T22:50:01.707-07:00 [Info] GSIC[default/multiple_table_db_6145_simple_table_1-1506663663885140581] Scan(172a5dc1-fa9c-4b80-a454-31a28cb5abb1) removing backfill file /tmp/scan-results14068194640315 ...
      		 
       

      Attachments

        1. logs.zip
          5.95 MB
        2. Plan.rtf
          12.23 MB
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            Donald.haggart Donald Haggart
            Prerna.Manaktala Prerna Manaktala (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty