cockroachdb / cockroachdb/cockroach

ccl/serverccl: TestExecSQL failed

Open
#174,999 0 comments 0 reactions 0 assignees View on GitHub
branch-master 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/5bfb4faf-02ac-4445-8fa2-1f163941e06f?testReportRun=2&testReportShard=1&testReportAttempt=1#targets-Ly9wa2cvY2NsL3NlcnZlcmNjbDpzZXJ2ZXJjY2xfdGVzdA==) on master @ [5318641d2b0ff04dbdaced9f83ecb0d692f697b6](https://github.com/cockroachdb/cockroach/commits/5318641d2b0ff04dbdaced9f83ecb0d692f697b6):

```
=== RUN TestExecSQL
test_log_scope.go:172: test logs captured to: outputs.zip/logTestExecSQL2195849299
test_log_scope.go:82: use -show-logs to present logs inline
test_server_shim.go:637: DRPC is enabled (via testserver factory defaults)
panic.go:694: -- test log scope end --
test logs left over in: outputs.zip/logTestExecSQL2195849299
--- FAIL: TestExecSQL (122.03s)
=== RUN TestExecSQL/sql_alter_table
datadriven.go:357: testdata/api_v2_sql:346: still running after 10.000028485s
datadriven.go:357: testdata/api_v2_sql:346: still running after 20.004945971s
datadriven.go:357: testdata/api_v2_sql:346: still running after 30.012117238s
api_v2_tenant_test.go:60:
Error Trace: pkg/ccl/serverccl/api_v2_tenant_test.go:60
external/com_github_cockroachdb_datadriven/datadriven.go:120
external/com_github_cockroachdb_datadriven/datadriven.go:367
external/com_github_cockroachdb_datadriven/datadriven.go:373
external/com_github_cockroachdb_datadriven/datadriven.go:215
external/com_github_cockroachdb_datadriven/datadriven.go:263
external/com_github_cockroachdb_datadriven/test_interface.go:27
Error: Received unexpected error:
Post "https://127.0.0.1:41275/api/v2/sql/": context deadline exceeded (Client.Timeout exceeded while awaiting headers)
Test: TestExecSQL/sql_alter_table
datadriven.go:343:
fatal during testdata/api_v2_sql:346:
{
"database": "mydb",
"execute": true,
"timeout": "30s",
"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"}
]
}
--- FAIL: TestExecSQL/sql_alter_table (30.02s)
```

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

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

/cc @cockroachlabs/obs-prs

[Improve this report!](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/bazci/githubpost/issues)

Jira issue: CRDB-68151

Contributor guide

Open the contributing guide

Research direction

Start with pkg/ccl/serverccl/api_v2_tenant_test.go and the testdata/api_v2_sql case at line 346, then reproduce TestExecSQL/sql_alter_table with the reported race settings. Inspect the captured test logs and the failing API request around the 30-second timeout. Done means the ALTER TABLE sequence completes without the context deadline exceeded failure.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, sql
Domain
databases, testing-qa
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 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.