cockroachdb / cockroachdb/cockroach

basalt-26.3.2-rc-20260914: ccl/serverccl: TestExecSQL failed

Open
#175,585 0 comments 0 reactions 0 assignees View on GitHub
branch-basalt-26.3.2-rc-20260914 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/e97a94d3-9833-4a85-9ee3-760c3aa12029?testReportRun=1&testReportShard=1&testReportAttempt=1#targets-Ly9wa2cvY2NsL3NlcnZlcmNjbDpzZXJ2ZXJjY2xfdGVzdA==) on basalt-26.3.2-rc-20260914 @ [d3eb08ebdd1dacc8d3dac0b107a7db5929e09969](https://github.com/cockroachdb/cockroach/commits/d3eb08ebdd1dacc8d3dac0b107a7db5929e09969):

```
=== RUN TestExecSQL
test_log_scope.go:172: test logs captured to: outputs.zip/logTestExecSQL2568991047
test_log_scope.go:82: use -show-logs to present logs inline
test_server_shim.go:639: DRPC is enabled (via testserver factory defaults)
panic.go:694: -- test log scope end --
test logs left over in: outputs.zip/logTestExecSQL2568991047
--- FAIL: TestExecSQL (82.76s)
=== RUN TestExecSQL/sql_drop_table
datadriven.go:263:
testdata/api_v2_sql:473:
sql admin
{
"database": "mydb",
"execute": true,
"statements": [
{"sql": "DROP TABLE bar"}
]
}
output didn't match expected:
@@ -1,6 +1,17 @@
{
+ "error": {
+ "code": "XXUUU",
+ "hint": "The job may not have succeeded.",
+ "message": "operation \"run-sql-via-api\" timed out after 5.006s (given timeout 5s): job 1211012725635743745 could not be loaded: txn exec: context deadline exceeded",
+ "severity": "ERROR",
+ "source": {
+ "file": "txn.go",
+ "function": "exec",
+ "line": 1188
+ }
+ },
"execution": {
"txn_results": [
{
"columns": [
{
--- FAIL: TestExecSQL/sql_drop_table (5.16s)
```

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

- #175551 ccl/serverccl: TestExecSQL failed [C-test-failure O-robot T-observability branch-staging-v25.4.16 release-blocker]
- #175519 basalt-26.3.2-rc-20260913: ccl/serverccl: TestExecSQL failed [C-test-failure O-robot T-observability branch-basalt-26.3.2-rc-20260913 release-blocker]
- #174999 ccl/serverccl: TestExecSQL failed [C-test-failure O-robot T-observability branch-master]

/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 ccl/serverccl.TestExecSQL and the failing testdata/api_v2_sql:473 sql_drop_table case, then inspect the linked test invocation and captured test logs. Reproduce the failure and trace why run-sql-via-api times out while dropping the table; done means the test completes successfully with matching output.

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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.