sql/tests: TestRandomSyntaxGeneration failed

[cockroach-teamcity]

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-22.2 @ 59a2f42f39e0bfd8d5140f1493c602d9dccd43eb:

    rsg_test.go:824: 1m15s of 5m0s: 266754 executions, 14198 successful
    rsg_test.go:824: 1m20s of 5m0s: 284060 executions, 15013 successful
    rsg_test.go:824: 1m25s of 5m0s: 301915 executions, 15896 successful
    rsg_test.go:824: 1m30s of 5m0s: 320380 executions, 16758 successful
    rsg_test.go:824: 1m35s of 5m0s: 338717 executions, 17575 successful
    rsg_test.go:824: 1m40s of 5m0s: 356290 executions, 18394 successful
    rsg_test.go:824: 1m45s of 5m0s: 374730 executions, 19235 successful
    rsg_test.go:824: 1m50s of 5m0s: 392445 executions, 19999 successful
    rsg_test.go:824: 1m55s of 5m0s: 410685 executions, 20837 successful
    rsg_test.go:824: 2m0s of 5m0s: 428811 executions, 21636 successful
    rsg_test.go:824: 2m5s of 5m0s: 445310 executions, 22445 successful
    rsg_test.go:824: 2m10s of 5m0s: 462914 executions, 23218 successful
    rsg_test.go:824: 2m15s of 5m0s: 481686 executions, 24085 successful
    rsg_test.go:824: 2m20s of 5m0s: 499955 executions, 24973 successful
    rsg_test.go:824: 2m25s of 5m0s: 519368 executions, 25812 successful
    rsg_test.go:824: 2m30s of 5m0s: 537699 executions, 26623 successful
    rsg_test.go:824: 2m35s of 5m0s: 554601 executions, 27334 successful
    rsg_test.go:824: 2m40s of 5m0s: 573732 executions, 28060 successful
    rsg_test.go:824: 2m45s of 5m0s: 592298 executions, 28821 successful
    rsg_test.go:824: 2m50s of 5m0s: 610491 executions, 29512 successful
    rsg_test.go:824: 2m55s of 5m0s: 629613 executions, 30305 successful
    rsg_test.go:824: 3m0s of 5m0s: 647424 executions, 30994 successful
    rsg_test.go:824: 3m5s of 5m0s: 665943 executions, 31773 successful
    rsg_test.go:824: 3m10s of 5m0s: 683619 executions, 32506 successful
    rsg_test.go:824: 3m15s of 5m0s: 702284 executions, 33214 successful
    rsg_test.go:824: 3m20s of 5m0s: 721099 executions, 33965 successful
    rsg_test.go:824: 3m25s of 5m0s: 739876 executions, 34692 successful
    rsg_test.go:824: 3m30s of 5m0s: 758189 executions, 35345 successful
    rsg_test.go:824: 3m35s of 5m0s: 777540 executions, 36238 successful
    rsg_test.go:824: 3m40s of 5m0s: 795299 executions, 37060 successful
    rsg_test.go:824: 3m45s of 5m0s: 814342 executions, 37884 successful
    rsg_test.go:824: 3m50s of 5m0s: 832989 executions, 38691 successful
    rsg_test.go:824: 3m55s of 5m0s: 851543 executions, 39580 successful
    rsg_test.go:824: 4m0s of 5m0s: 868939 executions, 40410 successful
    rsg_test.go:824: 4m5s of 5m0s: 883516 executions, 41081 successful
    rsg_test.go:824: 4m10s of 5m0s: 901252 executions, 41869 successful
    rsg_test.go:824: 4m15s of 5m0s: 919314 executions, 42680 successful
    rsg_test.go:824: 4m20s of 5m0s: 938055 executions, 43539 successful
    rsg_test.go:824: 4m25s of 5m0s: 956524 executions, 44328 successful
    rsg_test.go:824: 4m30s of 5m0s: 974054 executions, 45167 successful
    rsg_test.go:824: 4m35s of 5m0s: 991520 executions, 45922 successful
    rsg_test.go:824: 4m40s of 5m0s: 1010357 executions, 46774 successful
    rsg_test.go:824: 4m45s of 5m0s: 1029078 executions, 47617 successful
    rsg_test.go:824: 4m50s of 5m0s: 1047539 executions, 48356 successful
    rsg_test.go:824: 4m55s of 5m0s: 1065219 executions, 49174 successful
    rsg_test.go:860: 1083414 executions, 49935 successful
    rsg_test.go:868: cannot parse output of Format: sql="SHOW BACKUP PLACEHOLDER WITH OPTIONS ( BUCKET_COUNT , 'string' )", formattedSQL="SHOW BACKUP 'placeholder' WITH bucket_count, \"string\"": at or near "with": syntax error
    rsg_test.go:306: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration2073406983
--- FAIL: TestRandomSyntaxGeneration (301.26s)

Help

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

Same failure on other branches

• sql/tests: TestRandomSyntaxGeneration failed [DROP DATABASE timeout] #109946 sql/tests: TestRandomSyntaxGeneration failed [DROP DATABASE timeout] [C-test-failure O-robot T-sql-foundations branch-master release-blocker]

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-31410

[rafiss]

@annrpom when you get some time, I think the WITH OPTIONS change for BACKUP syntax needs to be backported to 22.2.