ClickHouse Error Codes

Numeric server error codes returned by ClickHouse. Each code has a symbolic name (e.g. BAD_ARGUMENTS, UNKNOWN_TABLE) and is surfaced in error messages and system tables.

72 codes

• ACCESS_DENIED Access denied
• AMBIGUOUS_COLUMN_NAME Ambiguous column name
• BAD_ARGUMENTS Bad arguments
• CANNOT_COMPRESS Cannot compress
• CANNOT_CONNECT_TO_ZOOKEEPER Cannot connect to ZooKeeper
• CANNOT_DECOMPRESS Cannot decompress
• CANNOT_OPEN_FILE Cannot open file
• CANNOT_PARSE_DATE Cannot parse date
• CANNOT_PARSE_DATETIME Cannot parse datetime
• CANNOT_PARSE_NUMBER Cannot parse number
• CANNOT_PARSE_TEXT Cannot parse text
• CANNOT_READ_ALL_DATA Cannot read all data
• CANNOT_WRITE_TO_FILE_DESCRIPTOR Cannot write to file descriptor
• CHECKSUM_DOESNT_MATCH Checksum doesn't match
• COLUMN_SPECIFIED_MORE_THAN_ONCE Column specified more than once
• DATABASE_ALREADY_EXISTS Database already exists
• DISTRIBUTED_CONNECTION_FAILURE Distributed connection failure
• DUPLICATE_COLUMN Duplicate column
• ILLEGAL_COLUMN Illegal column
• ILLEGAL_TYPE_OF_ARGUMENT Illegal type of argument
• INTERSERVER_SCHEME_DOESNT_MATCH Interserver scheme doesn't match
• LIMIT_EXCEEDED Limit exceeded
• LOGICAL_ERROR Logical error
• MEMORY_LIMIT_EXCEEDED Memory limit exceeded
• NETWORK_ERROR Network error
• NO_REPLICA_HAS_PART No replica has part
• NO_SUCH_COLUMN_IN_TABLE No such column in table
• NO_ZOOKEEPER No ZooKeeper
• NOT_ENOUGH_SPACE Not enough space
• NOT_IMPLEMENTED Not implemented
• NUMBER_OF_ARGUMENTS_DOESNT_MATCH Number of arguments doesn't match
• NUMBER_OF_COLUMNS_DOESNT_MATCH Number of columns doesn't match
• PART_IS_TEMPORARILY_LOCKED Part is temporarily locked
• POCO_EXCEPTION Poco exception
• QUERY_IS_TOO_LARGE Query is too large
• QUERY_WAS_CANCELLED Query was cancelled
• READONLY Readonly
• REPLICA_IS_ALREADY_ACTIVE Replica is already active
• REPLICA_IS_NOT_IN_QUORUM Replica is not in quorum
• REQUIRED_PASSWORD Required password
• SOCKET_TIMEOUT Socket timeout
• STD_EXCEPTION Std exception
• SYNTAX_ERROR Syntax error
• TABLE_ALREADY_EXISTS Table already exists
• TABLE_IS_DROPPED Table is dropped
• TABLE_SIZE_EXCEEDS_MAX_DROP_SIZE_LIMIT Table size exceeds max drop size limit
• THERE_IS_NO_COLUMN There is no column
• TIMEOUT_EXCEEDED Timeout exceeded
• TOO_DEEP_RECURSION Too deep recursion
• TOO_LARGE_SIZE_COMPRESSED Too large size compressed
• TOO_MANY_PARTS Too many parts
• TOO_MANY_SIMULTANEOUS_QUERIES Too many simultaneous queries
• TOO_SLOW Too slow
• TYPE_MISMATCH Type mismatch
• UNEXPECTED_END_OF_FILE Unexpected end of file
• UNEXPECTED_PACKET_FROM_CLIENT Unexpected packet from client
• UNEXPECTED_PACKET_FROM_SERVER Unexpected packet from server
• UNKNOWN_COLUMN Unknown column
• UNKNOWN_COMPRESSION_METHOD Unknown compression method
• UNKNOWN_DATABASE Unknown database
• UNKNOWN_EXCEPTION Unknown exception
• UNKNOWN_FUNCTION Unknown function
• UNKNOWN_IDENTIFIER Unknown identifier
• UNKNOWN_SETTING Unknown setting
• UNKNOWN_TABLE Unknown table
• UNKNOWN_TYPE Unknown type
• UNKNOWN_USER Unknown user
• UNSUPPORTED_METHOD Unsupported method
• UNSUPPORTED_PARAMETER Unsupported parameter
• VALUE_IS_OUT_OF_RANGE_OF_DATA_TYPE Value is out of range of data type
• WRONG_PASSWORD Wrong password
• ZOOKEEPER_SESSION_EXPIRED ZooKeeper session expired