sql: TestExplainRedact failed

[cockroach-teamcity]

sql.TestExplainRedact failed with artifacts on master @ de0f60255e3f82da1b37504b294ae91f9268942d:

        	'-12 years -10 mons -266 days -14:15:06.547073':::INTERVAL AS col47,
        	st_isclosed('010500000002000000010200000003000000000000000000244000000000000024400000000000003440000000000000344000000000000024400000000000004440010200000004000000000000000000444000000000000044400000000000003E400000000000003E40000000000000444000000000000034400000000000003E400000000000002440':::GEOMETRY::GEOMETRY)::BOOL
        		AS col48,
        	tab😼15.crdb_internal_mvcc_timestamp AS col49,
        	e'pterodactyl\x10\x1a':::STRING AS "col
        50",
        	'\xc96761488e':::BYTES AS "co%ql51",
        	'd6a6196c-fa36-4e0d-92e1-8fa8f88d1519':::UUID AS "coL52",
        	tab😼15._inet AS col53,
        	tab😼15._jsonb AS col54,
        	tab😼15._enum AS "c!O	l55"
        FROM
        	defaultdb.public.seed@[0] AS tab😼15
        ORDER BY
        	tab😼15._interval DESC NULLS FIRST,
        	tab😼15.crdb_internal_mvcc_timestamp NULLS FIRST,
        	tab😼15.crdb_internal_mvcc_timestamp DESC NULLS LAST,
        	tab😼15._int8 DESC NULLS FIRST,
        	tab😼15._uuid ASC NULLS LAST,
        	tab😼15._int4 DESC NULLS LAST
    explain_test_util.go:39: SELECT
        	"ta\\x3eb16"._timestamp AS "co%pl56",
        	"ta\\x3eb16".crdb_internal_mvcc_timestamp AS "%vcol57",
        	"ta\\x3eb16"._float8 AS col58,
        	"ta\\x3eb16".crdb_internal_mvcc_timestamp AS "col\\xf359",
        	"ta\\x3eb16"._date AS "coL60",
        	"ta\\x3eb16".tableoid AS c😑ol61,
        	false AS "Col62",
        	"ta\\x3eb16"._interval AS col63,
        	NULL AS "coL64"
        FROM
        	defaultdb.public.seed@seed__int8__float8__date_idx AS "ta\\x3eb16"
        LIMIT
        	83:::INT8
    explain_test_util.go:39: SELECT
        	"tab 17"._bool AS col65, "tab 17"._date AS col66, (-0.22942033506035892):::FLOAT8 AS "c%9bol67"
        FROM
        	defaultdb.public.seed@seed__int8__float8__date_idx AS "tab 17"
        WHERE
        	false
        LIMIT
        	8:::INT8
=== CONT  TestExplainRedact
    explain_test.go:566: -- test log scope end --
    explain_test.go:566: Leaked goroutine: goroutine 93840 [select]:
        github.com/cockroachdb/pebble/vfs.(*diskHealthCheckingFile).startTicker.func1()
        	github.com/cockroachdb/pebble/vfs/external/com_github_cockroachdb_pebble/vfs/disk_health.go:172 +0xdc
        created by github.com/cockroachdb/pebble/vfs.(*diskHealthCheckingFile).startTicker
        	github.com/cockroachdb/pebble/vfs/external/com_github_cockroachdb_pebble/vfs/disk_health.go:167 +0x5d
--- FAIL: TestExplainRedact (35.49s)

Help

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

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-30787

[michae2]

Leaked goroutine in diskHealthCheckingFile seems like #106119

[msirek]

Closing as dup of #106119