roachtest: schemachange/random-load failed [found invalid objects]

[cockroach-teamcity]

roachtest.schemachange/random-load failed with artifacts on master @ 6806299943a595425030f0ad3c54ccc680c89842:

(schemachange_random_load.go:86).func1: found 2 invalid objects
test artifacts and logs in: /artifacts/schemachange/random-load/run_1

Parameters:

• arch=amd64
• cloud=gce
• coverageBuild=false
• cpu=4
• encrypted=false
• fs=ext4
• localSSD=true
• metamorphicLeases=default
• runtimeAssertionsBuild=false
• ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-50565

[Dedej-Bergin]

Next steps: Find out what these descriptors were by looking through the CRDB logs (unredacted sql.schemalogs) and see why they weren't deleted when we dropped the database.

2025/05/11 13:07:54 schemachange_random_load.go:143: test status: performing validation after workload
2025/05/11 13:07:54 schemachange_random_load.go:145: test status: dropping database
2025/05/11 13:08:59 schemachange_random_load.go:150: test status: performing validation after dropping database
2025/05/11 13:08:59 schemachange_random_load.go:77: invalid object found: id: 381, database_name: , schema_name: , obj_name: , error: comment exists for non-existent descriptor 381
2025/05/11 13:08:59 schemachange_random_load.go:77: invalid object found: id: 623, database_name: , schema_name: , obj_name: , error: comment exists for non-existent descriptor 623

Notes: Seem to be type descriptors, look at cleanup logic for comment on type. There is a legacy drop and there is no cleanup for comments on types.

[cockroach-teamcity]

roachtest.schemachange/random-load failed with artifacts on master @ f903e26dff81dacc1e67662cfa9652b49d82a9c2:

(schemachange_random_load.go:86).func1: found 1 invalid objects
test artifacts and logs in: /artifacts/schemachange/random-load/run_1

Parameters:

• arch=amd64
• cloud=gce
• coverageBuild=false
• cpu=4
• encrypted=false
• metamorphicLeases=epoch
• runtimeAssertionsBuild=false
• ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!