cockroachdb / cockroachdb/cockroach

basalt-26.3: sql/inspect: TestInspectWithoutASOFSchemaChange failed

Open
#174,922 2 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/inspect.TestInspectWithoutASOFSchemaChange [failed](https://mesolite.cluster.engflow.com/invocations/default/376fcf97-274a-4e7c-ad0a-4aafab7d24f7?testReportRun=1&testReportShard=4&testReportAttempt=1#targets-Ly9wa2cvc3FsL2luc3BlY3Q6aW5zcGVjdF90ZXN0) on basalt-26.3 @ [c6d01ae4be9708178b248a49819b505daf713377](https://github.com/cockroachdb/cockroach/commits/c6d01ae4be9708178b248a49819b505daf713377):

```
=== RUN TestInspectWithoutASOFSchemaChange
test_log_scope.go:172: test logs captured to: outputs.zip/logTestInspectWithoutASOFSchemaChange723691072
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.
test_server_shim.go:639: DRPC is enabled (via testserver factory defaults)
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/logTestInspectWithoutASOFSchemaChange723691072
--- FAIL: TestInspectWithoutASOFSchemaChange (63.60s)
```

Parameters:
- attempt=1
- race=true
- run=1
- 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

- #174656 sql/inspect: TestInspectWithoutASOFSchemaChange failed [C-test-failure O-robot T-sql-queries branch-master release-blocker]

[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)

Jira issue: CRDB-68093

Contributor guide

Open the contributing guide

Research direction

Start with TestInspectWithoutASOFSchemaChange in pkg/sql/inspect/index_consistency_check_test.go around line 906, then reproduce the reported race-enabled failure and review the captured test logs. Done means the timeout behavior is understood and the test no longer fails with the reported mismatch across the affected branches.

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
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.