cockroachdb / cockroachdb/cockroach
ccl/serverccl: TestExecSQL failed
- 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
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