pkg/sql/sem/eval/cast_test/cast_test_test: TestAssignmentCastsMatchPostgres failed

pkg/sql/sem/eval/cast_test/cast_test_test.TestAssignmentCastsMatchPostgres [failed](https://mesolite.cluster.engflow.com/invocations/default/5bfb4faf-02ac-4445-8fa2-1f163941e06f?testReportRun=3&testReportShard=1&testReportAttempt=1#targets-Ly9wa2cvc3FsL3NlbS9ldmFsL2Nhc3RfdGVzdDpjYXN0X3Rlc3RfdGVzdA==) on master @ [5318641d2b0ff04dbdaced9f83ecb0d692f697b6](https://github.com/cockroachdb/cockroach/commits/5318641d2b0ff04dbdaced9f83ecb0d692f697b6):

```
github.com/cockroachdb/cockroach/pkg/util/admission.initWorkQueue.func2()
pkg/util/admission/work_queue.go:511 +0xfa
created by github.com/cockroachdb/cockroach/pkg/util/admission.initWorkQueue in goroutine 39221
pkg/util/admission/work_queue.go:508 +0x7bd

goroutine 39247 [select]:
github.com/cockroachdb/cockroach/pkg/util/admission.initWorkQueue.func2()
pkg/util/admission/work_queue.go:511 +0xfa
created by github.com/cockroachdb/cockroach/pkg/util/admission.initWorkQueue in goroutine 39221
pkg/util/admission/work_queue.go:508 +0x7bd

goroutine 39250 [runnable]:
github.com/cockroachdb/cockroach/pkg/util/admission.(*WorkQueue).startClosingEpochs.func1()
pkg/util/admission/work_queue.go:621 +0x1c9
created by github.com/cockroachdb/cockroach/pkg/util/admission.(*WorkQueue).startClosingEpochs in goroutine 39221
pkg/util/admission/work_queue.go:592 +0x8b

goroutine 39265 [select]:
github.com/cockroachdb/pebble/vfs.(*diskHealthCheckingFile).startTicker.func1()
external/com_github_cockroachdb_pebble/vfs/disk_health.go:259 +0x18c
created by github.com/cockroachdb/pebble/vfs.(*diskHealthCheckingFile).startTicker in goroutine 39221
external/com_github_cockroachdb_pebble/vfs/disk_health.go:254 +0xa8

goroutine 39262 [chan receive, 37 minutes]:
github.com/cockroachdb/pebble/internal/genericcache.(*shard[...]).releaseLoop(0x0)
external/com_github_cockroachdb_pebble/internal/genericcache/shard.go:62 +0xbf
created by github.com/cockroachdb/pebble/internal/genericcache.(*shard[...]).Init in goroutine 39221
external/com_github_cockroachdb_pebble/internal/genericcache/shard.go:55 +0x36b

goroutine 307511 [sync.Cond.Wait, "pebble":"wal-sync"]:
sync.runtime_notifyListWait(0xc0344d0088, 0x1a)
GOROOT/src/runtime/sema.go:617 +0x1b3
sync.(*Cond).Wait(0xc0344d0078)
GOROOT/src/sync/cond.go:71 +0x55
github.com/cockroachdb/pebble/record.(*flusherCond).Wait(...)
external/com_github_cockroachdb_pebble/record/log_writer.go:374
github.com/cockroachdb/pebble/record.(*LogWriter).flushLoop(0xc0344d0000, {0xc004813848?, 0x96760c0?})
external/com_github_cockroachdb_pebble/record/log_writer.go:677 +0x1f9
runtime/pprof.Do({0xa603570, 0x120b8840}, {{0xc001146b60?, 0x8fe2880?, 0x7f26ecc79200?}}, 0xc01d24efc0)
GOROOT/src/runtime/pprof/runtime.go:57 +0x112
github.com/cockroachdb/pebble/record.NewLogWriter.func2()
external/com_github_cockroachdb_pebble/record/log_writer.go:591 +0x92
created by github.com/cockroachdb/pebble/record.NewLogWriter in goroutine 307508
external/com_github_cockroachdb_pebble/record/log_writer.go:590 +0x8e6

goroutine 39244 [runnable]:
github.com/cockroachdb/cockroach/pkg/util/admission.(*WorkQueue).startClosingEpochs.func1()
pkg/util/admission/work_queue.go:621 +0x1c9
created by github.com/cockroachdb/cockroach/pkg/util/admission.(*WorkQueue).startClosingEpochs in goroutine 39221
pkg/util/admission/work_queue.go:592 +0x8b
```

Parameters:
- attempt=1
- race=true
- run=3
- shard=1
Help

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

[Improve this report!](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/bazci/githubpost/issues)

Jira issue: CRDB-68156

Start with pkg/sql/sem/eval/cast_test/cast_test_test and the linked test invocation, reproducing TestAssignmentCastsMatchPostgres with race=true, run=3, shard=1, and attempt=1. Read the reported stack trace and test output to determine why the test fails; done means the test passes reliably under the reported configuration.

Written by the indexing model from the issue text.