PR #108559 - schematelemetry: emit metrics and logs about invalid objects

[exalate-issue-sync[bot]]

Syed Shamim (rafiss) commented:

Related PR: https://github.com/cockroachdb/cockroach/pull/108559

Commit: https://github.com/cockroachdb/cockroach/commit/f6af97a21661502a680f455541f35f0385b6e6c2

Fixes: https://github.com/cockroachdb/cockroach/issues/104266

---

Release note (ops change): Added a new {{sql.schema.invalid_objects}} gauge metric. This gauge is periodically updated based on the schedule set by the {{sql.schema.telemetry.recurrence}} cluster setting. When it is updated, it counts the number of schema objects (tables, types, schemas, databases, and functions) that are in an invalid state according to CockroachDB’s internal validation checks. This metric is expected to be zero in a healthy cluster, and if it is not, it indicates that there is a problem that must be repaired.

Jira Issue: DOC-8710