cockroachdb / cockroachdb/cockroach

basalt-26.3.2-rc-20260908: sql/inspect: TestInspectWithoutASOFSchemaChange failed

Open
#174,992 1 comment 0 reactions 0 assignees View on GitHub
branch-basalt-26.3.2-rc-20260908 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/inspect.TestInspectWithoutASOFSchemaChange [failed](https://mesolite.cluster.engflow.com/invocations/default/4e6b3e4b-4f3a-4ae0-ac38-acabe7fa7d66?testReportRun=2&testReportShard=4&testReportAttempt=1#targets-Ly9wa2cvc3FsL2luc3BlY3Q6aW5zcGVjdF90ZXN0) on basalt-26.3.2-rc-20260908 @ [807558e5e81666af257c811e925e4cae570abc28](https://github.com/cockroachdb/cockroach/commits/807558e5e81666af257c811e925e4cae570abc28):

```
=== RUN TestInspectWithoutASOFSchemaChange
test_log_scope.go:172: test logs captured to: outputs.zip/logTestInspectWithoutASOFSchemaChange1152768596
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.
index_consistency_check_test.go:906:
Error Trace: pkg/sql/inspect/index_consistency_check_test.go:906
Error: Expect "timed out waiting for DROP INDEX to complete" to match "table pk_swap \[\d+\] has had a schema change since the job has started at .+\nHINT: use AS OF SYSTEM TIME to avoid schema changes during inspection"
Test: TestInspectWithoutASOFSchemaChange
panic.go:694: -- test log scope end --
test logs left over in: outputs.zip/logTestInspectWithoutASOFSchemaChange1152768596
--- FAIL: TestInspectWithoutASOFSchemaChange (62.24s)
```

Parameters:
- attempt=1
- race=true
- run=2
- shard=4
Help

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

Same failure on other branches

- #174922 basalt-26.3: sql/inspect: TestInspectWithoutASOFSchemaChange failed [C-test-failure O-robot T-sql-queries branch-basalt-26.3]

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

Contributor guide

Open the contributing guide

Research direction

Start with pkg/sql/inspect/index_consistency_check_test.go around line 906 and run sql/inspect.TestInspectWithoutASOFSchemaChange with the reported race settings. Compare the captured test logs and failure at the assertion, then identify the cause of the timeout or mismatched error; done means the test reliably passes with the intended schema-change behavior.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, sql
Domain
databases, testing-qa
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Active
Clarity
Mostly clear
Newbie friendliness
52/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.