sql/tests: TestRandomSyntaxGeneration failed

[cockroach-teamcity]

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1.0 @ 358e0d87912365b8976c55ab9b3292e999cf720d:

    rsg_test.go:828: 1m15s of 5m0s: 223580 executions, 12326 successful
    rsg_test.go:828: 1m20s of 5m0s: 236222 executions, 12968 successful
    rsg_test.go:828: 1m25s of 5m0s: 248868 executions, 13558 successful
    rsg_test.go:828: 1m30s of 5m0s: 263646 executions, 14303 successful
    rsg_test.go:828: 1m35s of 5m0s: 277179 executions, 14930 successful
    rsg_test.go:828: 1m40s of 5m0s: 290678 executions, 15569 successful
    rsg_test.go:828: 1m45s of 5m0s: 304004 executions, 16224 successful
    rsg_test.go:828: 1m50s of 5m0s: 318055 executions, 16893 successful
    rsg_test.go:828: 1m55s of 5m0s: 330859 executions, 17525 successful
    rsg_test.go:828: 2m0s of 5m0s: 344047 executions, 18122 successful
    rsg_test.go:828: 2m5s of 5m0s: 356770 executions, 18774 successful
    rsg_test.go:828: 2m10s of 5m0s: 371892 executions, 19525 successful
    rsg_test.go:828: 2m15s of 5m0s: 388251 executions, 20269 successful
    rsg_test.go:828: 2m20s of 5m0s: 404324 executions, 20997 successful
    rsg_test.go:828: 2m25s of 5m0s: 419871 executions, 21752 successful
    rsg_test.go:828: 2m30s of 5m0s: 435178 executions, 22426 successful
    rsg_test.go:828: 2m35s of 5m0s: 450696 executions, 23167 successful
    rsg_test.go:828: 2m40s of 5m0s: 467366 executions, 23933 successful
    rsg_test.go:828: 2m45s of 5m0s: 483475 executions, 24669 successful
    rsg_test.go:828: 2m50s of 5m0s: 500073 executions, 25441 successful
    rsg_test.go:828: 2m55s of 5m0s: 515469 executions, 26162 successful
    rsg_test.go:828: 3m0s of 5m0s: 532570 executions, 26913 successful
    rsg_test.go:828: 3m5s of 5m0s: 548518 executions, 27649 successful
    rsg_test.go:828: 3m10s of 5m0s: 566156 executions, 28429 successful
    rsg_test.go:828: 3m15s of 5m0s: 583202 executions, 29203 successful
    rsg_test.go:828: 3m20s of 5m0s: 601287 executions, 30004 successful
    rsg_test.go:828: 3m25s of 5m0s: 618920 executions, 30848 successful
    rsg_test.go:828: 3m30s of 5m0s: 637670 executions, 31772 successful
    rsg_test.go:828: 3m35s of 5m0s: 655731 executions, 32626 successful
    rsg_test.go:828: 3m40s of 5m0s: 674041 executions, 33456 successful
    rsg_test.go:828: 3m45s of 5m0s: 692377 executions, 34307 successful
    rsg_test.go:828: 3m50s of 5m0s: 710328 executions, 35123 successful
    rsg_test.go:828: 3m55s of 5m0s: 729487 executions, 35985 successful
    rsg_test.go:828: 4m0s of 5m0s: 748459 executions, 36826 successful
    rsg_test.go:828: 4m5s of 5m0s: 766125 executions, 37664 successful
    rsg_test.go:828: 4m10s of 5m0s: 783404 executions, 38522 successful
    rsg_test.go:828: 4m15s of 5m0s: 800890 executions, 39339 successful
    rsg_test.go:828: 4m20s of 5m0s: 818625 executions, 40070 successful
    rsg_test.go:828: 4m25s of 5m0s: 836712 executions, 40857 successful
    rsg_test.go:828: 4m30s of 5m0s: 852706 executions, 41589 successful
    rsg_test.go:828: 4m35s of 5m0s: 867109 executions, 42232 successful
    rsg_test.go:828: 4m40s of 5m0s: 883819 executions, 43047 successful
    rsg_test.go:828: 4m45s of 5m0s: 901093 executions, 43875 successful
    rsg_test.go:828: 4m50s of 5m0s: 918672 executions, 44772 successful
    rsg_test.go:828: 4m55s of 5m0s: 936394 executions, 45614 successful
    rsg_test.go:864: 953578 executions, 46376 successful
    rsg_test.go:872: cannot parse output of Format: sql="CREATE TENANT IF NOT EXISTS 'string' FROM REPLICATION OF TRUE ON INTERVAL 'string'", formattedSQL="CREATE TENANT IF NOT EXISTS 'string' FROM REPLICATION OF (true) ON 'string'::INTERVAL": at or near ":": syntax error
    rsg_test.go:305: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration385513911
--- FAIL: TestRandomSyntaxGeneration (302.02s)

Help

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

Same failure on other branches

• sql/tests: TestRandomSyntaxGeneration failed #101272 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot todo-deprecate.branch-release-23.1.0]
• sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-master]
• sql/tests: TestRandomSyntaxGeneration failed #99183 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-release-23.1]
• sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-release-22.2]
• sql/tests: TestRandomSyntaxGeneration failed #77893 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-release-22.1]

/cc @cockroachdb/sql-sessions

This test on roachdash | Improve this report!

Jira issue: CRDB-28483