cockroachdb / cockroachdb/cockroach
basalt-26.3.2-rc-20260914: 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/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
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