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: TestRandomSyntaxSchemaChangeColumn failed #114480

Closed
cockroach-teamcity opened this issue Nov 15, 2023 · 0 comments · Fixed by #114550
Closed

sql/tests: TestRandomSyntaxSchemaChangeColumn failed #114480

cockroach-teamcity opened this issue Nov 15, 2023 · 0 comments · Fixed by #114550
Assignees
Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. O-rsg Random Syntax Generator T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Milestone

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Nov 15, 2023

sql/tests.TestRandomSyntaxSchemaChangeColumn failed with artifacts on master @ 7f96bac8ce44a128b1f98f5462369a9910c802e5:

    rsg_test.go:884: 2m0s of 5m0s: 46390 executions, 7363 successful
    rsg_test.go:884: 2m5s of 5m0s: 47603 executions, 7583 successful
    rsg_test.go:884: 2m10s of 5m0s: 48795 executions, 7776 successful
    rsg_test.go:884: 2m15s of 5m0s: 50185 executions, 8008 successful
    rsg_test.go:884: 2m20s of 5m0s: 51349 executions, 8208 successful
    rsg_test.go:884: 2m25s of 5m0s: 52823 executions, 8439 successful
    rsg_test.go:884: 2m30s of 5m0s: 54102 executions, 8648 successful
    rsg_test.go:884: 2m35s of 5m0s: 55283 executions, 8851 successful
    rsg_test.go:884: 2m40s of 5m0s: 56550 executions, 9050 successful
    rsg_test.go:884: 2m45s of 5m0s: 58141 executions, 9298 successful
    rsg_test.go:884: 2m50s of 5m0s: 59556 executions, 9507 successful
    rsg_test.go:884: 2m55s of 5m0s: 60918 executions, 9774 successful
    rsg_test.go:884: 3m0s of 5m0s: 61765 executions, 9951 successful
    rsg_test.go:884: 3m5s of 5m0s: 63123 executions, 10192 successful
    rsg_test.go:884: 3m10s of 5m0s: 64395 executions, 10414 successful
    rsg_test.go:884: 3m15s of 5m0s: 65860 executions, 10658 successful
    rsg_test.go:884: 3m20s of 5m0s: 66541 executions, 10769 successful
    rsg_test.go:884: 3m25s of 5m0s: 67885 executions, 10982 successful
    rsg_test.go:884: 3m30s of 5m0s: 68931 executions, 11166 successful
    rsg_test.go:884: 3m35s of 5m0s: 70174 executions, 11341 successful
    rsg_test.go:884: 3m40s of 5m0s: 71171 executions, 11514 successful
    rsg_test.go:884: 3m45s of 5m0s: 72116 executions, 11674 successful
    rsg_test.go:884: 3m50s of 5m0s: 73209 executions, 11833 successful
    rsg_test.go:884: 3m55s of 5m0s: 73971 executions, 11967 successful
    rsg_test.go:884: 4m0s of 5m0s: 74996 executions, 12140 successful
    rsg_test.go:884: 4m5s of 5m0s: 75977 executions, 12303 successful
    rsg_test.go:884: 4m10s of 5m0s: 77081 executions, 12464 successful
    rsg_test.go:884: 4m15s of 5m0s: 78068 executions, 12623 successful
    rsg_test.go:884: 4m20s of 5m0s: 79286 executions, 12810 successful
    rsg_test.go:884: 4m25s of 5m0s: 80161 executions, 12948 successful
    rsg_test.go:884: 4m30s of 5m0s: 80904 executions, 13065 successful
    rsg_test.go:884: 4m35s of 5m0s: 81957 executions, 13223 successful
    rsg_test.go:884: 4m40s of 5m0s: 82524 executions, 13319 successful
    rsg_test.go:884: 4m45s of 5m0s: 83339 executions, 13449 successful
    rsg_test.go:884: 4m50s of 5m0s: 84018 executions, 13557 successful
    rsg_test.go:884: 4m55s of 5m0s: 84422 executions, 13630 successful
    rsg_test.go:211: Context cancelled while executing: "ALTER TABLE ident.ident2 DROP IF EXISTS ident RESTRICT"
    rsg_test.go:211: Context cancelled while executing: "ALTER TABLE ident.ident2 DROP DECIMAL CASCADE"
    rsg_test.go:211: Context cancelled while executing: "ALTER TABLE ident.ident0 ALTER ident SET VISIBLE"
    rsg_test.go:211: Context cancelled while executing: "ALTER TABLE ident.ident3 ADD IF NOT EXISTS ROWS SMALLINT ARRAY"
    rsg_test.go:211: Context cancelled while executing: "ALTER TABLE ident.ident2 ALTER CHARACTER SET VISIBLE"
    rsg_test.go:211: Context cancelled while executing: "ALTER TABLE ident.ident6 RENAME SYNTAX TO NO"
    rsg_test.go:211: Context cancelled while executing: "ALTER TABLE ident.ident2 ADD COLUMN IF NOT EXISTS VIRTUAL INTERVAL ARRAY [ 268 ]"
    rsg_test.go:211: Context cancelled while executing: "ALTER TABLE ident.ident7 ADD COLUMN OUT INTEGER CONSTRAINT ident UNIQUE"
    rsg_test.go:884: 5m0s of 5m0s: 84932 executions, 13727 successful
    rsg_test.go:920: 84938 executions, 13733 successful
    rsg_test.go:928: cannot parse output of Format: sql="ALTER TABLE ident.ident7 ALTER TENANT_NAME SET ON UPDATE PLACEHOLDER IS NOT DISTINCT FROM FALSE", formattedSQL="ALTER TABLE ident.ident7 ALTER COLUMN tenant_name SET ON UPDATE placeholder IS false": at or near "false": syntax error
    rsg_test.go:539: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxSchemaChangeColumn4243554364
--- FAIL: TestRandomSyntaxSchemaChangeColumn (303.51s)
Help

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

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-33527

@cockroach-teamcity cockroach-teamcity added branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) labels Nov 15, 2023
@cockroach-teamcity cockroach-teamcity added this to the 24.1 milestone Nov 15, 2023
@rafiss rafiss added O-rsg Random Syntax Generator and removed release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. labels Nov 15, 2023
@rafiss rafiss self-assigned this Nov 16, 2023
@craig craig bot closed this as completed in f47f05c Nov 16, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. O-rsg Random Syntax Generator T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
No open projects
Archived in project
Development

Successfully merging a pull request may close this issue.

2 participants