cockroachdb / cockroachdb/cockroach

sql/tests: TestRandomSyntaxSchemaChangeColumn failed

Open
#174,677 0 comments 0 reactions 0 assignees View on GitHub
branch-release-25.2.24-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/21499463?buildTab=log) with [artifacts](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RandomSyntaxTestsBazel/21499463?buildTab=artifacts#/) on release-25.2.24-rc @ [92c7311721160180bed1228023264f6df947fc1e](https://github.com/cockroachdb/cockroach/commits/92c7311721160180bed1228023264f6df947fc1e):

```
rsg_test.go:113: Last executed (4): ALTER TABLE ident.ident5 DROP COLUMN IF EXISTS VECTOR
rsg_test.go:113: Last executed (5): ALTER TABLE ident.ident6 RENAME CONSTRAINT ident TO ident
rsg_test.go:113: Last executed (6): ALTER TABLE ident.ident7 ALTER COLUMN EXTRACT DROP NOT NULL
rsg_test.go:113: Last executed (7): ALTER TABLE ident.ident0 ADD ident GEOMETRY [ 291 ] [ error
rsg_test.go:113: Last executed (8): ALTER TABLE ident.ident1 ALTER PRECISION ADD GENERATED_BY_DEFAULT BY DEFAULT AS IDENTITY ( )
rsg_test.go:113: Last executed (9): ALTER TABLE ident.ident2 ALTER COLUMN ident DROP STORED
rsg_test.go:113: Last executed (10): ALTER TABLE ident.ident3 ALTER COLUMN STRING DROP IDENTITY IF EXISTS
rsg_test.go:113: Last executed (11): ALTER TABLE ident.ident4 ALTER FLOAT SET GENERATED_ALWAYS ALWAYS
rsg_test.go:113: Last executed (12): ALTER TABLE ident.ident5 ALTER COLUMN LANGUAGE DROP NOT NULL
rsg_test.go:113: Last executed (13): ALTER TABLE ident.ident6 ALTER BIGINT SET NOT NULL
rsg_test.go:113: Last executed (14): ALTER TABLE ident.ident7 ALTER NUMERIC SET NOT VISIBLE
rsg_test.go:113: Last executed (15): ALTER TABLE ident.ident0 ADD COLUMN ident POINT error ARRAY CREATE FAMILY
rsg_test.go:113: Last executed (16): ALTER TABLE ident.ident1 ADD CONSTRAINT IF NOT EXISTS VIEW PRIMARY KEY ( OUT ident DESC ) USING HASH NOT VALID
rsg_test.go:113: Last executed (17): ALTER TABLE ident.ident2 ALTER COLUMN UNSAFE_RESTORE_INCOMPATIBLE_VERSION ADD GENERATED_ALWAYS ALWAYS AS IDENTITY
rsg_test.go:113: Last executed (18): ALTER TABLE ident.ident3 ADD IF NOT EXISTS OPTION INTERVAL [ ]
rsg_test.go:113: Last executed (19): ALTER TABLE ident.ident4 ALTER LOOKUP SET GENERATED_BY_DEFAULT BY DEFAULT
rsg_test.go:113: Last executed (20): ALTER TABLE ident.ident5 DROP CONSTRAINT IF EXISTS INT RESTRICT
rsg_test.go:113: Last executed (21): ALTER TABLE ident.ident6 ALTER COLUMN ident SET NOT NULL
rsg_test.go:113: Last executed (22): ALTER TABLE ident.ident0 DROP CONSTRAINT RANGES CASCADE
rsg_test.go:113: Last executed (23): ALTER TABLE ident.ident7 INHERITS error
rsg_test.go:113: Last executed (24): ALTER TABLE ident.ident1 RENAME COLUMN ident TO MULTIPOINTM
rsg_test.go:113: Last executed (25): ALTER TABLE ident.ident2 RENAME COLUMN MULTIPOLYGONZM TO ident
rsg_test.go:113: Last executed (26): ALTER TABLE ident.ident3 DROP CONSTRAINT IF EXISTS ident RESTRICT
rsg_test.go:113: Last executed (27): ALTER TABLE ident.ident5 ALTER COLUMN OVERLAY DROP NOT NULL
rsg_test.go:113: Last executed (28): ALTER TABLE ident.ident4 ALTER INVISIBLE ADD error
rsg_test.go:113: Last executed (29): ALTER TABLE ident.ident6 ALTER IFERROR ADD GENERATED_BY_DEFAULT BY DEFAULT AS IDENTITY ( PER NODE CACHE -200 NO MINVALUE )
rsg_test.go:113: Last executed (30): ALTER TABLE ident.ident7 ALTER ident ADD error
rsg_test.go:113: Last executed (31): ALTER TABLE ident.ident0 DROP CONSTRAINT IF EXISTS BOOLEAN
rsg_test.go:113: Last executed (32): ALTER TABLE ident.ident1 NO INHERITS error
rsg_test.go:113: Last executed (33): ALTER TABLE ident.ident2 RESET ( 'string' , 'string' , NOTHING , ident )
rsg_test.go:113: Last executed (34): ALTER TABLE ident.ident3 ADD IF NOT EXISTS TIME BIT ( -441 ) ARRAY
rsg_test.go:113: Last executed (35): ALTER TABLE ident.ident4 ALTER ident SET GENERATED_BY_DEFAULT BY DEFAULT
rsg_test.go:113: Last executed (36): ALTER TABLE ident.ident5 RENAME CONSTRAINT ident TO VALUES
rsg_test.go:113: Last executed (37): ALTER TABLE ident.ident6 ALTER ISERROR DROP NOT NULL
rsg_test.go:113: Last executed (38): ALTER TABLE ident.ident7 DROP CONSTRAINT ident CASCADE
rsg_test.go:113: Last executed (39): ALTER TABLE ident.ident0 EXPERIMENTAL_AUDIT SET OFF
rsg_test.go:113: Last executed (40): ALTER TABLE ident.ident1 ALTER CONSTRAINT JOBS error
rsg_test.go:113: Last executed (41): ALTER TABLE ident.ident2 ALTER COLUMN DEC ADD GENERATED_BY_DEFAULT BY DEFAULT AS IDENTITY
rsg_test.go:113: Last executed (42): ALTER TABLE ident.ident3 ALTER COLUMN GROUPING DROP STORED
rsg_test.go:113: Last executed (43): ALTER TABLE ident.ident4 ALTER PARTIAL SET NOT VISIBLE
rsg_test.go:113: Last executed (44): ALTER TABLE ident.ident5 ALTER COLUMN VALUES ADD GENERATED_BY_DEFAULT BY DEFAULT AS IDENTITY ( START WITH 443 )
rsg_test.go:113: Last executed (45): ALTER TABLE ident.ident6 ADD ident OFF . ident ARRAY
rsg_test.go:113: Last executed (46): ALTER TABLE ident.ident7 DROP COLUMN IF EXISTS IGNORE_FOREIGN_KEYS RESTRICT
rsg_test.go:113: Last executed (47): ALTER TABLE ident.ident0 EXPERIMENTAL_AUDIT SET READ WRITE
rsg_test.go:113: Last executed (48): ALTER TABLE ident.ident1 ALTER THROTTLING ADD GENERATED_ALWAYS ALWAYS AS IDENTITY ( )
rsg_test.go:113: Last executed (49): ALTER TABLE ident.ident2 ALTER INTERVAL SET INCREMENT -259
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/logTestRandomSyntaxSchemaChangeColumn3613286674
--- FAIL: TestRandomSyntaxSchemaChangeColumn (303.58s)
```
Help

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

Same failure on other branches

- #173856 sql/tests: TestRandomSyntaxSchemaChangeColumn failed [C-test-failure O-robot T-sql-foundations branch-release-25.2.23-rc release-blocker]

/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 by running TestRandomSyntaxSchemaChangeColumn in sql/tests and inspect rsg_test.go around the reported lines 113 and 593. Review the linked TeamCity logs and artifacts, the internal Go test failure investigation guide, and related issue #173856. Done means the reported failure is understood and the test passes on the affected branch.

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.