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

aggregation regression

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • Cheshire-Cat
    • 7.0.0
    • query
    • Untriaged
    • Centos 64-bit
    • 1
    • Yes

    Description

      Build 3372 has a bunch of regressions affecting aggregation queries
      CREATE INDEX wf7 ON `bucket-1`(customer.zip, customer.preferred_flag);

      SELECT customer.zip, FIRST_VALUE(customer.zip) OVER(ORDER BY customer.zip), LAST_VALUE(customer.zip) OVER(ORDER BY customer.zip DESC) FROM `bucket-1` WHERE customer.zip IN $1 AND customer.preferred_flag = true GROUP BY customer.zip HAVING COUNT(1) > 10;
      3772 - http://perf.jenkins.couchbase.com/job/arke/6525/ - 5978

      3771 - http://perf.jenkins.couchbase.com/job/arke/6526/ - 430

      http://cbmonitor.sc.couchbase.com/reports/html/?snapshot=arke_700-3771_access_8d16&snapshot=arke_700-3772_access_9beb

      http://172.23.123.43:10000/?product=couchbase-server&fromVersion=7.0.0&fromBuild=3771&toVersion=7.0.0&toBuild=3772&f_asterixdb=off&f_cbas-core=off&f_ns_server=off&f_query=off&f_query-ee=on&f_testrunner=off

      https://issues.couchbase.com/browse/MB-33009

      https://github.com/couchbase/query-ee/commit/273b156c02c1b0c4369998558c8cfd7e457f6866

      Attachments

        Issue Links

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

          Activity

            korrigan.clark Korrigan Clark (Inactive) added a comment - - edited Running two test to grab profiles: 3771 -    http://perf.jenkins.couchbase.com/job/arke/6624/   3772 - http://perf.jenkins.couchbase.com/job/arke/6618/  

            Build couchbase-server-7.0.0-3908 contains query commit b0b0fcb with commit message:
            MB-42956 Replace query parameters for generation of index spans for IN and LIKE clauses

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.0.0-3908 contains query commit b0b0fcb with commit message: MB-42956 Replace query parameters for generation of index spans for IN and LIKE clauses
            bingjie.miao Bingjie Miao added a comment -

            Korrigan Clark please try with build 7.0.0-3908 or later.

            bingjie.miao Bingjie Miao added a comment - Korrigan Clark please try with build 7.0.0-3908 or later.
            korrigan.clark Korrigan Clark (Inactive) added a comment - waiting for verification on these jobs: http://perf.jenkins.couchbase.com/job/arke/6626/ http://perf.jenkins.couchbase.com/job/arke/6627/ http://perf.jenkins.couchbase.com/job/arke/6628/ http://perf.jenkins.couchbase.com/job/arke/6629/ http://perf.jenkins.couchbase.com/job/arke/6630/  
            bingjie.miao Bingjie Miao added a comment -

            The fix was backported to 6.6.2 as part of backport of MB-33009. Build 6.6.2-9529.

            bingjie.miao Bingjie Miao added a comment - The fix was backported to 6.6.2 as part of backport of MB-33009 . Build 6.6.2-9529.

            People

              korrigan.clark Korrigan Clark (Inactive)
              korrigan.clark Korrigan Clark (Inactive)
              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