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

Syed Shamim (rafiss) commented:

Related PR: [https://github.com/cockroachdb/cockroach/pull/108559](https://github.com/cockroachdb/cockroach/pull/108559)

Commit: [https://github.com/cockroachdb/cockroach/commit/f6af97a21661502a680f455541f35f0385b6e6c2](https://github.com/cockroachdb/cockroach/commit/f6af97a21661502a680f455541f35f0385b6e6c2)

Fixes: [https://github.com/cockroachdb/cockroach/issues/104266](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