docs/en/operations/system-tables/error_log.md
import SystemTableCloud from '@site/docs/_snippets/_system_table_cloud.md';
Contains history of error values from table system.errors, periodically flushed to disk.
Columns:
hostname (LowCardinality(String)) — Hostname of the server executing the query.event_date (Date) — Event date.event_time (DateTime) — Event time.code (Int32) — Code number of the error.error (LowCardinality(String)) - Name of the error.value (UInt64) — The number of times this error happened.remote (UInt8) — Remote exception (i.e. received during one of the distributed queries).last_error_time (DateTime) — The time when the last error happened.last_error_message (String) — Message for the last error.last_error_query_id (String) — Id of a query that caused the last error (if available).last_error_trace (Array(UInt64)) — A stack trace that represents a list of physical addresses where the called methods are stored.Example
SELECT * FROM system.error_log LIMIT 1 FORMAT Vertical;
Row 1:
──────
hostname: clickhouse.testing.internal
event_date: 2025-11-11
event_time: 2025-11-11 11:35:28
code: 60
error: UNKNOWN_TABLE
value: 1
remote: 0
last_error_time: 2025-11-11 11:35:28
last_error_message: Unknown table expression identifier 'system.table_not_exist' in scope SELECT * FROM system.table_not_exist
last_error_query_id: 77ad9ece-3db7-4236-9b5a-f789bce4aa2e
last_error_trace: [100506790044914,100506534488542,100506409937998,100506409936517,100506425182891,100506618154123,100506617994473,100506617990486,100506617988112,100506618341386,100506630272160,100506630266232,100506630276900,100506629795243,100506633519500,100506633495783,100506692143858,100506692248921,100506790779783,100506790781278,100506790390399,100506790380047,123814948752036,123814949330028]
See also