cockroachdb / cockroachdb/cockroach

ccl/serverccl: TestExecSQL failed

Open
#175,551 0 comments 0 reactions 0 assignees View on GitHub
branch-staging-v25.4.16 C-test-failure O-robot release-blocker T-observability
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

ccl/serverccl.TestExecSQL [failed](https://mesolite.cluster.engflow.com/invocations/default/f66aefed-82f0-4864-bcdb-01720253685c?testReportRun=1&testReportShard=1&testReportAttempt=1#targets-Ly9wa2cvY2NsL3NlcnZlcmNjbDpzZXJ2ZXJjY2xfdGVzdA==) on staging-v25.4.16 @ [65ac8a6bd3d10290de3f25297aaa6d1c3de3c369](https://github.com/cockroachdb/cockroach/commits/65ac8a6bd3d10290de3f25297aaa6d1c3de3c369):

```
=== RUN TestExecSQL
test_log_scope.go:171: test logs captured to: outputs.zip/logTestExecSQL905900820
test_log_scope.go:82: use -show-logs to present logs inline
panic.go:635: -- test log scope end --
test logs left over in: outputs.zip/logTestExecSQL905900820
--- FAIL: TestExecSQL (37.01s)
=== RUN TestExecSQL/sql_alter_table
datadriven.go:263:
testdata/api_v2_sql:346:
sql admin
{
"database": "mydb",
"execute": true,
"statements": [
{"sql": "ALTER TABLE foo RENAME TO bar"},
{"sql": "INSERT INTO bar (i) VALUES (1), (2)"},
{"sql": "ALTER TABLE bar DROP COLUMN j"},
{"sql": "ALTER TABLE bar ADD COLUMN k INT DEFAULT 42"}
]
}
output didn't match expected:
@@ -1,6 +1,16 @@
{
+ "error": {
+ "code": "57014",
+ "message": "operation \"run-sql-via-api\" timed out after 5.008s (given timeout 5s): polling for queued jobs to complete: poll-show-jobs: failed to read query result: query execution canceled",
+ "severity": "ERROR",
+ "source": {
+ "file": "cancel_checker.go",
+ "function": "init",
+ "line": 75
+ }
+ },
"execution": {
"txn_results": [
{
"columns": [
{
--- FAIL: TestExecSQL/sql_alter_table (5.09s)
```

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

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

Same failure on other branches

- #174999 ccl/serverccl: TestExecSQL failed [C-test-failure O-robot T-observability branch-master release-blocker]

/cc @cockroachlabs/obs-prs

[This test on roachdash](https://roachdash.crdb.dev/?filter=status:open%20t:.*TestExecSQL.*&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 TestExecSQL, especially the failing testdata/api_v2_sql:346 sql_alter_table case, and inspect the linked test report and captured logs around the 5-second timeout. Done means the case completes without the query-execution cancellation and its output matches the expected data-driven result.

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
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.