Details
-
Bug
-
Resolution: Fixed
-
Critical
-
7.2.0
-
Untriaged
-
0
-
Yes
-
Analytics Sprint 14
Description
All Analytics latency tests on build 7.2.0-5186 show regressions.
http://showfast.sc.couchbase.com/#/timeline/Linux/analytics/latency/With%20Index
Avg. query latency (ms), BF03 Temporal range scan (100 matches), 4 nodes, BigFUN 20M users (320M docs), SSD, s=1 c=3
| Build | Latency | Job |
|---|---|---|
| 7.2.0-5081 | 58 | http://perf.jenkins.couchbase.com/job/oceanus/10781/ |
| 7.2.0-5178 | 56 | http://perf.jenkins.couchbase.com/job/oceanus/10955/ |
| 7.2.0-5178 | 57 | http://perf.jenkins.couchbase.com/job/oceanus/10964/ |
| 7.2.0-5179 | 164 | http://perf.jenkins.couchbase.com/job/oceanus/10959/ |
| 7.2.0-5179 | 115 | http://perf.jenkins.couchbase.com/job/oceanus/10965/ |
| 7.2.0-5180 | 107 | http://perf.jenkins.couchbase.com/job/oceanus/10958/ |
| 7.2.0-5180 | 111 | http://perf.jenkins.couchbase.com/job/oceanus/10966/ |
| 7.2.0-5182 | 108 | http://perf.jenkins.couchbase.com/job/oceanus/10957/ |
| 7.2.0-5186 | 103 | http://perf.jenkins.couchbase.com/job/oceanus/10939/ |
http://showfast.sc.couchbase.com/#/timeline/Linux/analytics/latency/Without%20Index
Avg. query latency (ms), BF14 Select join with grouping aggregation (10K matches), 4 nodes, BigFUN 20M users (320M docs), SSD, no indexes (ad hoc), s=1 c=99
| Build | Latency | Job |
|---|---|---|
| 7.2.0-5081 | 470 | http://perf.jenkins.couchbase.com/job/oceanus/10786/ |
| 7.2.0-5186 | 659 | http://perf.jenkins.couchbase.com/job/oceanus/10944/ |
http://showfast.sc.couchbase.com/#/timeline/Linux/analytics/latency/Window%20Functions
Avg. query latency (ms), WF01 Minimal streaming window function, 4 nodes, BigFUN 20M users (320M docs), SSD, no indexes (ad hoc), window functions, s=1 c=99
| Build | Latency | Job |
|---|---|---|
| 7.2.0-5081 | 115 | http://perf.jenkins.couchbase.com/job/oceanus/10789/ |
| 7.2.0-5186 | 188 | http://perf.jenkins.couchbase.com/job/oceanus/10947/ |
Note that, we won't be able to bisect the root cause because cbbackupmgr restore was broken due to MB-55427 which is fixed on 7.2.0-5178.