v.24.7New Feature

Add system.error_log for error history from system.errors

Official CH changelog text
Add system.error_log which contains history of error values from table system.errors, periodically flushed to disk. #65381 (Pablo Marcos).
Added a new system table system.error_log that stores a historical record of error values from system.errors, with data being periodically flushed to disk.

Why it matters

This feature provides persistent and historical tracking of errors encountered by the ClickHouse server, enabling users to analyze error trends over time and improve diagnostics and monitoring beyond the ephemeral in-memory error counters.

How to use it

Users can query the system.error_log table just like other system tables to review historical error data. The error data is automatically flushed to disk at regular intervals, requiring no additional configuration to start collecting error history.

Related resources

PreviousNext