roachtest: sqlsmith/setup=seed-multi-region/setting=multi-region failed

Note: This build has runtime assertions enabled. If the same failure was hit in a run without assertions enabled, there should be a similar failure without this message. If there isn't one, then this failure is likely due to an assertion violation or (assertion) timeout.

roachtest.sqlsmith/setup=seed-multi-region/setting=multi-region failed with artifacts on release-24.1 @ 5d5fb881579da37f33e660d4fc8cc54b5fdc4ba7:

stmt:
SELECT
    *
FROM
    (
        SELECT
            (
                SELECT
                    tab_446._int8 AS col_867
                FROM
                    defaultdb.public.seed_mr_table@[0] AS tab_447
                ORDER BY
                    col_867 DESC NULLS FIRST
                LIMIT
                    1:::INT8
            )
                AS col_868,
            NULL::INTERVAL AS col_869,
            '\x46':::BYTES::BYTES AS col_870,
            tab_446._timestamp AS col_871,
            NULL::STRING AS col_872
        FROM
            defaultdb.public.seed_mr_table@[0] AS tab_446
        ORDER BY
            col_870 ASC NULLS FIRST,
            tab_446._int2 DESC,
            col_869 ASC NULLS FIRST,
            tab_446._float8 NULLS FIRST,
            tab_446._int4 DESC,
            col_872,
            tab_446._int8 DESC NULLS FIRST,
            tab_446._decimal ASC,
            col_868 NULLS LAST,
            tab_446._bytes DESC NULLS FIRST,
            col_871 DESC,
            tab_446._bool ASC NULLS LAST,
            tab_446._timestamptz DESC NULLS LAST,
            tab_446._uuid NULLS LAST,
            tab_446._date DESC NULLS LAST,
            tab_446.tableoid DESC NULLS LAST,
            tab_446._string,
            tab_446._timestamp NULLS FIRST,
            tab_446._interval ASC NULLS FIRST
        LIMIT
            32:::INT8
    )
        AS tab_448
ORDER BY
    col_868 ASC NULLS LAST, col_869 ASC NULLS LAST, col_870 DESC NULLS LAST, col_871 ASC, col_872 ASC NULLS FIRST;
test artifacts and logs in: /artifacts/sqlsmith/setup=seed-multi-region/setting=multi-region/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_fs=ext4
ROACHTEST_localSSD=true
ROACHTEST_runtimeAssertionsBuild=true
ROACHTEST_ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!

Jira issue: CRDB-43931}

cockroachdb / cockroach

roachtest: sqlsmith/setup=seed-multi-region/setting=multi-region failed #134142