cockroachdb / cockroachdb/cockroach

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

Open
#175,661 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

branch-basalt-26.3.2-rc-20260908 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 on basalt-26.3.2-rc-20260908 @ 807558e5e81666af257c811e925e4cae570abc28:

=== RUN   TestExecSQL
    test_log_scope.go:172: test logs captured to: outputs.zip/logTestExecSQL496628396
    test_log_scope.go:82: use -show-logs to present logs inline
    panic.go:694: -- test log scope end --
test logs left over in: outputs.zip/logTestExecSQL496628396
--- FAIL: TestExecSQL (70.06s)
=== 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.019s (given timeout 5s): job 1211579745433092097 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.06s)

Parameters:

  • attempt=1
  • race=true
  • run=1
  • shard=1
Help

See also: How To Investigate a Go Test Failure (internal)

Same failure on other branches

  • #175585 basalt-26.3.2-rc-20260914: ccl/serverccl: TestExecSQL failed [C-test-failure O-robot T-observability branch-basalt-26.3.2-rc-20260914 release-blocker]
  • #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 | Improve this report!

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with ccl/serverccl.TestExecSQL, especially the sql_drop_table case and testdata/api_v2_sql:473. Inspect the captured test logs from outputs.zip/logTestExecSQL496628396 and rerun the test with -show-logs. Done means the operation no longer times out and the expected output matches.

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.