cockroachdb / cockroachdb/cockroach

sql/tests: TestRandomSyntaxSchemaChangeColumn failed

Open
#173,856 0 comments 0 reactions 0 assignees View on GitHub
branch-release-25.2.23-rc C-test-failure O-robot release-blocker T-sql-foundations
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

sql/tests.TestRandomSyntaxSchemaChangeColumn [failed](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RandomSyntaxTestsBazel/21481096?buildTab=log) with [artifacts](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RandomSyntaxTestsBazel/21481096?buildTab=artifacts#/) on release-25.2.23-rc @ [bae624cb34196597859b8ce6d6e59069ac2a81d8](https://github.com/cockroachdb/cockroach/commits/bae624cb34196597859b8ce6d6e59069ac2a81d8):

```
rsg_test.go:113: Last executed (4): ALTER TABLE ident.ident1 ALTER ident ADD GENERATED_ALWAYS ALWAYS AS IDENTITY ( )
rsg_test.go:113: Last executed (5): ALTER TABLE ident.ident2 ALTER CREATEDB DROP IDENTITY IF EXISTS
rsg_test.go:113: Last executed (6): ALTER TABLE ident.ident3 DROP COLUMN IF EXISTS VALUES CASCADE
rsg_test.go:113: Last executed (7): ALTER TABLE ident.ident4 ALTER INTERVAL SET MAXVALUE + 422 error
rsg_test.go:113: Last executed (8): ALTER TABLE ident.ident5 NO INHERITS error
rsg_test.go:113: Last executed (9): ALTER TABLE ident.ident6 ALTER ident DROP IDENTITY IF EXISTS
rsg_test.go:113: Last executed (10): ALTER TABLE ident.ident7 ADD FOREIGN KEY ( CACHE , SETOF , IMPORT , PUBLICATION , MULTILINESTRINGM ) REFERENCES FAMILY . EXTRACT_DURATION ( RETURN , ident ) MATCH PARTIAL ON UPDATE SET NULL NOT VALID
rsg_test.go:113: Last executed (11): ALTER TABLE ident.ident0 INHERITS error
rsg_test.go:113: Last executed (12): ALTER TABLE ident.ident1 ALTER ISERROR ADD GENERATED_BY_DEFAULT BY DEFAULT AS IDENTITY
rsg_test.go:113: Last executed (13): ALTER TABLE ident.ident2 ALTER COLUMN WITHIN SET GENERATED_BY_DEFAULT BY DEFAULT
rsg_test.go:113: Last executed (14): ALTER TABLE ident.ident3 ADD COLUMN TEMPORARY POLYGON error ARRAY CREATE FAMILY
rsg_test.go:113: Last executed (15): ALTER TABLE ident.ident4 ALTER BIGINT DROP STORED
rsg_test.go:113: Last executed (16): ALTER TABLE ident.ident5 ALTER ident DROP IDENTITY IF EXISTS
rsg_test.go:113: Last executed (17): ALTER TABLE ident.ident6 VALIDATE CONSTRAINT SETTINGS
rsg_test.go:113: Last executed (18): ALTER TABLE ident.ident7 ALTER GREATEST ADD GENERATED_ALWAYS ALWAYS AS IDENTITY
rsg_test.go:113: Last executed (19): ALTER TABLE ident.ident0 ALTER REVISION_HISTORY SET GENERATED_ALWAYS ALWAYS
rsg_test.go:113: Last executed (20): ALTER TABLE ident.ident1 ADD IF NOT EXISTS ABSOLUTE INTERVAL YEAR ARRAY CREATE FAMILY CREATE FAMILY GENERATED_ALWAYS ALWAYS AS IDENTITY
rsg_test.go:113: Last executed (21): ALTER TABLE ident.ident2 ALTER OVER DROP ON UPDATE
rsg_test.go:113: Last executed (22): ALTER TABLE ident.ident3 DROP CONSTRAINT ident RESTRICT
rsg_test.go:113: Last executed (23): ALTER TABLE ident.ident4 ALTER ident ADD error
rsg_test.go:113: Last executed (24): ALTER TABLE ident.ident5 VALIDATE CONSTRAINT CANCEL
rsg_test.go:113: Last executed (25): ALTER TABLE ident.ident6 EXPERIMENTAL_AUDIT SET OFF
rsg_test.go:113: Last executed (26): ALTER TABLE ident.ident7 ALTER ident SET NOT NULL
rsg_test.go:113: Last executed (27): ALTER TABLE ident.ident0 DROP CONSTRAINT ENCRYPTED
rsg_test.go:113: Last executed (28): ALTER TABLE ident.ident1 ADD IF NOT EXISTS DECIMAL POINT error ARRAY [ -397 ] FAMILY MULTILINESTRINGM COLLATE ident FAMILY REAL
rsg_test.go:113: Last executed (29): ALTER TABLE ident.ident2 RENAME CONSTRAINT WORK TO ident
rsg_test.go:113: Last executed (30): ALTER TABLE ident.ident3 ADD COLUMN AT @ -28 ARRAY [ 194 ]
rsg_test.go:113: Last executed (31): ALTER TABLE ident.ident4 ADD COLUMN SKIP_MISSING_UDFS INTERVAL ( 409 ) ARRAY [ 153 ] [ error CREATE FAMILY CREATE FAMILY ident
rsg_test.go:113: Last executed (32): ALTER TABLE ident.ident5 ALTER COLUMN EXTRACT_DURATION SET VISIBLE
rsg_test.go:113: Last executed (33): ALTER TABLE ident.ident6 ALTER TIMETZ ADD GENERATED_BY_DEFAULT BY DEFAULT AS IDENTITY ( )
rsg_test.go:113: Last executed (34): ALTER TABLE ident.ident7 INHERITS error
rsg_test.go:113: Last executed (35): ALTER TABLE ident.ident0 NO FORCE ROW LEVEL SECURITY
rsg_test.go:113: Last executed (36): ALTER TABLE ident.ident1 ALTER COLUMN TRIGGERS SET GENERATED_ALWAYS ALWAYS
rsg_test.go:113: Last executed (37): ALTER TABLE ident.ident3 RENAME CONSTRAINT FORCE_INVERTED_INDEX TO NUMERIC
rsg_test.go:113: Last executed (38): ALTER TABLE ident.ident2 NO INHERITS error
rsg_test.go:113: Last executed (39): ALTER TABLE ident.ident4 RENAME CONSTRAINT LOGIN TO ADD
rsg_test.go:113: Last executed (40): ALTER TABLE ident.ident5 ALTER COALESCE DROP NOT NULL
rsg_test.go:113: Last executed (41): ALTER TABLE ident.ident6 DISABLE ROW LEVEL SECURITY
rsg_test.go:113: Last executed (42): ALTER TABLE ident.ident7 ADD CONSTRAINT ident FOREIGN KEY ( ident , GEOMETRYCOLLECTIONZ , ident ) REFERENCES INDEX_AFTER_ORDER_BY_BEFORE_AT ( PRECISION ) MATCH SIMPLE ON UPDATE SET DEFAULT DEFERRABLE INITIALLY DEFERRED
rsg_test.go:113: Last executed (43): ALTER TABLE ident.ident0 INJECT STATISTICS DEFAULT
rsg_test.go:113: Last executed (44): ALTER TABLE ident.ident1 INHERITS error
rsg_test.go:113: Last executed (45): ALTER TABLE ident.ident2 EXPERIMENTAL_AUDIT SET READ WRITE
rsg_test.go:113: Last executed (46): ALTER TABLE ident.ident3 ALTER COLUMN SETOF DROP NOT NULL
rsg_test.go:113: Last executed (47): ALTER TABLE ident.ident4 RENAME CONSTRAINT ident TO TRIM
rsg_test.go:113: Last executed (48): ALTER TABLE ident.ident5 ADD COLUMN IF NOT EXISTS EXTERNAL INTERVAL ( 51 ) ARRAY
rsg_test.go:113: Last executed (49): ALTER TABLE ident.ident6 PARTITION ALL BY NOTHING
rsg_test.go:116: Currently active statements: map[]
rsg_test.go:593: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxSchemaChangeColumn3748016544
--- FAIL: TestRandomSyntaxSchemaChangeColumn (301.88s)
```
Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

/cc @cockroachlabs/sql-foundations

[This test on roachdash](https://roachdash.crdb.dev/?filter=status:open%20t:.*TestRandomSyntaxSchemaChangeColumn.*&sort=title+created&display=lastcommented+project) | [Improve this report!](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/bazci/githubpost/issues)

Contributor guide

Open the contributing guide

Research direction

Start with the linked TeamCity build and its artifacts, then inspect pkg/sql/tests/rsg_test.go around lines 113 and 593 for how TestRandomSyntaxSchemaChangeColumn reports failures. Reproduce the failure using the recorded release commit and test logs, identify the underlying cause, and consider the issue done when the test passes without leaving test logs behind.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, sql
Domain
databases, testing-qa
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Active
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.