ccl/sqlproxyccl: TestCancelQuery failed

ccl/sqlproxyccl.TestCancelQuery [failed](https://mesolite.cluster.engflow.com/invocations/default/5212fe07-f5e0-4cc5-a521-f1ba76c82b45?testReportRun=2&testReportShard=7&testReportAttempt=1#targets-Ly9wa2cvY2NsL3NxbHByb3h5Y2NsOnNxbHByb3h5Y2NsX3Rlc3Q=) on release-24.3.30-rc @ [6df225aaaada0fb2bec6dd2c61e3f40c003f8914](https://github.com/cockroachdb/cockroach/commits/6df225aaaada0fb2bec6dd2c61e3f40c003f8914):

Fatal error:

```
panic: use of Span after Finish. Span: proxy-con-serve. Finish previously called at: [recovered]
panic: use of Span after Finish. Span: proxy-con-serve. Finish previously called at:

```
Stack:

```
goroutine 5709 [running]:
github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).recover(0xc007586c70?, {0xe3d0c18, 0xc00a69d1d0})
pkg/util/stop/stopper.go:226 +0x74
panic({0xa76d460?, 0xc00a743040?})
GOROOT/src/runtime/panic.go:770 +0x132
github.com/cockroachdb/cockroach/pkg/util/tracing.(*Span).detectUseAfterFinish(0xc007357808)
pkg/util/tracing/span.go:177 +0x274
github.com/cockroachdb/cockroach/pkg/util/tracing.(*Span).RecordingType(0xc007357808)
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({0xe3d0ac0, 0xc004cefa40})
pkg/util/log/trace.go:22 +0x45
github.com/cockroachdb/cockroach/pkg/util/log.logfDepthInternal({0xe3d0ac0, 0xc004cefa40}, 0x2, 0x3, 0x1, 0x0, {0xaf6404a, 0x27}, {0xc007587698, 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(0xc001852880, {0xe3d0ac0, 0xc004cefa40}, {0xe3d0970, 0xc00548a0a0})
pkg/ccl/sqlproxyccl/connector.go:243 +0xcd8
github.com/cockroachdb/cockroach/pkg/ccl/sqlproxyccl.(*connector).OpenTenantConnWithToken(0xc001852880, {0xe3d0ac0, 0xc004cefa40}, {0xe3d0970, 0xc00548a0a0}, {0xc00b7f3b80, 0x94})
pkg/ccl/sqlproxyccl/connector.go:106 +0x1ba
github.com/cockroachdb/cockroach/pkg/ccl/sqlproxyccl.transferConnection(0xc004cefa40, {0xe3d0970, 0xc00548a0a0}, 0xc001852880, 0xc0084c3440, 0xc0058f8d68, 0xc00c2fd2d8)
pkg/ccl/sqlproxyccl/conn_migration.go:274 +0x40d
github.com/cockroachdb/cockroach/pkg/ccl/sqlproxyccl.(*forwarder).TransferConnection(0xc00548a0a0)
pkg/ccl/sqlproxyccl/conn_migration.go:213 +0x509
github.com/cockroachdb/cockroach/pkg/ccl/sqlproxyccl/balancer.(*Balancer).processQueue.func1.1({0xe3d0c18, 0xc00a69d1d0})
pkg/ccl/sqlproxyccl/balancer/balancer.go:371 +0x268
github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTaskEx.func2({0xaea4f37, 0x11})
pkg/util/stop/stopper.go:498 +0x339
created by github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTaskEx in goroutine 4755
pkg/util/stop/stopper.go:488 +0x786
```
Log preceding fatal error

```
=== RUN TestCancelQuery
test_log_scope.go:165: test logs captured to: outputs.zip/logTestCancelQuery144295529
test_log_scope.go:76: use -show-logs to present logs inline
=== 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:
* (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:
* Error types: (1) *withstack.withStack (2) *assert.withAssertionFailure (3) *withstack.withStack (4) *errutil.leafError
*
```

Parameters:
- attempt=1
- race=true
- run=2
- shard=7
Help

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

Same failure on other branches

- #165202 ccl/sqlproxyccl: TestCancelQuery failed [C-test-failure O-robot T-cloud-platform branch-release-26.1]
- #165007 ccl/sqlproxyccl: TestCancelQuery failed [C-test-failure O-robot T-cloud-platform branch-release-24.3.29-rc]

/cc @cockroachdb/sqlproxy-prs @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-62062