sql/tests: TestRandomSyntaxGeneration failed #99183

cockroach-teamcity · 2023-03-22T05:18:30Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ 80c4895c566a7eaa6f16c4098980509dd3795ad7:

    rsg_test.go:828: 1m15s of 5m0s: 304485 executions, 16236 successful
    rsg_test.go:828: 1m20s of 5m0s: 324097 executions, 17220 successful
    rsg_test.go:828: 1m25s of 5m0s: 344845 executions, 18191 successful
    rsg_test.go:828: 1m30s of 5m0s: 365578 executions, 19164 successful
    rsg_test.go:828: 1m35s of 5m0s: 386509 executions, 20224 successful
    rsg_test.go:828: 1m40s of 5m0s: 407054 executions, 21228 successful
    rsg_test.go:828: 1m45s of 5m0s: 428383 executions, 22185 successful
    rsg_test.go:828: 1m50s of 5m0s: 449511 executions, 23172 successful
    rsg_test.go:828: 1m55s of 5m0s: 469966 executions, 24117 successful
    rsg_test.go:828: 2m0s of 5m0s: 490256 executions, 25060 successful
    rsg_test.go:828: 2m5s of 5m0s: 509540 executions, 26006 successful
    rsg_test.go:828: 2m10s of 5m0s: 530677 executions, 26952 successful
    rsg_test.go:828: 2m15s of 5m0s: 551647 executions, 27862 successful
    rsg_test.go:828: 2m20s of 5m0s: 571437 executions, 28837 successful
    rsg_test.go:828: 2m25s of 5m0s: 591440 executions, 29775 successful
    rsg_test.go:828: 2m30s of 5m0s: 611527 executions, 30766 successful
    rsg_test.go:828: 2m35s of 5m0s: 630722 executions, 31633 successful
    rsg_test.go:828: 2m40s of 5m0s: 650553 executions, 32566 successful
    rsg_test.go:828: 2m45s of 5m0s: 671106 executions, 33513 successful
    rsg_test.go:828: 2m50s of 5m0s: 691279 executions, 34377 successful
    rsg_test.go:828: 2m55s of 5m0s: 711558 executions, 35358 successful
    rsg_test.go:828: 3m0s of 5m0s: 731435 executions, 36233 successful
    rsg_test.go:828: 3m5s of 5m0s: 750009 executions, 37126 successful
    rsg_test.go:828: 3m10s of 5m0s: 770059 executions, 38080 successful
    rsg_test.go:828: 3m15s of 5m0s: 789423 executions, 39011 successful
    rsg_test.go:828: 3m20s of 5m0s: 809807 executions, 39892 successful
    rsg_test.go:828: 3m25s of 5m0s: 830506 executions, 40801 successful
    rsg_test.go:828: 3m30s of 5m0s: 851135 executions, 41749 successful
    rsg_test.go:828: 3m35s of 5m0s: 869967 executions, 42661 successful
    rsg_test.go:828: 3m40s of 5m0s: 889403 executions, 43650 successful
    rsg_test.go:828: 3m45s of 5m0s: 910104 executions, 44646 successful
    rsg_test.go:828: 3m50s of 5m0s: 929595 executions, 45563 successful
    rsg_test.go:828: 3m55s of 5m0s: 949496 executions, 46468 successful
    rsg_test.go:828: 4m0s of 5m0s: 970782 executions, 47416 successful
    rsg_test.go:828: 4m5s of 5m0s: 991459 executions, 48336 successful
    rsg_test.go:828: 4m10s of 5m0s: 1011580 executions, 49262 successful
    rsg_test.go:828: 4m15s of 5m0s: 1032564 executions, 50249 successful
    rsg_test.go:828: 4m20s of 5m0s: 1051415 executions, 51177 successful
    rsg_test.go:828: 4m25s of 5m0s: 1072807 executions, 52052 successful
    rsg_test.go:828: 4m30s of 5m0s: 1094219 executions, 52986 successful
    rsg_test.go:828: 4m35s of 5m0s: 1113226 executions, 53914 successful
    rsg_test.go:828: 4m40s of 5m0s: 1133876 executions, 54914 successful
    rsg_test.go:828: 4m45s of 5m0s: 1154037 executions, 55930 successful
    rsg_test.go:828: 4m50s of 5m0s: 1174356 executions, 56842 successful
    rsg_test.go:828: 4m55s of 5m0s: 1194922 executions, 57783 successful
    rsg_test.go:864: 1215012 executions, 58697 successful
    rsg_test.go:872: cannot parse output of Format: sql="SHOW BACKUP CONNECTION 'string' WITH TRANSFER = PLACEHOLDER , TIME = PLACEHOLDER", formattedSQL="SHOW BACKUP CONNECTION 'string' WITH TIME = 'placeholder', TRANSFER = 'placeholder'": at or near "with": syntax error
    rsg_test.go:305: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration3672579691
--- FAIL: TestRandomSyntaxGeneration (300.62s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2]
sql/tests: TestRandomSyntaxGeneration failed #89363 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2.0]
sql/tests: TestRandomSyntaxGeneration failed #77893 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.1]
sql/tests: TestRandomSyntaxGeneration failed #74271 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.2]
sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

/cc @cockroachdb/sql-sessions _{This test on roachdash | Improve this report!

Jira issue: CRDB-25739}

The text was updated successfully, but these errors were encountered:

cockroach-teamcity · 2023-03-23T05:10:05Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ 751b17200b6026b73351c57cab734415d2c4b02a:

    rsg_test.go:828: 2m40s of 5m0s: 591356 executions, 29764 successful
    rsg_test.go:828: 2m45s of 5m0s: 611232 executions, 30636 successful
    rsg_test.go:828: 2m50s of 5m0s: 629870 executions, 31517 successful
    rsg_test.go:828: 2m55s of 5m0s: 648452 executions, 32351 successful
    rsg_test.go:828: 3m0s of 5m0s: 666258 executions, 33227 successful
    rsg_test.go:828: 3m5s of 5m0s: 684557 executions, 34089 successful
    rsg_test.go:828: 3m10s of 5m0s: 701939 executions, 34893 successful
    rsg_test.go:828: 3m15s of 5m0s: 721010 executions, 35717 successful
    rsg_test.go:828: 3m20s of 5m0s: 740928 executions, 36593 successful
    rsg_test.go:828: 3m25s of 5m0s: 761171 executions, 37629 successful
    rsg_test.go:828: 3m30s of 5m0s: 780286 executions, 38537 successful
    rsg_test.go:828: 3m35s of 5m0s: 799450 executions, 39440 successful
    rsg_test.go:828: 3m40s of 5m0s: 819119 executions, 40384 successful
    rsg_test.go:828: 3m45s of 5m0s: 838623 executions, 41308 successful
    rsg_test.go:828: 3m50s of 5m0s: 857235 executions, 42220 successful
    rsg_test.go:828: 3m55s of 5m0s: 876505 executions, 43112 successful
    rsg_test.go:828: 4m0s of 5m0s: 895375 executions, 44002 successful
    rsg_test.go:828: 4m5s of 5m0s: 915970 executions, 44933 successful
    rsg_test.go:828: 4m10s of 5m0s: 935143 executions, 45835 successful
    rsg_test.go:828: 4m15s of 5m0s: 955015 executions, 46799 successful
    rsg_test.go:828: 4m20s of 5m0s: 975290 executions, 47715 successful
    rsg_test.go:828: 4m25s of 5m0s: 994776 executions, 48664 successful
    rsg_test.go:828: 4m30s of 5m0s: 1014674 executions, 49534 successful
    rsg_test.go:828: 4m35s of 5m0s: 1035177 executions, 50501 successful
    rsg_test.go:828: 4m40s of 5m0s: 1054469 executions, 51379 successful
panic: cannot disable buffering here

goroutine 9789358 [running]:
github.com/cockroachdb/cockroach/pkg/sql.(*streamingCommandResult).DisableBuffering(0xc0143e5000?)
	github.com/cockroachdb/cockroach/pkg/sql/conn_io.go:1016 +0x27
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine(0xc0143e5000, {0x70a0d30, 0xc04c6e69f0}, 0xc0143e55e8, {0x70f8620, 0xc04c6e68d0})
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1260 +0x483
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState(0xc0143e5000, {0x70a0d30?, 0xc04c6e6840?}, {{0x70cb0a0, 0xc0182c9f90}, {0x0, 0x0, 0x0}, {0xc03a2c1040, 0xc6}, ...}, ...)
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:772 +0x2aef
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt.func1({0x70a0d30?, 0xc04c6e6840?})
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:137 +0xbc
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithProfiling(0x70a0d30?, {0x70a0d30?, 0xc04c6e6840?}, {0x70cb0a0?, 0xc0182c9f90?}, 0xc01cdeb590?, 0x59896a?)
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:2666 +0x330
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt(0xc0143e5000, {0x70a0d30, 0xc04c6e6840}, {{0x70cb0a0, 0xc0182c9f90}, {0x0, 0x0, 0x0}, {0xc03a2c1040, 0xc6}, ...}, ...)
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:136 +0x4da
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd.func1(0xc01cdebbd0, 0xc0143e5000, 0xc01cdeb890, 0xc01cdeb950, 0xc01cdeb990, 0xc0159b9970, 0xc0159b9960, 0xc0159b9980)
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1992 +0x319
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd(0xc0143e5000)
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1997 +0x1127
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).run(0xc0143e5000, {0x70a0d30, 0xc04c6e6420}, 0xc0026ea750?, 0xc01cdebfd0?, 0x4a5f1e8?)
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1913 +0x20b
github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).runWithEx.func1()
	github.com/cockroachdb/cockroach/pkg/sql/internal.go:172 +0xac
created by github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).runWithEx
	github.com/cockroachdb/cockroach/pkg/sql/internal.go:171 +0x195

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2]
sql/tests: TestRandomSyntaxGeneration failed #89363 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2.0]
sql/tests: TestRandomSyntaxGeneration failed #77893 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.1]
sql/tests: TestRandomSyntaxGeneration failed #74271 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.2]
sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-03-24T05:21:16Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ 52e55d2ef172b7cfec14e8a0a954f8864b2be779:

    rsg_test.go:828: 1m15s of 5m0s: 238516 executions, 13265 successful
    rsg_test.go:828: 1m20s of 5m0s: 253943 executions, 14070 successful
    rsg_test.go:828: 1m25s of 5m0s: 269083 executions, 14794 successful
    rsg_test.go:828: 1m30s of 5m0s: 283888 executions, 15554 successful
    rsg_test.go:828: 1m35s of 5m0s: 298912 executions, 16263 successful
    rsg_test.go:828: 1m40s of 5m0s: 315429 executions, 17042 successful
    rsg_test.go:828: 1m45s of 5m0s: 332110 executions, 17864 successful
    rsg_test.go:828: 1m50s of 5m0s: 349097 executions, 18705 successful
    rsg_test.go:828: 1m55s of 5m0s: 365741 executions, 19534 successful
    rsg_test.go:828: 2m0s of 5m0s: 381703 executions, 20326 successful
    rsg_test.go:828: 2m5s of 5m0s: 398044 executions, 21100 successful
    rsg_test.go:828: 2m10s of 5m0s: 414934 executions, 21853 successful
    rsg_test.go:828: 2m15s of 5m0s: 430515 executions, 22569 successful
    rsg_test.go:828: 2m20s of 5m0s: 446626 executions, 23311 successful
    rsg_test.go:828: 2m25s of 5m0s: 461487 executions, 24029 successful
    rsg_test.go:828: 2m30s of 5m0s: 477503 executions, 24793 successful
    rsg_test.go:828: 2m35s of 5m0s: 494068 executions, 25577 successful
    rsg_test.go:828: 2m40s of 5m0s: 510200 executions, 26372 successful
    rsg_test.go:828: 2m45s of 5m0s: 526888 executions, 27132 successful
    rsg_test.go:828: 2m50s of 5m0s: 545248 executions, 27969 successful
    rsg_test.go:828: 2m55s of 5m0s: 564888 executions, 28880 successful
    rsg_test.go:828: 3m0s of 5m0s: 584048 executions, 29808 successful
    rsg_test.go:828: 3m5s of 5m0s: 603095 executions, 30711 successful
    rsg_test.go:828: 3m10s of 5m0s: 620513 executions, 31557 successful
    rsg_test.go:828: 3m15s of 5m0s: 637644 executions, 32382 successful
    rsg_test.go:828: 3m20s of 5m0s: 656020 executions, 33219 successful
    rsg_test.go:828: 3m25s of 5m0s: 673676 executions, 34086 successful
    rsg_test.go:828: 3m30s of 5m0s: 690983 executions, 34872 successful
    rsg_test.go:828: 3m35s of 5m0s: 707452 executions, 35665 successful
    rsg_test.go:828: 3m40s of 5m0s: 725366 executions, 36495 successful
    rsg_test.go:828: 3m45s of 5m0s: 743767 executions, 37401 successful
    rsg_test.go:828: 3m50s of 5m0s: 760822 executions, 38170 successful
    rsg_test.go:828: 3m55s of 5m0s: 777639 executions, 38953 successful
    rsg_test.go:828: 4m0s of 5m0s: 794176 executions, 39736 successful
    rsg_test.go:828: 4m5s of 5m0s: 809160 executions, 40422 successful
    rsg_test.go:828: 4m10s of 5m0s: 824541 executions, 41153 successful
    rsg_test.go:828: 4m15s of 5m0s: 842760 executions, 41942 successful
    rsg_test.go:828: 4m20s of 5m0s: 859757 executions, 42703 successful
    rsg_test.go:828: 4m25s of 5m0s: 877186 executions, 43516 successful
    rsg_test.go:828: 4m30s of 5m0s: 893158 executions, 44295 successful
    rsg_test.go:828: 4m35s of 5m0s: 912001 executions, 45156 successful
    rsg_test.go:828: 4m40s of 5m0s: 930771 executions, 45912 successful
    rsg_test.go:828: 4m45s of 5m0s: 950084 executions, 46813 successful
    rsg_test.go:828: 4m50s of 5m0s: 968564 executions, 47648 successful
    rsg_test.go:828: 4m55s of 5m0s: 987141 executions, 48438 successful
    rsg_test.go:864: 1005043 executions, 49221 successful
    rsg_test.go:872: cannot parse output of Format: sql="PREPARE STRING ( TIMESTAMP WITH TIME ZONE ARRAY [ 224 ] ) AS SHOW BACKUP CONNECTION FAMILY WITH TRANSFER = 'string' , TIME = PLACEHOLDER", formattedSQL="PREPARE \"string\" (TIMESTAMPTZ[]) AS SHOW BACKUP CONNECTION 'family' WITH TIME = 'placeholder', TRANSFER = 'string'": at or near "with": syntax error
    rsg_test.go:305: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration4211893898
--- FAIL: TestRandomSyntaxGeneration (301.71s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2]
sql/tests: TestRandomSyntaxGeneration failed #89363 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2.0]
sql/tests: TestRandomSyntaxGeneration failed #77893 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.1]
sql/tests: TestRandomSyntaxGeneration failed #74271 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.2]
sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-03-25T05:22:56Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ f351747ed97862fc037717cadec23f18073fb6be:

    rsg_test.go:828: 1m20s of 5m0s: 274788 executions, 14924 successful
    rsg_test.go:828: 1m25s of 5m0s: 291278 executions, 15702 successful
    rsg_test.go:828: 1m30s of 5m0s: 307541 executions, 16483 successful
    rsg_test.go:828: 1m35s of 5m0s: 324323 executions, 17299 successful
    rsg_test.go:828: 1m40s of 5m0s: 340627 executions, 18109 successful
    rsg_test.go:828: 1m45s of 5m0s: 356687 executions, 18867 successful
    rsg_test.go:828: 1m50s of 5m0s: 372606 executions, 19631 successful
    rsg_test.go:828: 1m55s of 5m0s: 388298 executions, 20347 successful
    rsg_test.go:828: 2m0s of 5m0s: 404843 executions, 21144 successful
    rsg_test.go:828: 2m5s of 5m0s: 421241 executions, 21953 successful
    rsg_test.go:828: 2m10s of 5m0s: 435721 executions, 22605 successful
    rsg_test.go:828: 2m15s of 5m0s: 451902 executions, 23376 successful
    rsg_test.go:828: 2m20s of 5m0s: 468866 executions, 24170 successful
    rsg_test.go:828: 2m25s of 5m0s: 484481 executions, 24910 successful
    rsg_test.go:828: 2m30s of 5m0s: 500554 executions, 25709 successful
    rsg_test.go:828: 2m35s of 5m0s: 517146 executions, 26475 successful
    rsg_test.go:828: 2m40s of 5m0s: 535518 executions, 27332 successful
    rsg_test.go:828: 2m45s of 5m0s: 554525 executions, 28170 successful
    rsg_test.go:828: 2m50s of 5m0s: 574082 executions, 29019 successful
    rsg_test.go:828: 2m55s of 5m0s: 590899 executions, 29754 successful
    rsg_test.go:828: 3m0s of 5m0s: 609026 executions, 30583 successful
    rsg_test.go:828: 3m5s of 5m0s: 626919 executions, 31384 successful
    rsg_test.go:828: 3m10s of 5m0s: 644692 executions, 32244 successful
    rsg_test.go:828: 3m15s of 5m0s: 663281 executions, 33080 successful
    rsg_test.go:828: 3m20s of 5m0s: 679341 executions, 33871 successful
    rsg_test.go:828: 3m25s of 5m0s: 695719 executions, 34622 successful
    rsg_test.go:828: 3m30s of 5m0s: 713531 executions, 35480 successful
    rsg_test.go:828: 3m35s of 5m0s: 731522 executions, 36285 successful
    rsg_test.go:828: 3m40s of 5m0s: 750165 executions, 37104 successful
    rsg_test.go:828: 3m45s of 5m0s: 767820 executions, 37926 successful
    rsg_test.go:828: 3m50s of 5m0s: 785618 executions, 38694 successful
    rsg_test.go:828: 3m55s of 5m0s: 802063 executions, 39443 successful
    rsg_test.go:828: 4m0s of 5m0s: 819399 executions, 40262 successful
    rsg_test.go:828: 4m5s of 5m0s: 837350 executions, 41045 successful
    rsg_test.go:828: 4m10s of 5m0s: 854738 executions, 41807 successful
    rsg_test.go:828: 4m15s of 5m0s: 871720 executions, 42601 successful
    rsg_test.go:828: 4m20s of 5m0s: 888516 executions, 43464 successful
    rsg_test.go:828: 4m25s of 5m0s: 906160 executions, 44308 successful
    rsg_test.go:828: 4m30s of 5m0s: 923894 executions, 45146 successful
    rsg_test.go:828: 4m35s of 5m0s: 943039 executions, 45999 successful
    rsg_test.go:828: 4m40s of 5m0s: 961830 executions, 46848 successful
    rsg_test.go:828: 4m45s of 5m0s: 980207 executions, 47679 successful
    rsg_test.go:828: 4m50s of 5m0s: 998636 executions, 48520 successful
    rsg_test.go:828: 4m55s of 5m0s: 1017170 executions, 49352 successful
    rsg_test.go:828: 5m0s of 5m0s: 1035167 executions, 50106 successful
    rsg_test.go:864: 1035168 executions, 50107 successful
    rsg_test.go:872: cannot parse output of Format: sql="ALTER TENANT b'bytes' RENAME TO INTERVAL 'string' DAY TO HOUR", formattedSQL="ALTER TENANT b'bytes' RENAME TO 'string'::INTERVAL DAY TO HOUR": at or near ":": syntax error
    rsg_test.go:305: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration925614853
--- FAIL: TestRandomSyntaxGeneration (301.70s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2]
sql/tests: TestRandomSyntaxGeneration failed #89363 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2.0]
sql/tests: TestRandomSyntaxGeneration failed #77893 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.1]
sql/tests: TestRandomSyntaxGeneration failed #74271 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.2]
sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-03-26T05:07:24Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ b995ddff53ee95a30537a366c6cd8e0e13fcee79:

=== RUN   TestRandomSyntaxGeneration
    test_log_scope.go:161: test logs captured to: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration1991526972
    test_log_scope.go:79: use -show-logs to present logs inline
    rsg_test.go:828: 5s of 5m0s: 17758 executions, 1079 successful
panic: cannot disable buffering here

goroutine 164344 [running]:
github.com/cockroachdb/cockroach/pkg/sql.(*streamingCommandResult).DisableBuffering(0xc00e6c9800?)
	github.com/cockroachdb/cockroach/pkg/sql/conn_io.go:1016 +0x27
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine(0xc00e6c9800, {0x70a8f70, 0xc00ff9c9c0}, 0xc00e6c9de8, {0x7100860, 0xc00ff9c900})
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1260 +0x483
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState(0xc00e6c9800, {0x70a8f70?, 0xc00ff9c8a0?}, {{0x70d2d20, 0xc00ec53650}, {0x0, 0x0, 0x0}, {0xc00d543300, 0xfb}, ...}, ...)
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:772 +0x2aef
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt.func1({0x70a8f70?, 0xc00ff9c8a0?})
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:137 +0xbc
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithProfiling(0x70a8f70?, {0x70a8f70?, 0xc00ff9c8a0?}, {0x70d2d20?, 0xc00ec53650?}, 0x0?, 0x0?)
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:2666 +0x330
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt(0xc00e6c9800, {0x70a8f70, 0xc00ff9c8a0}, {{0x70d2d20, 0xc00ec53650}, {0x0, 0x0, 0x0}, {0xc00d543300, 0xfb}, ...}, ...)
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:136 +0x4da
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd.func1(0xc003c15bd0, 0xc00e6c9800, 0xc003c15890, 0xc003c15950, 0xc003c15990, 0xc0034f3970, 0xc0034f3960, 0xc0034f3980)
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1992 +0x319
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd(0xc00e6c9800)
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1997 +0x1127
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).run(0xc00e6c9800, {0x70a8f70, 0xc00ff9c4b0}, 0x0?, 0xc003c15fd0?, 0x4a63b01?)
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1913 +0x20b
github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).runWithEx.func1()
	github.com/cockroachdb/cockroach/pkg/sql/internal.go:172 +0xac
created by github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).runWithEx
	github.com/cockroachdb/cockroach/pkg/sql/internal.go:171 +0x195

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2]
sql/tests: TestRandomSyntaxGeneration failed #89363 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2.0]
sql/tests: TestRandomSyntaxGeneration failed #77893 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.1]
sql/tests: TestRandomSyntaxGeneration failed #74271 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.2]
sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-03-27T05:20:28Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ 186218edb86b5974501b2976cfd0704d4d6d1beb:

    rsg_test.go:828: 1m20s of 5m0s: 318500 executions, 16896 successful
    rsg_test.go:828: 1m25s of 5m0s: 337696 executions, 17791 successful
    rsg_test.go:828: 1m30s of 5m0s: 357956 executions, 18788 successful
    rsg_test.go:828: 1m35s of 5m0s: 377917 executions, 19756 successful
    rsg_test.go:828: 1m40s of 5m0s: 397530 executions, 20617 successful
    rsg_test.go:828: 1m45s of 5m0s: 418550 executions, 21589 successful
    rsg_test.go:828: 1m50s of 5m0s: 438328 executions, 22515 successful
    rsg_test.go:828: 1m55s of 5m0s: 459147 executions, 23438 successful
    rsg_test.go:828: 2m0s of 5m0s: 477971 executions, 24309 successful
    rsg_test.go:828: 2m5s of 5m0s: 498426 executions, 25312 successful
    rsg_test.go:828: 2m10s of 5m0s: 518022 executions, 26237 successful
    rsg_test.go:828: 2m15s of 5m0s: 535997 executions, 27059 successful
    rsg_test.go:828: 2m20s of 5m0s: 556563 executions, 27941 successful
    rsg_test.go:828: 2m25s of 5m0s: 576380 executions, 28838 successful
    rsg_test.go:828: 2m30s of 5m0s: 596559 executions, 29743 successful
    rsg_test.go:828: 2m35s of 5m0s: 615300 executions, 30592 successful
    rsg_test.go:828: 2m40s of 5m0s: 633840 executions, 31453 successful
    rsg_test.go:828: 2m45s of 5m0s: 654123 executions, 32367 successful
    rsg_test.go:828: 2m50s of 5m0s: 674951 executions, 33299 successful
    rsg_test.go:828: 2m55s of 5m0s: 695503 executions, 34204 successful
    rsg_test.go:828: 3m0s of 5m0s: 715001 executions, 35118 successful
    rsg_test.go:828: 3m5s of 5m0s: 734307 executions, 36067 successful
    rsg_test.go:828: 3m10s of 5m0s: 753139 executions, 36909 successful
    rsg_test.go:828: 3m15s of 5m0s: 771502 executions, 37860 successful
    rsg_test.go:828: 3m20s of 5m0s: 791731 executions, 38822 successful
    rsg_test.go:828: 3m25s of 5m0s: 812568 executions, 39741 successful
    rsg_test.go:828: 3m30s of 5m0s: 833270 executions, 40639 successful
    rsg_test.go:828: 3m35s of 5m0s: 852035 executions, 41489 successful
    rsg_test.go:828: 3m40s of 5m0s: 870645 executions, 42352 successful
    rsg_test.go:828: 3m45s of 5m0s: 890784 executions, 43242 successful
    rsg_test.go:828: 3m50s of 5m0s: 911204 executions, 44108 successful
    rsg_test.go:828: 3m55s of 5m0s: 932743 executions, 45060 successful
    rsg_test.go:828: 4m0s of 5m0s: 952653 executions, 46020 successful
    rsg_test.go:828: 4m5s of 5m0s: 973294 executions, 47041 successful
    rsg_test.go:828: 4m10s of 5m0s: 993624 executions, 47877 successful
    rsg_test.go:828: 4m15s of 5m0s: 1013561 executions, 48732 successful
    rsg_test.go:828: 4m20s of 5m0s: 1031643 executions, 49562 successful
    rsg_test.go:828: 4m25s of 5m0s: 1051716 executions, 50370 successful
    rsg_test.go:828: 4m30s of 5m0s: 1071044 executions, 51212 successful
    rsg_test.go:828: 4m35s of 5m0s: 1090069 executions, 52002 successful
    rsg_test.go:828: 4m40s of 5m0s: 1108362 executions, 52860 successful
    rsg_test.go:828: 4m45s of 5m0s: 1127697 executions, 53707 successful
    rsg_test.go:828: 4m50s of 5m0s: 1146331 executions, 54592 successful
    rsg_test.go:828: 4m55s of 5m0s: 1164945 executions, 55399 successful
    rsg_test.go:828: 5m0s of 5m0s: 1183337 executions, 56233 successful
    rsg_test.go:864: 1183338 executions, 56234 successful
    rsg_test.go:872: cannot parse output of Format: sql="ALTER TENANT 'string' RENAME TO INTERVAL 'string' MINUTE TO SECOND", formattedSQL="ALTER TENANT 'string' RENAME TO 'string'::INTERVAL MINUTE TO SECOND": at or near ":": syntax error
    rsg_test.go:305: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration3774222428
--- FAIL: TestRandomSyntaxGeneration (301.70s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2]
sql/tests: TestRandomSyntaxGeneration failed #89363 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2.0]
sql/tests: TestRandomSyntaxGeneration failed #77893 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.1]
sql/tests: TestRandomSyntaxGeneration failed #74271 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.2]
sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-03-28T05:20:52Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ 3551dc089ac3efcb3772df2109164dcb01e79d8f:

* 	github.com/cockroachdb/cockroach/pkg/sql/plan_node_to_row_source.go:172 +0xbd
* github.com/cockroachdb/cockroach/pkg/sql/colexec.(*Columnarizer).Init(0xc0151d2000, {0x70aa090, 0xc0560e71a0})
* 	github.com/cockroachdb/cockroach/pkg/sql/colexec/columnarizer.go:183 +0xea
* github.com/cockroachdb/cockroach/pkg/sql/colexec.(*invariantsChecker).Init(0xc05a166840, {0x70aa090?, 0xc0560e71a0?})
* 	github.com/cockroachdb/cockroach/pkg/sql/colexec/invariants_checker.go:67 +0x4f
* github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).init(0xc0040436c0?)
* 	github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:94 +0x2c
* github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError(0xc05a166880?)
* 	github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:92 +0x62
* github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).Init(0xc05c079ef0, {0x70aa090?, 0xc0560e71a0?})
* 	github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:103 +0x7f
* github.com/cockroachdb/cockroach/pkg/sql/colexec.(*Materializer).Start.func1()
* 	github.com/cockroachdb/cockroach/pkg/sql/colexec/materializer.go:229 +0x34
* github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError(0xc0596094a0?)
* 	github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:92 +0x62
* github.com/cockroachdb/cockroach/pkg/sql/colexec.(*Materializer).Start(0xc0596094a0, {0x70aa090?, 0xc0560e7140?})
* 	github.com/cockroachdb/cockroach/pkg/sql/colexec/materializer.go:228 +0x7a
* github.com/cockroachdb/cockroach/pkg/sql/colflow.(*FlowCoordinator).Start.func1()
* 	github.com/cockroachdb/cockroach/pkg/sql/colflow/flow_coordinator.go:121 +0x34
* github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError(0xc0668ee900?)
* 	github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:92 +0x62
* github.com/cockroachdb/cockroach/pkg/sql/colflow.(*FlowCoordinator).Start(0xc0668ee900, {0x70a9fe8?, 0xc059edbf40?})
* 	github.com/cockroachdb/cockroach/pkg/sql/colflow/flow_coordinator.go:120 +0x70
* github.com/cockroachdb/cockroach/pkg/sql/execinfra.(*ProcessorBaseNoHelper).Run(0xc0668ee900, {0x70a9fe8?, 0xc059edbf40?}, {0x707e1f0?, 0xc0384b0e00})
* 	github.com/cockroachdb/cockroach/pkg/sql/execinfra/processorsbase.go:736 +0x50
* github.com/cockroachdb/cockroach/pkg/sql/flowinfra.(*FlowBase).Run(0xc05a132c80, {0x70a9fe8?, 0xc059edbf40}, 0x0?)
* 	github.com/cockroachdb/cockroach/pkg/sql/flowinfra/flow.go:552 +0x21a
* created by github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).runWithEx
* 	github.com/cockroachdb/cockroach/pkg/sql/internal.go:171 +0x195
* 
* goroutine 12425555 [sync.Cond.Wait, 1 minutes]:
* sync.runtime_notifyListWait(0xc064864ae0, 0x418)
* 	GOROOT/src/runtime/sema.go:517 +0x14c
* sync.(*Cond).Wait(0xc100bb97c5888a54?)
* 	GOROOT/src/sync/cond.go:70 +0x8c
* github.com/cockroachdb/pebble/record.(*flusherCond).Wait(...)
* 	github.com/cockroachdb/pebble/record/external/com_github_cockroachdb_pebble/record/log_writer.go:203
* github.com/cockroachdb/pebble/record.(*LogWriter).flushLoop(0xc064864a00, {0x52a6680, 0xa7179e0})
* 	github.com/cockroachdb/pebble/record/external/com_github_cockroachdb_pebble/record/log_writer.go:428 +0x63f
* runtime/pprof.Do({0x70aa020?, 0xc000080048?}, {{0xc000314b20?, 0xc000088b40?, 0x0?}}, 0xc005730fc0)
* 	GOROOT/src/runtime/pprof/runtime.go:40 +0xa3
* github.com/cockroachdb/pebble/record.NewLogWriter.func2()
* 	github.com/cockroachdb/pebble/record/external/com_github_cockroachdb_pebble/record/log_writer.go:351 +0x5c
* created by github.com/cockroachdb/pebble/record.NewLogWriter
* 	github.com/cockroachdb/pebble/record/external/com_github_cockroachdb_pebble/record/log_writer.go:350 +0x456
* 
*
    rsg_test.go:305: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration3651931367
--- FAIL: TestRandomSyntaxGeneration (469.67s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2]
sql/tests: TestRandomSyntaxGeneration failed #89363 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2.0]
sql/tests: TestRandomSyntaxGeneration failed #77893 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.1]
sql/tests: TestRandomSyntaxGeneration failed #74271 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.2]
sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

_{This test on roachdash | Improve this report!}

rafiss · 2023-03-28T17:20:55Z

the failure from #99183 (comment) is

panic: cannot disable buffering here

goroutine 164344 [running]:
github.com/cockroachdb/cockroach/pkg/sql.(*streamingCommandResult).DisableBuffering(0xc00e6c9800?)
	github.com/cockroachdb/cockroach/pkg/sql/conn_io.go:1016 +0x27
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine(0xc00e6c9800, {0x70a8f70, 0xc00ff9c9c0}, 0xc00e6c9de8, {0x7100860, 0xc00ff9c900})
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1260 +0x483
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState(0xc00e6c9800, {0x70a8f70?, 0xc00ff9c8a0?}, {{0x70d2d20, 0xc00ec53650}, {0x0, 0x0, 0x0}, {0xc00d543300, 0xfb}, ...}, ...)
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:772 +0x2aef
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt.func1({0x70a8f70?, 0xc00ff9c8a0?})
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:137 +0xbc
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithProfiling(0x70a8f70?, {0x70a8f70?, 0xc00ff9c8a0?}, {0x70d2d20?, 0xc00ec53650?}, 0x0?, 0x0?)
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:2666 +0x330
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt(0xc00e6c9800, {0x70a8f70, 0xc00ff9c8a0}, {{0x70d2d20, 0xc00ec53650}, {0x0, 0x0, 0x0}, {0xc00d543300, 0xfb}, ...}, ...)
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:136 +0x4da
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd.func1(0xc003c15bd0, 0xc00e6c9800, 0xc003c15890, 0xc003c15950, 0xc003c15990, 0xc0034f3970, 0xc0034f3960, 0xc0034f3980)
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1992 +0x319
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd(0xc00e6c9800)
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1997 +0x1127
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).run(0xc00e6c9800, {0x70a8f70, 0xc00ff9c4b0}, 0x0?, 0xc003c15fd0?, 0x4a63b01?)
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1913 +0x20b
github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).runWithEx.func1()
	github.com/cockroachdb/cockroach/pkg/sql/internal.go:172 +0xac
created by github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).runWithEx
	github.com/cockroachdb/cockroach/pkg/sql/internal.go:171 +0x195

My understanding is that we cannot disable buffering in the internal executor. Would a patch like this make sense?

diff --git a/pkg/sql/conn_executor_exec.go b/pkg/sql/conn_executor_exec.go
index 483859ab639..5729876dc6d 100644
--- a/pkg/sql/conn_executor_exec.go
+++ b/pkg/sql/conn_executor_exec.go
@@ -1254,7 +1254,7 @@ func (ex *connExecutor) dispatchToExecutionEngine(

     // Certain statements want their results to go to the client
     // directly. Configure this here.
-    if planner.curPlan.avoidBuffering || ex.sessionData().AvoidBuffering {
+    if ex.executorType != executorTypeInternal && (planner.curPlan.avoidBuffering || ex.sessionData().AvoidBuffering) {
         res.DisableBuffering()
     }

cc @yuzefovich or @michae2 - maybe you're more familiar?

yuzefovich · 2023-03-28T17:27:37Z

I thought #98290 would fix it, no?

yuzefovich · 2023-03-28T17:28:47Z

But your patch sounds good to me.

rafiss · 2023-03-28T19:24:22Z

oh yeah i forgot about that. i suppose it might still be possible to have planner.curPlan.avoidBuffering=true even if ex.sessionData().AvoidBuffering=false?

Randomized testing in cockroachdb#99183 showed that this could still happen, even after cockroachdb#98290 was merged to fix this issue. Release note: None

cockroach-teamcity · 2023-03-29T05:22:05Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ a34af06d8e7230e4052db80d55da21a06013f81b:

* 	github.com/cockroachdb/cockroach/pkg/sql/colexec/materializer.go:228 +0x7a
* github.com/cockroachdb/cockroach/pkg/sql/colflow.(*FlowCoordinator).Start.func1()
* 	github.com/cockroachdb/cockroach/pkg/sql/colflow/flow_coordinator.go:121 +0x34
* github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError(0xc0626bec60?)
* 	github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:92 +0x62
* github.com/cockroachdb/cockroach/pkg/sql/colflow.(*FlowCoordinator).Start(0xc0626bec60, {0x70b2788?, 0xc0401de740?})
* 	github.com/cockroachdb/cockroach/pkg/sql/colflow/flow_coordinator.go:120 +0x70
* github.com/cockroachdb/cockroach/pkg/sql/execinfra.(*ProcessorBaseNoHelper).Run(0xc0626bec60, {0x70b2788?, 0xc0401de740?}, {0x70869d0?, 0xc064892380})
* 	github.com/cockroachdb/cockroach/pkg/sql/execinfra/processorsbase.go:736 +0x50
* github.com/cockroachdb/cockroach/pkg/sql/flowinfra.(*FlowBase).Run(0xc0400f3680, {0x70b2788?, 0xc0401de740}, 0x60?)
* 	github.com/cockroachdb/cockroach/pkg/sql/flowinfra/flow.go:552 +0x21a
* github.com/cockroachdb/cockroach/pkg/sql/colflow.(*vectorizedFlow).Run(0x711b820?, {0x70b2788?, 0xc0401de740?}, 0xe0?)
* 	github.com/cockroachdb/cockroach/pkg/sql/colflow/vectorized_flow.go:311 +0x245
* github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).Run(0xc00193d900, {0x70b2830, 0xc02f423b90}, 0xc04018ed10, 0xc03febf1e0, 0xc040208380, 0xc064892380, 0xc03f863230, 0xc023f65940)
* 	github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:904 +0xb73
* github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).PlanAndRun(0x0?, {0x70b2830, 0xc02f423b90}, 0x0?, 0xc04018ed10, 0x203010?, {{0x70b5498?, 0xc01c272f60?}, 0x0?}, 0xc064892380, ...)
* 	github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:1900 +0x205
* github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).PlanAndRunAll.func2(0xc03f862e08, 0x0?, {0x70b2830, 0xc02f423b90}, 0x10?, 0x7f3576fc0878?, 0xc0401e7f38?)
* 	github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:1636 +0xcb
* github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).PlanAndRunAll(0xc04018ed10?, {0x70b2830, 0xc02f423b90}, 0xc03f863230, 0x1?, 0xc03f862e08, 0xc064892380, 0x0)
* 	github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:1639 +0x1e5
* github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithDistSQLEngine(0xc03f862800, {0x70b2830?, 0xc02f423b90}, 0xc03f862e08, 0xc02f423b90?, {0x710a120?, 0xc024deef30}, 0xc024deef30?, 0xc0400a2458)
* 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1776 +0x5eb
* github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine(0xc03f862800, {0x70b2830, 0xc024deefc0}, 0xc03f862e08, {0x710a120, 0xc024deef30})
* 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1351 +0xc19
* github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState(0xc03f862800, {0x70b2830?, 0xc024deecc0?}, {{0x70dcba0, 0xc029372d70}, {0x0, 0x0, 0x0}, {0xc03fba6421, 0x146}, ...}, ...)
* 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:770 +0x2c0f
* github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt.func1({0x70b2830?, 0xc024deecc0?})
* 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:137 +0xbc
* github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithProfiling(0x70b2830?, {0x70b2830?, 0xc024deecc0?}, {0x70dcba0?, 0xc029372d70?}, 0x9da7d41f16d55b38?, 0x0?)
* 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:2665 +0x330
* github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt(0xc03f862800, {0x70b2830, 0xc024deecc0}, {{0x70dcba0, 0xc029372d70}, {0x0, 0x0, 0x0}, {0xc03fba6421, 0x146}, ...}, ...)
* 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:136 +0x4da
* github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execPortal(0xc03f862800, {0x70b2830, 0xc024deecc0}, {{0x0, 0x0}, 0xc02ed62b40, {0xc03febf550, 0xb, 0xb}, {0x0, ...}, ...}, ...)
* 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:226 +0x18b
* github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd.func2({{0x0, 0x0}, 0x0, {0xc1011028647e2b41, 0x61f971dbdd, 0x0}, 0x1}, 0xc03f862800, 0xc042f1d970, 0xc042f1d960, ...)
* 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:2198 +0x54b
* github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd(0xc03f862800)
* 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:2200 +0x6df
* github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).run(0xc03f862800, {0x70b2830, 0xc024dee8d0}, 0x6f632f6c71732f67?, 0x6f632f636578656c?, 0x0?)
* 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:2039 +0x20b
* github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).runWithEx.func1()
* 	github.com/cockroachdb/cockroach/pkg/sql/internal.go:172 +0xac
* created by github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).runWithEx
* 	github.com/cockroachdb/cockroach/pkg/sql/internal.go:171 +0x195
* 
*
    rsg_test.go:305: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration1911018529
--- FAIL: TestRandomSyntaxGeneration (605.03s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2]
sql/tests: TestRandomSyntaxGeneration failed #89363 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2.0]
sql/tests: TestRandomSyntaxGeneration failed #77893 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.1]
sql/tests: TestRandomSyntaxGeneration failed #74271 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.2]
sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

_{This test on roachdash | Improve this report!}

Randomized testing in #99183 showed that this could still happen, even after #98290 was merged to fix this issue. Release note: None

cockroach-teamcity · 2023-03-30T05:19:34Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ aec78f33d45a8376a0ecec885688bae60dbfb85c:

Random syntax error:

    rsg_test.go:855: Crash detected: server panic: pq: internal error: write-job-info-insert: referenced descriptor ID 254: descriptor not found

Query:

        BACKUP * TO 'string' INCREMENTAL FROM ident , QUOTE , 'string';

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2]
sql/tests: TestRandomSyntaxGeneration failed #89363 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2.0]
sql/tests: TestRandomSyntaxGeneration failed #77893 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.1]
sql/tests: TestRandomSyntaxGeneration failed #74271 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.2]
sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-03-31T05:22:00Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ 7e72aae900c3ff4b44f1643c2d7ba55fbb2cbe23:

    rsg_test.go:828: 1m15s of 5m0s: 280914 executions, 15215 successful
    rsg_test.go:828: 1m20s of 5m0s: 299712 executions, 16134 successful
    rsg_test.go:828: 1m25s of 5m0s: 318497 executions, 17038 successful
    rsg_test.go:828: 1m30s of 5m0s: 337151 executions, 17926 successful
    rsg_test.go:828: 1m35s of 5m0s: 354446 executions, 18780 successful
    rsg_test.go:828: 1m40s of 5m0s: 373358 executions, 19643 successful
    rsg_test.go:828: 1m45s of 5m0s: 392378 executions, 20562 successful
    rsg_test.go:828: 1m50s of 5m0s: 410451 executions, 21408 successful
    rsg_test.go:828: 1m55s of 5m0s: 429328 executions, 22315 successful
    rsg_test.go:828: 2m0s of 5m0s: 448443 executions, 23233 successful
    rsg_test.go:828: 2m5s of 5m0s: 467064 executions, 24149 successful
    rsg_test.go:828: 2m10s of 5m0s: 484519 executions, 24999 successful
    rsg_test.go:828: 2m15s of 5m0s: 503169 executions, 25852 successful
    rsg_test.go:828: 2m20s of 5m0s: 522407 executions, 26715 successful
    rsg_test.go:828: 2m25s of 5m0s: 542081 executions, 27587 successful
    rsg_test.go:828: 2m30s of 5m0s: 561792 executions, 28533 successful
    rsg_test.go:828: 2m35s of 5m0s: 581805 executions, 29471 successful
    rsg_test.go:828: 2m40s of 5m0s: 600848 executions, 30310 successful
    rsg_test.go:828: 2m45s of 5m0s: 620539 executions, 31153 successful
    rsg_test.go:828: 2m50s of 5m0s: 640073 executions, 31988 successful
    rsg_test.go:828: 2m55s of 5m0s: 657934 executions, 32836 successful
    rsg_test.go:828: 3m0s of 5m0s: 675463 executions, 33679 successful
    rsg_test.go:828: 3m5s of 5m0s: 693241 executions, 34446 successful
    rsg_test.go:828: 3m10s of 5m0s: 710535 executions, 35266 successful
    rsg_test.go:828: 3m15s of 5m0s: 729027 executions, 36160 successful
    rsg_test.go:828: 3m20s of 5m0s: 746289 executions, 37005 successful
    rsg_test.go:828: 3m25s of 5m0s: 767050 executions, 38027 successful
    rsg_test.go:828: 3m30s of 5m0s: 788868 executions, 39037 successful
    rsg_test.go:828: 3m35s of 5m0s: 808619 executions, 39878 successful
    rsg_test.go:828: 3m40s of 5m0s: 823667 executions, 40583 successful
    rsg_test.go:828: 3m45s of 5m0s: 842188 executions, 41449 successful
    rsg_test.go:828: 3m50s of 5m0s: 859823 executions, 42287 successful
    rsg_test.go:828: 3m55s of 5m0s: 879515 executions, 43201 successful
    rsg_test.go:828: 4m0s of 5m0s: 899066 executions, 44107 successful
    rsg_test.go:828: 4m5s of 5m0s: 918059 executions, 45003 successful
    rsg_test.go:828: 4m10s of 5m0s: 937284 executions, 45912 successful
    rsg_test.go:828: 4m15s of 5m0s: 955322 executions, 46697 successful
    rsg_test.go:828: 4m20s of 5m0s: 974514 executions, 47603 successful
    rsg_test.go:828: 4m25s of 5m0s: 992950 executions, 48449 successful
    rsg_test.go:828: 4m30s of 5m0s: 1012803 executions, 49357 successful
    rsg_test.go:828: 4m35s of 5m0s: 1032580 executions, 50299 successful
    rsg_test.go:828: 4m40s of 5m0s: 1052348 executions, 51234 successful
    rsg_test.go:828: 4m45s of 5m0s: 1072114 executions, 52152 successful
    rsg_test.go:828: 4m50s of 5m0s: 1092262 executions, 53071 successful
    rsg_test.go:828: 4m55s of 5m0s: 1111231 executions, 53957 successful
    rsg_test.go:864: 1131249 executions, 54849 successful
    rsg_test.go:872: cannot parse output of Format: sql="ALTER TENANT LEAST RENAME TO INTERVAL 'string'", formattedSQL="ALTER TENANT \"least\" RENAME TO 'string'::INTERVAL": at or near ":": syntax error
    rsg_test.go:305: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration3355438014
--- FAIL: TestRandomSyntaxGeneration (301.79s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2]
sql/tests: TestRandomSyntaxGeneration failed #89363 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2.0]
sql/tests: TestRandomSyntaxGeneration failed #77893 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.1]
sql/tests: TestRandomSyntaxGeneration failed #74271 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.2]
sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-04-01T05:22:34Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ 5d5abe704b0551556c35d51aa673d3162f493aa8:

    rsg_test.go:828: 1m15s of 5m0s: 221441 executions, 12335 successful
    rsg_test.go:828: 1m20s of 5m0s: 235718 executions, 12980 successful
    rsg_test.go:828: 1m25s of 5m0s: 248934 executions, 13632 successful
    rsg_test.go:828: 1m30s of 5m0s: 261453 executions, 14316 successful
    rsg_test.go:828: 1m35s of 5m0s: 275829 executions, 15032 successful
    rsg_test.go:828: 1m40s of 5m0s: 290917 executions, 15765 successful
    rsg_test.go:828: 1m45s of 5m0s: 305510 executions, 16485 successful
    rsg_test.go:828: 1m50s of 5m0s: 319497 executions, 17142 successful
    rsg_test.go:828: 1m55s of 5m0s: 333706 executions, 17838 successful
    rsg_test.go:828: 2m0s of 5m0s: 348400 executions, 18516 successful
    rsg_test.go:828: 2m5s of 5m0s: 364072 executions, 19252 successful
    rsg_test.go:828: 2m10s of 5m0s: 379612 executions, 20008 successful
    rsg_test.go:828: 2m15s of 5m0s: 395063 executions, 20754 successful
    rsg_test.go:828: 2m20s of 5m0s: 410594 executions, 21500 successful
    rsg_test.go:828: 2m25s of 5m0s: 425113 executions, 22236 successful
    rsg_test.go:828: 2m30s of 5m0s: 439995 executions, 22946 successful
    rsg_test.go:828: 2m35s of 5m0s: 455060 executions, 23610 successful
    rsg_test.go:828: 2m40s of 5m0s: 469834 executions, 24280 successful
    rsg_test.go:828: 2m45s of 5m0s: 484956 executions, 25001 successful
    rsg_test.go:828: 2m50s of 5m0s: 499113 executions, 25710 successful
    rsg_test.go:828: 2m55s of 5m0s: 513219 executions, 26373 successful
    rsg_test.go:828: 3m0s of 5m0s: 528636 executions, 27031 successful
    rsg_test.go:828: 3m5s of 5m0s: 543006 executions, 27707 successful
    rsg_test.go:828: 3m10s of 5m0s: 557651 executions, 28387 successful
    rsg_test.go:828: 3m15s of 5m0s: 572003 executions, 29075 successful
    rsg_test.go:828: 3m20s of 5m0s: 587865 executions, 29813 successful
    rsg_test.go:828: 3m25s of 5m0s: 603758 executions, 30584 successful
    rsg_test.go:828: 3m30s of 5m0s: 619973 executions, 31296 successful
    rsg_test.go:828: 3m35s of 5m0s: 632832 executions, 31889 successful
    rsg_test.go:828: 3m40s of 5m0s: 648809 executions, 32633 successful
    rsg_test.go:828: 3m45s of 5m0s: 664678 executions, 33370 successful
    rsg_test.go:828: 3m50s of 5m0s: 678830 executions, 34042 successful
    rsg_test.go:828: 3m55s of 5m0s: 694271 executions, 34759 successful
    rsg_test.go:828: 4m0s of 5m0s: 709013 executions, 35449 successful
    rsg_test.go:828: 4m5s of 5m0s: 724383 executions, 36177 successful
    rsg_test.go:828: 4m10s of 5m0s: 739075 executions, 36841 successful
    rsg_test.go:828: 4m15s of 5m0s: 753901 executions, 37599 successful
    rsg_test.go:828: 4m20s of 5m0s: 769366 executions, 38310 successful
    rsg_test.go:828: 4m25s of 5m0s: 784109 executions, 38998 successful
    rsg_test.go:828: 4m30s of 5m0s: 798387 executions, 39622 successful
    rsg_test.go:828: 4m35s of 5m0s: 814129 executions, 40296 successful
    rsg_test.go:828: 4m40s of 5m0s: 829508 executions, 41006 successful
    rsg_test.go:828: 4m45s of 5m0s: 844556 executions, 41690 successful
    rsg_test.go:828: 4m50s of 5m0s: 858218 executions, 42375 successful
    rsg_test.go:828: 4m55s of 5m0s: 871852 executions, 43002 successful
    rsg_test.go:864: 886650 executions, 43664 successful
    rsg_test.go:872: cannot parse output of Format: sql="IMPORT TABLE FAMILY . ident FROM PRECISION 'string' WITH OPTIONS ( BUCKET_COUNT , 'string' )", formattedSQL="IMPORT TABLE \"family\".ident FROM PRECISION 'string' WITH bucket_count, \"string\"": at or near "with": syntax error
    rsg_test.go:305: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration1098472034
--- FAIL: TestRandomSyntaxGeneration (301.88s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2]
sql/tests: TestRandomSyntaxGeneration failed #89363 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2.0]
sql/tests: TestRandomSyntaxGeneration failed #77893 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.1]
sql/tests: TestRandomSyntaxGeneration failed #74271 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.2]
sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-04-02T05:21:53Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ 63b683eab3e0ebfff812bb54fdac936c101d9383:

* 	github.com/cockroachdb/cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/opt/norm/factory.og.go:24349 +0x8e37
* github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).AssignPlaceholders.func2({0x70f4200?, 0xc07b5e7d78?})
* 	github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.go:357 +0xbc
* github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).invokeReplace(0x60046008d?, {0x70f4200, 0xc07b5e7d78}, 0xc007aebd78)
* 	github.com/cockroachdb/cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/opt/norm/factory.og.go:25671 +0x77
* github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).CopyAndReplaceDefault(0xc01cdd7be0, {0x70f31c0?, 0xc07ee381f8?}, 0x461016?)
* 	github.com/cockroachdb/cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/opt/norm/factory.og.go:24270 +0x1be8
* github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).AssignPlaceholders.func2({0x70f31c0?, 0xc07ee381f8?})
* 	github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.go:357 +0xbc
* github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).invokeReplace(0xc059e8c000?, {0x70f31c0, 0xc07ee381f8}, 0xc007aebd78)
* 	github.com/cockroachdb/cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/opt/norm/factory.og.go:25671 +0x77
* github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).CopyAndReplace(0xc01cdd7be0, {0x712aef0, 0xc07ee381f8}, 0x50c8b00?, 0x1?)
* 	github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.go:316 +0x110
* github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).AssignPlaceholders(0xc01cdd7be0, 0xc07d249a00)
* 	github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.go:359 +0x105
* github.com/cockroachdb/cockroach/pkg/sql.(*optPlanningCtx).reuseMemo(0xc01cdd7b98, {0x70ce710?, 0xc038b914a0?}, 0xc07d249a00)
* 	github.com/cockroachdb/cockroach/pkg/sql/plan_opt.go:501 +0x73
* github.com/cockroachdb/cockroach/pkg/sql.(*optPlanningCtx).buildExecMemo(0xc01cdd7b98, {0x70ce710?, 0xc038b914a0})
* 	github.com/cockroachdb/cockroach/pkg/sql/plan_opt.go:534 +0x1c5
* github.com/cockroachdb/cockroach/pkg/sql.(*planner).makeOptimizerPlan(0xc01cdd6e08, {0x70ce710?, 0xc038b91440?})
* 	github.com/cockroachdb/cockroach/pkg/sql/plan_opt.go:237 +0x1c5
* github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).makeExecPlan(0xc01cdd6800, {0x70ce710, 0xc038b91440}, 0xc01cdd6e08)
* 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1651 +0x4e
* github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine(0xc01cdd6800, {0x70ce710, 0xc038b91440}, 0xc01cdd6e08, {0x7126020, 0xc038b913b0})
* 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1246 +0x328
* github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState(0xc01cdd6800, {0x70ce710?, 0xc038b91140?}, {{0x70f8cc0, 0xc030d26ff0}, {0x0, 0x0, 0x0}, {0xc01c4df341, 0x146}, ...}, ...)
* 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:770 +0x2c0f
* github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt.func1({0x70ce710?, 0xc038b91140?})
* 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:137 +0xbc
* github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithProfiling(0x70ce710?, {0x70ce710?, 0xc038b91140?}, {0x70f8cc0?, 0xc030d26ff0?}, 0x5afd09ff71185c9f?, 0x0?)
* 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:2665 +0x330
* github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt(0xc01cdd6800, {0x70ce710, 0xc038b91140}, {{0x70f8cc0, 0xc030d26ff0}, {0x0, 0x0, 0x0}, {0xc01c4df341, 0x146}, ...}, ...)
* 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:136 +0x4da
* github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execPortal(0xc01cdd6800, {0x70ce710, 0xc038b91140}, {{0x0, 0x0}, 0xc0419f1440, {0xc01d2f44d0, 0xb, 0xb}, {0x0, ...}, ...}, ...)
* 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:226 +0x18b
* github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd.func2({{0x0, 0x0}, 0x0, {0xc10261a572868716, 0x6208ffc1a1, 0x0}, 0x1}, 0xc01cdd6800, 0xc01d579980, 0xc01d579970, ...)
* 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:2197 +0x54b
* github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd(0xc01cdd6800)
* 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:2199 +0x6df
* github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).run(0xc01cdd6800, {0x70ce710, 0xc038b90d50}, 0x1251520?, 0xc000770c00?, 0x0?)
* 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:2038 +0x20b
* github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).runWithEx.func1()
* 	github.com/cockroachdb/cockroach/pkg/sql/internal.go:172 +0xac
* created by github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).runWithEx
* 	github.com/cockroachdb/cockroach/pkg/sql/internal.go:171 +0x195
* 
*
    rsg_test.go:305: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration3449405466
--- FAIL: TestRandomSyntaxGeneration (598.45s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2]
sql/tests: TestRandomSyntaxGeneration failed #89363 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2.0]
sql/tests: TestRandomSyntaxGeneration failed #77893 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.1]
sql/tests: TestRandomSyntaxGeneration failed #74271 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.2]
sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-04-03T05:22:11Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ 63b683eab3e0ebfff812bb54fdac936c101d9383:

    rsg_test.go:828: 1m15s of 5m0s: 294760 executions, 15706 successful
    rsg_test.go:828: 1m20s of 5m0s: 315749 executions, 16709 successful
    rsg_test.go:828: 1m25s of 5m0s: 336189 executions, 17682 successful
    rsg_test.go:828: 1m30s of 5m0s: 356760 executions, 18685 successful
    rsg_test.go:828: 1m35s of 5m0s: 377064 executions, 19678 successful
    rsg_test.go:828: 1m40s of 5m0s: 397799 executions, 20689 successful
    rsg_test.go:828: 1m45s of 5m0s: 417987 executions, 21578 successful
    rsg_test.go:828: 1m50s of 5m0s: 437541 executions, 22422 successful
    rsg_test.go:828: 1m55s of 5m0s: 457091 executions, 23318 successful
    rsg_test.go:828: 2m0s of 5m0s: 477666 executions, 24240 successful
    rsg_test.go:828: 2m5s of 5m0s: 497765 executions, 25251 successful
    rsg_test.go:828: 2m10s of 5m0s: 518576 executions, 26243 successful
    rsg_test.go:828: 2m15s of 5m0s: 540244 executions, 27191 successful
    rsg_test.go:828: 2m20s of 5m0s: 560927 executions, 28146 successful
    rsg_test.go:828: 2m25s of 5m0s: 581567 executions, 29065 successful
    rsg_test.go:828: 2m30s of 5m0s: 602517 executions, 30018 successful
    rsg_test.go:828: 2m35s of 5m0s: 623382 executions, 30982 successful
    rsg_test.go:828: 2m40s of 5m0s: 643041 executions, 31836 successful
    rsg_test.go:828: 2m45s of 5m0s: 664126 executions, 32769 successful
    rsg_test.go:828: 2m50s of 5m0s: 684669 executions, 33731 successful
    rsg_test.go:828: 2m55s of 5m0s: 704272 executions, 34629 successful
    rsg_test.go:828: 3m0s of 5m0s: 723210 executions, 35512 successful
    rsg_test.go:828: 3m5s of 5m0s: 742105 executions, 36395 successful
    rsg_test.go:828: 3m10s of 5m0s: 761159 executions, 37282 successful
    rsg_test.go:828: 3m15s of 5m0s: 782128 executions, 38159 successful
    rsg_test.go:828: 3m20s of 5m0s: 802692 executions, 39169 successful
    rsg_test.go:828: 3m25s of 5m0s: 824254 executions, 40199 successful
    rsg_test.go:828: 3m30s of 5m0s: 844339 executions, 41126 successful
    rsg_test.go:828: 3m35s of 5m0s: 863049 executions, 41976 successful
    rsg_test.go:828: 3m40s of 5m0s: 882664 executions, 42868 successful
    rsg_test.go:828: 3m45s of 5m0s: 903941 executions, 43862 successful
    rsg_test.go:828: 3m50s of 5m0s: 924504 executions, 44753 successful
    rsg_test.go:828: 3m55s of 5m0s: 945581 executions, 45686 successful
    rsg_test.go:828: 4m0s of 5m0s: 966123 executions, 46654 successful
    rsg_test.go:828: 4m5s of 5m0s: 986982 executions, 47624 successful
    rsg_test.go:828: 4m10s of 5m0s: 1008052 executions, 48543 successful
    rsg_test.go:828: 4m15s of 5m0s: 1028618 executions, 49489 successful
    rsg_test.go:828: 4m20s of 5m0s: 1048010 executions, 50324 successful
    rsg_test.go:828: 4m25s of 5m0s: 1067843 executions, 51145 successful
    rsg_test.go:828: 4m30s of 5m0s: 1087628 executions, 51984 successful
    rsg_test.go:828: 4m35s of 5m0s: 1107203 executions, 52872 successful
    rsg_test.go:828: 4m40s of 5m0s: 1127883 executions, 53837 successful
    rsg_test.go:828: 4m45s of 5m0s: 1147660 executions, 54718 successful
    rsg_test.go:828: 4m50s of 5m0s: 1168688 executions, 55684 successful
    rsg_test.go:828: 4m55s of 5m0s: 1190431 executions, 56666 successful
    rsg_test.go:864: 1211212 executions, 57601 successful
    rsg_test.go:872: cannot parse output of Format: sql="ALTER TENANT PLACEHOLDER RENAME TO INTERVAL 'string'", formattedSQL="ALTER TENANT placeholder RENAME TO 'string'::INTERVAL": at or near ":": syntax error
    rsg_test.go:305: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration3361902465
--- FAIL: TestRandomSyntaxGeneration (301.83s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2]
sql/tests: TestRandomSyntaxGeneration failed #89363 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.2.0]
sql/tests: TestRandomSyntaxGeneration failed #77893 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-sessions branch-release-22.1]
sql/tests: TestRandomSyntaxGeneration failed #74271 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.2]
sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-07-08T05:26:46Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ 5a53114bf5ae9e5ec672d43acf599f145bf22341:

    rsg_test.go:827: 1m15s of 5m0s: 184419 executions, 10417 successful
    rsg_test.go:827: 1m20s of 5m0s: 197000 executions, 11066 successful
    rsg_test.go:827: 1m25s of 5m0s: 210570 executions, 11729 successful
    rsg_test.go:827: 1m30s of 5m0s: 223182 executions, 12346 successful
    rsg_test.go:827: 1m35s of 5m0s: 235782 executions, 12928 successful
    rsg_test.go:827: 1m40s of 5m0s: 248832 executions, 13596 successful
    rsg_test.go:827: 1m45s of 5m0s: 261179 executions, 14197 successful
    rsg_test.go:827: 1m50s of 5m0s: 272868 executions, 14768 successful
    rsg_test.go:827: 1m55s of 5m0s: 286027 executions, 15365 successful
    rsg_test.go:827: 2m0s of 5m0s: 299101 executions, 15944 successful
    rsg_test.go:827: 2m5s of 5m0s: 311458 executions, 16509 successful
    rsg_test.go:827: 2m10s of 5m0s: 323704 executions, 17094 successful
    rsg_test.go:827: 2m15s of 5m0s: 334922 executions, 17673 successful
    rsg_test.go:827: 2m20s of 5m0s: 346858 executions, 18272 successful
    rsg_test.go:827: 2m25s of 5m0s: 359499 executions, 18900 successful
    rsg_test.go:827: 2m30s of 5m0s: 372494 executions, 19496 successful
    rsg_test.go:827: 2m35s of 5m0s: 386067 executions, 20113 successful
    rsg_test.go:827: 2m40s of 5m0s: 399353 executions, 20729 successful
    rsg_test.go:827: 2m45s of 5m0s: 412654 executions, 21367 successful
    rsg_test.go:827: 2m50s of 5m0s: 425598 executions, 21957 successful
    rsg_test.go:827: 2m55s of 5m0s: 437531 executions, 22500 successful
    rsg_test.go:827: 3m0s of 5m0s: 449625 executions, 23084 successful
    rsg_test.go:827: 3m5s of 5m0s: 461180 executions, 23625 successful
    rsg_test.go:827: 3m10s of 5m0s: 472460 executions, 24144 successful
    rsg_test.go:827: 3m15s of 5m0s: 484980 executions, 24731 successful
    rsg_test.go:827: 3m20s of 5m0s: 497530 executions, 25296 successful
    rsg_test.go:827: 3m25s of 5m0s: 511093 executions, 25946 successful
    rsg_test.go:827: 3m30s of 5m0s: 523920 executions, 26552 successful
    rsg_test.go:827: 3m35s of 5m0s: 537580 executions, 27220 successful
    rsg_test.go:827: 3m40s of 5m0s: 550780 executions, 27864 successful
    rsg_test.go:827: 3m45s of 5m0s: 564189 executions, 28454 successful
    rsg_test.go:827: 3m50s of 5m0s: 575411 executions, 28943 successful
    rsg_test.go:827: 3m55s of 5m0s: 588697 executions, 29572 successful
    rsg_test.go:827: 4m0s of 5m0s: 601872 executions, 30198 successful
    rsg_test.go:827: 4m5s of 5m0s: 614608 executions, 30785 successful
    rsg_test.go:827: 4m10s of 5m0s: 627118 executions, 31283 successful
    rsg_test.go:827: 4m15s of 5m0s: 639379 executions, 31827 successful
    rsg_test.go:827: 4m20s of 5m0s: 650823 executions, 32347 successful
    rsg_test.go:827: 4m25s of 5m0s: 663664 executions, 32920 successful
    rsg_test.go:827: 4m30s of 5m0s: 675579 executions, 33465 successful
    rsg_test.go:827: 4m35s of 5m0s: 687023 executions, 33995 successful
    rsg_test.go:827: 4m40s of 5m0s: 698170 executions, 34524 successful
    rsg_test.go:827: 4m45s of 5m0s: 711379 executions, 35103 successful
    rsg_test.go:827: 4m50s of 5m0s: 724332 executions, 35683 successful
    rsg_test.go:827: 4m55s of 5m0s: 738029 executions, 36311 successful
    rsg_test.go:863: 751439 executions, 36916 successful
    rsg_test.go:871: cannot parse output of Format: sql="IMPORT INTO EXTRACT SEQUENCES DATA ( ident ) WITH OPTIONS ( BUCKET_COUNT = PLACEHOLDER , 'string' )", formattedSQL="IMPORT INTO \"extract\" SEQUENCES DATA ('ident') WITH bucket_count = 'placeholder', \"string\"": at or near "with": syntax error
    rsg_test.go:304: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration2146154648
--- FAIL: TestRandomSyntaxGeneration (301.97s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-release-22.2]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-07-09T05:27:48Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ 15480b8496e7928845330055d191e331b228eb66:

    rsg_test.go:827: 1m15s of 5m0s: 181875 executions, 10044 successful
    rsg_test.go:827: 1m20s of 5m0s: 194031 executions, 10684 successful
    rsg_test.go:827: 1m25s of 5m0s: 207210 executions, 11339 successful
    rsg_test.go:827: 1m30s of 5m0s: 219755 executions, 11963 successful
    rsg_test.go:827: 1m35s of 5m0s: 232079 executions, 12630 successful
    rsg_test.go:827: 1m40s of 5m0s: 245254 executions, 13287 successful
    rsg_test.go:827: 1m45s of 5m0s: 258466 executions, 13951 successful
    rsg_test.go:827: 1m50s of 5m0s: 272226 executions, 14593 successful
    rsg_test.go:827: 1m55s of 5m0s: 285065 executions, 15179 successful
    rsg_test.go:827: 2m0s of 5m0s: 297201 executions, 15722 successful
    rsg_test.go:827: 2m5s of 5m0s: 309492 executions, 16346 successful
    rsg_test.go:827: 2m10s of 5m0s: 323014 executions, 16996 successful
    rsg_test.go:827: 2m15s of 5m0s: 334398 executions, 17574 successful
    rsg_test.go:827: 2m20s of 5m0s: 347037 executions, 18168 successful
    rsg_test.go:827: 2m25s of 5m0s: 360475 executions, 18793 successful
    rsg_test.go:827: 2m30s of 5m0s: 372513 executions, 19375 successful
    rsg_test.go:827: 2m35s of 5m0s: 384744 executions, 20001 successful
    rsg_test.go:827: 2m40s of 5m0s: 397244 executions, 20588 successful
    rsg_test.go:827: 2m45s of 5m0s: 408990 executions, 21147 successful
    rsg_test.go:827: 2m50s of 5m0s: 421298 executions, 21752 successful
    rsg_test.go:827: 2m55s of 5m0s: 431855 executions, 22326 successful
    rsg_test.go:827: 3m0s of 5m0s: 445004 executions, 22980 successful
    rsg_test.go:827: 3m5s of 5m0s: 458718 executions, 23670 successful
    rsg_test.go:827: 3m10s of 5m0s: 471890 executions, 24297 successful
    rsg_test.go:827: 3m15s of 5m0s: 484817 executions, 24895 successful
    rsg_test.go:827: 3m20s of 5m0s: 498607 executions, 25524 successful
    rsg_test.go:827: 3m25s of 5m0s: 512341 executions, 26171 successful
    rsg_test.go:827: 3m30s of 5m0s: 525267 executions, 26799 successful
    rsg_test.go:827: 3m35s of 5m0s: 538378 executions, 27438 successful
    rsg_test.go:827: 3m40s of 5m0s: 551780 executions, 28127 successful
    rsg_test.go:827: 3m45s of 5m0s: 564507 executions, 28715 successful
    rsg_test.go:827: 3m50s of 5m0s: 577276 executions, 29365 successful
    rsg_test.go:827: 3m55s of 5m0s: 590010 executions, 29970 successful
    rsg_test.go:827: 4m0s of 5m0s: 601527 executions, 30553 successful
    rsg_test.go:827: 4m5s of 5m0s: 613817 executions, 31141 successful
    rsg_test.go:827: 4m10s of 5m0s: 627223 executions, 31725 successful
    rsg_test.go:827: 4m15s of 5m0s: 640364 executions, 32310 successful
    rsg_test.go:827: 4m20s of 5m0s: 653582 executions, 32909 successful
    rsg_test.go:827: 4m25s of 5m0s: 665442 executions, 33441 successful
    rsg_test.go:827: 4m30s of 5m0s: 679138 executions, 34029 successful
    rsg_test.go:827: 4m35s of 5m0s: 691658 executions, 34603 successful
    rsg_test.go:827: 4m40s of 5m0s: 704521 executions, 35190 successful
    rsg_test.go:827: 4m45s of 5m0s: 716901 executions, 35792 successful
    rsg_test.go:827: 4m50s of 5m0s: 729384 executions, 36380 successful
    rsg_test.go:827: 4m55s of 5m0s: 741104 executions, 36968 successful
    rsg_test.go:863: 752721 executions, 37545 successful
    rsg_test.go:871: cannot parse output of Format: sql="SHOW STATISTICS FOR TABLE FAMILY . TO . FLOAT WITH OPTIONS ( BUCKET_COUNT = PLACEHOLDER , 'string' , NEXT )", formattedSQL="SHOW STATISTICS FOR TABLE \"family\".to.float WITH bucket_count = 'placeholder', \"string\", next": at or near "with": syntax error
    rsg_test.go:304: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration3559668424
--- FAIL: TestRandomSyntaxGeneration (302.07s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-release-22.2]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-07-10T05:28:33Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ f62527e83e458f5f4521497e7bfd5c60b70f1e31:

    rsg_test.go:827: 1m15s of 5m0s: 166541 executions, 9446 successful
    rsg_test.go:827: 1m20s of 5m0s: 177650 executions, 10026 successful
    rsg_test.go:827: 1m25s of 5m0s: 190876 executions, 10635 successful
    rsg_test.go:827: 1m30s of 5m0s: 202632 executions, 11225 successful
    rsg_test.go:827: 1m35s of 5m0s: 213778 executions, 11772 successful
    rsg_test.go:827: 1m40s of 5m0s: 225873 executions, 12372 successful
    rsg_test.go:827: 1m45s of 5m0s: 238411 executions, 12965 successful
    rsg_test.go:827: 1m50s of 5m0s: 250564 executions, 13558 successful
    rsg_test.go:827: 1m55s of 5m0s: 262286 executions, 14149 successful
    rsg_test.go:827: 2m0s of 5m0s: 275057 executions, 14805 successful
    rsg_test.go:827: 2m5s of 5m0s: 286739 executions, 15404 successful
    rsg_test.go:827: 2m10s of 5m0s: 298574 executions, 15959 successful
    rsg_test.go:827: 2m15s of 5m0s: 310526 executions, 16542 successful
    rsg_test.go:827: 2m20s of 5m0s: 323100 executions, 17147 successful
    rsg_test.go:827: 2m25s of 5m0s: 334644 executions, 17721 successful
    rsg_test.go:827: 2m30s of 5m0s: 346586 executions, 18275 successful
    rsg_test.go:827: 2m35s of 5m0s: 358149 executions, 18846 successful
    rsg_test.go:827: 2m40s of 5m0s: 369455 executions, 19402 successful
    rsg_test.go:827: 2m45s of 5m0s: 380857 executions, 19925 successful
    rsg_test.go:827: 2m50s of 5m0s: 392585 executions, 20430 successful
    rsg_test.go:827: 2m55s of 5m0s: 404573 executions, 21008 successful
    rsg_test.go:827: 3m0s of 5m0s: 417357 executions, 21606 successful
    rsg_test.go:827: 3m5s of 5m0s: 430888 executions, 22191 successful
    rsg_test.go:827: 3m10s of 5m0s: 443414 executions, 22751 successful
    rsg_test.go:827: 3m15s of 5m0s: 455688 executions, 23331 successful
    rsg_test.go:827: 3m20s of 5m0s: 467263 executions, 23825 successful
    rsg_test.go:827: 3m25s of 5m0s: 479792 executions, 24382 successful
    rsg_test.go:827: 3m30s of 5m0s: 490766 executions, 24900 successful
    rsg_test.go:827: 3m35s of 5m0s: 502496 executions, 25435 successful
    rsg_test.go:827: 3m40s of 5m0s: 514972 executions, 25948 successful
    rsg_test.go:827: 3m45s of 5m0s: 527395 executions, 26486 successful
    rsg_test.go:827: 3m50s of 5m0s: 539712 executions, 27065 successful
    rsg_test.go:827: 3m55s of 5m0s: 551633 executions, 27634 successful
    rsg_test.go:827: 4m0s of 5m0s: 562768 executions, 28154 successful
    rsg_test.go:827: 4m5s of 5m0s: 573984 executions, 28604 successful
    rsg_test.go:827: 4m10s of 5m0s: 585902 executions, 29136 successful
    rsg_test.go:827: 4m15s of 5m0s: 598139 executions, 29684 successful
    rsg_test.go:827: 4m20s of 5m0s: 609778 executions, 30241 successful
    rsg_test.go:827: 4m25s of 5m0s: 621194 executions, 30751 successful
    rsg_test.go:827: 4m30s of 5m0s: 632752 executions, 31286 successful
    rsg_test.go:827: 4m35s of 5m0s: 644343 executions, 31845 successful
    rsg_test.go:827: 4m40s of 5m0s: 655424 executions, 32404 successful
    rsg_test.go:827: 4m45s of 5m0s: 667743 executions, 32955 successful
    rsg_test.go:827: 4m50s of 5m0s: 680078 executions, 33555 successful
    rsg_test.go:827: 4m55s of 5m0s: 693257 executions, 34122 successful
    rsg_test.go:863: 705535 executions, 34694 successful
    rsg_test.go:871: cannot parse output of Format: sql="IMPORT CALLED ( PLACEHOLDER ) WITH OPTIONS ( BUCKET_COUNT , LINESTRINGZ = PLACEHOLDER , ANNOTATE_TYPE )", formattedSQL="IMPORT CALLED 'placeholder' WITH bucket_count, linestringz = 'placeholder', \"annotate_type\"": at or near "with": syntax error
    rsg_test.go:304: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration1098547473
--- FAIL: TestRandomSyntaxGeneration (301.96s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-release-22.2]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-07-12T05:28:04Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ 57c94bfe124fd08b948caa257acd3cb1e7cf1667:

    rsg_test.go:827: 1m15s of 5m0s: 176552 executions, 9896 successful
    rsg_test.go:827: 1m20s of 5m0s: 187849 executions, 10470 successful
    rsg_test.go:827: 1m25s of 5m0s: 199896 executions, 11091 successful
    rsg_test.go:827: 1m30s of 5m0s: 211493 executions, 11654 successful
    rsg_test.go:827: 1m35s of 5m0s: 222987 executions, 12239 successful
    rsg_test.go:827: 1m40s of 5m0s: 235342 executions, 12844 successful
    rsg_test.go:827: 1m45s of 5m0s: 247748 executions, 13459 successful
    rsg_test.go:827: 1m50s of 5m0s: 260325 executions, 14077 successful
    rsg_test.go:827: 1m55s of 5m0s: 273000 executions, 14696 successful
    rsg_test.go:827: 2m0s of 5m0s: 284796 executions, 15303 successful
    rsg_test.go:827: 2m5s of 5m0s: 296663 executions, 15917 successful
    rsg_test.go:827: 2m10s of 5m0s: 309151 executions, 16512 successful
    rsg_test.go:827: 2m15s of 5m0s: 322001 executions, 17116 successful
    rsg_test.go:827: 2m20s of 5m0s: 334366 executions, 17697 successful
    rsg_test.go:827: 2m25s of 5m0s: 346396 executions, 18254 successful
    rsg_test.go:827: 2m30s of 5m0s: 358513 executions, 18776 successful
    rsg_test.go:827: 2m35s of 5m0s: 371801 executions, 19359 successful
    rsg_test.go:827: 2m40s of 5m0s: 384569 executions, 19968 successful
    rsg_test.go:827: 2m45s of 5m0s: 396900 executions, 20541 successful
    rsg_test.go:827: 2m50s of 5m0s: 410238 executions, 21115 successful
    rsg_test.go:827: 2m55s of 5m0s: 421964 executions, 21679 successful
    rsg_test.go:827: 3m0s of 5m0s: 433305 executions, 22212 successful
    rsg_test.go:827: 3m5s of 5m0s: 445068 executions, 22759 successful
    rsg_test.go:827: 3m10s of 5m0s: 456686 executions, 23250 successful
    rsg_test.go:827: 3m15s of 5m0s: 468982 executions, 23827 successful
    rsg_test.go:827: 3m20s of 5m0s: 480464 executions, 24383 successful
    rsg_test.go:827: 3m25s of 5m0s: 492672 executions, 24932 successful
    rsg_test.go:827: 3m30s of 5m0s: 505422 executions, 25526 successful
    rsg_test.go:827: 3m35s of 5m0s: 518825 executions, 26113 successful
    rsg_test.go:827: 3m40s of 5m0s: 532073 executions, 26718 successful
    rsg_test.go:827: 3m45s of 5m0s: 544657 executions, 27263 successful
    rsg_test.go:827: 3m50s of 5m0s: 557095 executions, 27830 successful
    rsg_test.go:827: 3m55s of 5m0s: 569567 executions, 28394 successful
    rsg_test.go:827: 4m0s of 5m0s: 581611 executions, 28937 successful
    rsg_test.go:827: 4m5s of 5m0s: 593726 executions, 29507 successful
    rsg_test.go:827: 4m10s of 5m0s: 606147 executions, 30049 successful
    rsg_test.go:827: 4m15s of 5m0s: 618258 executions, 30650 successful
    rsg_test.go:827: 4m20s of 5m0s: 630094 executions, 31241 successful
    rsg_test.go:827: 4m25s of 5m0s: 641574 executions, 31816 successful
    rsg_test.go:827: 4m30s of 5m0s: 654118 executions, 32367 successful
    rsg_test.go:827: 4m35s of 5m0s: 665855 executions, 32917 successful
    rsg_test.go:827: 4m40s of 5m0s: 677067 executions, 33436 successful
    rsg_test.go:827: 4m45s of 5m0s: 688044 executions, 33962 successful
    rsg_test.go:827: 4m50s of 5m0s: 700028 executions, 34491 successful
    rsg_test.go:827: 4m55s of 5m0s: 712423 executions, 35070 successful
    rsg_test.go:863: 723862 executions, 35540 successful
    rsg_test.go:871: cannot parse output of Format: sql="ALTER TENANT ARRAY ( ) SET REPLICATION RETENTION = INTERVAL 'string'", formattedSQL="ALTER TENANT (ARRAY[]) SET REPLICATION RETENTION = 'string'::INTERVAL": at or near ":": syntax error
    rsg_test.go:304: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration2366890737
--- FAIL: TestRandomSyntaxGeneration (301.15s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-release-22.2]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-07-13T05:27:04Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ 0efd1568d09a5c6a54ae41b0bbf42c682331d24b:

    rsg_test.go:827: 1m15s of 5m0s: 167007 executions, 9512 successful
    rsg_test.go:827: 1m20s of 5m0s: 179993 executions, 10100 successful
    rsg_test.go:827: 1m25s of 5m0s: 193248 executions, 10746 successful
    rsg_test.go:827: 1m30s of 5m0s: 206367 executions, 11398 successful
    rsg_test.go:827: 1m35s of 5m0s: 219824 executions, 12043 successful
    rsg_test.go:827: 1m40s of 5m0s: 232436 executions, 12706 successful
    rsg_test.go:827: 1m45s of 5m0s: 244832 executions, 13302 successful
    rsg_test.go:827: 1m50s of 5m0s: 257260 executions, 13929 successful
    rsg_test.go:827: 1m55s of 5m0s: 269848 executions, 14491 successful
    rsg_test.go:827: 2m0s of 5m0s: 283031 executions, 15120 successful
    rsg_test.go:827: 2m5s of 5m0s: 296275 executions, 15737 successful
    rsg_test.go:827: 2m10s of 5m0s: 308962 executions, 16395 successful
    rsg_test.go:827: 2m15s of 5m0s: 321286 executions, 16971 successful
    rsg_test.go:827: 2m20s of 5m0s: 333632 executions, 17605 successful
    rsg_test.go:827: 2m25s of 5m0s: 346731 executions, 18232 successful
    rsg_test.go:827: 2m30s of 5m0s: 359885 executions, 18866 successful
    rsg_test.go:827: 2m35s of 5m0s: 372566 executions, 19500 successful
    rsg_test.go:827: 2m40s of 5m0s: 384615 executions, 20088 successful
    rsg_test.go:827: 2m45s of 5m0s: 396053 executions, 20658 successful
    rsg_test.go:827: 2m50s of 5m0s: 407649 executions, 21210 successful
    rsg_test.go:827: 2m55s of 5m0s: 420893 executions, 21831 successful
    rsg_test.go:827: 3m0s of 5m0s: 433883 executions, 22415 successful
    rsg_test.go:827: 3m5s of 5m0s: 446751 executions, 23009 successful
    rsg_test.go:827: 3m10s of 5m0s: 459107 executions, 23584 successful
    rsg_test.go:827: 3m15s of 5m0s: 471285 executions, 24173 successful
    rsg_test.go:827: 3m20s of 5m0s: 483846 executions, 24729 successful
    rsg_test.go:827: 3m25s of 5m0s: 496126 executions, 25300 successful
    rsg_test.go:827: 3m30s of 5m0s: 508747 executions, 25915 successful
    rsg_test.go:827: 3m35s of 5m0s: 521277 executions, 26506 successful
    rsg_test.go:827: 3m40s of 5m0s: 533938 executions, 27056 successful
    rsg_test.go:827: 3m45s of 5m0s: 546331 executions, 27612 successful
    rsg_test.go:827: 3m50s of 5m0s: 558291 executions, 28164 successful
    rsg_test.go:827: 3m55s of 5m0s: 570690 executions, 28728 successful
    rsg_test.go:827: 4m0s of 5m0s: 582660 executions, 29334 successful
    rsg_test.go:827: 4m5s of 5m0s: 595373 executions, 29933 successful
    rsg_test.go:827: 4m10s of 5m0s: 608077 executions, 30436 successful
    rsg_test.go:827: 4m15s of 5m0s: 619742 executions, 30920 successful
    rsg_test.go:827: 4m20s of 5m0s: 631487 executions, 31511 successful
    rsg_test.go:827: 4m25s of 5m0s: 643761 executions, 32098 successful
    rsg_test.go:827: 4m30s of 5m0s: 656384 executions, 32721 successful
    rsg_test.go:827: 4m35s of 5m0s: 669313 executions, 33329 successful
    rsg_test.go:827: 4m40s of 5m0s: 682169 executions, 33948 successful
    rsg_test.go:827: 4m45s of 5m0s: 693977 executions, 34482 successful
    rsg_test.go:827: 4m50s of 5m0s: 707175 executions, 35129 successful
    rsg_test.go:827: 4m55s of 5m0s: 720821 executions, 35773 successful
    rsg_test.go:863: 733528 executions, 36368 successful
    rsg_test.go:871: cannot parse output of Format: sql="IMPORT ident ( PLACEHOLDER ) WITH OPTIONS ( BUCKET_COUNT = FAMILY )", formattedSQL="IMPORT IDENT 'placeholder' WITH bucket_count = 'family'": at or near "with": syntax error
    rsg_test.go:304: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration430683563
--- FAIL: TestRandomSyntaxGeneration (302.03s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-release-22.2]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-07-14T05:28:10Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ 2463ccadcd1658130cb79a1e061282a75c596ea4:

    rsg_test.go:827: 1m15s of 5m0s: 173974 executions, 9842 successful
    rsg_test.go:827: 1m20s of 5m0s: 186129 executions, 10462 successful
    rsg_test.go:827: 1m25s of 5m0s: 198863 executions, 11131 successful
    rsg_test.go:827: 1m30s of 5m0s: 211832 executions, 11809 successful
    rsg_test.go:827: 1m35s of 5m0s: 224496 executions, 12442 successful
    rsg_test.go:827: 1m40s of 5m0s: 236757 executions, 13039 successful
    rsg_test.go:827: 1m45s of 5m0s: 249470 executions, 13632 successful
    rsg_test.go:827: 1m50s of 5m0s: 261175 executions, 14215 successful
    rsg_test.go:827: 1m55s of 5m0s: 273989 executions, 14795 successful
    rsg_test.go:827: 2m0s of 5m0s: 286674 executions, 15382 successful
    rsg_test.go:827: 2m5s of 5m0s: 300582 executions, 16047 successful
    rsg_test.go:827: 2m10s of 5m0s: 313342 executions, 16651 successful
    rsg_test.go:827: 2m15s of 5m0s: 325808 executions, 17217 successful
    rsg_test.go:827: 2m20s of 5m0s: 338306 executions, 17813 successful
    rsg_test.go:827: 2m25s of 5m0s: 350921 executions, 18446 successful
    rsg_test.go:827: 2m30s of 5m0s: 362957 executions, 18990 successful
    rsg_test.go:827: 2m35s of 5m0s: 374160 executions, 19547 successful
    rsg_test.go:827: 2m40s of 5m0s: 386505 executions, 20166 successful
    rsg_test.go:827: 2m45s of 5m0s: 399390 executions, 20770 successful
    rsg_test.go:827: 2m50s of 5m0s: 412751 executions, 21401 successful
    rsg_test.go:827: 2m55s of 5m0s: 425003 executions, 21950 successful
    rsg_test.go:827: 3m0s of 5m0s: 438080 executions, 22510 successful
    rsg_test.go:827: 3m5s of 5m0s: 451078 executions, 23060 successful
    rsg_test.go:827: 3m10s of 5m0s: 464077 executions, 23703 successful
    rsg_test.go:827: 3m15s of 5m0s: 477848 executions, 24311 successful
    rsg_test.go:827: 3m20s of 5m0s: 491617 executions, 24908 successful
    rsg_test.go:827: 3m25s of 5m0s: 504632 executions, 25554 successful
    rsg_test.go:827: 3m30s of 5m0s: 517173 executions, 26102 successful
    rsg_test.go:827: 3m35s of 5m0s: 529261 executions, 26688 successful
    rsg_test.go:827: 3m40s of 5m0s: 541903 executions, 27239 successful
    rsg_test.go:827: 3m45s of 5m0s: 554326 executions, 27845 successful
    rsg_test.go:827: 3m50s of 5m0s: 566191 executions, 28405 successful
    rsg_test.go:827: 3m55s of 5m0s: 579000 executions, 28944 successful
    rsg_test.go:827: 4m0s of 5m0s: 591667 executions, 29550 successful
    rsg_test.go:827: 4m5s of 5m0s: 604574 executions, 30194 successful
    rsg_test.go:827: 4m10s of 5m0s: 617529 executions, 30773 successful
    rsg_test.go:827: 4m15s of 5m0s: 630768 executions, 31420 successful
    rsg_test.go:827: 4m20s of 5m0s: 643508 executions, 31987 successful
    rsg_test.go:827: 4m25s of 5m0s: 656611 executions, 32611 successful
    rsg_test.go:827: 4m30s of 5m0s: 668364 executions, 33179 successful
    rsg_test.go:827: 4m35s of 5m0s: 679149 executions, 33698 successful
    rsg_test.go:827: 4m40s of 5m0s: 689503 executions, 34210 successful
    rsg_test.go:827: 4m45s of 5m0s: 701479 executions, 34752 successful
    rsg_test.go:827: 4m50s of 5m0s: 712805 executions, 35264 successful
    rsg_test.go:827: 4m55s of 5m0s: 723912 executions, 35752 successful
    rsg_test.go:863: 735059 executions, 36269 successful
    rsg_test.go:871: cannot parse output of Format: sql="IMPORT INTO ident SCHEMA DATA ( PLACEHOLDER , PLACEHOLDER , PLACEHOLDER , TESTING_RELOCATE , 'string' , PLACEHOLDER , PLACEHOLDER , PLACEHOLDER , INOUT ) WITH OPTIONS ( BUCKET_COUNT = 'string' )", formattedSQL="IMPORT INTO ident SCHEMA DATA ('placeholder', 'placeholder', 'placeholder', 'testing_relocate', 'string', 'placeholder', 'placeholder', 'placeholder', 'inout') WITH bucket_count = 'string'": at or near "with": syntax error
    rsg_test.go:304: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration2959789297
--- FAIL: TestRandomSyntaxGeneration (302.14s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-release-22.2]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-07-15T05:28:32Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ de4ce5b55d2ff48258b6b981fe3f6d376318861e:

    rsg_test.go:827: 1m15s of 5m0s: 175416 executions, 9968 successful
    rsg_test.go:827: 1m20s of 5m0s: 187566 executions, 10601 successful
    rsg_test.go:827: 1m25s of 5m0s: 199573 executions, 11160 successful
    rsg_test.go:827: 1m30s of 5m0s: 211678 executions, 11799 successful
    rsg_test.go:827: 1m35s of 5m0s: 223127 executions, 12364 successful
    rsg_test.go:827: 1m40s of 5m0s: 235135 executions, 12948 successful
    rsg_test.go:827: 1m45s of 5m0s: 246889 executions, 13537 successful
    rsg_test.go:827: 1m50s of 5m0s: 259238 executions, 14152 successful
    rsg_test.go:827: 1m55s of 5m0s: 271386 executions, 14767 successful
    rsg_test.go:827: 2m0s of 5m0s: 283817 executions, 15405 successful
    rsg_test.go:827: 2m5s of 5m0s: 296909 executions, 16088 successful
    rsg_test.go:827: 2m10s of 5m0s: 309971 executions, 16715 successful
    rsg_test.go:827: 2m15s of 5m0s: 322063 executions, 17333 successful
    rsg_test.go:827: 2m20s of 5m0s: 333873 executions, 17932 successful
    rsg_test.go:827: 2m25s of 5m0s: 346191 executions, 18524 successful
    rsg_test.go:827: 2m30s of 5m0s: 357969 executions, 19096 successful
    rsg_test.go:827: 2m35s of 5m0s: 370002 executions, 19659 successful
    rsg_test.go:827: 2m40s of 5m0s: 382013 executions, 20221 successful
    rsg_test.go:827: 2m45s of 5m0s: 394953 executions, 20794 successful
    rsg_test.go:827: 2m50s of 5m0s: 408076 executions, 21361 successful
    rsg_test.go:827: 2m55s of 5m0s: 421743 executions, 21958 successful
    rsg_test.go:827: 3m0s of 5m0s: 434200 executions, 22490 successful
    rsg_test.go:827: 3m5s of 5m0s: 446823 executions, 23079 successful
    rsg_test.go:827: 3m10s of 5m0s: 459430 executions, 23628 successful
    rsg_test.go:827: 3m15s of 5m0s: 471922 executions, 24146 successful
    rsg_test.go:827: 3m20s of 5m0s: 485017 executions, 24774 successful
    rsg_test.go:827: 3m25s of 5m0s: 498485 executions, 25386 successful
    rsg_test.go:827: 3m30s of 5m0s: 511920 executions, 25981 successful
    rsg_test.go:827: 3m35s of 5m0s: 524471 executions, 26555 successful
    rsg_test.go:827: 3m40s of 5m0s: 537697 executions, 27145 successful
    rsg_test.go:827: 3m45s of 5m0s: 551092 executions, 27757 successful
    rsg_test.go:827: 3m50s of 5m0s: 563557 executions, 28294 successful
    rsg_test.go:827: 3m55s of 5m0s: 576297 executions, 28908 successful
    rsg_test.go:827: 4m0s of 5m0s: 588933 executions, 29461 successful
    rsg_test.go:827: 4m5s of 5m0s: 600700 executions, 30044 successful
    rsg_test.go:827: 4m10s of 5m0s: 612672 executions, 30600 successful
    rsg_test.go:827: 4m15s of 5m0s: 625302 executions, 31207 successful
    rsg_test.go:827: 4m20s of 5m0s: 638184 executions, 31807 successful
    rsg_test.go:827: 4m25s of 5m0s: 650408 executions, 32371 successful
    rsg_test.go:827: 4m30s of 5m0s: 663306 executions, 32954 successful
    rsg_test.go:827: 4m35s of 5m0s: 676669 executions, 33610 successful
    rsg_test.go:827: 4m40s of 5m0s: 689444 executions, 34141 successful
    rsg_test.go:827: 4m45s of 5m0s: 701914 executions, 34679 successful
    rsg_test.go:827: 4m50s of 5m0s: 714013 executions, 35250 successful
    rsg_test.go:827: 4m55s of 5m0s: 726458 executions, 35808 successful
    rsg_test.go:863: 737807 executions, 36367 successful
    rsg_test.go:871: cannot parse output of Format: sql="PREPARE ident AS SHOW BACKUP CONNECTION 'string' WITH TRANSFER = FAMILY , TIME = 'string'", formattedSQL="PREPARE ident AS SHOW BACKUP CONNECTION 'string' WITH TIME = 'string', TRANSFER = 'family'": at or near "with": syntax error
    rsg_test.go:304: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration1536225856
--- FAIL: TestRandomSyntaxGeneration (302.00s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-release-22.2]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-07-16T05:27:22Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ de4ce5b55d2ff48258b6b981fe3f6d376318861e:

    rsg_test.go:827: 1m15s of 5m0s: 169952 executions, 9707 successful
    rsg_test.go:827: 1m20s of 5m0s: 181878 executions, 10349 successful
    rsg_test.go:827: 1m25s of 5m0s: 193632 executions, 10966 successful
    rsg_test.go:827: 1m30s of 5m0s: 206485 executions, 11617 successful
    rsg_test.go:827: 1m35s of 5m0s: 218312 executions, 12187 successful
    rsg_test.go:827: 1m40s of 5m0s: 231086 executions, 12802 successful
    rsg_test.go:827: 1m45s of 5m0s: 243866 executions, 13450 successful
    rsg_test.go:827: 1m50s of 5m0s: 257676 executions, 14071 successful
    rsg_test.go:827: 1m55s of 5m0s: 270480 executions, 14681 successful
    rsg_test.go:827: 2m0s of 5m0s: 282536 executions, 15239 successful
    rsg_test.go:827: 2m5s of 5m0s: 294104 executions, 15781 successful
    rsg_test.go:827: 2m10s of 5m0s: 306685 executions, 16394 successful
    rsg_test.go:827: 2m15s of 5m0s: 319013 executions, 16957 successful
    rsg_test.go:827: 2m20s of 5m0s: 331050 executions, 17516 successful
    rsg_test.go:827: 2m25s of 5m0s: 343501 executions, 18055 successful
    rsg_test.go:827: 2m30s of 5m0s: 356169 executions, 18628 successful
    rsg_test.go:827: 2m35s of 5m0s: 368728 executions, 19249 successful
    rsg_test.go:827: 2m40s of 5m0s: 381171 executions, 19816 successful
    rsg_test.go:827: 2m45s of 5m0s: 392941 executions, 20400 successful
    rsg_test.go:827: 2m50s of 5m0s: 406172 executions, 21027 successful
    rsg_test.go:827: 2m55s of 5m0s: 419498 executions, 21653 successful
    rsg_test.go:827: 3m0s of 5m0s: 433375 executions, 22262 successful
    rsg_test.go:827: 3m5s of 5m0s: 445826 executions, 22845 successful
    rsg_test.go:827: 3m10s of 5m0s: 457994 executions, 23411 successful
    rsg_test.go:827: 3m15s of 5m0s: 470195 executions, 23999 successful
    rsg_test.go:827: 3m20s of 5m0s: 482938 executions, 24609 successful
    rsg_test.go:827: 3m25s of 5m0s: 494916 executions, 25173 successful
    rsg_test.go:827: 3m30s of 5m0s: 506752 executions, 25732 successful
    rsg_test.go:827: 3m35s of 5m0s: 518547 executions, 26310 successful
    rsg_test.go:827: 3m40s of 5m0s: 531173 executions, 26866 successful
    rsg_test.go:827: 3m45s of 5m0s: 544490 executions, 27464 successful
    rsg_test.go:827: 3m50s of 5m0s: 557041 executions, 28018 successful
    rsg_test.go:827: 3m55s of 5m0s: 569169 executions, 28592 successful
    rsg_test.go:827: 4m0s of 5m0s: 581881 executions, 29151 successful
    rsg_test.go:827: 4m5s of 5m0s: 594395 executions, 29732 successful
    rsg_test.go:827: 4m10s of 5m0s: 606117 executions, 30301 successful
    rsg_test.go:827: 4m15s of 5m0s: 616643 executions, 30761 successful
    rsg_test.go:827: 4m20s of 5m0s: 629546 executions, 31361 successful
    rsg_test.go:827: 4m25s of 5m0s: 641695 executions, 31919 successful
    rsg_test.go:827: 4m30s of 5m0s: 653834 executions, 32432 successful
    rsg_test.go:827: 4m35s of 5m0s: 665648 executions, 32952 successful
    rsg_test.go:827: 4m40s of 5m0s: 676846 executions, 33461 successful
    rsg_test.go:827: 4m45s of 5m0s: 688037 executions, 33970 successful
    rsg_test.go:827: 4m50s of 5m0s: 700765 executions, 34563 successful
    rsg_test.go:827: 4m55s of 5m0s: 713790 executions, 35142 successful
    rsg_test.go:863: 726559 executions, 35734 successful
    rsg_test.go:871: cannot parse output of Format: sql="SHOW BACKUP CONNECTION 'string' WITH TRANSFER = PLACEHOLDER , TIME = FAMILY", formattedSQL="SHOW BACKUP CONNECTION 'string' WITH TIME = 'family', TRANSFER = 'placeholder'": at or near "with": syntax error
    rsg_test.go:304: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration4235321895
--- FAIL: TestRandomSyntaxGeneration (301.15s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-release-22.2]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-07-17T05:28:14Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ de4ce5b55d2ff48258b6b981fe3f6d376318861e:

    rsg_test.go:827: 1m15s of 5m0s: 177761 executions, 9865 successful
    rsg_test.go:827: 1m20s of 5m0s: 190672 executions, 10530 successful
    rsg_test.go:827: 1m25s of 5m0s: 203720 executions, 11149 successful
    rsg_test.go:827: 1m30s of 5m0s: 216113 executions, 11783 successful
    rsg_test.go:827: 1m35s of 5m0s: 227666 executions, 12334 successful
    rsg_test.go:827: 1m40s of 5m0s: 239490 executions, 12894 successful
    rsg_test.go:827: 1m45s of 5m0s: 252251 executions, 13531 successful
    rsg_test.go:827: 1m50s of 5m0s: 265666 executions, 14157 successful
    rsg_test.go:827: 1m55s of 5m0s: 277174 executions, 14699 successful
    rsg_test.go:827: 2m0s of 5m0s: 290106 executions, 15329 successful
    rsg_test.go:827: 2m5s of 5m0s: 302707 executions, 15891 successful
    rsg_test.go:827: 2m10s of 5m0s: 315068 executions, 16492 successful
    rsg_test.go:827: 2m15s of 5m0s: 327324 executions, 17099 successful
    rsg_test.go:827: 2m20s of 5m0s: 339110 executions, 17641 successful
    rsg_test.go:827: 2m25s of 5m0s: 351437 executions, 18187 successful
    rsg_test.go:827: 2m30s of 5m0s: 364591 executions, 18822 successful
    rsg_test.go:827: 2m35s of 5m0s: 377716 executions, 19483 successful
    rsg_test.go:827: 2m40s of 5m0s: 390281 executions, 20058 successful
    rsg_test.go:827: 2m45s of 5m0s: 403087 executions, 20681 successful
    rsg_test.go:827: 2m50s of 5m0s: 415772 executions, 21217 successful
    rsg_test.go:827: 2m55s of 5m0s: 427096 executions, 21754 successful
    rsg_test.go:827: 3m0s of 5m0s: 439239 executions, 22326 successful
    rsg_test.go:827: 3m5s of 5m0s: 451713 executions, 22955 successful
    rsg_test.go:827: 3m10s of 5m0s: 464934 executions, 23616 successful
    rsg_test.go:827: 3m15s of 5m0s: 477640 executions, 24230 successful
    rsg_test.go:827: 3m20s of 5m0s: 491208 executions, 24863 successful
    rsg_test.go:827: 3m25s of 5m0s: 504429 executions, 25479 successful
    rsg_test.go:827: 3m30s of 5m0s: 516934 executions, 26113 successful
    rsg_test.go:827: 3m35s of 5m0s: 529562 executions, 26684 successful
    rsg_test.go:827: 3m40s of 5m0s: 542639 executions, 27282 successful
    rsg_test.go:827: 3m45s of 5m0s: 555917 executions, 27913 successful
    rsg_test.go:827: 3m50s of 5m0s: 569468 executions, 28524 successful
    rsg_test.go:827: 3m55s of 5m0s: 583194 executions, 29176 successful
    rsg_test.go:827: 4m0s of 5m0s: 596736 executions, 29854 successful
    rsg_test.go:827: 4m5s of 5m0s: 608880 executions, 30445 successful
    rsg_test.go:827: 4m10s of 5m0s: 621472 executions, 31059 successful
    rsg_test.go:827: 4m15s of 5m0s: 634665 executions, 31677 successful
    rsg_test.go:827: 4m20s of 5m0s: 646470 executions, 32249 successful
    rsg_test.go:827: 4m25s of 5m0s: 658237 executions, 32841 successful
    rsg_test.go:827: 4m30s of 5m0s: 670051 executions, 33397 successful
    rsg_test.go:827: 4m35s of 5m0s: 682501 executions, 33999 successful
    rsg_test.go:827: 4m40s of 5m0s: 695644 executions, 34612 successful
    rsg_test.go:827: 4m45s of 5m0s: 707674 executions, 35176 successful
    rsg_test.go:827: 4m50s of 5m0s: 720557 executions, 35756 successful
    rsg_test.go:827: 4m55s of 5m0s: 732592 executions, 36326 successful
    rsg_test.go:863: 746042 executions, 36921 successful
    rsg_test.go:871: cannot parse output of Format: sql="PREPARE DEFAULTS AS SHOW BACKUP CONNECTION FAMILY WITH TRANSFER = TIMESTAMPTZ , TIME = PLACEHOLDER", formattedSQL="PREPARE defaults AS SHOW BACKUP CONNECTION 'family' WITH TIME = 'placeholder', TRANSFER = 'timestamptz'": at or near "with": syntax error
    rsg_test.go:304: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration3960260864
--- FAIL: TestRandomSyntaxGeneration (301.96s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-release-22.2]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-07-18T05:27:29Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ ae14f647a4bda2532bc9f2be41f25f6acc113412:

    rsg_test.go:827: 1m15s of 5m0s: 185583 executions, 10320 successful
    rsg_test.go:827: 1m20s of 5m0s: 198906 executions, 10964 successful
    rsg_test.go:827: 1m25s of 5m0s: 212527 executions, 11672 successful
    rsg_test.go:827: 1m30s of 5m0s: 225237 executions, 12324 successful
    rsg_test.go:827: 1m35s of 5m0s: 238501 executions, 12980 successful
    rsg_test.go:827: 1m40s of 5m0s: 250749 executions, 13615 successful
    rsg_test.go:827: 1m45s of 5m0s: 263426 executions, 14262 successful
    rsg_test.go:827: 1m50s of 5m0s: 275374 executions, 14826 successful
    rsg_test.go:827: 1m55s of 5m0s: 287645 executions, 15461 successful
    rsg_test.go:827: 2m0s of 5m0s: 300198 executions, 16058 successful
    rsg_test.go:827: 2m5s of 5m0s: 313047 executions, 16669 successful
    rsg_test.go:827: 2m10s of 5m0s: 325652 executions, 17266 successful
    rsg_test.go:827: 2m15s of 5m0s: 338269 executions, 17883 successful
    rsg_test.go:827: 2m20s of 5m0s: 351237 executions, 18502 successful
    rsg_test.go:827: 2m25s of 5m0s: 363473 executions, 19096 successful
    rsg_test.go:827: 2m30s of 5m0s: 376089 executions, 19687 successful
    rsg_test.go:827: 2m35s of 5m0s: 389029 executions, 20296 successful
    rsg_test.go:827: 2m40s of 5m0s: 401218 executions, 20936 successful
    rsg_test.go:827: 2m45s of 5m0s: 414288 executions, 21568 successful
    rsg_test.go:827: 2m50s of 5m0s: 426913 executions, 22185 successful
    rsg_test.go:827: 2m55s of 5m0s: 439287 executions, 22770 successful
    rsg_test.go:827: 3m0s of 5m0s: 451351 executions, 23403 successful
    rsg_test.go:827: 3m5s of 5m0s: 463957 executions, 23963 successful
    rsg_test.go:827: 3m10s of 5m0s: 476162 executions, 24555 successful
    rsg_test.go:827: 3m15s of 5m0s: 488731 executions, 25110 successful
    rsg_test.go:827: 3m20s of 5m0s: 500496 executions, 25691 successful
    rsg_test.go:827: 3m25s of 5m0s: 513407 executions, 26254 successful
    rsg_test.go:827: 3m30s of 5m0s: 525344 executions, 26866 successful
    rsg_test.go:827: 3m35s of 5m0s: 537732 executions, 27429 successful
    rsg_test.go:827: 3m40s of 5m0s: 549815 executions, 28026 successful
    rsg_test.go:827: 3m45s of 5m0s: 561780 executions, 28579 successful
    rsg_test.go:827: 3m50s of 5m0s: 574255 executions, 29154 successful
    rsg_test.go:827: 3m55s of 5m0s: 587209 executions, 29758 successful
    rsg_test.go:827: 4m0s of 5m0s: 599321 executions, 30322 successful
    rsg_test.go:827: 4m5s of 5m0s: 612004 executions, 30905 successful
    rsg_test.go:827: 4m10s of 5m0s: 625177 executions, 31520 successful
    rsg_test.go:827: 4m15s of 5m0s: 637949 executions, 32095 successful
    rsg_test.go:827: 4m20s of 5m0s: 649362 executions, 32598 successful
    rsg_test.go:827: 4m25s of 5m0s: 662701 executions, 33240 successful
    rsg_test.go:827: 4m30s of 5m0s: 675711 executions, 33842 successful
    rsg_test.go:827: 4m35s of 5m0s: 689379 executions, 34493 successful
    rsg_test.go:827: 4m40s of 5m0s: 702864 executions, 35116 successful
    rsg_test.go:827: 4m45s of 5m0s: 716639 executions, 35708 successful
    rsg_test.go:827: 4m50s of 5m0s: 728921 executions, 36320 successful
    rsg_test.go:827: 4m55s of 5m0s: 741121 executions, 36869 successful
    rsg_test.go:863: 753277 executions, 37453 successful
    rsg_test.go:871: cannot parse output of Format: sql="ALTER TENANT 0 SET REPLICATION RETENTION = INTERVAL 'string'", formattedSQL="ALTER TENANT 0 SET REPLICATION RETENTION = 'string'::INTERVAL": at or near ":": syntax error
    rsg_test.go:304: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration2105081711
--- FAIL: TestRandomSyntaxGeneration (301.01s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-release-22.2]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-07-19T05:27:05Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ 6ccfa2ca599092e742151ea7017695e99567d6f1:

    rsg_test.go:827: 1m15s of 5m0s: 174375 executions, 9931 successful
    rsg_test.go:827: 1m20s of 5m0s: 187460 executions, 10599 successful
    rsg_test.go:827: 1m25s of 5m0s: 200864 executions, 11208 successful
    rsg_test.go:827: 1m30s of 5m0s: 213911 executions, 11829 successful
    rsg_test.go:827: 1m35s of 5m0s: 225977 executions, 12491 successful
    rsg_test.go:827: 1m40s of 5m0s: 238142 executions, 13106 successful
    rsg_test.go:827: 1m45s of 5m0s: 251311 executions, 13756 successful
    rsg_test.go:827: 1m50s of 5m0s: 264260 executions, 14400 successful
    rsg_test.go:827: 1m55s of 5m0s: 276454 executions, 14984 successful
    rsg_test.go:827: 2m0s of 5m0s: 288274 executions, 15569 successful
    rsg_test.go:827: 2m5s of 5m0s: 299976 executions, 16130 successful
    rsg_test.go:827: 2m10s of 5m0s: 312436 executions, 16749 successful
    rsg_test.go:827: 2m15s of 5m0s: 325398 executions, 17398 successful
    rsg_test.go:827: 2m20s of 5m0s: 337877 executions, 18036 successful
    rsg_test.go:827: 2m25s of 5m0s: 350823 executions, 18651 successful
    rsg_test.go:827: 2m30s of 5m0s: 362609 executions, 19221 successful
    rsg_test.go:827: 2m35s of 5m0s: 375286 executions, 19793 successful
    rsg_test.go:827: 2m40s of 5m0s: 386835 executions, 20338 successful
    rsg_test.go:827: 2m45s of 5m0s: 398892 executions, 20913 successful
    rsg_test.go:827: 2m50s of 5m0s: 410855 executions, 21460 successful
    rsg_test.go:827: 2m55s of 5m0s: 422535 executions, 22034 successful
    rsg_test.go:827: 3m0s of 5m0s: 434380 executions, 22614 successful
    rsg_test.go:827: 3m5s of 5m0s: 446940 executions, 23183 successful
    rsg_test.go:827: 3m10s of 5m0s: 459675 executions, 23718 successful
    rsg_test.go:827: 3m15s of 5m0s: 472147 executions, 24285 successful
    rsg_test.go:827: 3m20s of 5m0s: 485063 executions, 24846 successful
    rsg_test.go:827: 3m25s of 5m0s: 498177 executions, 25436 successful
    rsg_test.go:827: 3m30s of 5m0s: 511069 executions, 25975 successful
    rsg_test.go:827: 3m35s of 5m0s: 523011 executions, 26472 successful
    rsg_test.go:827: 3m40s of 5m0s: 534930 executions, 27053 successful
    rsg_test.go:827: 3m45s of 5m0s: 547309 executions, 27663 successful
    rsg_test.go:827: 3m50s of 5m0s: 558886 executions, 28194 successful
    rsg_test.go:827: 3m55s of 5m0s: 571426 executions, 28783 successful
    rsg_test.go:827: 4m0s of 5m0s: 583928 executions, 29366 successful
    rsg_test.go:827: 4m5s of 5m0s: 595721 executions, 29913 successful
    rsg_test.go:827: 4m10s of 5m0s: 607735 executions, 30453 successful
    rsg_test.go:827: 4m15s of 5m0s: 620247 executions, 31059 successful
    rsg_test.go:827: 4m20s of 5m0s: 632159 executions, 31623 successful
    rsg_test.go:827: 4m25s of 5m0s: 644298 executions, 32171 successful
    rsg_test.go:827: 4m30s of 5m0s: 656203 executions, 32718 successful
    rsg_test.go:827: 4m35s of 5m0s: 667921 executions, 33239 successful
    rsg_test.go:827: 4m40s of 5m0s: 680781 executions, 33817 successful
    rsg_test.go:827: 4m45s of 5m0s: 694095 executions, 34420 successful
    rsg_test.go:827: 4m50s of 5m0s: 706598 executions, 35003 successful
    rsg_test.go:827: 4m55s of 5m0s: 719987 executions, 35623 successful
    rsg_test.go:863: 732766 executions, 36164 successful
    rsg_test.go:871: cannot parse output of Format: sql="CREATE TENANT IF NOT EXISTS 4.0634982043586595e-27 FROM REPLICATION OF LINESTRINGZ . FAMILY . OWNED . * ON INTERVAL 'string' WITH OPTIONS ( RETENTION = 'string' )", formattedSQL="CREATE TENANT IF NOT EXISTS 4.0634982043586595e-27 FROM REPLICATION OF linestringz.family.owned.* ON 'string'::INTERVAL WITH RETENTION = 'string'": at or near ":": syntax error
    rsg_test.go:304: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration1126326648
--- FAIL: TestRandomSyntaxGeneration (302.13s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-release-22.2]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-07-20T05:27:32Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ d62a2f3ab1dff86bd80cac037b215121537a2a9a:

    rsg_test.go:827: 1m15s of 5m0s: 185425 executions, 10412 successful
    rsg_test.go:827: 1m20s of 5m0s: 198318 executions, 11040 successful
    rsg_test.go:827: 1m25s of 5m0s: 211228 executions, 11683 successful
    rsg_test.go:827: 1m30s of 5m0s: 223088 executions, 12345 successful
    rsg_test.go:827: 1m35s of 5m0s: 235663 executions, 12930 successful
    rsg_test.go:827: 1m40s of 5m0s: 247513 executions, 13505 successful
    rsg_test.go:827: 1m45s of 5m0s: 259690 executions, 14140 successful
    rsg_test.go:827: 1m50s of 5m0s: 272195 executions, 14700 successful
    rsg_test.go:827: 1m55s of 5m0s: 284579 executions, 15288 successful
    rsg_test.go:827: 2m0s of 5m0s: 296190 executions, 15863 successful
    rsg_test.go:827: 2m5s of 5m0s: 307930 executions, 16427 successful
    rsg_test.go:827: 2m10s of 5m0s: 320077 executions, 16987 successful
    rsg_test.go:827: 2m15s of 5m0s: 332939 executions, 17596 successful
    rsg_test.go:827: 2m20s of 5m0s: 346215 executions, 18207 successful
    rsg_test.go:827: 2m25s of 5m0s: 358860 executions, 18827 successful
    rsg_test.go:827: 2m30s of 5m0s: 371806 executions, 19427 successful
    rsg_test.go:827: 2m35s of 5m0s: 384839 executions, 20018 successful
    rsg_test.go:827: 2m40s of 5m0s: 398285 executions, 20622 successful
    rsg_test.go:827: 2m45s of 5m0s: 411257 executions, 21203 successful
    rsg_test.go:827: 2m50s of 5m0s: 423321 executions, 21746 successful
    rsg_test.go:827: 2m55s of 5m0s: 436285 executions, 22353 successful
    rsg_test.go:827: 3m0s of 5m0s: 448802 executions, 22953 successful
    rsg_test.go:827: 3m5s of 5m0s: 460891 executions, 23506 successful
    rsg_test.go:827: 3m10s of 5m0s: 473202 executions, 24089 successful
    rsg_test.go:827: 3m15s of 5m0s: 486391 executions, 24712 successful
    rsg_test.go:827: 3m20s of 5m0s: 499233 executions, 25313 successful
    rsg_test.go:827: 3m25s of 5m0s: 512038 executions, 25905 successful
    rsg_test.go:827: 3m30s of 5m0s: 525147 executions, 26506 successful
    rsg_test.go:827: 3m35s of 5m0s: 537873 executions, 27051 successful
    rsg_test.go:827: 3m40s of 5m0s: 551038 executions, 27679 successful
    rsg_test.go:827: 3m45s of 5m0s: 563543 executions, 28267 successful
    rsg_test.go:827: 3m50s of 5m0s: 576054 executions, 28816 successful
    rsg_test.go:827: 3m55s of 5m0s: 589271 executions, 29429 successful
    rsg_test.go:827: 4m0s of 5m0s: 602243 executions, 30059 successful
    rsg_test.go:827: 4m5s of 5m0s: 615095 executions, 30696 successful
    rsg_test.go:827: 4m10s of 5m0s: 628059 executions, 31294 successful
    rsg_test.go:827: 4m15s of 5m0s: 639655 executions, 31824 successful
    rsg_test.go:827: 4m20s of 5m0s: 652488 executions, 32429 successful
    rsg_test.go:827: 4m25s of 5m0s: 665267 executions, 33060 successful
    rsg_test.go:827: 4m30s of 5m0s: 678619 executions, 33670 successful
    rsg_test.go:827: 4m35s of 5m0s: 691143 executions, 34255 successful
    rsg_test.go:827: 4m40s of 5m0s: 703091 executions, 34850 successful
    rsg_test.go:827: 4m45s of 5m0s: 715968 executions, 35448 successful
    rsg_test.go:827: 4m50s of 5m0s: 728772 executions, 36026 successful
    rsg_test.go:827: 4m55s of 5m0s: 741404 executions, 36599 successful
    rsg_test.go:863: 753532 executions, 37187 successful
    rsg_test.go:871: cannot parse output of Format: sql="PREPARE TIMESTAMPTZ AS SHOW BACKUP CONNECTION PLACEHOLDER WITH TRANSFER = PLACEHOLDER , TIME = PLACEHOLDER", formattedSQL="PREPARE \"timestamptz\" AS SHOW BACKUP CONNECTION 'placeholder' WITH TIME = 'placeholder', TRANSFER = 'placeholder'": at or near "with": syntax error
    rsg_test.go:304: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration3415648236
--- FAIL: TestRandomSyntaxGeneration (302.09s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-release-22.2]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-07-21T05:28:06Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ 043024b889af86e0b8f23f09619d8d3c2c9acd13:

    rsg_test.go:827: 1m15s of 5m0s: 171850 executions, 9739 successful
    rsg_test.go:827: 1m20s of 5m0s: 184057 executions, 10333 successful
    rsg_test.go:827: 1m25s of 5m0s: 196467 executions, 10980 successful
    rsg_test.go:827: 1m30s of 5m0s: 209251 executions, 11616 successful
    rsg_test.go:827: 1m35s of 5m0s: 220987 executions, 12237 successful
    rsg_test.go:827: 1m40s of 5m0s: 232431 executions, 12812 successful
    rsg_test.go:827: 1m45s of 5m0s: 244498 executions, 13434 successful
    rsg_test.go:827: 1m50s of 5m0s: 257551 executions, 14089 successful
    rsg_test.go:827: 1m55s of 5m0s: 269982 executions, 14667 successful
    rsg_test.go:827: 2m0s of 5m0s: 280852 executions, 15183 successful
    rsg_test.go:827: 2m5s of 5m0s: 292647 executions, 15754 successful
    rsg_test.go:827: 2m10s of 5m0s: 304786 executions, 16324 successful
    rsg_test.go:827: 2m15s of 5m0s: 316393 executions, 16884 successful
    rsg_test.go:827: 2m20s of 5m0s: 328454 executions, 17463 successful
    rsg_test.go:827: 2m25s of 5m0s: 340737 executions, 18081 successful
    rsg_test.go:827: 2m30s of 5m0s: 352298 executions, 18643 successful
    rsg_test.go:827: 2m35s of 5m0s: 365079 executions, 19235 successful
    rsg_test.go:827: 2m40s of 5m0s: 376940 executions, 19801 successful
    rsg_test.go:827: 2m45s of 5m0s: 388722 executions, 20333 successful
    rsg_test.go:827: 2m50s of 5m0s: 400685 executions, 20914 successful
    rsg_test.go:827: 2m55s of 5m0s: 412219 executions, 21510 successful
    rsg_test.go:827: 3m0s of 5m0s: 424771 executions, 22097 successful
    rsg_test.go:827: 3m5s of 5m0s: 436623 executions, 22683 successful
    rsg_test.go:827: 3m10s of 5m0s: 448530 executions, 23244 successful
    rsg_test.go:827: 3m15s of 5m0s: 461450 executions, 23799 successful
    rsg_test.go:827: 3m20s of 5m0s: 474044 executions, 24379 successful
    rsg_test.go:827: 3m25s of 5m0s: 486709 executions, 24989 successful
    rsg_test.go:827: 3m30s of 5m0s: 499232 executions, 25565 successful
    rsg_test.go:827: 3m35s of 5m0s: 511980 executions, 26174 successful
    rsg_test.go:827: 3m40s of 5m0s: 524451 executions, 26756 successful
    rsg_test.go:827: 3m45s of 5m0s: 536505 executions, 27284 successful
    rsg_test.go:827: 3m50s of 5m0s: 549017 executions, 27805 successful
    rsg_test.go:827: 3m55s of 5m0s: 561790 executions, 28390 successful
    rsg_test.go:827: 4m0s of 5m0s: 574657 executions, 29002 successful
    rsg_test.go:827: 4m5s of 5m0s: 587053 executions, 29581 successful
    rsg_test.go:827: 4m10s of 5m0s: 599784 executions, 30160 successful
    rsg_test.go:827: 4m15s of 5m0s: 612150 executions, 30770 successful
    rsg_test.go:827: 4m20s of 5m0s: 624317 executions, 31314 successful
    rsg_test.go:827: 4m25s of 5m0s: 636176 executions, 31820 successful
    rsg_test.go:827: 4m30s of 5m0s: 647988 executions, 32382 successful
    rsg_test.go:827: 4m35s of 5m0s: 659676 executions, 32866 successful
    rsg_test.go:827: 4m40s of 5m0s: 671226 executions, 33368 successful
    rsg_test.go:827: 4m45s of 5m0s: 682417 executions, 33833 successful
    rsg_test.go:827: 4m50s of 5m0s: 694459 executions, 34381 successful
    rsg_test.go:827: 4m55s of 5m0s: 705901 executions, 34944 successful
    rsg_test.go:863: 717526 executions, 35422 successful
    rsg_test.go:871: cannot parse output of Format: sql="CREATE TENANT IF NOT EXISTS NULL FROM REPLICATION OF INDEX_BEFORE_PAREN . * ON ( ) WITH OPTIONS ( RETENTION = INTERVAL 'string' MINUTE )", formattedSQL="CREATE VIRTUAL CLUSTER IF NOT EXISTS NULL FROM REPLICATION OF \"index_before_paren\".* ON () WITH RETENTION = 'string'::INTERVAL MINUTE": at or near ":": syntax error
    rsg_test.go:304: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration2465446694
--- FAIL: TestRandomSyntaxGeneration (302.04s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-release-22.2]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-07-22T05:27:28Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ 81e44ab558b20b0ff55020ff05621c0ef43b4241:

    rsg_test.go:832: 1m15s of 5m0s: 178995 executions, 9959 successful
    rsg_test.go:832: 1m20s of 5m0s: 192992 executions, 10649 successful
    rsg_test.go:832: 1m25s of 5m0s: 206576 executions, 11357 successful
    rsg_test.go:832: 1m30s of 5m0s: 219610 executions, 12015 successful
    rsg_test.go:832: 1m35s of 5m0s: 233254 executions, 12648 successful
    rsg_test.go:832: 1m40s of 5m0s: 247594 executions, 13296 successful
    rsg_test.go:832: 1m45s of 5m0s: 261390 executions, 13969 successful
    rsg_test.go:832: 1m50s of 5m0s: 274803 executions, 14637 successful
    rsg_test.go:832: 1m55s of 5m0s: 288174 executions, 15263 successful
    rsg_test.go:832: 2m0s of 5m0s: 301070 executions, 15900 successful
    rsg_test.go:832: 2m5s of 5m0s: 314145 executions, 16533 successful
    rsg_test.go:832: 2m10s of 5m0s: 327704 executions, 17188 successful
    rsg_test.go:832: 2m15s of 5m0s: 340509 executions, 17776 successful
    rsg_test.go:832: 2m20s of 5m0s: 353120 executions, 18348 successful
    rsg_test.go:832: 2m25s of 5m0s: 365793 executions, 18943 successful
    rsg_test.go:832: 2m30s of 5m0s: 377289 executions, 19499 successful
    rsg_test.go:832: 2m35s of 5m0s: 389106 executions, 20058 successful
    rsg_test.go:832: 2m40s of 5m0s: 401183 executions, 20631 successful
    rsg_test.go:832: 2m45s of 5m0s: 414802 executions, 21246 successful
    rsg_test.go:832: 2m50s of 5m0s: 428180 executions, 21883 successful
    rsg_test.go:832: 2m55s of 5m0s: 441391 executions, 22479 successful
    rsg_test.go:832: 3m0s of 5m0s: 455091 executions, 23084 successful
    rsg_test.go:832: 3m5s of 5m0s: 467578 executions, 23705 successful
    rsg_test.go:832: 3m10s of 5m0s: 479719 executions, 24257 successful
    rsg_test.go:832: 3m15s of 5m0s: 493139 executions, 24889 successful
    rsg_test.go:832: 3m20s of 5m0s: 505211 executions, 25435 successful
    rsg_test.go:832: 3m25s of 5m0s: 518321 executions, 26036 successful
    rsg_test.go:832: 3m30s of 5m0s: 531334 executions, 26637 successful
    rsg_test.go:832: 3m35s of 5m0s: 545200 executions, 27261 successful
    rsg_test.go:832: 3m40s of 5m0s: 558533 executions, 27869 successful
    rsg_test.go:832: 3m45s of 5m0s: 571533 executions, 28477 successful
    rsg_test.go:832: 3m50s of 5m0s: 584228 executions, 29065 successful
    rsg_test.go:832: 3m55s of 5m0s: 595712 executions, 29618 successful
    rsg_test.go:832: 4m0s of 5m0s: 608515 executions, 30224 successful
    rsg_test.go:832: 4m5s of 5m0s: 622139 executions, 30861 successful
    rsg_test.go:832: 4m10s of 5m0s: 635474 executions, 31461 successful
    rsg_test.go:832: 4m15s of 5m0s: 648027 executions, 32038 successful
    rsg_test.go:832: 4m20s of 5m0s: 661128 executions, 32621 successful
    rsg_test.go:832: 4m25s of 5m0s: 673662 executions, 33208 successful
    rsg_test.go:832: 4m30s of 5m0s: 686952 executions, 33838 successful
    rsg_test.go:832: 4m35s of 5m0s: 699748 executions, 34395 successful
    rsg_test.go:832: 4m40s of 5m0s: 712369 executions, 34927 successful
    rsg_test.go:832: 4m45s of 5m0s: 724826 executions, 35484 successful
    rsg_test.go:832: 4m50s of 5m0s: 737270 executions, 36070 successful
    rsg_test.go:832: 4m55s of 5m0s: 750631 executions, 36668 successful
    rsg_test.go:868: 762781 executions, 37153 successful
    rsg_test.go:876: cannot parse output of Format: sql="PREPARE DELIMITER AS IMPORT TABLE INDEX_AFTER_ORDER_BY_BEFORE_AT . INSERT FROM CHARACTER ( AGGREGATE ) WITH OPTIONS ( BUCKET_COUNT = 'string' , 'string' , OVERLAY = 'string' , SCROLL , 'string' = PLACEHOLDER )", formattedSQL="PREPARE delimiter AS IMPORT TABLE \"index_after_order_by_before_at\".insert FROM CHARACTER 'aggregate' WITH bucket_count = 'string', \"string\", \"overlay\" = 'string', scroll, \"string\" = 'placeholder'": at or near "with": syntax error
    rsg_test.go:304: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration538534912
--- FAIL: TestRandomSyntaxGeneration (301.00s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-release-22.2]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-07-23T05:26:45Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ 5fe2141d9f7c5e429e3e589a4dd722aa12840e53:

    rsg_test.go:832: 1m15s of 5m0s: 182334 executions, 10199 successful
    rsg_test.go:832: 1m20s of 5m0s: 195723 executions, 10848 successful
    rsg_test.go:832: 1m25s of 5m0s: 208772 executions, 11524 successful
    rsg_test.go:832: 1m30s of 5m0s: 221896 executions, 12160 successful
    rsg_test.go:832: 1m35s of 5m0s: 234236 executions, 12728 successful
    rsg_test.go:832: 1m40s of 5m0s: 246628 executions, 13311 successful
    rsg_test.go:832: 1m45s of 5m0s: 259859 executions, 13965 successful
    rsg_test.go:832: 1m50s of 5m0s: 273266 executions, 14606 successful
    rsg_test.go:832: 1m55s of 5m0s: 284944 executions, 15170 successful
    rsg_test.go:832: 2m0s of 5m0s: 297242 executions, 15700 successful
    rsg_test.go:832: 2m5s of 5m0s: 310214 executions, 16317 successful
    rsg_test.go:832: 2m10s of 5m0s: 322958 executions, 16951 successful
    rsg_test.go:832: 2m15s of 5m0s: 336600 executions, 17598 successful
    rsg_test.go:832: 2m20s of 5m0s: 348657 executions, 18196 successful
    rsg_test.go:832: 2m25s of 5m0s: 362162 executions, 18820 successful
    rsg_test.go:832: 2m30s of 5m0s: 375258 executions, 19432 successful
    rsg_test.go:832: 2m35s of 5m0s: 388215 executions, 20033 successful
    rsg_test.go:832: 2m40s of 5m0s: 401732 executions, 20662 successful
    rsg_test.go:832: 2m45s of 5m0s: 415484 executions, 21330 successful
    rsg_test.go:832: 2m50s of 5m0s: 428821 executions, 21981 successful
    rsg_test.go:832: 2m55s of 5m0s: 442476 executions, 22635 successful
    rsg_test.go:832: 3m0s of 5m0s: 455257 executions, 23246 successful
    rsg_test.go:832: 3m5s of 5m0s: 467018 executions, 23792 successful
    rsg_test.go:832: 3m10s of 5m0s: 479133 executions, 24329 successful
    rsg_test.go:832: 3m15s of 5m0s: 490487 executions, 24876 successful
    rsg_test.go:832: 3m20s of 5m0s: 502002 executions, 25471 successful
    rsg_test.go:832: 3m25s of 5m0s: 514422 executions, 26045 successful
    rsg_test.go:832: 3m30s of 5m0s: 527016 executions, 26667 successful
    rsg_test.go:832: 3m35s of 5m0s: 540525 executions, 27312 successful
    rsg_test.go:832: 3m40s of 5m0s: 553945 executions, 27926 successful
    rsg_test.go:832: 3m45s of 5m0s: 567325 executions, 28529 successful
    rsg_test.go:832: 3m50s of 5m0s: 580074 executions, 29127 successful
    rsg_test.go:832: 3m55s of 5m0s: 593020 executions, 29775 successful
    rsg_test.go:832: 4m0s of 5m0s: 605954 executions, 30378 successful
    rsg_test.go:832: 4m5s of 5m0s: 618614 executions, 30994 successful
    rsg_test.go:832: 4m10s of 5m0s: 630528 executions, 31577 successful
    rsg_test.go:832: 4m15s of 5m0s: 642279 executions, 32099 successful
    rsg_test.go:832: 4m20s of 5m0s: 654487 executions, 32670 successful
    rsg_test.go:832: 4m25s of 5m0s: 667188 executions, 33211 successful
    rsg_test.go:832: 4m30s of 5m0s: 679703 executions, 33738 successful
    rsg_test.go:832: 4m35s of 5m0s: 692015 executions, 34298 successful
    rsg_test.go:832: 4m40s of 5m0s: 704587 executions, 34864 successful
    rsg_test.go:832: 4m45s of 5m0s: 716744 executions, 35380 successful
    rsg_test.go:832: 4m50s of 5m0s: 727989 executions, 35909 successful
    rsg_test.go:832: 4m55s of 5m0s: 739346 executions, 36411 successful
    rsg_test.go:868: 748552 executions, 36858 successful
    rsg_test.go:876: cannot parse output of Format: sql="PREPARE BIT AS IMPORT VIRTUAL_CLUSTER_NAME ident WITH OPTIONS ( BUCKET_COUNT = SETTINGS , SKIP = PLACEHOLDER )", formattedSQL="PREPARE \"bit\" AS IMPORT VIRTUAL_CLUSTER_NAME 'ident' WITH bucket_count = 'settings', skip = 'placeholder'": at or near "with": syntax error
    rsg_test.go:304: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration1064119687
--- FAIL: TestRandomSyntaxGeneration (301.95s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-release-22.2]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-07-24T05:27:20Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ 5fe2141d9f7c5e429e3e589a4dd722aa12840e53:

Random syntax error:

    rsg_test.go:859: Crash detected: server panic: pq: internal error: referenced descriptor ID 168: descriptor not found

Query:

        COPY LEAST ( COMMITTED , ident , ident ) FROM STDIN;

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-release-22.2]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-07-25T05:26:48Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ fe6e361e4148bfee1d6e9ad12d0dddb9cd364dd0:

    rsg_test.go:832: 1m15s of 5m0s: 185901 executions, 10306 successful
    rsg_test.go:832: 1m20s of 5m0s: 198560 executions, 10916 successful
    rsg_test.go:832: 1m25s of 5m0s: 211609 executions, 11601 successful
    rsg_test.go:832: 1m30s of 5m0s: 224955 executions, 12320 successful
    rsg_test.go:832: 1m35s of 5m0s: 238021 executions, 13037 successful
    rsg_test.go:832: 1m40s of 5m0s: 251198 executions, 13681 successful
    rsg_test.go:832: 1m45s of 5m0s: 264402 executions, 14331 successful
    rsg_test.go:832: 1m50s of 5m0s: 278422 executions, 15005 successful
    rsg_test.go:832: 1m55s of 5m0s: 291728 executions, 15634 successful
    rsg_test.go:832: 2m0s of 5m0s: 304376 executions, 16269 successful
    rsg_test.go:832: 2m5s of 5m0s: 317802 executions, 16868 successful
    rsg_test.go:832: 2m10s of 5m0s: 331295 executions, 17527 successful
    rsg_test.go:832: 2m15s of 5m0s: 344060 executions, 18149 successful
    rsg_test.go:832: 2m20s of 5m0s: 355959 executions, 18708 successful
    rsg_test.go:832: 2m25s of 5m0s: 368193 executions, 19308 successful
    rsg_test.go:832: 2m30s of 5m0s: 380858 executions, 19869 successful
    rsg_test.go:832: 2m35s of 5m0s: 392815 executions, 20420 successful
    rsg_test.go:832: 2m40s of 5m0s: 406156 executions, 21027 successful
    rsg_test.go:832: 2m45s of 5m0s: 418915 executions, 21605 successful
    rsg_test.go:832: 2m50s of 5m0s: 432366 executions, 22261 successful
    rsg_test.go:832: 2m55s of 5m0s: 445986 executions, 22895 successful
    rsg_test.go:832: 3m0s of 5m0s: 458118 executions, 23440 successful
    rsg_test.go:832: 3m5s of 5m0s: 470981 executions, 24010 successful
    rsg_test.go:832: 3m10s of 5m0s: 483396 executions, 24595 successful
    rsg_test.go:832: 3m15s of 5m0s: 495887 executions, 25190 successful
    rsg_test.go:832: 3m20s of 5m0s: 507812 executions, 25719 successful
    rsg_test.go:832: 3m25s of 5m0s: 519899 executions, 26255 successful
    rsg_test.go:832: 3m30s of 5m0s: 532635 executions, 26862 successful
    rsg_test.go:832: 3m35s of 5m0s: 544348 executions, 27436 successful
    rsg_test.go:832: 3m40s of 5m0s: 555998 executions, 27964 successful
    rsg_test.go:832: 3m45s of 5m0s: 567949 executions, 28513 successful
    rsg_test.go:832: 3m50s of 5m0s: 580606 executions, 29144 successful
    rsg_test.go:832: 3m55s of 5m0s: 594158 executions, 29728 successful
    rsg_test.go:832: 4m1s of 5m0s: 607949 executions, 30289 successful
    rsg_test.go:832: 4m6s of 5m0s: 620956 executions, 30901 successful
    rsg_test.go:832: 4m11s of 5m0s: 633611 executions, 31473 successful
    rsg_test.go:832: 4m16s of 5m0s: 646169 executions, 32059 successful
    rsg_test.go:832: 4m21s of 5m0s: 659840 executions, 32734 successful
    rsg_test.go:832: 4m26s of 5m0s: 673407 executions, 33328 successful
    rsg_test.go:832: 4m31s of 5m0s: 687057 executions, 33929 successful
    rsg_test.go:832: 4m36s of 5m0s: 700002 executions, 34561 successful
    rsg_test.go:832: 4m41s of 5m0s: 712769 executions, 35121 successful
    rsg_test.go:832: 4m46s of 5m0s: 725465 executions, 35688 successful
    rsg_test.go:832: 4m51s of 5m0s: 738216 executions, 36303 successful
    rsg_test.go:832: 4m56s of 5m0s: 751399 executions, 36935 successful
    rsg_test.go:868: 761764 executions, 37411 successful
    rsg_test.go:876: cannot parse output of Format: sql="CREATE TENANT IF NOT EXISTS ( ( ) AS FORCE_NULL , ident , ident ) FROM REPLICATION OF b'bytes' ON INTERVAL 'string' DAY TO HOUR", formattedSQL="CREATE VIRTUAL CLUSTER IF NOT EXISTS ((() AS force_null, ident, ident)) FROM REPLICATION OF b'bytes' ON 'string'::INTERVAL DAY TO HOUR": at or near ":": syntax error
    rsg_test.go:304: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration309756945
