cockroachdb / cockroachdb/cockroach

basalt-26.3: sql/stats: TestCacheAutoRefresh failed

Open
#175,423 0 comments 0 reactions 0 assignees View on GitHub
branch-basalt-26.3 C-test-failure O-robot T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

sql/stats.TestCacheAutoRefresh [failed](https://mesolite.cluster.engflow.com/invocations/default/d89facd7-c830-45fd-905c-b927dc2cd064?testReportRun=1&testReportShard=8&testReportAttempt=1#targets-Ly9wa2cvc3FsL3N0YXRzOnN0YXRzX3Rlc3Q=) on basalt-26.3 @ [4fda4910b2015319b2f775e42d2f2fb15130d19a](https://github.com/cockroachdb/cockroach/commits/4fda4910b2015319b2f775e42d2f2fb15130d19a):

```
=== RUN TestCacheAutoRefresh
test_log_scope.go:172: test logs captured to: outputs.zip/logTestCacheAutoRefresh4042064625
test_log_scope.go:82: use -show-logs to present logs inline
test_server_shim.go:168: automatically injected a shared process virtual cluster under test; see comment at top of test_server_shim.go for details.
stats_cache_test.go:878: error executing query="CREATE STATISTICS v ON v FROM test.t" args=[]: pq: job 1209877931385028611: could not mark as succeeded: job 1209877931385028611: select-job: failed to read query result: query execution canceled
panic.go:694: -- test log scope end --
test logs left over in: outputs.zip/logTestCacheAutoRefresh4042064625
--- FAIL: TestCacheAutoRefresh (1332.50s)
```

Parameters:
- attempt=1
- race=true
- run=1
- shard=8
Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

- #175419 basalt-26.3.2-rc-20260913: sql/stats: TestCacheAutoRefresh failed [C-test-failure O-robot T-sql-queries branch-basalt-26.3.2-rc-20260913 release-blocker]
- #174912 basalt-26.3.2-rc-20260908: sql/stats: TestCacheAutoRefresh failed [C-test-failure O-robot T-sql-queries branch-basalt-26.3.2-rc-20260908]
- #174859 sql/stats: TestCacheAutoRefresh failed [OOM] [C-test-failure O-robot T-sql-queries branch-master]

[This test on roachdash](https://roachdash.crdb.dev/?filter=status:open%20t:.*TestCacheAutoRefresh.*&sort=title+created&display=lastcommented+project) | [Improve this report!](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/bazci/githubpost/issues)

Jira issue: CRDB-68366

Contributor guide

Open the contributing guide

Research direction

Start with sql/stats.TestCacheAutoRefresh and the failing query at stats_cache_test.go:878; inspect the captured test logs at outputs.zip/logTestCacheAutoRefresh4042064625 and the test_server_shim.go notes. Reproduce with the reported race configuration, then determine why CREATE STATISTICS is canceled and leave the test passing reliably.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, sql
Domain
databases, testing
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Active
Clarity
Needs clarification
Newbie friendliness
38/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.