search

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
https://www.cockroachlabs.com
Other
29.99k stars 3.79k forks source link

sql: TestExplainRedact failed #119938

Closed cockroach-teamcity closed 7 months ago

cockroach-teamcity commented 7 months ago

sql.TestExplainRedact failed with artifacts on release-23.2.3-rc @ ff5f4fb2c63a92c655ea0f9a5920c48885831d06:

                        )
                            AS tab37 (col67)
                )
        SELECT
            tab38._uuid AS "col/68",
            tab38._decimal AS "Col69",
            int2(tab38.crdb_internal_mvcc_timestamp::DECIMAL)::INT2 AS col70,
            tab38._timestamp AS "'coL71",
            tab38._jsonb AS "co}l72",
            tab38._enum AS col73,
            tab38._date AS col74,
            tab38._int2 AS "😪co%vl75",
            NULL AS "co�l76",
            true AS col77,
            e'pterodactyloee\x05\fPZ\t':::STRING AS col78,
            tab38._float8 AS "col\\x2a79",
            '52 years 5 mons 426 days 18:29:58.951442':::INTERVAL AS col😫80
        FROM
            defaultdb.public.seed@[0] AS tab38
        WHERE
            tab38._bool
        ORDER BY
            tab38._uuid DESC, tab38._enum ASC, tab38._date DESC
    explain_test.go:561: -- test log scope end --
    explain_test.go:561: Leaked goroutine: goroutine 1161324 [select]:
        github.com/cockroachdb/pebble/vfs.(*diskHealthCheckingFile).startTicker.func1()
            github.com/cockroachdb/pebble/vfs/external/com_github_cockroachdb_pebble/vfs/disk_health.go:171 +0xcb
        created by github.com/cockroachdb/pebble/vfs.(*diskHealthCheckingFile).startTicker in goroutine 1158205
            github.com/cockroachdb/pebble/vfs/external/com_github_cockroachdb_pebble/vfs/disk_health.go:166 +0x58
        Leaked goroutine: goroutine 1161325 [select]:
        github.com/cockroachdb/pebble/vfs.(*diskHealthCheckingFile).startTicker.func1()
            github.com/cockroachdb/pebble/vfs/external/com_github_cockroachdb_pebble/vfs/disk_health.go:171 +0xcb
        created by github.com/cockroachdb/pebble/vfs.(*diskHealthCheckingFile).startTicker in goroutine 1158205
            github.com/cockroachdb/pebble/vfs/external/com_github_cockroachdb_pebble/vfs/disk_health.go:166 +0x58
        Leaked goroutine: goroutine 1161326 [select]:
        github.com/cockroachdb/pebble/vfs.(*diskHealthCheckingFile).startTicker.func1()
            github.com/cockroachdb/pebble/vfs/external/com_github_cockroachdb_pebble/vfs/disk_health.go:171 +0xcb
        created by github.com/cockroachdb/pebble/vfs.(*diskHealthCheckingFile).startTicker in goroutine 1158205
            github.com/cockroachdb/pebble/vfs/external/com_github_cockroachdb_pebble/vfs/disk_health.go:166 +0x58
        Leaked goroutine: goroutine 1161327 [select]:
        github.com/cockroachdb/pebble/vfs.(*diskHealthCheckingFile).startTicker.func1()
            github.com/cockroachdb/pebble/vfs/external/com_github_cockroachdb_pebble/vfs/disk_health.go:171 +0xcb
        created by github.com/cockroachdb/pebble/vfs.(*diskHealthCheckingFile).startTicker in goroutine 1158205
            github.com/cockroachdb/pebble/vfs/external/com_github_cockroachdb_pebble/vfs/disk_health.go:166 +0x58
        Leaked goroutine: goroutine 1161328 [select]:
        github.com/cockroachdb/pebble/vfs.(*diskHealthCheckingFile).startTicker.func1()
            github.com/cockroachdb/pebble/vfs/external/com_github_cockroachdb_pebble/vfs/disk_health.go:171 +0xcb
        created by github.com/cockroachdb/pebble/vfs.(*diskHealthCheckingFile).startTicker in goroutine 1158205
            github.com/cockroachdb/pebble/vfs/external/com_github_cockroachdb_pebble/vfs/disk_health.go:166 +0x58
--- FAIL: TestExplainRedact (143.13s)

Parameters:

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

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-36401

yuzefovich commented 7 months ago

Let's backport #118790 to 23.2 in hopes of understanding this failure.