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

View query latency regression in 1070

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 7.1.0
    • 7.1.0
    • performance
    • Untriaged
    • Centos 64-bit
    • 1
    • Unknown
    • KV 2021-Dec

    Description

      Looks like in build 1070 there is a regression in some of the views queries

      http://showfast.sc.couchbase.com/#/timeline/Linux/views/by_type/all

      80th percentile query latency (ms), 1 node, 20M docs, 3 views, 100 updates/sec, 100 queries/sec, stale=false, basic queries, default collection

      1069 - http://perf.jenkins.couchbase.com/job/leto/21592/console - 220

      1070 - http://perf.jenkins.couchbase.com/job/leto/21588/console - 248

      http://changelog.build.couchbase.com/?product=couchbase-server&fromVersion=7.1.0&fromBuild=1069&toVersion=7.1.0&toBuild=1070&f_couchbase-cli=off&f_eventing=off&f_kv_engine=on&f_magma=off&f_product-metadata=off&f_tlm=on

      Looks like there is 3 kv engine commits related to memory allocation. From the graphs it appears as though there is more free memory in the 1070 run: http://cbmonitor.sc.couchbase.com/reports/html/?snapshot=leto_710-1069_access_0477&snapshot=leto_710-1070_access_963d#6799c0925e8393e50adc1e168ec87cbd

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MB-47908 Performance: Single function log throughput reduce by 17%

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            Ascending order - Click to sort in descending order
            korrigan.clark Korrigan Clark (Inactive) created issue -
            owend Daniel Owen made changes -
            Field Original Value New Value
            Attachment perftrendof80percentquerylatency.png [ 167908 ]
            owend Daniel Owen made changes -
            Assignee Daniel Owen [ owend ] Korrigan Clark [ korrigan.clark ]
            owend Daniel Owen made changes -
            Rank Ranked higher
            wayne Wayne Siu made changes -
            Link This issue relates to MB-39745 [ MB-39745 ]
            owend Daniel Owen made changes -
            Component/s performance [ 10222 ]
            Component/s couchbase-bucket [ 10173 ]
            Component/s view-engine [ 10060 ]
            korrigan.clark Korrigan Clark (Inactive) made changes -
            Assignee Korrigan Clark [ korrigan.clark ] Daniel Owen [ owend ]
            owend Daniel Owen made changes -
            Component/s view-engine [ 10060 ]
            Component/s performance [ 10222 ]
            owend Daniel Owen made changes -
            Assignee Daniel Owen [ owend ] Jeelan Poola [ jeelan.poola ]
            owend Daniel Owen made changes -
            Component/s couchbase-bucket [ 10173 ]
            Component/s view-engine [ 10060 ]
            owend Daniel Owen made changes -
            Assignee Jeelan Poola [ jeelan.poola ] Daniel Owen [ owend ]
            paolo.cocchi Paolo Cocchi made changes -
            Assignee Daniel Owen [ owend ] Paolo Cocchi [ paolo.cocchi ]
            owend Daniel Owen made changes -
            Sprint KV 2021-Dec [ 1906 ]
            owend Daniel Owen made changes -
            Rank Ranked higher
            paolo.cocchi Paolo Cocchi made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            paolo.cocchi Paolo Cocchi made changes -
            Attachment MB-49399_avg_disk_update_time.png [ 171993 ]
            Attachment MB-49399_query_latency.png [ 171994 ]
            owend Daniel Owen made changes -
            Rank Ranked higher
            paolo.cocchi Paolo Cocchi made changes -
            Status In Progress [ 3 ] Open [ 1 ]
            paolo.cocchi Paolo Cocchi made changes -
            Assignee Paolo Cocchi [ paolo.cocchi ] Korrigan Clark [ korrigan.clark ]
            owend Daniel Owen made changes -
            Component/s performance [ 10222 ]
            Component/s couchbase-bucket [ 10173 ]
            owend Daniel Owen made changes -
            Summary View query latency increase after memory allocation fixes View query latency regression in 1070
            wayne Wayne Siu made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            drigby Dave Rigby made changes -
            Link This issue relates to MB-47908 [ MB-47908 ]
            drigby Dave Rigby made changes -
            Link This issue relates to MB-39745 [ MB-39745 ]
            korrigan.clark Korrigan Clark (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Resolved [ 5 ]
            korrigan.clark Korrigan Clark (Inactive) made changes -
            Status Resolved [ 5 ] Closed [ 6 ]
            korrigan.clark Korrigan Clark (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Closed [ 6 ] Reopened [ 4 ]
            wayne Wayne Siu made changes -
            Assignee Korrigan Clark [ korrigan.clark ] Wayne Siu [ wayne ]
            wayne Wayne Siu made changes -
            Resolution Fixed [ 1 ]
            Status Reopened [ 4 ] Closed [ 6 ]

            People

              wayne Wayne Siu
              korrigan.clark Korrigan Clark (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty