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

Index scan timed out - cause: Index scan timed out

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Critical
    • 4.0.0
    • 4.0.0
    • query
    • Security Level: Public
    • None
    • 4.0.0-3402
      centos

    Description

      there is primary index (view) and an gsi index:
      CREATE INDEX auto_ind_join_day ON default(join_day)

      query is (in where clause one indexed attribute and 1 not)
      SELECT name, join_day, join_mo FROM default WHERE join_day>2 AND join_mo>3

      {u'status': u'errors', u'errors': [

      {u'msg': u'Index scan timed out - cause: Index scan timed out', u'code': 5000}

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

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

      , u'requestID': u'3d5d1483-1c0f-4fe2-8237-49825f8be7c8', u'signature': {u'join_mo': u'json', u'name': u'json', u'join_day': u'json'}}

      attaching logs

      test to reproduce
      ./testrunner -i /tmp/tuqvm2.ini doc-per-day=6,standard_buckets=1,skip_build_tuq=True,cbq_version=sherlock,get-cbcollect-info=True,services_init=n1ql:kv:index,index_type=GSI -t tuqquery.tuq_index.QueriesViewsTests.test_multiple_indexes_query_attr

      Attachments

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

        Activity

          People

            Prerna.Manaktala Prerna Manaktala (Inactive)
            iryna iryna
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty