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/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
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