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

RQG:: CreateIndex() - cause: Request Timeout during parallel index creation with 10 buckets, lighly loaded cluster

    XMLWordPrintable

Details

    • Task
    • Resolution: Fixed
    • Major
    • 4.5.0
    • 4.0.0
    • secondary-index
    • Security Level: Public
    • build 4019

    Description

      We are running RQG with 1 node cluster with all services and 10 buckets. For each bucket we create around 40 indexes using defer build. This keeps happening in parallel for all buckets. After a while, we hit the following exception. Note that each bucket has only 1000 items

      2015-08-08 00:05:40 | INFO | MainProcess | Thread-1366 | [tuq_helper.run_cbq_query] RUN QUERY DROP INDEX simple_table_3.simple_table_3_where_based_fields_occur_1003 USING GSI
      2015-08-08 00:05:40 | INFO | MainProcess | Thread-1366 | [rest_client.query_tool] query params : statement=DROP+INDEX+simple_table_3.simple_table_3_where_based_fields_occur_1003+USING+GSI
      2015-08-08 00:05:45 | INFO | MainProcess | Thread-1369 | [test_rqg._generate_secondary_indexes_in_batches] CBQError: host 172.23.107.87: ERROR:{u'status': u'errors', u'errors': [

      {u'msg': u'GSI CreateIndex() - cause: Request Timeout', u'code': 5000}

      ], u'results': [], u'metrics':

      {u'elapsedTime': u'2m0.042777882s', u'executionTime': u'2m0.042620621s', u'resultSize': 0, u'resultCount': 0, u'errorCount': 1}

      , u'requestID': u'3433bb81-c316-424c-8dc9-65af1ffd2564', u'signature': None}
      Exception in thread Thread-1369:

      Test case ran:

      ./testrunner -i b/resources/dev-1-node_n1ql_2i.ini -t rqg.test_rqg.RQGTests.test_rqg_concurrent_with_secondary,test_file_path=b/resources/rqg/simple_table_db/query_tests_using_templates/query_50000_aggregate_functions.txt.zip,database=multiple_table_db,reset_database=True,concurreny_count=2,index_quota_percent=1,use_mysql=True,replicas=0,run_query_with_secondary=True,run_explain_with_hints=True,total_queries=5000

      Attachments

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

        Activity

          People

            jliang John Liang
            parag Parag Agarwal (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