sql/tests: TestRandomSyntaxGeneration failed

[cockroach-teamcity]

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-24.1.0-rc @ 5e4ca9e26f1a25681de9c944298cfa139c344466:

    rsg_test.go:882: 2m0s of 5m0s: 228939 executions, 12142 successful
    rsg_test.go:882: 2m5s of 5m0s: 232675 executions, 12331 successful
    rsg_test.go:882: 2m10s of 5m0s: 236761 executions, 12522 successful
    rsg_test.go:882: 2m15s of 5m0s: 240877 executions, 12704 successful
    rsg_test.go:882: 2m20s of 5m0s: 244639 executions, 12888 successful
    rsg_test.go:882: 2m25s of 5m0s: 248013 executions, 13061 successful
    rsg_test.go:882: 2m30s of 5m0s: 251470 executions, 13249 successful
    rsg_test.go:882: 2m35s of 5m0s: 255174 executions, 13438 successful
    rsg_test.go:882: 2m40s of 5m0s: 259012 executions, 13619 successful
    rsg_test.go:882: 2m45s of 5m0s: 262916 executions, 13813 successful
    rsg_test.go:882: 2m50s of 5m0s: 266691 executions, 13993 successful
    rsg_test.go:882: 2m55s of 5m0s: 270330 executions, 14162 successful
    rsg_test.go:882: 3m0s of 5m0s: 273886 executions, 14327 successful
    rsg_test.go:882: 3m5s of 5m0s: 277399 executions, 14491 successful
    rsg_test.go:882: 3m10s of 5m0s: 281108 executions, 14653 successful
    rsg_test.go:882: 3m15s of 5m0s: 285088 executions, 14832 successful
    rsg_test.go:882: 3m20s of 5m0s: 288795 executions, 15017 successful
    rsg_test.go:882: 3m25s of 5m0s: 292648 executions, 15181 successful
    rsg_test.go:882: 3m30s of 5m0s: 295914 executions, 15309 successful
    rsg_test.go:882: 3m35s of 5m0s: 299079 executions, 15458 successful
    rsg_test.go:882: 3m40s of 5m0s: 302350 executions, 15616 successful
    rsg_test.go:882: 3m45s of 5m0s: 305956 executions, 15792 successful
    rsg_test.go:882: 3m50s of 5m0s: 309606 executions, 15948 successful
    rsg_test.go:882: 3m55s of 5m0s: 313398 executions, 16120 successful
    rsg_test.go:882: 4m0s of 5m0s: 316982 executions, 16296 successful
    rsg_test.go:882: 4m5s of 5m0s: 320961 executions, 16503 successful
    rsg_test.go:882: 4m10s of 5m0s: 324656 executions, 16647 successful
    rsg_test.go:882: 4m15s of 5m0s: 328541 executions, 16812 successful
    rsg_test.go:882: 4m20s of 5m0s: 332284 executions, 17009 successful
    rsg_test.go:882: 4m25s of 5m0s: 336109 executions, 17179 successful
    rsg_test.go:882: 4m30s of 5m0s: 339526 executions, 17365 successful
    rsg_test.go:882: 4m35s of 5m0s: 342874 executions, 17526 successful
    rsg_test.go:882: 4m40s of 5m0s: 346221 executions, 17674 successful
    rsg_test.go:882: 4m45s of 5m0s: 349414 executions, 17833 successful
    rsg_test.go:882: 4m50s of 5m0s: 352480 executions, 17958 successful
    rsg_test.go:882: 4m55s of 5m0s: 354217 executions, 18033 successful
    rsg_test.go:211: Context cancelled while executing: "SHOW JOBS WITH EXECUTION DETAILS , EXECUTION DETAILS"
    rsg_test.go:211: Context cancelled while executing: "REASSIGN OWNED BY CURRENT_USER , SESSION_USER , CURRENT_USER , REDACT TO SESSION_USER"
    rsg_test.go:211: Context cancelled while executing: "REASSIGN OWNED BY TRUNCATE , SESSION_USER , ident TO SESSION_USER"
    rsg_test.go:211: Context cancelled while executing: "REASSIGN OWNED BY CURRENT_USER , CURRENT_USER , SESSION_USER , CURRENT_USER , SESSION_USER TO CURRENT_USER"
    rsg_test.go:211: Context cancelled while executing: "REASSIGN OWNED BY CURRENT_USER , CURRENT_USER , ident , ident , SESSION_USER , ident TO CURRENT_USER"
    rsg_test.go:211: Context cancelled while executing: "REASSIGN OWNED BY NODE , CURRENT_USER TO SESSION_USER"
    rsg_test.go:211: Context cancelled while executing: "REASSIGN OWNED BY CURRENT_USER , ATTRIBUTE , SESSION_USER , SESSION_USER TO SESSION_USER"
    rsg_test.go:211: Context cancelled while executing: "REASSIGN OWNED BY SESSION_USER , ident , CURRENT_USER , SESSION_USER , SESSION_USER , ident TO ident"
    rsg_test.go:882: 5m0s of 5m0s: 354218 executions, 18033 successful
    rsg_test.go:918: 354225 executions, 18040 successful
    rsg_test.go:926: cannot parse output of Format: sql="PREPARE SMALLINT AS CREATE TEMP TABLE IF NOT EXISTS SEARCH ( UNIQUE INDEX ( CURRENT_TIMESTAMP SMALLINT , CURRENT_TIMESTAMP ident ASC ) PARTITION BY NOTHING WITH ( 'string' = INDEX_BEFORE_PAREN ) ) WITHOUT OIDS LOCALITY GLOBAL", formattedSQL="PREPARE \"smallint\" AS CREATE TEMPORARY TABLE IF NOT EXISTS search (UNIQUE (current_timestamp() \"smallint\", current_timestamp() ident ASC) PARTITION BY NOTHING WITH (\"string\" = \"index_before_paren\")) LOCALITY GLOBAL": at or near "with": syntax error
    rsg_test.go:319: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration3102831984
--- FAIL: TestRandomSyntaxGeneration (301.98s)

Help

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

Same failure on other branches

• sql/tests: TestRandomSyntaxGeneration failed [default zone config got deleted] #124198 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-release-23.1.22-rc]

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-38855