system.errors 

Contains error codes with number of times they have been triggered.

Columns:

  • name (String) — name of the error (errorCodeToName).
  • code (Int32) — code number of the error.
  • value (UInt64) - number of times this error has been happened.

Example

SELECT *
FROM system.errors
WHERE value > 0
ORDER BY code ASC
LIMIT 1

┌─name─────────────┬─code─┬─value─┐
 CANNOT_OPEN_FILE    76      1 
└──────────────────┴──────┴───────┘

Rating: 4 - 1 votes

Was this content helpful?
★★★★☆