cockroachdb / cockroachdb/cockroach

Expose crdb_internal.invalid_objects inside the console UI

Open
#107,568 1 comment 0 reactions 0 assignees View on GitHub
C-enhancement T-observability ui-design-needed
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

**Is your feature request related to a problem? Please describe.**
Clusters can potentially have descriptor corruption because of schema changer bugs, which can lead to upgrade issues
or inaccessible tables. Fortunately Cockroach DB has builtin diagnostics for these using the crdb_internal.invalid_objects table.

**Describe the solution you'd like**
We should periodically have the console scan crdb_internal.invalid_objects and have some type of notification for
database administration when descriptor issues are addressed. This will allow for administrators to be aware of
any potential upgrade issues earlier.

**Describe alternatives you've considered**

**Additional context**
This is important also in reference to a recent TA: https://www.cockroachlabs.com/docs/advisories/a99561 where this CRDB internal table now reports this problem

Jira issue: CRDB-30112

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.