cockroachdb / cockroachdb/cockroach

queries: unexplained plan oscillation when running MR tpcc

Open
#123,157 4 comments 0 reactions 0 assignees View on GitHub
A-sql-optimizer C-bug O-testcluster P-1 T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

When running TPC-C on the `drt-large` cluster, we're seeing some unexpected plan oscillation for some of the queries. We saw this earlier in the run, shortly after we loaded the tables and before the statistics were run (https://github.com/cockroachdb/cockroach/issues/122818) but then a few days later, the plans briefly oscillated again.

![image](https://github.com/cockroachdb/cockroach/assets/18447034/ab81b40f-abf2-4800-b63c-b87f3691bef0)
![image](https://github.com/cockroachdb/cockroach/assets/18447034/19319fc1-301e-487f-9edf-37f9a36d05d9)
![image](https://github.com/cockroachdb/cockroach/assets/18447034/90f60a80-6321-49d1-a3a7-2735066eb838)

Discussed in [this](https://cockroachlabs.slack.com/archives/C01RX2G8LT1/p1714137469892169) internal thread.

Jira issue: CRDB-38218

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.