v.21.4Improvements

Add last_error_time, last_error_message, last_error_stacktrace, and remote columns to system.errors

Add last_error_time/last_error_message/last_error_stacktrace/remote columns for system.errors. #21529 (Azat Khuzhin).
Adds last_error_time, last_error_message, last_error_stacktrace, and remote columns to the system.errors table.

Why it matters

This feature enhances error diagnostics by providing detailed information about the most recent errors, including their timestamps, messages, stack traces, and the remote host involved, enabling users to more effectively monitor and troubleshoot ClickHouse issues.

How to use it

Users can query the system.errors table to retrieve the new columns:

SELECT last_error_time, last_error_message, last_error_stacktrace, remote FROM system.errors


No additional configuration is required to enable this feature.