system.error_log
Querying in ClickHouse Cloud
The data in this system table is held locally on each node in ClickHouse Cloud. Obtaining a complete view of all data, therefore, requires the clusterAllReplicas function. See here for further details.
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.last_error_time(DateTime) — The time when the last error happened.last_error_message(String) — Message for the last 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_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.last_error_symbols(Array(LowCardinality(String))), If the symbolization is enabled, contains demangled symbol names, corresponding to thelast_error_trace.last_error_lines(Array(LowCardinality(String))), If the symbolization is enabled, contains strings with file names with line numbers, corresponding to thelast_error_trace.
The symbolization can be enabled or disabled in the symbolize under error_log in the server's configuration file.
Example
See also
- error_log setting — Enabling and disabling the setting.
- system.errors — Contains error codes with the number of times they have been triggered.
- Monitoring — Base concepts of ClickHouse monitoring.
