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

RQG:Error evaluating ORDER BY. - cause: Aggregate count(*) not found.

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 5.0.0
    • 5.0.0
    • query
    • 4.7.0-1567
    • Untriaged
    • Yes

    Description

      {noformat}

       

      This is a regression from 4.7.0-1533

      Test which fails:

      ./testrunner -i local.ini -p gsi_type=forestdb -t rqg.test_rqg.RQGTests.test_rqg_concurrent,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=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=1000,skip_cleanup=True

      Job which fails:
      cen006-n1ql-vset02-01-rqg-aggregate-methods-simple-table-primary-secondary-tests

      Number of secondary indexes created:131
      Primary index is created.

      Query run:

      n1ql_query :: SELECT COUNT FROM multiple_table_db_5322_simple_table_1 WHERE (bool_field1 OR char_field1 > "N") ORDER BY COUNT

      Error reported:
      Scenario :: run_query_without_index_hint
      Reason :: CBQError: host 172.23.105.209: ERROR:{u'status': u'errors', u'errors': [\{u'msg': u'Error evaluating ORDER BY. - cause: Aggregate count(*) not found.', u'code': 5010}, \{u'msg': u'Error evaluating ORDER BY. - cause: Aggregate count(*) not found.', u'code': 5010}, \{u'msg': u'Error evaluating ORDER BY. - cause: Aggregate count(*) not found.', u'code': 5010}, \{u'msg': u'Error evaluating ORDER BY. - cause: Aggregate count(*) not found.', u'code': 5010}], u'results': [{u'$1': {}}, {u'$1': {}}, {u'$1': {}}, {u'$1': {}}, {u'$1': {}}, {u'$1'

      {noformat}

      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)
            Prerna.Manaktala Prerna Manaktala (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty