ccl/sqlproxyccl: TestCancelQuery failed

ccl/sqlproxyccl.TestCancelQuery [failed](https://mesolite.cluster.engflow.com/invocations/default/4d786a30-134a-4785-9e70-9d13d5878a0b?testReportRun=1&testReportShard=7&testReportAttempt=1#targets-Ly9wa2cvY2NsL3NxbHByb3h5Y2NsOnNxbHByb3h5Y2NsX3Rlc3Q=) on release-24.3.19-rc @ [faf059d833b409c16409d1095dfa387068996c1c](https://github.com/cockroachdb/cockroach/commits/faf059d833b409c16409d1095dfa387068996c1c):

Fatal error:

```
panic: use of Span after Finish. Span: proxy-con-serve. Finish previously called at: <stack not captured. Set debugUseAfterFinish> [recovered]
	panic: use of Span after Finish. Span: proxy-con-serve. Finish previously called at: <stack not captured. Set debugUseAfterFinish>

```
Stack: 

```
goroutine 4742 [running]:
github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).recover(0xc00840cc70?, {0xe39a218, 0xc0029d8db0})
	pkg/util/stop/stopper.go:226 +0x74
panic({0xa756240?, 0xc005685730?})
	GOROOT/src/runtime/panic.go:770 +0x132
github.com/cockroachdb/cockroach/pkg/util/tracing.(*Span).detectUseAfterFinish(0xc00601fc08)
	pkg/util/tracing/span.go:177 +0x274
github.com/cockroachdb/cockroach/pkg/util/tracing.(*Span).RecordingType(0xc00601fc08)
	pkg/util/tracing/span.go:437 +0x27
github.com/cockroachdb/cockroach/pkg/util/tracing.(*Span).IsVerbose(...)
	pkg/util/tracing/span.go:445
github.com/cockroachdb/cockroach/pkg/util/log.getSpan({0xe39a0c0, 0xc0058c9040})
	pkg/util/log/trace.go:22 +0x45
github.com/cockroachdb/cockroach/pkg/util/log.logfDepthInternal({0xe39a0c0, 0xc0058c9040}, 0x2, 0x3, 0x1, 0x0, {0xaf4b568, 0x27}, {0xc00840d698, 0x2, ...})
	pkg/util/log/channels.go:99 +0x66b
github.com/cockroachdb/cockroach/pkg/util/log.logfDepth(...)
	pkg/util/log/channels.go:34
github.com/cockroachdb/cockroach/pkg/util/log.loggerOps.Errorf(...)
	bazel-out/k8-fastbuild/bin/pkg/util/log/log_channels_generated.go:1281
github.com/cockroachdb/cockroach/pkg/ccl/sqlproxyccl.(*connector).dialTenantCluster(0xc00182d500, {0xe39a0c0, 0xc0058c9040}, {0xe399f70, 0xc005d1b540})
	pkg/ccl/sqlproxyccl/connector.go:243 +0xcd8
github.com/cockroachdb/cockroach/pkg/ccl/sqlproxyccl.(*connector).OpenTenantConnWithToken(0xc00182d500, {0xe39a0c0, 0xc0058c9040}, {0xe399f70, 0xc005d1b540}, {0xc003f0b180, 0x9c})
	pkg/ccl/sqlproxyccl/connector.go:106 +0x1ba
github.com/cockroachdb/cockroach/pkg/ccl/sqlproxyccl.transferConnection(0xc0058c9040, {0xe399f70, 0xc005d1b540}, 0xc00182d500, 0xc000e44fc0, 0xc00a41efc0, 0xc0016003a8)
	pkg/ccl/sqlproxyccl/conn_migration.go:274 +0x40d
github.com/cockroachdb/cockroach/pkg/ccl/sqlproxyccl.(*forwarder).TransferConnection(0xc005d1b540)
	pkg/ccl/sqlproxyccl/conn_migration.go:213 +0x509
github.com/cockroachdb/cockroach/pkg/ccl/sqlproxyccl/balancer.(*Balancer).processQueue.func1.1({0xe39a218, 0xc0029d8db0})
	pkg/ccl/sqlproxyccl/balancer/balancer.go:371 +0x268
github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTaskEx.func2({0xae8c869, 0x11})
	pkg/util/stop/stopper.go:498 +0x339
created by github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTaskEx in goroutine 4539
	pkg/util/stop/stopper.go:488 +0x786
```
<details><summary>Log preceding fatal error</summary>


```
=== RUN TestCancelQuery
 test_log_scope.go:165: test logs captured to: outputs.zip/logTestCancelQuery2849126953
 test_log_scope.go:76: use -show-logs to present logs inline
=== RUN TestCancelQuery/cancel_over_http
=== RUN TestCancelQuery/cancel_over_sql
=== RUN TestCancelQuery/forward_over_http
=== RUN TestCancelQuery/ignore_unknown_secret_key
*
* ERROR: a panic has occurred!
* use of Span after Finish. Span: proxy-con-serve. Finish previously called at: <stack not captured. Set debugUseAfterFinish>
* (1) attached stack trace
* -- stack trace:
* | runtime.gopanic
* | 	GOROOT/src/runtime/panic.go:770
* | [...repeated from below...]
* Wraps: (2) assertion failure
* Wraps: (3) attached stack trace
* -- stack trace:
* | github.com/cockroachdb/cockroach/pkg/util/tracing.(*Span).detectUseAfterFinish
* | 	pkg/util/tracing/span.go:177
* | github.com/cockroachdb/cockroach/pkg/util/tracing.(*Span).RecordingType
* | 	pkg/util/tracing/span.go:437
* | github.com/cockroachdb/cockroach/pkg/util/tracing.(*Span).IsVerbose
* | 	pkg/util/tracing/span.go:445
* | github.com/cockroachdb/cockroach/pkg/util/log.getSpan
* | 	pkg/util/log/trace.go:22
* | github.com/cockroachdb/cockroach/pkg/util/log.logfDepthInternal
* | 	pkg/util/log/channels.go:99
* | github.com/cockroachdb/cockroach/pkg/util/log.logfDepth
* | 	pkg/util/log/channels.go:34
* | github.com/cockroachdb/cockroach/pkg/util/log.loggerOps.Errorf
* | 	bazel-out/k8-fastbuild/bin/pkg/util/log/log_channels_generated.go:1281
* | github.com/cockroachdb/cockroach/pkg/ccl/sqlproxyccl.(*connector).dialTenantCluster
* | 	pkg/ccl/sqlproxyccl/connector.go:243
* | github.com/cockroachdb/cockroach/pkg/ccl/sqlproxyccl.(*connector).OpenTenantConnWithToken
* | 	pkg/ccl/sqlproxyccl/connector.go:106
* | github.com/cockroachdb/cockroach/pkg/ccl/sqlproxyccl.transferConnection
* | 	pkg/ccl/sqlproxyccl/conn_migration.go:274
* | github.com/cockroachdb/cockroach/pkg/ccl/sqlproxyccl.(*forwarder).TransferConnection
* | 	pkg/ccl/sqlproxyccl/conn_migration.go:213
* | github.com/cockroachdb/cockroach/pkg/ccl/sqlproxyccl/balancer.(*Balancer).processQueue.func1.1
* | 	pkg/ccl/sqlproxyccl/balancer/balancer.go:371
* | github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTaskEx.func2
* | 	pkg/util/stop/stopper.go:498
* | runtime.goexit
* | 	src/runtime/asm_amd64.s:1695
* Wraps: (4) use of Span after Finish. Span: proxy-con-serve. Finish previously called at: <stack not captured. Set debugUseAfterFinish>
* Error types: (1) *withstack.withStack (2) *assert.withAssertionFailure (3) *withstack.withStack (4) *errutil.leafError
*
```

</details>

Parameters:
 - <code>attempt=1</code>
 - <code>race=true</code>
 - <code>run=1</code>
 - <code>shard=7</code>
<details><summary>Help</summary>


See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

</details>
<details><summary>Same failure on other branches</summary>


- #151651 ccl/sqlproxyccl: TestCancelQuery failed [C-test-failure O-robot T-sql-foundations branch-release-24.1.23-rc release-blocker]
- #150766 ccl/sqlproxyccl: TestCancelQuery failed [C-test-failure O-robot T-serverless branch-release-24.3.16-rc]
- #149408 ccl/sqlproxyccl: TestCancelQuery failed [C-test-failure O-robot P-3 T-cloud-platform branch-release-25.3]
- #148599 ccl/sqlproxyccl: TestCancelQuery failed [C-test-failure O-robot T-serverless branch-release-24.1]
- #145279 ccl/sqlproxyccl: TestCancelQuery failed [C-test-failure O-robot T-serverless branch-release-25.1]
- #144691 ccl/sqlproxyccl: TestCancelQuery failed [C-test-failure O-robot T-serverless branch-release-24.3]
- #142810 ccl/sqlproxyccl: TestCancelQuery failed [C-test-failure O-robot T-serverless branch-master]
- #136573 ccl/sqlproxyccl: TestCancelQuery failed [C-test-failure O-robot T-serverless branch-release-24.3.0-rc release-blocker]
- #135551 ccl/sqlproxyccl: TestCancelQuery failed [C-test-failure O-robot T-serverless branch-release-24.2 release-blocker]

</details>
/cc @cockroachdb/sql-foundations @cockroachdb/server


[This test on roachdash](https://roachdash.crdb.dev/?filter=status:open%20t:.*TestCancelQuery.*&sort=title+created&display=lastcommented+project) | [Improve this report!](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/bazci/githubpost/issues)




Jira issue: CRDB-53405

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

ccl/sqlproxyccl: TestCancelQuery failed #151664

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

ccl/sqlproxyccl: TestCancelQuery failed #151664

Description

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions