Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sql/tests: TestRandomSyntaxGeneration failed #77893

Closed
cockroach-teamcity opened this issue Mar 16, 2022 · 14 comments
Closed

sql/tests: TestRandomSyntaxGeneration failed #77893

cockroach-teamcity opened this issue Mar 16, 2022 · 14 comments
Labels
branch-release-22.1 Used to mark GA and release blockers, technical advisories, and bugs for 22.1 C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Mar 16, 2022

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-22.1 @ a1c1879e01ceee79a81693c67a1dba184b5fc1b1:

    rsg_test.go:755: 1m15s of 5m0s: 300791 executions, 3373 successful
    rsg_test.go:755: 1m20s of 5m0s: 319124 executions, 3616 successful
    rsg_test.go:755: 1m25s of 5m0s: 339687 executions, 3937 successful
    rsg_test.go:755: 1m30s of 5m0s: 359239 executions, 4218 successful
    rsg_test.go:755: 1m35s of 5m0s: 378190 executions, 4511 successful
    rsg_test.go:755: 1m40s of 5m0s: 401614 executions, 4835 successful
    rsg_test.go:755: 1m45s of 5m0s: 424497 executions, 5152 successful
    rsg_test.go:755: 1m50s of 5m0s: 444097 executions, 5474 successful
    rsg_test.go:755: 1m55s of 5m0s: 464310 executions, 5741 successful
    rsg_test.go:755: 2m0s of 5m0s: 485620 executions, 6033 successful
    rsg_test.go:755: 2m5s of 5m0s: 507403 executions, 6287 successful
    rsg_test.go:755: 2m10s of 5m0s: 528103 executions, 6589 successful
    rsg_test.go:755: 2m15s of 5m0s: 548587 executions, 6890 successful
    rsg_test.go:755: 2m20s of 5m0s: 562022 executions, 7083 successful
    rsg_test.go:755: 2m25s of 5m0s: 581040 executions, 7321 successful
    rsg_test.go:755: 2m30s of 5m0s: 598999 executions, 7526 successful
    rsg_test.go:755: 2m35s of 5m0s: 621791 executions, 7842 successful
    rsg_test.go:755: 2m40s of 5m0s: 642033 executions, 8146 successful
    rsg_test.go:755: 2m45s of 5m0s: 660531 executions, 8404 successful
    rsg_test.go:755: 2m50s of 5m0s: 679504 executions, 8658 successful
    rsg_test.go:755: 2m55s of 5m0s: 702383 executions, 9015 successful
    rsg_test.go:755: 3m0s of 5m0s: 725574 executions, 9311 successful
    rsg_test.go:755: 3m5s of 5m0s: 748125 executions, 9668 successful
    rsg_test.go:755: 3m10s of 5m0s: 771006 executions, 9946 successful
    rsg_test.go:755: 3m15s of 5m0s: 793595 executions, 10237 successful
    rsg_test.go:755: 3m20s of 5m0s: 816101 executions, 10584 successful
    rsg_test.go:755: 3m25s of 5m0s: 836964 executions, 10874 successful
    rsg_test.go:755: 3m30s of 5m0s: 857362 executions, 11237 successful
    rsg_test.go:755: 3m35s of 5m0s: 877933 executions, 11628 successful
    rsg_test.go:755: 3m40s of 5m0s: 897854 executions, 11936 successful
    rsg_test.go:755: 3m45s of 5m0s: 917914 executions, 12277 successful
    rsg_test.go:755: 3m50s of 5m0s: 938032 executions, 12589 successful
    rsg_test.go:755: 3m55s of 5m0s: 957719 executions, 12900 successful
    rsg_test.go:755: 4m0s of 5m0s: 975543 executions, 13189 successful
    rsg_test.go:755: 4m5s of 5m0s: 996400 executions, 13488 successful
    rsg_test.go:755: 4m10s of 5m0s: 1015982 executions, 13805 successful
    rsg_test.go:755: 4m15s of 5m0s: 1033983 executions, 14150 successful
    rsg_test.go:755: 4m20s of 5m0s: 1053215 executions, 14503 successful
    rsg_test.go:755: 4m25s of 5m0s: 1070540 executions, 14796 successful
    rsg_test.go:755: 4m30s of 5m0s: 1090507 executions, 15038 successful
    rsg_test.go:755: 4m35s of 5m0s: 1110025 executions, 15360 successful
    rsg_test.go:755: 4m40s of 5m0s: 1128520 executions, 15678 successful
    rsg_test.go:755: 4m45s of 5m0s: 1150116 executions, 16083 successful
    rsg_test.go:755: 4m50s of 5m0s: 1171699 executions, 16445 successful
    rsg_test.go:755: 4m55s of 5m0s: 1192547 executions, 16791 successful
    rsg_test.go:791: 1211427 executions, 17112 successful
    rsg_test.go:799: cannot parse output of Format: sql="RESTORE SYSTEM USERS FROM STDIN IN ( 'string' , 'string' , PLACEHOLDER , PLACEHOLDER , FAMILY ) WITH OPTIONS ( ENCRYPTION_PASSPHRASE = PLACEHOLDER )", formattedSQL="RESTORE TABLE  FROM 'stdin' IN ('string', 'string', 'placeholder', 'placeholder', 'family') WITH encryption_passphrase = 'placeholder'": at or near "from": syntax error
    rsg_test.go:252: -- test log scope end --
test logs left over in: /go/src/github.com/cockroachdb/cockroach/artifacts/logTestRandomSyntaxGeneration2484803686
--- FAIL: TestRandomSyntaxGeneration (301.27s)
Help

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

Same failure on other branches

/cc @cockroachdb/sql-experience

This test on roachdash | Improve this report!

Jira issue: CRDB-13818

@cockroach-teamcity cockroach-teamcity added branch-release-22.1 Used to mark GA and release blockers, technical advisories, and bugs for 22.1 C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. labels Mar 16, 2022
@blathers-crl blathers-crl bot added the T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) label Mar 16, 2022
@cockroach-teamcity
Copy link
Member Author

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-22.1 @ 2d49a7bd0d1ebeff93277233695411d25b2a5d39:

    rsg_test.go:755: 1m15s of 5m0s: 317287 executions, 3577 successful
    rsg_test.go:755: 1m20s of 5m0s: 336809 executions, 3819 successful
    rsg_test.go:755: 1m25s of 5m0s: 358641 executions, 4096 successful
    rsg_test.go:755: 1m30s of 5m0s: 380023 executions, 4362 successful
    rsg_test.go:755: 1m35s of 5m0s: 400877 executions, 4657 successful
    rsg_test.go:755: 1m40s of 5m0s: 422231 executions, 4944 successful
    rsg_test.go:755: 1m45s of 5m0s: 443002 executions, 5211 successful
    rsg_test.go:755: 1m50s of 5m0s: 463989 executions, 5510 successful
    rsg_test.go:755: 1m55s of 5m0s: 485207 executions, 5805 successful
    rsg_test.go:755: 2m0s of 5m0s: 506482 executions, 6070 successful
    rsg_test.go:755: 2m5s of 5m0s: 527803 executions, 6324 successful
    rsg_test.go:755: 2m10s of 5m0s: 547952 executions, 6577 successful
    rsg_test.go:755: 2m15s of 5m0s: 568067 executions, 6834 successful
    rsg_test.go:755: 2m20s of 5m0s: 586684 executions, 7080 successful
    rsg_test.go:755: 2m25s of 5m0s: 606650 executions, 7300 successful
    rsg_test.go:755: 2m30s of 5m0s: 626131 executions, 7500 successful
    rsg_test.go:755: 2m35s of 5m0s: 645372 executions, 7728 successful
    rsg_test.go:755: 2m40s of 5m0s: 663781 executions, 7985 successful
    rsg_test.go:755: 2m45s of 5m0s: 680475 executions, 8173 successful
    rsg_test.go:755: 2m50s of 5m0s: 698396 executions, 8412 successful
    rsg_test.go:755: 2m55s of 5m0s: 713725 executions, 8662 successful
    rsg_test.go:755: 3m0s of 5m0s: 728981 executions, 8896 successful
    rsg_test.go:755: 3m5s of 5m0s: 746435 executions, 9159 successful
    rsg_test.go:755: 3m10s of 5m0s: 762011 executions, 9345 successful
    rsg_test.go:755: 3m15s of 5m0s: 778864 executions, 9620 successful
    rsg_test.go:755: 3m20s of 5m0s: 793982 executions, 9791 successful
    rsg_test.go:755: 3m25s of 5m0s: 811051 executions, 10037 successful
    rsg_test.go:755: 3m30s of 5m0s: 826844 executions, 10278 successful
    rsg_test.go:755: 3m35s of 5m0s: 847421 executions, 10590 successful
    rsg_test.go:755: 3m40s of 5m0s: 866807 executions, 10886 successful
    rsg_test.go:755: 3m45s of 5m0s: 887626 executions, 11248 successful
    rsg_test.go:755: 3m50s of 5m0s: 908580 executions, 11576 successful
    rsg_test.go:755: 3m55s of 5m0s: 931116 executions, 11963 successful
    rsg_test.go:755: 4m0s of 5m0s: 952343 executions, 12275 successful
    rsg_test.go:755: 4m5s of 5m0s: 974838 executions, 12611 successful
    rsg_test.go:755: 4m10s of 5m0s: 994947 executions, 12945 successful
    rsg_test.go:755: 4m15s of 5m0s: 1014249 executions, 13264 successful
    rsg_test.go:755: 4m20s of 5m0s: 1033757 executions, 13594 successful
    rsg_test.go:755: 4m25s of 5m0s: 1052321 executions, 13912 successful
    rsg_test.go:755: 4m30s of 5m0s: 1072004 executions, 14236 successful
    rsg_test.go:755: 4m35s of 5m0s: 1091852 executions, 14576 successful
    rsg_test.go:755: 4m40s of 5m0s: 1110075 executions, 14888 successful
    rsg_test.go:755: 4m45s of 5m0s: 1128714 executions, 15193 successful
    rsg_test.go:755: 4m50s of 5m0s: 1145090 executions, 15472 successful
    rsg_test.go:755: 4m55s of 5m0s: 1164060 executions, 15775 successful
    rsg_test.go:791: 1181987 executions, 16078 successful
    rsg_test.go:799: cannot parse output of Format: sql="RESTORE SYSTEM USERS FROM 'string' IN 'string' , ( PLACEHOLDER ) , ( PRESERVE ) WITH SKIP_MISSING_SEQUENCE_OWNERS", formattedSQL="RESTORE TABLE  FROM 'string' IN 'string', 'placeholder', 'preserve' WITH skip_missing_sequence_owners": at or near "from": syntax error
    rsg_test.go:252: -- test log scope end --
test logs left over in: /go/src/github.com/cockroachdb/cockroach/artifacts/logTestRandomSyntaxGeneration2723130233
--- FAIL: TestRandomSyntaxGeneration (301.22s)
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-22.1 @ d7252106b166f23d791a4d677afdbc46b6b059ae:

    rsg_test.go:758: 1m15s of 5m0s: 313364 executions, 3702 successful
    rsg_test.go:758: 1m20s of 5m0s: 335636 executions, 3952 successful
    rsg_test.go:758: 1m25s of 5m0s: 355610 executions, 4212 successful
    rsg_test.go:758: 1m30s of 5m0s: 376181 executions, 4509 successful
    rsg_test.go:758: 1m35s of 5m0s: 395322 executions, 4818 successful
    rsg_test.go:758: 1m40s of 5m0s: 415010 executions, 5074 successful
    rsg_test.go:758: 1m45s of 5m0s: 434877 executions, 5338 successful
    rsg_test.go:758: 1m50s of 5m0s: 453948 executions, 5615 successful
    rsg_test.go:758: 1m55s of 5m0s: 470403 executions, 5836 successful
    rsg_test.go:758: 2m0s of 5m0s: 490732 executions, 6143 successful
    rsg_test.go:758: 2m5s of 5m0s: 507138 executions, 6388 successful
    rsg_test.go:758: 2m10s of 5m0s: 527730 executions, 6667 successful
    rsg_test.go:758: 2m15s of 5m0s: 550384 executions, 6947 successful
    rsg_test.go:758: 2m20s of 5m0s: 573341 executions, 7209 successful
    rsg_test.go:758: 2m25s of 5m0s: 591794 executions, 7491 successful
    rsg_test.go:758: 2m30s of 5m0s: 613082 executions, 7845 successful
    rsg_test.go:758: 2m35s of 5m0s: 635188 executions, 8170 successful
    rsg_test.go:758: 2m40s of 5m0s: 657110 executions, 8533 successful
    rsg_test.go:758: 2m45s of 5m0s: 678973 executions, 8818 successful
    rsg_test.go:758: 2m50s of 5m0s: 699542 executions, 9096 successful
    rsg_test.go:758: 2m55s of 5m0s: 721108 executions, 9418 successful
    rsg_test.go:758: 3m0s of 5m0s: 742505 executions, 9784 successful
    rsg_test.go:758: 3m5s of 5m0s: 765320 executions, 10049 successful
    rsg_test.go:758: 3m10s of 5m0s: 787070 executions, 10327 successful
    rsg_test.go:758: 3m15s of 5m0s: 808201 executions, 10711 successful
    rsg_test.go:758: 3m20s of 5m0s: 828799 executions, 10986 successful
    rsg_test.go:758: 3m25s of 5m0s: 849017 executions, 11306 successful
    rsg_test.go:758: 3m30s of 5m0s: 868530 executions, 11644 successful
    rsg_test.go:758: 3m35s of 5m0s: 888013 executions, 11968 successful
    rsg_test.go:758: 3m40s of 5m0s: 908394 executions, 12249 successful
    rsg_test.go:758: 3m45s of 5m0s: 928784 executions, 12495 successful
    rsg_test.go:758: 3m50s of 5m0s: 948436 executions, 12764 successful
    rsg_test.go:758: 3m55s of 5m0s: 971973 executions, 13060 successful
    rsg_test.go:758: 4m0s of 5m0s: 994835 executions, 13382 successful
    rsg_test.go:758: 4m5s of 5m0s: 1017269 executions, 13693 successful
    rsg_test.go:758: 4m10s of 5m0s: 1036562 executions, 13996 successful
    rsg_test.go:758: 4m15s of 5m0s: 1057658 executions, 14270 successful
    rsg_test.go:758: 4m20s of 5m0s: 1079385 executions, 14499 successful
    rsg_test.go:758: 4m25s of 5m0s: 1099343 executions, 14754 successful
    rsg_test.go:758: 4m30s of 5m0s: 1118346 executions, 15024 successful
    rsg_test.go:758: 4m35s of 5m0s: 1135785 executions, 15319 successful
    rsg_test.go:758: 4m40s of 5m0s: 1158096 executions, 15672 successful
    rsg_test.go:758: 4m45s of 5m0s: 1179665 executions, 15956 successful
    rsg_test.go:758: 4m50s of 5m0s: 1200583 executions, 16344 successful
    rsg_test.go:758: 4m55s of 5m0s: 1221340 executions, 16635 successful
    rsg_test.go:794: 1238636 executions, 16949 successful
    rsg_test.go:802: cannot parse output of Format: sql="RESTORE SYSTEM USERS FROM PLACEHOLDER WITH OPTIONS ( SKIP_MISSING_FOREIGN_KEYS , SKIP_MISSING_VIEWS , SKIP_MISSING_SEQUENCE_OWNERS , SKIP_MISSING_SEQUENCES )", formattedSQL="RESTORE TABLE  FROM 'placeholder' WITH skip_missing_foreign_keys, skip_missing_sequence_owners, skip_missing_sequences, skip_missing_views": at or near "from": syntax error
    rsg_test.go:252: -- test log scope end --
test logs left over in: /go/src/github.com/cockroachdb/cockroach/artifacts/logTestRandomSyntaxGeneration1817598765
--- FAIL: TestRandomSyntaxGeneration (301.23s)
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-22.1 @ f5b42a4e3bbdadb25aee89a41871239a624d538d:

Random syntax error:

    rsg_test.go:785: Crash detected: server panic: statement exec timeout

Query:

        DROP SCHEMA IF EXISTS TIMETZ CASCADE;
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-22.1 @ a25a145510d5d0bc7570db327a21cd3fcde21980:

    rsg_test.go:758: 1m15s of 5m0s: 321053 executions, 3738 successful
    rsg_test.go:758: 1m20s of 5m0s: 338066 executions, 3986 successful
    rsg_test.go:758: 1m25s of 5m0s: 358349 executions, 4274 successful
    rsg_test.go:758: 1m30s of 5m0s: 379159 executions, 4598 successful
    rsg_test.go:758: 1m35s of 5m0s: 401936 executions, 4902 successful
    rsg_test.go:758: 1m40s of 5m0s: 423895 executions, 5219 successful
    rsg_test.go:758: 1m45s of 5m0s: 444086 executions, 5516 successful
    rsg_test.go:758: 1m50s of 5m0s: 463459 executions, 5805 successful
    rsg_test.go:758: 1m55s of 5m0s: 483724 executions, 6096 successful
    rsg_test.go:758: 2m0s of 5m0s: 503052 executions, 6383 successful
    rsg_test.go:758: 2m5s of 5m0s: 521368 executions, 6668 successful
    rsg_test.go:758: 2m10s of 5m0s: 537640 executions, 6938 successful
    rsg_test.go:758: 2m15s of 5m0s: 556757 executions, 7245 successful
    rsg_test.go:758: 2m20s of 5m0s: 576920 executions, 7552 successful
    rsg_test.go:758: 2m25s of 5m0s: 596560 executions, 7824 successful
    rsg_test.go:758: 2m30s of 5m0s: 616629 executions, 8158 successful
    rsg_test.go:758: 2m35s of 5m0s: 638495 executions, 8502 successful
    rsg_test.go:758: 2m40s of 5m0s: 658768 executions, 8813 successful
    rsg_test.go:758: 2m45s of 5m0s: 680391 executions, 9153 successful
    rsg_test.go:758: 2m50s of 5m0s: 700847 executions, 9489 successful
    rsg_test.go:758: 2m55s of 5m0s: 722613 executions, 9833 successful
    rsg_test.go:758: 3m0s of 5m0s: 742775 executions, 10145 successful
    rsg_test.go:758: 3m5s of 5m0s: 762212 executions, 10458 successful
    rsg_test.go:758: 3m10s of 5m0s: 781282 executions, 10760 successful
    rsg_test.go:758: 3m15s of 5m0s: 795740 executions, 10983 successful
    rsg_test.go:758: 3m20s of 5m0s: 817291 executions, 11322 successful
    rsg_test.go:758: 3m25s of 5m0s: 836314 executions, 11656 successful
    rsg_test.go:758: 3m30s of 5m0s: 856864 executions, 11990 successful
    rsg_test.go:758: 3m35s of 5m0s: 873847 executions, 12297 successful
    rsg_test.go:758: 3m40s of 5m0s: 893099 executions, 12568 successful
    rsg_test.go:758: 3m45s of 5m0s: 910137 executions, 12851 successful
    rsg_test.go:758: 3m50s of 5m0s: 927117 executions, 13141 successful
    rsg_test.go:758: 3m55s of 5m0s: 949009 executions, 13515 successful
    rsg_test.go:758: 4m0s of 5m0s: 972359 executions, 13855 successful
    rsg_test.go:758: 4m5s of 5m0s: 993623 executions, 14203 successful
    rsg_test.go:758: 4m10s of 5m0s: 1014650 executions, 14538 successful
    rsg_test.go:758: 4m15s of 5m0s: 1037428 executions, 14912 successful
    rsg_test.go:758: 4m20s of 5m0s: 1060599 executions, 15269 successful
    rsg_test.go:758: 4m25s of 5m0s: 1083529 executions, 15666 successful
    rsg_test.go:758: 4m30s of 5m0s: 1106559 executions, 16082 successful
    rsg_test.go:758: 4m35s of 5m0s: 1129527 executions, 16490 successful
    rsg_test.go:758: 4m40s of 5m0s: 1151380 executions, 16917 successful
    rsg_test.go:758: 4m45s of 5m0s: 1169951 executions, 17298 successful
    rsg_test.go:758: 4m50s of 5m0s: 1192123 executions, 17716 successful
    rsg_test.go:758: 4m55s of 5m0s: 1211436 executions, 18053 successful
    rsg_test.go:794: 1228474 executions, 18413 successful
    rsg_test.go:802: cannot parse output of Format: sql="PREPARE ident AS RESTORE SYSTEM USERS FROM ( PLACEHOLDER ) WITH INCREMENTAL_LOCATION = PLACEHOLDER , ENCRYPTION_PASSPHRASE = PLACEHOLDER", formattedSQL="PREPARE ident AS RESTORE TABLE  FROM 'placeholder' WITH encryption_passphrase = 'placeholder', incremental_location = 'placeholder'": at or near "from": syntax error
    rsg_test.go:252: -- test log scope end --
test logs left over in: /go/src/github.com/cockroachdb/cockroach/artifacts/logTestRandomSyntaxGeneration874024005
--- FAIL: TestRandomSyntaxGeneration (301.38s)
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-22.1 @ ec0a78bbf61f7d71fe4222cc1c11d262936df2e3:

    rsg_test.go:758: 1m15s of 5m0s: 318236 executions, 3592 successful
    rsg_test.go:758: 1m20s of 5m0s: 336021 executions, 3821 successful
    rsg_test.go:758: 1m25s of 5m0s: 352605 executions, 4039 successful
    rsg_test.go:758: 1m30s of 5m0s: 369273 executions, 4280 successful
    rsg_test.go:758: 1m35s of 5m0s: 390560 executions, 4539 successful
    rsg_test.go:758: 1m40s of 5m0s: 413488 executions, 4800 successful
    rsg_test.go:758: 1m45s of 5m0s: 435677 executions, 5060 successful
    rsg_test.go:758: 1m50s of 5m0s: 456704 executions, 5342 successful
    rsg_test.go:758: 1m55s of 5m0s: 477654 executions, 5609 successful
    rsg_test.go:758: 2m0s of 5m0s: 498681 executions, 5880 successful
    rsg_test.go:758: 2m5s of 5m0s: 518554 executions, 6170 successful
    rsg_test.go:758: 2m10s of 5m0s: 539066 executions, 6423 successful
    rsg_test.go:758: 2m15s of 5m0s: 559288 executions, 6722 successful
    rsg_test.go:758: 2m20s of 5m0s: 580796 executions, 6961 successful
    rsg_test.go:758: 2m25s of 5m0s: 598153 executions, 7215 successful
    rsg_test.go:758: 2m30s of 5m0s: 618339 executions, 7460 successful
    rsg_test.go:758: 2m35s of 5m0s: 638167 executions, 7741 successful
    rsg_test.go:758: 2m40s of 5m0s: 655253 executions, 7981 successful
    rsg_test.go:758: 2m45s of 5m0s: 674757 executions, 8236 successful
    rsg_test.go:758: 2m50s of 5m0s: 692964 executions, 8481 successful
    rsg_test.go:758: 2m55s of 5m0s: 711212 executions, 8731 successful
    rsg_test.go:758: 3m0s of 5m0s: 723991 executions, 8928 successful
    rsg_test.go:758: 3m5s of 5m0s: 743670 executions, 9141 successful
    rsg_test.go:758: 3m10s of 5m0s: 764560 executions, 9366 successful
    rsg_test.go:758: 3m15s of 5m0s: 784103 executions, 9672 successful
    rsg_test.go:758: 3m20s of 5m0s: 802560 executions, 9966 successful
    rsg_test.go:758: 3m25s of 5m0s: 818369 executions, 10207 successful
    rsg_test.go:758: 3m30s of 5m0s: 837111 executions, 10485 successful
    rsg_test.go:758: 3m35s of 5m0s: 854700 executions, 10781 successful
    rsg_test.go:758: 3m40s of 5m0s: 871885 executions, 11095 successful
    rsg_test.go:758: 3m45s of 5m0s: 887756 executions, 11368 successful
    rsg_test.go:758: 3m50s of 5m0s: 905182 executions, 11662 successful
    rsg_test.go:758: 3m55s of 5m0s: 925126 executions, 12007 successful
    rsg_test.go:758: 4m0s of 5m0s: 945288 executions, 12373 successful
    rsg_test.go:758: 4m5s of 5m0s: 963617 executions, 12672 successful
    rsg_test.go:758: 4m10s of 5m0s: 984868 executions, 12940 successful
    rsg_test.go:758: 4m15s of 5m0s: 1006238 executions, 13204 successful
    rsg_test.go:758: 4m20s of 5m0s: 1024437 executions, 13511 successful
    rsg_test.go:758: 4m25s of 5m0s: 1041658 executions, 13815 successful
    rsg_test.go:758: 4m30s of 5m0s: 1061439 executions, 14161 successful
    rsg_test.go:758: 4m35s of 5m0s: 1081389 executions, 14516 successful
    rsg_test.go:758: 4m40s of 5m0s: 1099742 executions, 14794 successful
    rsg_test.go:758: 4m45s of 5m0s: 1117965 executions, 15073 successful
    rsg_test.go:758: 4m50s of 5m0s: 1136501 executions, 15388 successful
    rsg_test.go:758: 4m55s of 5m0s: 1155123 executions, 15656 successful
    rsg_test.go:794: 1175045 executions, 15878 successful
    rsg_test.go:802: cannot parse output of Format: sql="RESTORE SYSTEM USERS FROM ( PLACEHOLDER ) , 'string' , ( PLACEHOLDER ) , PLACEHOLDER", formattedSQL="RESTORE TABLE  FROM 'placeholder', 'string', 'placeholder', 'placeholder'": at or near "from": syntax error
    rsg_test.go:252: -- test log scope end --
test logs left over in: /go/src/github.com/cockroachdb/cockroach/artifacts/logTestRandomSyntaxGeneration1275926521
--- FAIL: TestRandomSyntaxGeneration (300.38s)
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-22.1 @ 26c05e15d3752f47a91592b5b870360c30c57dd5:

    rsg_test.go:758: 1m15s of 5m0s: 299203 executions, 3469 successful
    rsg_test.go:758: 1m20s of 5m0s: 318175 executions, 3657 successful
    rsg_test.go:758: 1m25s of 5m0s: 336292 executions, 3893 successful
    rsg_test.go:758: 1m30s of 5m0s: 357722 executions, 4170 successful
    rsg_test.go:758: 1m35s of 5m0s: 379329 executions, 4440 successful
    rsg_test.go:758: 1m40s of 5m0s: 399388 executions, 4660 successful
    rsg_test.go:758: 1m45s of 5m0s: 419042 executions, 4930 successful
    rsg_test.go:758: 1m50s of 5m0s: 439066 executions, 5205 successful
    rsg_test.go:758: 1m55s of 5m0s: 457280 executions, 5446 successful
    rsg_test.go:758: 2m0s of 5m0s: 474012 executions, 5696 successful
    rsg_test.go:758: 2m5s of 5m0s: 494015 executions, 5953 successful
    rsg_test.go:758: 2m10s of 5m0s: 510836 executions, 6192 successful
    rsg_test.go:758: 2m15s of 5m0s: 528073 executions, 6423 successful
    rsg_test.go:758: 2m20s of 5m0s: 546921 executions, 6639 successful
    rsg_test.go:758: 2m25s of 5m0s: 562734 executions, 6820 successful
    rsg_test.go:758: 2m30s of 5m0s: 581160 executions, 7086 successful
    rsg_test.go:758: 2m35s of 5m0s: 591939 executions, 7244 successful
    rsg_test.go:758: 2m40s of 5m0s: 607897 executions, 7487 successful
    rsg_test.go:758: 2m45s of 5m0s: 622415 executions, 7715 successful
    rsg_test.go:758: 2m50s of 5m0s: 639851 executions, 7938 successful
    rsg_test.go:758: 2m55s of 5m0s: 656438 executions, 8184 successful
    rsg_test.go:758: 3m0s of 5m0s: 674518 executions, 8365 successful
    rsg_test.go:758: 3m5s of 5m0s: 692440 executions, 8578 successful
    rsg_test.go:758: 3m10s of 5m0s: 711409 executions, 8839 successful
    rsg_test.go:758: 3m15s of 5m0s: 729713 executions, 9074 successful
    rsg_test.go:758: 3m20s of 5m0s: 745957 executions, 9337 successful
    rsg_test.go:758: 3m25s of 5m0s: 760373 executions, 9559 successful
    rsg_test.go:758: 3m30s of 5m0s: 777402 executions, 9824 successful
    rsg_test.go:758: 3m35s of 5m0s: 795198 executions, 10073 successful
    rsg_test.go:758: 3m40s of 5m0s: 808968 executions, 10280 successful
    rsg_test.go:758: 3m45s of 5m0s: 826215 executions, 10546 successful
    rsg_test.go:758: 3m50s of 5m0s: 838584 executions, 10757 successful
    rsg_test.go:758: 3m55s of 5m0s: 856185 executions, 11060 successful
    rsg_test.go:758: 4m0s of 5m0s: 871892 executions, 11324 successful
    rsg_test.go:758: 4m5s of 5m0s: 888769 executions, 11595 successful
    rsg_test.go:758: 4m10s of 5m0s: 905027 executions, 11848 successful
    rsg_test.go:758: 4m15s of 5m0s: 919693 executions, 12014 successful
    rsg_test.go:758: 4m20s of 5m0s: 934682 executions, 12192 successful
    rsg_test.go:758: 4m25s of 5m0s: 942716 executions, 12329 successful
    rsg_test.go:758: 4m30s of 5m0s: 953027 executions, 12502 successful
    rsg_test.go:758: 4m35s of 5m0s: 964862 executions, 12702 successful
    rsg_test.go:758: 4m40s of 5m0s: 976600 executions, 12885 successful
    rsg_test.go:758: 4m45s of 5m0s: 994043 executions, 13102 successful
    rsg_test.go:758: 4m50s of 5m0s: 1009949 executions, 13280 successful
    rsg_test.go:758: 4m55s of 5m0s: 1027804 executions, 13509 successful
    rsg_test.go:794: 1043084 executions, 13769 successful
    rsg_test.go:802: cannot parse output of Format: sql="RESTORE SYSTEM USERS FROM FAMILY IN INNER WITH TENANT = PLACEHOLDER", formattedSQL="RESTORE TABLE  FROM 'family' IN 'inner' WITH tenant = 'placeholder'": at or near "from": syntax error
    rsg_test.go:252: -- test log scope end --
test logs left over in: /go/src/github.com/cockroachdb/cockroach/artifacts/logTestRandomSyntaxGeneration2872735925
--- FAIL: TestRandomSyntaxGeneration (301.25s)
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-22.1 @ a6c3138c2ab50b466ae1cc40409aa6a3b403129d:

    rsg_test.go:818: 1m15s of 5m0s: 290103 executions, 3534 successful
    rsg_test.go:818: 1m20s of 5m0s: 308694 executions, 3750 successful
    rsg_test.go:818: 1m25s of 5m0s: 324195 executions, 3953 successful
    rsg_test.go:818: 1m30s of 5m0s: 341572 executions, 4190 successful
    rsg_test.go:818: 1m35s of 5m0s: 359905 executions, 4454 successful
    rsg_test.go:818: 1m40s of 5m0s: 376639 executions, 4721 successful
    rsg_test.go:818: 1m45s of 5m0s: 391988 executions, 4943 successful
    rsg_test.go:818: 1m50s of 5m0s: 405635 executions, 5135 successful
    rsg_test.go:818: 1m55s of 5m0s: 421972 executions, 5373 successful
    rsg_test.go:818: 2m0s of 5m0s: 438342 executions, 5632 successful
    rsg_test.go:818: 2m5s of 5m0s: 455929 executions, 5899 successful
    rsg_test.go:818: 2m10s of 5m0s: 472177 executions, 6153 successful
    rsg_test.go:818: 2m15s of 5m0s: 488795 executions, 6412 successful
    rsg_test.go:818: 2m20s of 5m0s: 503391 executions, 6629 successful
    rsg_test.go:818: 2m25s of 5m0s: 518441 executions, 6858 successful
    rsg_test.go:818: 2m30s of 5m0s: 532124 executions, 7064 successful
    rsg_test.go:818: 2m35s of 5m0s: 547597 executions, 7286 successful
    rsg_test.go:818: 2m40s of 5m0s: 561635 executions, 7473 successful
    rsg_test.go:818: 2m45s of 5m0s: 576828 executions, 7647 successful
    rsg_test.go:818: 2m50s of 5m0s: 594959 executions, 7887 successful
    rsg_test.go:818: 2m55s of 5m0s: 611659 executions, 8128 successful
    rsg_test.go:818: 3m0s of 5m0s: 625000 executions, 8338 successful
    rsg_test.go:818: 3m5s of 5m0s: 638790 executions, 8523 successful
    rsg_test.go:818: 3m10s of 5m0s: 650124 executions, 8695 successful
    rsg_test.go:818: 3m15s of 5m0s: 671491 executions, 8983 successful
    rsg_test.go:818: 3m20s of 5m0s: 691964 executions, 9293 successful
    rsg_test.go:818: 3m25s of 5m0s: 713138 executions, 9597 successful
    rsg_test.go:818: 3m30s of 5m0s: 733878 executions, 9862 successful
    rsg_test.go:818: 3m35s of 5m0s: 754286 executions, 10182 successful
    rsg_test.go:818: 3m40s of 5m0s: 774324 executions, 10483 successful
    rsg_test.go:818: 3m45s of 5m0s: 792181 executions, 10746 successful
    rsg_test.go:818: 3m50s of 5m0s: 813228 executions, 11024 successful
    rsg_test.go:818: 3m55s of 5m0s: 831952 executions, 11324 successful
    rsg_test.go:818: 4m0s of 5m0s: 850039 executions, 11548 successful
    rsg_test.go:818: 4m5s of 5m0s: 870820 executions, 11829 successful
    rsg_test.go:818: 4m10s of 5m0s: 890956 executions, 12149 successful
    rsg_test.go:818: 4m15s of 5m0s: 910655 executions, 12480 successful
    rsg_test.go:818: 4m20s of 5m0s: 929918 executions, 12767 successful
    rsg_test.go:818: 4m25s of 5m0s: 948285 executions, 13038 successful
    rsg_test.go:818: 4m30s of 5m0s: 966778 executions, 13354 successful
    rsg_test.go:818: 4m35s of 5m0s: 982181 executions, 13626 successful
    rsg_test.go:818: 4m40s of 5m0s: 1002075 executions, 13916 successful
    rsg_test.go:818: 4m45s of 5m0s: 1022909 executions, 14185 successful
    rsg_test.go:818: 4m50s of 5m0s: 1041864 executions, 14465 successful
    rsg_test.go:818: 4m55s of 5m0s: 1060014 executions, 14747 successful
    rsg_test.go:854: 1077785 executions, 15043 successful
    rsg_test.go:862: cannot parse output of Format: sql="EXPLAIN ANALYZE RESTORE SYSTEM USERS FROM PLACEHOLDER IN ( 'string' , 'string' )", formattedSQL="EXPLAIN ANALYZE RESTORE TABLE  FROM 'placeholder' IN ('string', 'string')": at or near "from": syntax error
    rsg_test.go:305: -- test log scope end --
test logs left over in: /go/src/github.com/cockroachdb/cockroach/artifacts/logTestRandomSyntaxGeneration143882990
--- FAIL: TestRandomSyntaxGeneration (301.23s)
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-22.1 @ 443dd822332bb6487c949efbd9a4b700693850d4:

    rsg_test.go:818: 1m15s of 5m0s: 300844 executions, 3431 successful
    rsg_test.go:818: 1m20s of 5m0s: 320520 executions, 3687 successful
    rsg_test.go:818: 1m25s of 5m0s: 339741 executions, 3922 successful
    rsg_test.go:818: 1m30s of 5m0s: 360684 executions, 4196 successful
    rsg_test.go:818: 1m35s of 5m0s: 381324 executions, 4459 successful
    rsg_test.go:818: 1m40s of 5m0s: 402345 executions, 4735 successful
    rsg_test.go:818: 1m45s of 5m0s: 423813 executions, 4965 successful
    rsg_test.go:818: 1m50s of 5m0s: 444783 executions, 5215 successful
    rsg_test.go:818: 1m55s of 5m0s: 465457 executions, 5483 successful
    rsg_test.go:818: 2m0s of 5m0s: 484830 executions, 5748 successful
    rsg_test.go:818: 2m5s of 5m0s: 504741 executions, 5998 successful
    rsg_test.go:818: 2m10s of 5m0s: 523371 executions, 6257 successful
    rsg_test.go:818: 2m15s of 5m0s: 538017 executions, 6484 successful
    rsg_test.go:818: 2m20s of 5m0s: 555333 executions, 6736 successful
    rsg_test.go:818: 2m25s of 5m0s: 572213 executions, 6965 successful
    rsg_test.go:818: 2m30s of 5m0s: 589723 executions, 7203 successful
    rsg_test.go:818: 2m35s of 5m0s: 608563 executions, 7424 successful
    rsg_test.go:818: 2m40s of 5m0s: 624510 executions, 7642 successful
    rsg_test.go:818: 2m45s of 5m0s: 642429 executions, 7862 successful
    rsg_test.go:818: 2m50s of 5m0s: 655352 executions, 8066 successful
    rsg_test.go:818: 2m55s of 5m0s: 677942 executions, 8389 successful
    rsg_test.go:818: 3m0s of 5m0s: 700130 executions, 8672 successful
    rsg_test.go:818: 3m5s of 5m0s: 720222 executions, 8998 successful
    rsg_test.go:818: 3m10s of 5m0s: 742314 executions, 9323 successful
    rsg_test.go:818: 3m15s of 5m0s: 764791 executions, 9654 successful
    rsg_test.go:818: 3m20s of 5m0s: 782126 executions, 9945 successful
    rsg_test.go:818: 3m25s of 5m0s: 802374 executions, 10255 successful
    rsg_test.go:818: 3m30s of 5m0s: 821160 executions, 10576 successful
    rsg_test.go:818: 3m35s of 5m0s: 840510 executions, 10865 successful
    rsg_test.go:818: 3m40s of 5m0s: 858713 executions, 11182 successful
    rsg_test.go:818: 3m45s of 5m0s: 879115 executions, 11446 successful
    rsg_test.go:818: 3m50s of 5m0s: 897300 executions, 11713 successful
    rsg_test.go:818: 3m55s of 5m0s: 917053 executions, 12034 successful
    rsg_test.go:818: 4m0s of 5m0s: 934798 executions, 12378 successful
    rsg_test.go:818: 4m5s of 5m0s: 953513 executions, 12674 successful
    rsg_test.go:818: 4m10s of 5m0s: 971301 executions, 12911 successful
    rsg_test.go:818: 4m15s of 5m0s: 989529 executions, 13163 successful
    rsg_test.go:818: 4m20s of 5m0s: 1006099 executions, 13448 successful
    rsg_test.go:818: 4m25s of 5m0s: 1026867 executions, 13744 successful
    rsg_test.go:818: 4m30s of 5m0s: 1046917 executions, 14018 successful
    rsg_test.go:818: 4m35s of 5m0s: 1065692 executions, 14349 successful
    rsg_test.go:818: 4m40s of 5m0s: 1086117 executions, 14659 successful
    rsg_test.go:818: 4m45s of 5m0s: 1103860 executions, 14973 successful
    rsg_test.go:818: 4m50s of 5m0s: 1123241 executions, 15301 successful
    rsg_test.go:818: 4m55s of 5m0s: 1138175 executions, 15583 successful
    rsg_test.go:854: 1155479 executions, 15828 successful
    rsg_test.go:862: cannot parse output of Format: sql="RESTORE SYSTEM USERS FROM PLACEHOLDER , ( RESTORE , 'string' , BETWEEN ) WITH INTO_DB = PLACEHOLDER", formattedSQL="RESTORE TABLE  FROM 'placeholder', ('restore', 'string', 'between') WITH into_db = 'placeholder'": at or near "from": syntax error
    rsg_test.go:305: -- test log scope end --
test logs left over in: /go/src/github.com/cockroachdb/cockroach/artifacts/logTestRandomSyntaxGeneration1591716541
--- FAIL: TestRandomSyntaxGeneration (301.37s)
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-22.1 @ a70cc0eed145522afbf1e9f0307fb5c554562050:

Random syntax error:

    rsg_test.go:845: Crash detected: server panic: statement exec timeout

Query:

        DROP TYPE FAMILY RESTRICT;
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-22.1 @ cfb3d385aa86893b262adbf797b27f011a6c6944:

Random syntax error:

    rsg_test.go:848: Crash detected: server panic: statement exec timeout

Query:

        DROP SCHEMA error;
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-22.1 @ 3f5627115601dcb7d5ecc125973bb0de5a715030:

Random syntax error:

    rsg_test.go:848: Crash detected: server panic: statement exec timeout

Query:

        DROP SCHEMA IF EXISTS ident RESTRICT;
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-22.1 @ afad258bd2690d6ff8b0b8636224775dabbd6d98:

Random syntax error:

    rsg_test.go:848: Crash detected: server panic: statement exec timeout

Query:

        DROP SCHEMA IF EXISTS ident . EXTENSION , ident . HIGH RESTRICT;
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-22.1 @ 9f6299c114406eda106217932235fc83ddc2006c:

Random syntax error:

    rsg_test.go:848: Crash detected: server panic: statement exec timeout

Query:

        DROP SCHEMA IF EXISTS BINARY , ident RESTRICT;
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-22.1 @ 7724a4387fe5163b4251daf13469db3eca598ef2:

Random syntax error:

    rsg_test.go:848: Crash detected: server panic: statement exec timeout

Query:

        DROP SCHEMA error;
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@rafiss rafiss closed this as completed Jul 6, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
branch-release-22.1 Used to mark GA and release blockers, technical advisories, and bugs for 22.1 C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
None yet
Development

No branches or pull requests

2 participants