--- FAIL: TestRandomSyntaxGeneration (301.93s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-release-22.2]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-07-26T05:26:56Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ 96579474ba06b7dd7a06d447ed19c9b052b164ec:

    rsg_test.go:832: 1m15s of 5m0s: 175080 executions, 9961 successful
    rsg_test.go:832: 1m20s of 5m0s: 187960 executions, 10647 successful
    rsg_test.go:832: 1m25s of 5m0s: 201013 executions, 11296 successful
    rsg_test.go:832: 1m30s of 5m0s: 214100 executions, 11962 successful
    rsg_test.go:832: 1m35s of 5m0s: 227212 executions, 12589 successful
    rsg_test.go:832: 1m40s of 5m0s: 238798 executions, 13169 successful
    rsg_test.go:832: 1m45s of 5m0s: 250609 executions, 13820 successful
    rsg_test.go:832: 1m50s of 5m0s: 262106 executions, 14402 successful
    rsg_test.go:832: 1m55s of 5m0s: 274678 executions, 15021 successful
    rsg_test.go:832: 2m0s of 5m0s: 286798 executions, 15582 successful
    rsg_test.go:832: 2m5s of 5m0s: 299099 executions, 16171 successful
    rsg_test.go:832: 2m10s of 5m0s: 311081 executions, 16746 successful
    rsg_test.go:832: 2m15s of 5m0s: 322996 executions, 17311 successful
    rsg_test.go:832: 2m20s of 5m0s: 336123 executions, 17917 successful
    rsg_test.go:832: 2m25s of 5m0s: 349703 executions, 18523 successful
    rsg_test.go:832: 2m30s of 5m0s: 362671 executions, 19161 successful
    rsg_test.go:832: 2m35s of 5m0s: 375488 executions, 19758 successful
    rsg_test.go:832: 2m40s of 5m0s: 387864 executions, 20357 successful
    rsg_test.go:832: 2m45s of 5m0s: 399059 executions, 20870 successful
    rsg_test.go:832: 2m50s of 5m0s: 411088 executions, 21409 successful
    rsg_test.go:832: 2m55s of 5m0s: 423012 executions, 21943 successful
    rsg_test.go:832: 3m0s of 5m0s: 435692 executions, 22545 successful
    rsg_test.go:832: 3m5s of 5m0s: 447904 executions, 23129 successful
    rsg_test.go:832: 3m10s of 5m0s: 460094 executions, 23687 successful
    rsg_test.go:832: 3m15s of 5m0s: 472949 executions, 24351 successful
    rsg_test.go:832: 3m20s of 5m0s: 485209 executions, 24905 successful
    rsg_test.go:832: 3m25s of 5m0s: 497903 executions, 25456 successful
    rsg_test.go:832: 3m30s of 5m0s: 510943 executions, 26069 successful
    rsg_test.go:832: 3m35s of 5m0s: 524458 executions, 26672 successful
    rsg_test.go:832: 3m40s of 5m0s: 537784 executions, 27253 successful
    rsg_test.go:832: 3m45s of 5m0s: 550983 executions, 27901 successful
    rsg_test.go:832: 3m50s of 5m0s: 563537 executions, 28480 successful
    rsg_test.go:832: 3m55s of 5m0s: 576240 executions, 29030 successful
    rsg_test.go:832: 4m0s of 5m0s: 589096 executions, 29588 successful
    rsg_test.go:832: 4m5s of 5m0s: 601498 executions, 30195 successful
    rsg_test.go:832: 4m10s of 5m0s: 613784 executions, 30793 successful
    rsg_test.go:832: 4m15s of 5m0s: 626024 executions, 31375 successful
    rsg_test.go:832: 4m20s of 5m0s: 638559 executions, 31965 successful
    rsg_test.go:832: 4m25s of 5m0s: 651880 executions, 32608 successful
    rsg_test.go:832: 4m30s of 5m0s: 665121 executions, 33222 successful
    rsg_test.go:832: 4m35s of 5m0s: 678078 executions, 33800 successful
    rsg_test.go:832: 4m40s of 5m0s: 689193 executions, 34338 successful
    rsg_test.go:832: 4m45s of 5m0s: 702113 executions, 34902 successful
    rsg_test.go:832: 4m50s of 5m0s: 715117 executions, 35495 successful
    rsg_test.go:832: 4m55s of 5m0s: 727236 executions, 36069 successful
    rsg_test.go:868: 739210 executions, 36608 successful
    rsg_test.go:876: cannot parse output of Format: sql="PREPARE JSON AS SHOW BACKUP CONNECTION 'string' WITH TRANSFER = PLACEHOLDER , TIME = FAMILY", formattedSQL="PREPARE json AS SHOW BACKUP CONNECTION 'string' WITH TIME = 'family', TRANSFER = 'placeholder'": at or near "with": syntax error
    rsg_test.go:304: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration3770131382
--- FAIL: TestRandomSyntaxGeneration (302.09s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-release-22.2]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-07-27T05:27:05Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ aaedb3dd0d97097cff7afeb2532c6265d3d62818:

    rsg_test.go:832: 1m15s of 5m0s: 171465 executions, 9859 successful
    rsg_test.go:832: 1m20s of 5m0s: 182728 executions, 10442 successful
    rsg_test.go:832: 1m25s of 5m0s: 193684 executions, 11016 successful
    rsg_test.go:832: 1m30s of 5m0s: 205228 executions, 11639 successful
    rsg_test.go:832: 1m35s of 5m0s: 217154 executions, 12233 successful
    rsg_test.go:832: 1m40s of 5m0s: 229799 executions, 12871 successful
    rsg_test.go:832: 1m45s of 5m0s: 242878 executions, 13522 successful
    rsg_test.go:832: 1m50s of 5m0s: 256159 executions, 14151 successful
    rsg_test.go:832: 1m55s of 5m0s: 268777 executions, 14758 successful
    rsg_test.go:832: 2m0s of 5m0s: 282157 executions, 15404 successful
    rsg_test.go:832: 2m5s of 5m0s: 294878 executions, 16008 successful
    rsg_test.go:832: 2m10s of 5m0s: 307307 executions, 16641 successful
    rsg_test.go:832: 2m15s of 5m0s: 320572 executions, 17253 successful
    rsg_test.go:832: 2m20s of 5m0s: 334095 executions, 17890 successful
    rsg_test.go:832: 2m25s of 5m0s: 347157 executions, 18512 successful
    rsg_test.go:832: 2m30s of 5m0s: 358912 executions, 19094 successful
    rsg_test.go:832: 2m35s of 5m0s: 371576 executions, 19672 successful
    rsg_test.go:832: 2m40s of 5m0s: 384466 executions, 20242 successful
    rsg_test.go:832: 2m45s of 5m0s: 397063 executions, 20794 successful
    rsg_test.go:832: 2m50s of 5m0s: 409273 executions, 21438 successful
    rsg_test.go:832: 2m55s of 5m0s: 421334 executions, 22028 successful
    rsg_test.go:832: 3m0s of 5m0s: 433947 executions, 22619 successful
    rsg_test.go:832: 3m5s of 5m0s: 446034 executions, 23189 successful
    rsg_test.go:832: 3m10s of 5m0s: 458931 executions, 23793 successful
    rsg_test.go:832: 3m15s of 5m0s: 471922 executions, 24360 successful
    rsg_test.go:832: 3m20s of 5m0s: 484808 executions, 24920 successful
    rsg_test.go:832: 3m25s of 5m0s: 497917 executions, 25541 successful
    rsg_test.go:832: 3m30s of 5m0s: 510903 executions, 26181 successful
    rsg_test.go:832: 3m35s of 5m0s: 521705 executions, 26736 successful
    rsg_test.go:832: 3m40s of 5m0s: 533652 executions, 27298 successful
    rsg_test.go:832: 3m45s of 5m0s: 546425 executions, 27873 successful
    rsg_test.go:832: 3m50s of 5m0s: 559773 executions, 28514 successful
    rsg_test.go:832: 3m55s of 5m0s: 572640 executions, 29132 successful
    rsg_test.go:832: 4m0s of 5m0s: 585025 executions, 29755 successful
    rsg_test.go:832: 4m5s of 5m0s: 597603 executions, 30330 successful
    rsg_test.go:832: 4m10s of 5m0s: 610858 executions, 30892 successful
    rsg_test.go:832: 4m15s of 5m0s: 623926 executions, 31458 successful
    rsg_test.go:832: 4m20s of 5m0s: 636578 executions, 32009 successful
    rsg_test.go:832: 4m25s of 5m0s: 648561 executions, 32526 successful
    rsg_test.go:832: 4m30s of 5m0s: 661222 executions, 33151 successful
    rsg_test.go:832: 4m35s of 5m0s: 674911 executions, 33807 successful
    rsg_test.go:832: 4m40s of 5m0s: 687892 executions, 34332 successful
    rsg_test.go:832: 4m45s of 5m0s: 700146 executions, 34935 successful
    rsg_test.go:832: 4m50s of 5m0s: 712947 executions, 35564 successful
    rsg_test.go:832: 4m55s of 5m0s: 726423 executions, 36188 successful
    rsg_test.go:868: 738341 executions, 36733 successful
    rsg_test.go:876: cannot parse output of Format: sql="ALTER VIRTUAL CLUSTER b'bytes' SET REPLICATION RETENTION = INTERVAL 'string' YEAR TO MONTH", formattedSQL="ALTER VIRTUAL CLUSTER b'bytes' SET REPLICATION RETENTION = 'string'::INTERVAL YEAR TO MONTH": at or near ":": syntax error
    rsg_test.go:304: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration3945776834
--- FAIL: TestRandomSyntaxGeneration (300.93s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-release-22.2]

_{This test on roachdash | Improve this report!}

Informs: cockroachdb#99183 Similar to cockroachdb#107185, this commit wraps option formatting of import, backup and restore statement with `()`. Also wrap replcation expression with `()` in `create tenant from replication` statements. Release note: None

cockroach-teamcity · 2023-07-28T05:27:15Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-23.1 @ f698eca431a12cf1526ef18ac093ecba7da48b23:

    rsg_test.go:832: 1m15s of 5m0s: 179822 executions, 9965 successful
    rsg_test.go:832: 1m20s of 5m0s: 192007 executions, 10598 successful
    rsg_test.go:832: 1m25s of 5m0s: 204394 executions, 11226 successful
    rsg_test.go:832: 1m30s of 5m0s: 216239 executions, 11796 successful
    rsg_test.go:832: 1m35s of 5m0s: 228943 executions, 12431 successful
    rsg_test.go:832: 1m40s of 5m0s: 242586 executions, 13104 successful
    rsg_test.go:832: 1m45s of 5m0s: 255604 executions, 13739 successful
    rsg_test.go:832: 1m50s of 5m0s: 268420 executions, 14374 successful
    rsg_test.go:832: 1m55s of 5m0s: 279769 executions, 14960 successful
    rsg_test.go:832: 2m0s of 5m0s: 291908 executions, 15503 successful
    rsg_test.go:832: 2m5s of 5m0s: 304294 executions, 16084 successful
    rsg_test.go:832: 2m10s of 5m0s: 316076 executions, 16666 successful
    rsg_test.go:832: 2m15s of 5m0s: 328210 executions, 17262 successful
    rsg_test.go:832: 2m20s of 5m0s: 340591 executions, 17848 successful
    rsg_test.go:832: 2m25s of 5m0s: 352735 executions, 18426 successful
    rsg_test.go:832: 2m30s of 5m0s: 365282 executions, 19007 successful
    rsg_test.go:832: 2m35s of 5m0s: 378203 executions, 19654 successful
    rsg_test.go:832: 2m40s of 5m0s: 390658 executions, 20292 successful
    rsg_test.go:832: 2m45s of 5m0s: 403369 executions, 20858 successful
    rsg_test.go:832: 2m50s of 5m0s: 416558 executions, 21433 successful
    rsg_test.go:832: 2m55s of 5m0s: 429184 executions, 22012 successful
    rsg_test.go:832: 3m0s of 5m0s: 440695 executions, 22520 successful
    rsg_test.go:832: 3m5s of 5m0s: 451534 executions, 23035 successful
    rsg_test.go:832: 3m10s of 5m0s: 463272 executions, 23592 successful
    rsg_test.go:832: 3m15s of 5m0s: 474668 executions, 24138 successful
    rsg_test.go:832: 3m20s of 5m0s: 486672 executions, 24699 successful
    rsg_test.go:832: 3m25s of 5m0s: 500345 executions, 25366 successful
    rsg_test.go:832: 3m30s of 5m0s: 513735 executions, 26018 successful
    rsg_test.go:832: 3m35s of 5m0s: 526781 executions, 26625 successful
    rsg_test.go:832: 3m40s of 5m0s: 540156 executions, 27201 successful
    rsg_test.go:832: 3m45s of 5m0s: 552670 executions, 27801 successful
    rsg_test.go:832: 3m50s of 5m0s: 565357 executions, 28354 successful
    rsg_test.go:832: 3m55s of 5m0s: 578238 executions, 28951 successful
    rsg_test.go:832: 4m0s of 5m0s: 590085 executions, 29508 successful
    rsg_test.go:832: 4m5s of 5m0s: 603561 executions, 30147 successful
    rsg_test.go:832: 4m10s of 5m0s: 616763 executions, 30787 successful
    rsg_test.go:832: 4m15s of 5m0s: 629961 executions, 31364 successful
    rsg_test.go:832: 4m20s of 5m0s: 640891 executions, 31863 successful
    rsg_test.go:832: 4m25s of 5m0s: 652621 executions, 32410 successful
    rsg_test.go:832: 4m30s of 5m0s: 664418 executions, 32985 successful
    rsg_test.go:832: 4m35s of 5m0s: 675666 executions, 33537 successful
    rsg_test.go:832: 4m40s of 5m0s: 687924 executions, 34085 successful
    rsg_test.go:832: 4m45s of 5m0s: 701024 executions, 34687 successful
    rsg_test.go:832: 4m50s of 5m0s: 714165 executions, 35337 successful
    rsg_test.go:832: 4m55s of 5m0s: 727443 executions, 35901 successful
    rsg_test.go:868: 739926 executions, 36448 successful
    rsg_test.go:876: cannot parse output of Format: sql="CREATE TENANT IF NOT EXISTS PLACEHOLDER FROM REPLICATION OF TRUE ON INTERVAL 'string' MINUTE", formattedSQL="CREATE VIRTUAL CLUSTER IF NOT EXISTS placeholder FROM REPLICATION OF (true) ON 'string'::INTERVAL MINUTE": at or near ":": syntax error
    rsg_test.go:304: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration1622050662
--- FAIL: TestRandomSyntaxGeneration (302.09s)

Help

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

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #99185 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-master]
sql/tests: TestRandomSyntaxGeneration failed #95618 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-foundations branch-release-22.2]

_{This test on roachdash | Improve this report!}

chengxiong-ruan · 2023-07-31T13:49:17Z

closing this since it has been 3 days after the fix was merged. And it make more sense to have new tickets since it's just much easier to fix case by case than looking at a long ticket if there is anything else.

cockroach-teamcity added branch-release-23.1 Used to mark GA and release blockers, technical advisories, and bugs for 23.1 C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. labels Mar 22, 2023

cockroach-teamcity added this to the 23.1 milestone Mar 22, 2023

blathers-crl bot added the T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) label Mar 22, 2023

cockroach-teamcity mentioned this issue Mar 22, 2023

sql/tests: TestRandomSyntaxGeneration failed #99185

Closed

This was referenced Mar 28, 2023

sql: always prevent AvoidBuffering in internal executor #99850

Merged

parser: ALTER TENANT ... RENAME does not round trip #99853

Closed

blathers-crl bot mentioned this issue Mar 29, 2023

release-23.1: sql: always prevent AvoidBuffering in internal executor #99972

Merged

blathers-crl bot pushed a commit that referenced this issue Mar 29, 2023

sql: always prevent AvoidBuffering in internal executor

6ecfa77

Randomized testing in #99183 showed that this could still happen, even after #98290 was merged to fix this issue. Release note: None

chengxiong-ruan self-assigned this Jul 27, 2023

chengxiong-ruan mentioned this issue Jul 27, 2023

release-23.1: sql: fix formatting of import, backup and create tenant #107723

Merged

cockroach-teamcity mentioned this issue Jul 31, 2023

sql/tests: TestRandomSyntaxGeneration failed #107871

Closed

chengxiong-ruan closed this as completed Jul 31, 2023

sql/tests: TestRandomSyntaxGeneration failed #99183

sql/tests: TestRandomSyntaxGeneration failed #99183

Comments

cockroach-teamcity commented Mar 22, 2023 • edited by cockroach-jira-scripts Loading

cockroach-teamcity commented Mar 23, 2023

cockroach-teamcity commented Mar 24, 2023

cockroach-teamcity commented Mar 25, 2023

cockroach-teamcity commented Mar 26, 2023

cockroach-teamcity commented Mar 27, 2023

cockroach-teamcity commented Mar 28, 2023

rafiss commented Mar 28, 2023

yuzefovich commented Mar 28, 2023

yuzefovich commented Mar 28, 2023

rafiss commented Mar 28, 2023

cockroach-teamcity commented Mar 29, 2023

cockroach-teamcity commented Mar 30, 2023

cockroach-teamcity commented Mar 31, 2023

cockroach-teamcity commented Apr 1, 2023

cockroach-teamcity commented Apr 2, 2023

cockroach-teamcity commented Apr 3, 2023

cockroach-teamcity commented Jul 8, 2023

cockroach-teamcity commented Jul 9, 2023

cockroach-teamcity commented Jul 10, 2023

cockroach-teamcity commented Jul 12, 2023

cockroach-teamcity commented Jul 13, 2023

cockroach-teamcity commented Jul 14, 2023

cockroach-teamcity commented Jul 15, 2023

cockroach-teamcity commented Jul 16, 2023

cockroach-teamcity commented Jul 17, 2023

cockroach-teamcity commented Jul 18, 2023

cockroach-teamcity commented Jul 19, 2023

cockroach-teamcity commented Jul 20, 2023

cockroach-teamcity commented Jul 21, 2023

cockroach-teamcity commented Jul 22, 2023

cockroach-teamcity commented Jul 23, 2023

cockroach-teamcity commented Jul 24, 2023

cockroach-teamcity commented Jul 25, 2023

cockroach-teamcity commented Jul 26, 2023

cockroach-teamcity commented Jul 27, 2023

cockroach-teamcity commented Jul 28, 2023

chengxiong-ruan commented Jul 31, 2023

cockroach-teamcity commented Mar 22, 2023 •

edited by cockroach-jira-scripts

Loading