Details
-
Bug
-
Resolution: Duplicate
-
Critical
-
4.0.0
-
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