Open
Description
This task updates the CHECK job to persist validation errors in the system.check_errors system table. In #148299, detected errors were only written to the cockroach.log. This change moves error recording into the structured system table to support inspection via SHOW CHECK ERRORS.
Details
- Modify the integrity check processor to construct and insert rows into system.check_errors for each inconsistency found.
- Each row should include all relevant fields: job_id, error_type, object ID(s), and detailed context (e.g., stringified primary key, details JSON).
- This task enables proper integration with the SHOW CHECK ERRORS command and sets the foundation for job-based tracking and observability.
Jira issue: CRDB-51525
Epic CRDB-30356