This section provides a comprehensive reference for error messages encountered when interacting with MariaDB through its API, aiding in program development and troubleshooting.
NOTE: Error codes from 4195 on have been shifted!
MariaDB shares error codes with MySQL, as well as adding a number of new error codes specific to MariaDB.
An example of an error code is as follows:
SELECT * FROM x;
ERROR 1046 (3D000): No database selectedThere are three pieces of information returned in an error:
A numeric error code, in this case 1046. Error codes from 1900 and up are specific to MariaDB, while error codes from 1000 to 1800 are shared by MySQL and MariaDB.
An SQLSTATE value, consisting of five characters, in this case 3D000. These codes are standard to ODBC and ANSI SQL. When MariaDB cannot allocate a standard SQLSTATE code, a generic HY000, or general error, is used.
A string describing the error, in this case No database selected.
New error codes are being continually being added as new features are added. For a definitive list, see the file sql/share/errmsg-utf8.txt, as well as include/mysqld_error.h in the build directory, generated by the comp_err tool. Also, the perror tool can be used to get the error message which is associated with a given error code.
HY000
ER_OUT_OF_RESOURCES
Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
42000
ER_BLOB_USED_AS_KEY
BLOB column '%s' can't be used in key specification with the used table type
42000
ER_TOO_BIG_FIELDLENGTH
Column length too big for column '%s' (max = %lu); use BLOB or TEXT instead
42000
ER_WRONG_AUTO_KEY
Incorrect table definition; there can be only one auto column and it must be defined as a key
42S12
ER_NO_SUCH_INDEX
Table '%s' has no index like the one used in CREATE INDEX; recreate the table
42000
ER_WRONG_FIELD_TERMINATORS
Field separator argument is not what is expected; check the manual
42000
ER_BLOBS_AND_NO_TERMINATED
You can't use fixed rowlength with BLOBs; please use 'fields terminated by'
HY000
ER_TEXTFILE_NOT_READABLE
The file '%s' must be in the database directory or be readable by all
HY000
ER_WRONG_SUB_KEY
Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys
42000
ER_CANT_REMOVE_ALL_FIELDS
You can't delete all columns with ALTER TABLE; use DROP TABLE instead
42000
ER_TOO_BIG_SELECT
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE= ## if the SELECT is okay
42000
ER_UNSUPPORTED_EXTENSION
Table '%s' uses an extension that doesn't exist in this MariaDB version
42000
ER_TOO_BIG_ROWSIZE
Row size too large. The maximum row size for the used table type, not counting BLOBs, is %ld. You have to change some columns to TEXT or BLOBs
HY000
ER_STACK_OVERRUN
Thread stack overrun: Used: %ld of a %ld stack. Use 'mysqld --thread_stack=#' to specify a bigger stack if needed
42000
ER_NULL_COLUMN_IN_INDEX
Table handler doesn't support NULL in given index. Please change column '%s' to be NOT NULL or use another handler
HY000
ER_HOST_IS_BLOCKED
Host '%s' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
42000
ER_PASSWORD_ANONYMOUS_USER
You are using MariaDB as an anonymous user and anonymous users are not allowed to change passwords
42000
ER_PASSWORD_NOT_ALLOWED
You must have privileges to update tables in the mysql database to be able to change passwords for others
HY000
ER_CANT_CREATE_THREAD
Can't create a new thread (Errno %d); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug
42000
ER_MIX_OF_GROUP_FUNC_AND_FIELDS
Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
42000
ER_COLUMNACCESS_DENIED_ERROR
%s command denied to user '%s'@'%s' for column '%s' in table '%s'
42000
ER_ILLEGAL_GRANT_FOR_TABLE
Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used
42000
ER_NONEXISTING_TABLE_GRANT
There is no such grant defined for user '%s' on host '%s' on table '%s'
42000
ER_SYNTAX_ERROR
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use
42000
ER_TABLE_CANT_HANDLE_AUTO_INCREMENT
The used table type doesn't support AUTO_INCREMENT columns
HY000
ER_DELAYED_INSERT_TABLE_LOCKED
INSERT DELAYED can't be used with table '%s' because it is locked with LOCK TABLES
HY000
ER_WRONG_MRG_TABLE
Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist
42000
ER_BLOB_KEY_WITHOUT_LENGTH
BLOB/TEXT column '%s' used in key specification without a key length
42000
ER_PRIMARY_CANT_HAVE_NULL
All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
HY000
ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE
You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
25000
ER_CANT_DO_THIS_DURING_AN_TRANSACTION
You are not allowed to execute this command in a transaction
HY000
ER_LOCK_OR_ACTIVE_TRANSACTION
Can't execute the given command because you have active locked tables or an active transaction
HY000
ER_WARNING_NOT_COMPLETE_ROLLBACK
Some non-transactional changed tables couldn't be rolled back
HY000
ER_TRANS_CACHE_FULL
Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again
HY000
ER_SLAVE_MUST_STOP
This operation cannot be performed with a running slave; run STOP SLAVE first
HY000
ER_SLAVE_NOT_RUNNING
This operation requires a running slave; configure slave and do START SLAVE
HY000
ER_BAD_SLAVE
The server is not configured as slave; fix in config file or with CHANGE MASTER TO
HY000
ER_MASTER_INFO
Could not initialize master info structure; more error messages can be found in the MariaDB error log
42000
ER_TOO_MANY_USER_CONNECTIONS
User %s already has more than 'max_user_connections' active connections
25000
ER_READ_ONLY_TRANSACTION
Update locks cannot be acquired during a READ UNCOMMITTED transaction
HY000
ER_DROP_DB_WITH_READ_LOCK
DROP DATABASE not allowed while thread is holding global read lock
HY000
ER_CREATE_DB_WITH_READ_LOCK
CREATE DATABASE not allowed while thread is holding global read lock
HY000
ER_UNION_TABLES_IN_DIFFERENT_DIR
Incorrect table definition; all MERGE tables must be in the same database
21000
ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT
The used SELECT statements have a different number of columns
HY000
ER_CANT_UPDATE_WITH_READLOCK
Can't execute the query because you have a conflicting read lock
42000
ER_SPECIFIC_ACCESS_DENIED_ERROR
Access denied; you need (at least one of) the %s privilege(s) for this operation
HY000
ER_MASTER_FATAL_ERROR_READING_BINLOG
Got fatal error %d from master when reading data from binary log: '%s'
HY000
ER_SLAVE_IGNORED_TABLE
Slave SQL thread ignored the query because of replicate-*-table rules
08004
ER_NOT_SUPPORTED_AUTH_MODE
Client does not support authentication protocol requested by server; consider upgrading MariaDB client
HY000
ER_TOO_BIG_FOR_UNCOMPRESS
Uncompressed data size too large; the maximum size is %d (probably, length of uncompressed data was corrupted)
HY000
ER_ZLIB_Z_BUF_ERROR
ZLIB: Not enough room in the output buffer (probably, length of uncompressed data was corrupted)
01000
ER_WARN_TOO_MANY_RECORDS
Row %ld was truncated; it contained more data than there were input columns
22004
ER_WARN_NULL_TO_NOTNULL
Column set to default value; NULL supplied to NOT NULL column '%s' at row %ld
HY000
ER_CANT_AGGREGATE_2COLLATIONS
Illegal mix of collations (%s,%s) and (%s,%s) for operation '%s'
HY000
ER_CANT_AGGREGATE_3COLLATIONS
Illegal mix of collations (%s,%s), (%s,%s), (%s,%s) for operation '%s'
HY000
ER_VARIABLE_IS_NOT_STRUCT
Variable '%s' is not a variable component (can't be used as XXXX.variable_name)
HY000
ER_SLAVE_IGNORED_SSL_PARAMS
SSL parameters in CHANGE MASTER are ignored because this MariaDB slave was compiled without SSL support; they can be used later if MariaDB slave with SSL is started
HY000
ER_SERVER_IS_IN_SECURE_AUTH_MODE
Server is running in --secure-auth mode, but '%s'@'%s' has a password in the old format; please change the password to the new format
HY000
ER_WARN_FIELD_RESOLVED
Field or reference '%s%s%s%s%s' of SELECT #%d was resolved in SELECT #%d
HY000
ER_BAD_SLAVE_UNTIL_COND
Incorrect parameter or combination of parameters for START SLAVE UNTIL
HY000
ER_MISSING_SKIP_SLAVE
It is recommended to use --skip-slave-start when doing step-by-step replication with START SLAVE UNTIL; otherwise, you will get problems if you get an unexpected slave's mysqld restart
HY000
ER_WARN_HOSTNAME_WONT_WORK
MariaDB is started in --skip-name-resolve mode; you must restart it without this switch for this grant to work
HY000
ER_WARN_DEPRECATED_SYNTAX
'%s' is deprecated and will be removed in a future release. Please use %s instead
HY000
ER_FEATURE_DISABLED
The '%s' feature is disabled; you need MariaDB built with '%s' to have it working
HY000
ER_OPTION_PREVENTS_STATEMENT
The MariaDB server is running with the %s option so it cannot execute this statement
HY000
ER_TOO_MUCH_AUTO_TIMESTAMP_COLS
Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
HY000
ER_WARN_ALLOWED_PACKET_OVERFLOWED
Result of %s() was larger than max_allowed_packet (%ld) - truncated
42000
ER_UPDATE_LOG_DEPRECATED_IGNORED
The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been ignored. This option will be removed in MariaDB 5.6.
42000
ER_UPDATE_LOG_DEPRECATED_TRANSLATED
The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been translated to SET SQL_LOG_BIN. This option will be removed in MariaDB 5.6.
42000
ER_SP_VARCOND_AFTER_CURSHNDLR
Variable or condition declaration after cursor or handler declaration
HY000
ER_FPARSER_EOF_IN_UNKNOWN_PARAMETER
Unexpected end of file while skipping unknown parameter '%s'
HY000
ER_WARN_VIEW_MERGE
View merge algorithm can't be used here for now (assumed undefined algorithm)
HY000
ER_WARN_VIEW_WITHOUT_KEY
View being updated does not have complete key of underlying table in it
HY000
ER_VIEW_INVALID
View '%s.%s' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
HY000
ER_LOGGING_PROHIBIT_CHANGING_OF
Binary logging and replication forbid changing the global server %s
XAE07
ER_XAER_RMFAIL
XAER_RMFAIL: The command cannot be executed when global transaction is in the %s state
XAE03
ER_XAER_RMERR
XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency
42000
ER_NONEXISTING_PROC_GRANT
There is no such grant defined for user '%s' on host '%s' on routine '%s'
HY000
ER_LOAD_FROM_FIXED_SIZE_ROWS_TO_VAR
Can't load value from file with fixed size rows to variable
42000
ER_SP_NOT_VAR_ARG
OUT or INOUT argument %d for routine %s is not a variable or NEW pseudo-variable in BEFORE trigger
22003
ER_CANT_CREATE_GEOMETRY_OBJECT
Cannot get geometry object from data you send to the GEOMETRY field
HY000
ER_FAILED_ROUTINE_BREAK_BINLOG
A routine failed and has neither NO SQL nor READS SQL DATA in its declaration and binary logging is enabled; if non-transactional tables were updated, the binary log will miss their changes
HY000
ER_BINLOG_UNSAFE_ROUTINE
This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)
HY000
ER_BINLOG_CREATE_ROUTINE_NEED_SUPER
You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)
HY000
ER_EXEC_STMT_WITH_OPEN_CURSOR
You can't execute a prepared statement which has an open cursor associated with it. Reset the statement to re-execute it.
HY000
ER_COMMIT_NOT_ALLOWED_IN_SF_OR_TRG
Explicit or implicit commit is not allowed in stored function or trigger.
HY000
ER_NO_DEFAULT_FOR_VIEW_FIELD
Field of view '%s.%s' underlying table doesn't have a default value
HY000
ER_WRONG_LOCK_OF_SYSTEM_TABLE
You can't combine write-locking of system tables with other tables or lock types
HY000
ER_QUERY_ON_FOREIGN_DATA_SOURCE
There was a problem processing the query on the foreign data source. Data source error: %s
HY000
ER_FOREIGN_DATA_SOURCE_DOESNT_EXIST
The foreign data source you are trying to reference does not exist. Data source error: %s
HY000
ER_FOREIGN_DATA_STRING_INVALID_CANT_CREATE
Can't create federated table. The data source connection string '%s' is not in the correct format
HY000
ER_FOREIGN_DATA_STRING_INVALID
The data source connection string '%s' is not in the correct format
HY000
ER_STACK_OVERRUN_NEED_MORE
Thread stack overrun: %ld bytes used of a %ld byte stack, and %ld bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.
HY000
ER_CANT_UPDATE_USED_TABLE_IN_SF_OR_TRG
Can't update table '%s' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
HY000
ER_PS_NO_RECURSION
The prepared statement contains a stored routine call that refers to that same statement. It's not allowed to execute a prepared statement in such a recursive manner
HY000
ER_VIEW_FRM_NO_USER
View '%s'.'%s' has no definer information (old table format). Current user is used as definer. Please recreate the view!
23000
ER_ROW_IS_REFERENCED_2
Cannot delete or update a parent row: a foreign key constraint fails (%s)
23000
ER_NO_REFERENCED_ROW_2
Cannot add or update a child row: a foreign key constraint fails (%s)
HY000
ER_TRG_NO_DEFINER
No definer attribute for trigger '%s'.'%s'. The trigger will be activated under the authorization of the invoker, which may have insufficient privileges. Please recreate the trigger.
HY000
ER_SP_RECURSION_LIMIT
Recursive limit %d (as set by the max_sp_recursion_depth variable) was exceeded for routine %s
HY000
ER_SP_PROC_TABLE_CORRUPT
Failed to load routine %s. The table mysql.proc is missing, corrupt, or contains bad data (internal code %d)
HY000
ER_TABLE_NEEDS_UPGRADE
Table upgrade required. Please do "REPAIR TABLE %s" or dump/reload to fix it!
42000
ER_MAX_PREPARED_STMT_COUNT_REACHED
Can't create more than max_prepared_stmt_count statements (current value: %lu)
HY000
ER_ADMIN_WRONG_MRG_TABLE
Table '%s' is differently defined or of non-MyISAM type or doesn't exist
HY000
ER_AMBIGUOUS_FIELD_TERM
First character of the FIELDS TERMINATED string is ambiguous; please use non-optional and non-empty FIELDS ENCLOSED BY
HY000
ER_FOREIGN_SERVER_DOESNT_EXIST
The foreign server name you are trying to reference does not exist. Data source error: %s
HY000
ER_ILLEGAL_HA_CREATE_OPTION
Table storage engine '%s' does not support the create option '%s'
HY000
ER_PARTITION_REQUIRES_VALUES_ERROR
Syntax error: %s PARTITIONING requires definition of VALUES %s for each partition
HY000
ER_PARTITION_WRONG_VALUES_ERROR
Only %s PARTITIONING can use VALUES %s in partition definition
HY000
ER_PARTITION_SUBPART_MIX_ERROR
Must define subpartitions on all partitions if on one partition
HY000
ER_PARTITION_WRONG_NO_PART_ERROR
Wrong number of partitions defined, mismatch with previous setting
HY000
ER_PARTITION_WRONG_NO_SUBPART_ERROR
Wrong number of subpartitions defined, mismatch with previous setting
HY000
ER_CONST_EXPR_IN_PARTITION_FUNC_ERROR
Constant/Random expression in (sub)partitioning function is not allowed
HY000
ER_WRONG_EXPR_IN_PARTITION_FUNC_ERROR
Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed
HY000
ER_FIELD_NOT_FOUND_PART_ERROR
Field in list of fields for partition function not found in table
HY000
ER_INCONSISTENT_PARTITION_INFO_ERROR
The partition info in the frm file is not consistent with what can be written into the frm file
HY000
ER_RANGE_NOT_INCREASING_ERROR
VALUES LESS THAN value must be strictly increasing for each partition
HY000
ER_INCONSISTENT_TYPE_OF_FUNCTIONS_ERROR
VALUES value must be of same type as partition function
HY000
ER_MULTIPLE_DEF_CONST_IN_LIST_PART_ERROR
Multiple definition of same constant in list partitioning
HY000
ER_MIX_HANDLER_ERROR
The mix of handlers in the partitions is not allowed in this version of MariaDB
HY000
ER_SUBPARTITION_ERROR
It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning
HY000
ER_UNIQUE_KEY_NEED_ALL_FIELDS_IN_PF
A %s must include all columns in the table's partitioning function
HY000
ER_PARTITION_MGMT_ON_NONPARTITIONED
Partition management on a not partitioned table is not possible
HY000
ER_FOREIGN_KEY_ON_PARTITIONED
Foreign key clause is not yet supported in conjunction with partitioning
HY000
ER_COALESCE_ONLY_ON_HASH_PARTITION
COALESCE PARTITION can only be used on HASH/KEY partitions
HY000
ER_REORG_HASH_ONLY_ON_SAME_N
REORGANIZE PARTITION can only be used to reorganize partitions not to change their numbers
HY000
ER_REORG_NO_PARAM_ERROR
REORGANIZE PARTITION without parameters can only be used on auto-partitioned tables using HASH PARTITIONs
HY000
ER_ADD_PARTITION_SUBPART_ERROR
Trying to Add partition(s) with wrong number of subpartitions
HY000
ER_CONSECUTIVE_REORG_PARTITIONS
When reorganizing a set of partitions they must be in consecutive order
HY000
ER_REORG_OUTSIDE_RANGE
Reorganize of range partitions cannot change total ranges except for last partition where it can extend the range
HY000
ER_PARTITION_FUNCTION_FAILURE
Partition function not supported in this version for this handler
HY000
ER_WRONG_SIZE_NUMBER
A size parameter was incorrectly specified, either number or on the form 10M
HY000
ER_SIZE_OVERFLOW_ERROR
The size number was correct but we don't allow the digit part to be more than 2 billion
HY000
ER_BINLOG_ROW_RBR_TO_SBR
Slave running with --log-slave-updates must use row-based binary logging to be able to replicate row-based binary log events
HY000
ER_COL_COUNT_DOESNT_MATCH_CORRUPTED
Column count of mysql.%s is wrong. Expected %d, found %d. The table is probably corrupted
HY000
ER_WARN_DEPRECATED_SYNTAX_WITH_VER
The syntax '%s' is deprecated and will be removed in MariaDB %s. Please use %s instead
23000
ER_FOREIGN_DUPLICATE_KEY
Upholding foreign key constraints for table '%s', entry '%s', key %d would lead to a duplicate entry
HY000
ER_COL_COUNT_DOESNT_MATCH_PLEASE_UPDATE
Column count of mysql.%s is wrong. Expected %d, found %d. Created with MariaDB %d, now running %d. Please use mysql_upgrade to fix this error.
HY000
ER_TEMP_TABLE_PREVENTS_SWITCH_OUT_OF_RBR
Cannot switch out of the row-based binary log format when the session has open temporary tables
HY000
ER_STORED_FUNCTION_ PREVENTS_SWITCH_BINLOG_FORMAT
Cannot change the binary logging format inside a stored function or trigger
25001
ER_CANT_CHANGE_TX_ISOLATION
Transaction isolation level can't be changed while a transaction is in progress
HY000
ER_DUP_ENTRY_AUTOINCREMENT_CASE
ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '%s' for key '%s'
HY000
ER_EVENT_RECURSION_FORBIDDEN
Recursion of EVENT DDL statements is forbidden when body is present
HY000
ER_EVENTS_DB_ERROR
Cannot proceed because system tables used by Event Scheduler were found damaged at server start
HY000
ER_CANT_RENAME_LOG_TABLE
Cannot rename '%s'. When logging enabled, rename to/from log table must rename two tables: the log table to an archive table and another table back to '%s'
42000
ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
Incorrect parameter count in the call to native function '%s'
HY000
ER_EVENT_CANNOT_CREATE_IN_THE_PAST
Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was dropped immediately after creation.
HY000
ER_EVENT_CANNOT_ALTER_IN_THE_PAST
Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was dropped immediately after creation.
HY000
ER_BINLOG_UNSAFE_STATEMENT
Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. %s
HY000
ER_NO_FORMAT_DESCRIPTION_EVENT _BEFORE_BINLOG_STATEMENT
The BINLOG statement of type %s was not preceded by a format description BINLOG statement.
HY000
ER_WARN_ENGINE_TRANSACTION_ROLLBACK
Storage engine %s does not support rollback for this statement. Transaction rolled back and must be restarted
HY000
ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE
The requested value for the heartbeat period is either negative or exceeds the maximum allowed (%s seconds).
42000
ER_FUNC_INEXISTENT_NAME_COLLISION
FUNCTION %s does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual
HY000
WARN_NON_ASCII_SEPARATOR_NOT_IMPLEMENTED
Non-ASCII separator arguments are not fully supported
HY000
ER_SLAVE_IGNORE_SERVER_IDS
The requested server id %d clashes with the slave startup option --replicate-same-server-id
HY000
ER_QUERY_CACHE_DISABLED
Query cache is disabled; restart the server with query_cache_type=1 to enable it
HY000
ER_ROW_SINGLE_PARTITION_FIELD_ERROR
Row expressions in VALUES IN only allowed for multi-field column partitioning
HY000
ER_FIELD_TYPE_NOT_ALLOWED_AS_PARTITION_FIELD
Field '%s' is of a not allowed type for this type of partitioning
HY000
ER_BINLOG_ROW_ENGINE_AND_STMT_ENGINE
Cannot execute statement: impossible to write to binary log since both row-incapable engines and statement-incapable engines are involved.
HY000
ER_BINLOG_ROW_MODE_AND_STMT_ENGINE
Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = ROW and at least one table uses a storage engine limited to statement-based logging.
HY000
ER_BINLOG_UNSAFE_AND_STMT_ENGINE
Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. %s
HY000
ER_BINLOG_ROW_INJECTION_AND_STMT_ENGINE
Cannot execute statement: impossible to write to binary log since statement is in row format and at least one table uses a storage engine limited to statement-based logging.
HY000
ER_BINLOG_STMT_MODE_AND_ROW_ENGINE
Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging.%s
HY000
ER_BINLOG_ROW_INJECTION_AND_STMT_MODE
Cannot execute statement: impossible to write to binary log since statement is in row format and BINLOG_FORMAT = STATEMENT.
HY000
ER_BINLOG_MULTIPLE_ENGINES _AND_SELF_LOGGING_ENGINE
Cannot execute statement: impossible to write to binary log since more than one engine is involved and at least one engine is self-logging.
HY000
ER_BINLOG_UNSAFE_LIMIT
The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
HY000
ER_BINLOG_UNSAFE_INSERT_DELAYED
The statement is unsafe because it uses INSERT DELAYED. This is unsafe because the times when rows are inserted cannot be predicted.
HY000
ER_BINLOG_UNSAFE_SYSTEM_TABLE
The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on slaves.
HY000
ER_BINLOG_UNSAFE_AUTOINC_COLUMNS
Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
HY000
ER_BINLOG_UNSAFE_UDF
Statement is unsafe because it uses a UDF which may not return the same value on the slave.
HY000
ER_BINLOG_UNSAFE_SYSTEM_VARIABLE
Statement is unsafe because it uses a system variable that may have a different value on the slave.
HY000
ER_BINLOG_UNSAFE_SYSTEM_FUNCTION
Statement is unsafe because it uses a system function that may return a different value on the slave.
HY000
ER_BINLOG_UNSAFE_NONTRANS_AFTER_TRANS
Statement is unsafe because it accesses a non-transactional table after accessing a transactional table within the same transaction.
HY000
ER_SLAVE_CONVERSION_FAILED
Column %d of table '%s.%s' cannot be converted from type '%s' to type '%s'
HY000
ER_INSIDE_TRANSACTION _PREVENTS_SWITCH_BINLOG_FORMAT
Cannot modify @@session.binlog_format inside a transaction
HY000
ER_WARN_DEPRECATED_SYNTAX_NO_REPLACEMENT
'%s' is deprecated and will be removed in a future release.
HY000
ER_WARN_I_S_SKIPPED_TABLE
Table '%s'.'%s' was skipped since its definition is being modified by concurrent DDL statement
HY000
ER_INSIDE_TRANSACTION _PREVENTS_SWITCH_BINLOG_DIRECT
Cannot modify @@session.binlog_direct_non_transactional_updates inside a transaction
HY000
ER_STORED_FUNCTION_PREVENTS _SWITCH_BINLOG_DIRECT
Cannot change the binlog direct flag inside a stored function or trigger
HY000
ER_BINLOG_UNSAFE_MULTIPLE_ENGINES _AND_SELF_LOGGING_ENGINE
Mixing self-logging and non-self-logging engines in a statement is unsafe.
HY000
ER_BINLOG_UNSAFE_MIXED_STATEMENT
Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them.
HY000
ER_INSIDE_TRANSACTION_ PREVENTS_SWITCH_SQL_LOG_BIN
Cannot modify @@session.sql_log_bin inside a transaction
HY000
ER_STORED_FUNCTION_ PREVENTS_SWITCH_SQL_LOG_BIN
Cannot change the sql_log_bin inside a stored function or trigger
HY000
ER_SET_PASSWORD_AUTH_PLUGIN
SET PASSWORD has no significance for users authenticating via plugins
HY000
ER_GRANT_PLUGIN_USER_EXISTS
GRANT with IDENTIFIED WITH is illegal because the user %-.*s already exists
HY000
ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE_MIN
The requested value for the heartbeat period is less than 1 millisecond. The value is reset to 0, meaning that heartbeating will effectively be disabled.
HY000
ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE_MAX
The requested value for the heartbeat period exceeds the value of slave_net_timeout seconds. A sensible value for the period should be less than the timeout.
HY000
ER_STMT_CACHE_FULL
Multi-row statements required more than 'max_binlog_stmt_cache_size' bytes of storage; increase this mysqld variable and try again
HY000
ER_MULTI_UPDATE_KEY_CONFLICT
Primary key/partition key update is not allowed since the table is updated both as '%s' and '%s'.
HY000
ER_TABLE_NEEDS_REBUILD
Table rebuild required. Please do "ALTER TABLE %s FORCE" or dump/reload to fix it!
HY000
ER_BINLOG_UNSAFE_INSERT_IGNORE_SELECT
INSERT IGNORE... SELECT is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are ignored. This order cannot be predicted and may differ on master and the slave.
HY000
ER_BINLOG_UNSAFE_INSERT_SELECT_UPDATE
INSERT... SELECT... ON DUPLICATE KEY UPDATE is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are updated. This order cannot be predicted and may differ on master and the slave.
HY000
ER_BINLOG_UNSAFE_REPLACE_SELECT
REPLACE... SELECT is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are replaced. This order cannot be predicted and may differ on master and the slave.
HY000
ER_BINLOG_UNSAFE_CREATE_IGNORE_SELECT
CREATE... IGNORE SELECT is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are ignored. This order cannot be predicted and may differ on master and the slave.
HY000
ER_BINLOG_UNSAFE_CREATE_REPLACE_SELECT
CREATE... REPLACE SELECT is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are replaced. This order cannot be predicted and may differ on master and the slave.
HY000
ER_BINLOG_UNSAFE_UPDATE_IGNORE
UPDATE IGNORE is unsafe because the order in which rows are updated determines which (if any) rows are ignored. This order cannot be predicted and may differ on master and the slave.
HY000
ER_BINLOG_UNSAFE_WRITE_AUTOINC_SELECT
Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave.
HY000
ER_BINLOG_UNSAFE_CREATE_SELECT_AUTOINC
CREATE TABLE... SELECT... on a table with an auto-increment column is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are inserted. This order cannot be predicted and may differ on master and the slave.
HY000
ER_BINLOG_UNSAFE_INSERT_TWO_KEYS
INSERT... ON DUPLICATE KEY UPDATE on a table with more than one UNIQUE KEY is unsafe
HY000
ER_BINLOG_UNSAFE_AUTOINC_NOT_FIRST
INSERT into autoincrement field which is not the first part in the composed primary key is unsafe.
HY000
ER_MASTER_DELAY_VALUE_OUT_OF_RANGE
The requested value %s for the master delay exceeds the maximum %u
HY000
ER_ONLY_FD_AND_RBR_EVENTS_ALLOWED_IN_BINLOG_STATEMENT
Only Format_description_log_event and row events are allowed in BINLOG statements (but %s was provided
HY000
ER_PARTITION_EXCHANGE_DIFFERENT_OPTION
Non matching attribute '%s' between partition and table
HY000
ER_PARTITION_INSTEAD_OF_SUBPARTITION
Subpartitioned table, use subpartition instead of partition
HY000
ER_BINLOG_CACHE_SIZE_GREATER_THAN_MAX
Option binlog_cache_size (%lu) is greater than max_binlog_cache_size (%lu); setting binlog_cache_size equal to max_binlog_cache_size.
HY000
ER_WARN_INDEX_NOT_APPLICABLE
Cannot use %s access on index '%s' due to type or collation conversion on field '%s'
HY000
ER_PARTITION_EXCHANGE_FOREIGN_KEY
Table to exchange with partition has foreign key references: '%s'
HY000
ER_NETWORK_READ_EVENT_CHECKSUM_FAILURE
Replication event checksum verification failed while reading from network.
HY000
ER_BINLOG_READ_EVENT_CHECKSUM_FAILURE
Replication event checksum verification failed while reading from a log file.
HY000
ER_BINLOG_STMT_CACHE_SIZE_GREATER_THAN_MAX
Option binlog_stmt_cache_size (%lu) is greater than max_binlog_stmt_cache_size (%lu); setting binlog_stmt_cache_size equal to max_binlog_stmt_cache_size.
HY000
ER_CANT_UPDATE_TABLE_IN_CREATE_TABLE_SELECT
Can't update table '%s' while '%s' is being created.
HY000
ER_CHANGE_RPL_INFO_REPOSITORY_FAILURE
Failure while changing the type of replication repository: %s.
HY000
ER_WARNING_NOT_COMPLETE_ROLLBACK_WITH_CREATED_TEMP_TABLE
The creation of some temporary tables could not be rolled back.
HY000
ER_WARNING_NOT_COMPLETE_ROLLBACK_WITH_DROPPED_TEMP_TABLE
Some temporary tables were dropped, but these operations could not be rolled back.
HY000
ER_MTS_UPDATED_DBS_GREATER_MAX
The number of modified databases exceeds the maximum %d; the database names will not be included in the replication event metadata.
HY000
ER_MTS_CANT_PARALLEL
Cannot execute the current event group in the parallel mode. Encountered event %s, relay-log name %s, position %s which prevents execution of this event group in parallel mode. Reason: %s.
HY000
ER_FULLTEXT_NOT_SUPPORTED_WITH_PARTITIONING
FULLTEXT index is not supported for partitioned tables.
HY000
ER_INSECURE_PLAIN_TEXT
Sending passwords in plain text without SSL/TLS is extremely insecure.
HY000
ER_INSECURE_CHANGE_MASTER
Storing MariaDB user name or password information in the master.info repository is not secure and is therefore not recommended. Please see the MariaDB Manual for more about this issue and possible alternatives
23000
ER_FOREIGN_DUPLICATE_KEY_WITH_CHILD_INFO
Foreign key constraint for table '%s', record '%s' would lead to a duplicate entry in table '%s', key '%s'
23000
ER_FOREIGN_DUPLICATE_KEY_WITHOUT_CHILD_INFO
Foreign key constraint for table '%s', record '%s' would lead to a duplicate entry in a child table
HY000
ER_SQLTHREAD_WITH_SECURE_SLAVE
Setting authentication options is not possible when only the Slave SQL Thread is being started.
HY000
ER_VARIABLE_NOT_SETTABLE_IN_SF_OR_TRIGGER
The system variable %s cannot be set in stored functions or triggers.
HY000
ER_VARIABLE_NOT_SETTABLE_IN_TRANSACTION
The system variable %s cannot be set when there is an ongoing transaction.
HY000
ER_GTID_NEXT_IS_NOT_IN_GTID_NEXT_LIST
The system variable @@SESSION.GTID_NEXT has the value %s, which is not listed in @@SESSION.GTID_NEXT_LIST.
HY000
ER_CANT_CHANGE_GTID_NEXT_IN_TRANSACTION_WHEN_GTID_NEXT_LIST_IS_NULL
The system variable @@SESSION.GTID_NEXT cannot change inside a transaction.
HY000
ER_SET_STATEMENT_CANNOT_INVOKE_FUNCTION
The statement 'SET %s' cannot invoke a stored function.
HY000
ER_GTID_NEXT_CANT_BE_AUTOMATIC_IF_GTID_NEXT_LIST_IS_NON_NULL
The system variable @@SESSION.GTID_NEXT cannot be 'AUTOMATIC' when @@SESSION.GTID_NEXT_LIST is non-NULL.
HY000
ER_SKIPPING_LOGGED_TRANSACTION
Skipping transaction %s because it has already been executed and logged.
HY000
ER_GNO_EXHAUSTED
Impossible to generate Global Transaction Identifier: the integer component reached the maximal value. Restart the server with a new server_uuid.
HY000
ER_BAD_SLAVE_AUTO_POSITION
Parameters MASTER_LOG_FILE, MASTER_LOG_POS, RELAY_LOG_FILE and RELAY_LOG_POS cannot be set when MASTER_AUTO_POSITION is active.
HY000
ER_AUTO_POSITION_REQUIRES_GTID_MODE_ON
CHANGE MASTER TO MASTER_AUTO_POSITION = 1 can only be executed when @@GLOBAL.GTID_MODE = ON.
HY000
ER_CANT_DO_IMPLICIT_COMMIT_IN_TRX_WHEN_GTID_NEXT_IS_SET
Cannot execute statements with implicit commit inside a transaction when @@SESSION.GTID_NEXT != AUTOMATIC.
HY000
ER_GTID_MODE_2_OR_3_REQUIRES_DISABLE_GTID_UNSAFE_STATEMENTS_ON
GTID_MODE = ON or GTID_MODE = UPGRADE_STEP_2 requires DISABLE_GTID_UNSAFE_STATEMENTS = 1.
HY000
ER_GTID_MODE_2_OR_3_REQUIRES_ENFORCE_GTID_CONSISTENCY_ON
@@GLOBAL.GTID_MODE = ON or UPGRADE_STEP_2 requires @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1.
HY000
ER_GTID_MODE_REQUIRES_BINLOG
@@GLOBAL.GTID_MODE = ON or UPGRADE_STEP_1 or UPGRADE_STEP_2 requires --log-bin and --log-slave-updates.
HY000
ER_CANT_SET_GTID_NEXT_TO_GTID_WHEN_GTID_MODE_IS_OFF
@@SESSION.GTID_NEXT cannot be set to UUID:NUMBER when @@GLOBAL.GTID_MODE = OFF.
HY000
ER_CANT_SET_GTID_NEXT_TO_ANONYMOUS_WHEN_GTID_MODE_IS_ON
@@SESSION.GTID_NEXT cannot be set to ANONYMOUS when @@GLOBAL.GTID_MODE = ON.
HY000
ER_CANT_SET_GTID_NEXT_LIST_TO_NON_NULL_WHEN_GTID_MODE_IS_OFF
@@SESSION.GTID_NEXT_LIST cannot be set to a non-NULL value when @@GLOBAL.GTID_MODE = OFF.
HY000
ER_FOUND_GTID_EVENT_WHEN_GTID_MODE_IS_OFF
Found a Gtid_log_event or Previous_gtids_log_event when @@GLOBAL.GTID_MODE = OFF.
HY000
ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
HY000
ER_GTID_UNSAFE_CREATE_SELECT
CREATE TABLE ... SELECT is forbidden when @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1.
HY000
ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION
When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, the statements CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can be executed in a non-transactional context only, and require that AUTOCOMMIT = 1.
HY000
ER_GTID_MODE_CAN_ONLY_CHANGE_ONE_STEP_AT_A_TIME
The value of @@GLOBAL.GTID_MODE can only change one step at a time: OFF <-> UPGRADE_STEP_1 <-> UPGRADE_STEP_2 <-> ON. Also note that this value must be stepped up or down simultaneously on all servers; see the Manual for instructions.
HY000
ER_MASTER_HAS_PURGED_REQUIRED_GTIDS
The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master has purged binary logs containing GTIDs that the slave requires.
HY000
ER_CANT_SET_GTID_NEXT_WHEN_OWNING_GTID
@@SESSION.GTID_NEXT cannot be changed by a client that owns a GTID. The client owns %s. Ownership is released on COMMIT or ROLLBACK.
25006
ER_CANT_EXECUTE_IN_READ_ONLY_TRANSACTION
Cannot execute statement in a READ ONLY transaction.
HY000
ER_SLAVE_CONFIGURATION
Slave is not configured or failed to initialize properly. You must at least set --server-id to enable either a master or a slave. Additional error messages can be found in the MariaDB error log
HY000
ER_INNODB_ONLINE_LOG_TOO_BIG
Creating index '%s' required more than 'innodb_online_alter_log_max_size' bytes of modification log. Please try again.
HY000
ER_MTS_CHANGE_MASTER_CANT_RUN_WITH_GAPS
CHANGE MASTER cannot be executed when the slave was stopped with an error or killed in MTS mode. Consider using RESET SLAVE or START SLAVE UNTIL.
HY000
ER_MTS_RECOVERY_FAILURE
Cannot recover after SLAVE errored out in parallel execution mode. Additional error messages can be found in the MariaDB error log
HY000
ER_MTS_RESET_WORKERS
Cannot clean up worker info tables. Additional error messages can be found in the MariaDB error log
HY000
ER_COL_COUNT_DOESNT_MATCH_CORRUPTED_V2
Column count of %s.%s is wrong. Expected %d, found %d. The table is probably corrupted
HY000
ER_DISCARD_FK_CHECKS_RUNNING
There is a foreign key check running on table '%s'. Cannot discard the table.
HY000
ER_TABLESPACE_EXISTS
Tablespace for table '%s' exists. Please DISCARD the tablespace before IMPORT.
HY000
ER_INVALID_YEAR_COLUMN_LENGTH
YEAR(%lu) column type is deprecated. Creating YEAR(4) column instead.
HY000
ER_FK_NO_INDEX_CHILD
Failed to add the foreign key constaint. Missing index for constraint '%s' in the foreign table '%s'
HY000
ER_FK_NO_INDEX_PARENT
Failed to add the foreign key constaint. Missing index for constraint '%s' in the referenced table '%s'
HY000
ER_FK_INCORRECT_OPTION
Failed to add the foreign key constraint on table '%s'. Incorrect options in FOREIGN KEY constraint '%s'
HY000
ER_PASSWORD_FORMAT
The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function.
HY000
ER_FK_COLUMN_CANNOT_DROP_CHILD
Cannot drop column '%s': needed in a foreign key constraint '%s' of table '%s'
HY000
ER_FK_COLUMN_NOT_NULL
Column '%s' cannot be NOT NULL: needed in a foreign key constraint '%s' SET NULL
HY000
ER_DUP_INDEX
Duplicate index '%s' defined on the table '%s.%s'. This is deprecated and will be disallowed in a future release.
HY000
ER_FK_COLUMN_CANNOT_CHANGE_CHILD
Cannot change column '%s': used in a foreign key constraint '%s' of table '%s'
HY000
ER_FK_CANNOT_DELETE_PARENT
Cannot delete rows from table which is parent in a foreign key constraint '%s' of table '%s'
HY000
ER_GTID_NEXT_TYPE_UNDEFINED_GROUP
When GTID_NEXT is set to a GTID, you must explicitly set it again after a COMMIT or ROLLBACK. If you see this error message in the slave SQL thread, it means that a table in the current transaction is transactional on the master and non-transactional on the slave. In a client connection, it means that you executed SET GTID_NEXT before a transaction and forgot to set GTID_NEXT to a different identifier or to 'AUTOMATIC' after COMMIT or ROLLBACK. Current GTID_NEXT is '%s'
HY000
ER_CANT_SET_GTID_PURGED_WHEN_GTID_MODE_IS_OFF
@@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_MODE = ON.
HY000
ER_CANT_SET_GTID_PURGED_WHEN_GTID_EXECUTED_IS_NOT_EMPTY
@@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty.
HY000
ER_CANT_SET_GTID_PURGED_WHEN_OWNED_GTIDS_IS_NOT_EMPTY
@@GLOBAL.GTID_PURGED can only be set when there are no ongoing transactions (not even in other clients).
HY000
ER_BINLOG_STMT_MODE_AND_NO_REPL_TABLES
Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT, and both replicated and non replicated tables are written to.
HY000
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_PARTITION
Partition specific operations do not yet support LOCK/ALGORITHM
HY000
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_FK_RENAME
Columns participating in a foreign key are renamed
HY000
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_FK_CHECK
Adding foreign keys needs foreign_key_checks=OFF
HY000
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_IGNORE
Creating unique indexes with IGNORE requires COPY algorithm to remove duplicate rows
HY000
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_NOPK
Dropping a primary key is not allowed without also adding a new primary key
HY000
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_AUTOINC
Adding an auto-increment column requires a lock
HY000
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_HIDDEN_FTS
Cannot replace hidden FTS_DOC_ID with a user-visible one
HY000
ER_SQL_SLAVE_SKIP_COUNTER_NOT_SETTABLE_IN_GTID_MODE
sql_slave_skip_counter can not be set when the server is running with @@GLOBAL.GTID_MODE = ON. Instead, for each transaction that you want to skip, generate an empty transaction with the same GTID as the transaction
HY000
ER_IDENT_CAUSES_TOO_LONG_PATH
Long database name and identifier for object resulted in path length exceeding %d characters. Path: '%s'.
HY000
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_NOT_NULL
cannot silently convert NULL values, as required in this SQL_MODE
HY000
ER_MUST_CHANGE_PASSWORD_LOGIN
Your password has expired. To log in you must change it using a client that supports expired passwords.
HY000
ER_MTS_EVENT_BIGGER_PENDING_JOBS_SIZE_MAX
Cannot schedule event %s, relay-log name %s, position %s to Worker thread because its size %lu exceeds %lu of slave_pending_jobs_size_max.
HY000
ER_WARN_PURGE_LOG_IN_USE
file %s was not purged because it was being read by %d thread(s), purged only %d out of %d files.
HY000
ER_AUTO_INCREMENT_CONFLICT
Auto-increment value in UPDATE conflicts with internally generated values
HY000
WARN_ON_BLOCKHOLE_IN_RBR
Row events are not logged for %s statements that modify BLACKHOLE tables in row format. Table(s): '%s'
HY000
ER_SLAVE_MI_INIT_REPOSITORY
Slave failed to initialize master info structure from the repository
HY000
ER_SLAVE_RLI_INIT_REPOSITORY
Slave failed to initialize relay log info structure from the repository
28000
ER_ACCESS_DENIED_CHANGE_USER_ERROR
Access denied trying to change to user '%s'@'%s' (using password: %s). Disconnecting.
HY000
ER_STOP_SLAVE_SQL_THREAD_TIMEOUT
STOP SLAVE command execution is incomplete: Slave SQL thread got the stop signal, thread is busy, SQL thread will stop once the current task is complete.
HY000
ER_STOP_SLAVE_IO_THREAD_TIMEOUT
STOP SLAVE command execution is incomplete: Slave IO thread got the stop signal, thread is busy, IO thread will stop once the current task is complete.
HY000
ER_TABLE_CORRUPT
Operation cannot be performed. The table '%s.%s' is missing, corrupt or contains bad data.
HY000
ER_INNODB_FT_AUX_NOT_HEX_ID
Upgrade index name failed, please use create index(alter table) algorithm copy to rebuild index.
1900
ER_UNUSED_18
"
1901
ER_GENERATED_COLUMN_FUNCTION_IS_NOT_ALLOWED
Function or expression '%s' cannot be used in the %s clause of %`s
1902
ER_UNUSED_19
"
ER_KEY_BASED_ON_GENERATED_VIRTUAL_COLUMN
Key/Index cannot be defined on a virtual generated column
ER_WRONG_FK_OPTION_FOR_GENERATED_COLUMN
Cannot define foreign key with %s clause on a generated column
ER_WARNING_NON_DEFAULT_VALUE_FOR_GENERATED_COLUMN
The value specified for generated column '%s' in table '%s' has been ignored
1908
ER_UNUSED_20
"
1909
ER_UNUSED_21
"
ER_ILLEGAL_SUBQUERY_OPTIMIZER_SWITCHES
At least one of the 'in_to_exists' or 'materialization' optimizer_switch flags must be 'on'.
ER_QUERY_CACHE_IS_DISABLED
Query cache is disabled (resize or similar command in progress); repeat this command later
ER_QUERY_CACHE_IS_GLOBALY_DISABLED
Query cache is globally disabled and you can't enable it only for this session
ER_VIEW_ORDERBY_IGNORED
View '%-.192s'.'%-.192s' ORDER BY clause ignored because there is other ORDER BY clause already.
ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_SKIP_REPLICATION
Cannot modify @@session.skip_replication inside a transaction
ER_STORED_FUNCTION_PREVENTS_SWITCH_SKIP_REPLICATION
Cannot modify @@session.skip_replication inside a stored function or trigger
ER_QUERY_RESULT_INCOMPLETE
Query execution was interrupted. The query exceeded %s %llu. The query result may be incomplete
ER_GTID_POSITION_NOT_FOUND_IN_BINLOG
Connecting slave requested to start from GTID %u-%u-%llu, which is not in the master's binlog
ER_MASTER_GTID_POS_CONFLICTS_WITH_BINLOG
Specified GTID %u-%u-%llu conflicts with the binary log which contains a more recent GTID %u-%u-%llu. If MASTER_GTID_POS=CURRENT_POS is used, the binlog position will override the new value of @@gtid_slave_pos.
ER_MASTER_GTID_POS_MISSING_DOMAIN
Specified value for @@gtid_slave_pos contains no value for replication domain %u. This conflicts with the binary log which contains GTID %u-%u-%llu. If MASTER_GTID_POS=CURRENT_POS is used, the binlog position will override the new value of @@gtid_slave_pos.
ER_GTID_STRICT_OUT_OF_ORDER
An attempt was made to binlog GTID %u-%u-%llu which would create an out-of-order sequence number with existing GTID %u-%u-%llu, and gtid strict mode is enabled.
ER_GTID_START_FROM_BINLOG_HOLE
The binlog on the master is missing the GTID %u-%u-%llu requested by the slave (even though a subsequent sequence number does exist), and GTID strict mode is enabled
ER_SLAVE_UNEXPECTED_MASTER_SWITCH
Unexpected GTID received from master after reconnect. This normally indicates that the master server was replaced without restarting the slave threads. %s
ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_GTID_DOMAIN_ID_SEQ_NO
Cannot modify @@session.gtid_domain_id or @@session.gtid_seq_no inside a transaction
ER_STORED_FUNCTION_PREVENTS_SWITCH_GTID_DOMAIN_ID_SEQ_NO
Cannot modify @@session.gtid_domain_id or @@session.gtid_seq_no inside a stored function or trigger
ER_GTID_POSITION_NOT_FOUND_IN_BINLOG2
Connecting slave requested to start from GTID %u-%u-%llu, which is not in the master's binlog. Since the master's binlog contains GTIDs with higher sequence numbers, it probably means that the slave has diverged due to executing extra errorneous transactions
ER_BINLOG_MUST_BE_EMPTY
This operation is not allowed if any GTID has been logged to the binary log. Run RESET MASTER first to erase the log
ER_CHANGE_SLAVE_PARALLEL_THREADS_ACTIVE
Cannot change @@slave_parallel_threads while another change is in progress
ER_PRIOR_COMMIT_FAILED
Commit failed due to failure of an earlier commit on which this one depends
ER_SLAVE_SKIP_NOT_IN_GTID
When using GTID, @@sql_slave_skip_counter can not be used. Instead, setting @@gtid_slave_pos explicitly can be used to skip to after a given GTID position.
ER_ERROR_ON_MASTER
Query partially completed on the master (error on master: %d) and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE;. Query:'%s'"
ER_INCONSISTENT_ERROR
Query caused different errors on master and slave. Error on master: message (format)='%s' error code=%d; Error on slave:actual message='%s', error code=%d. Default database:'%s'. Query:'%s'
ER_BINLOG_UNSAFE_FULLTEXT_PLUGIN
Statement is unsafe because it uses a fulltext parser plugin which may not return the same value on the slave.
ER_CANNOT_DISCARD_TEMPORARY_TABLE
Cannot DISCARD/IMPORT tablespace associated with temporary table
ER_COL_COUNT_DOESNT_MATCH_PLEASE_UPDATE_V2
Column count of %s.%s is wrong. Expected %d, found %d. Created with MariaDB %d, now running %d. Please use mysql_upgrade to fix this error.
ER_REFERENCED_TRG_DOES_NOT_EXIST_MYSQL
Referenced trigger '%s' for the given action time and event type does not exist.
ER_EXPLAIN_NOT_SUPPORTED
EXPLAIN FOR CONNECTION command is supported only for SELECT/UPDATE/INSERT/DELETE/REPLACE
ER_SLAVE_SQL_THREAD_MUST_STOP
This operation cannot be performed with a running slave sql thread; run STOP SLAVE SQL_THREAD first
ER_SLAVE_CHANNEL_IO_THREAD_MUST_STOP
This operation cannot be performed with a running slave io thread; run STOP SLAVE IO_THREAD FOR CHANNEL '%s' first.
ER_WARN_OPEN_TEMP_TABLES_MUST_BE_ZERO
This operation may not be safe when the slave has temporary tables. The tables will be kept open until the server restarts or until the tables are deleted by any replicated DROP statement. Suggest to wait until slave_open_temp_tables = 0.
ER_WARN_ONLY_MASTER_LOG_FILE_NO_POS
CHANGE MASTER TO with a MASTER_LOG_FILE clause but no MASTER_LOG_POS clause may not be safe. The old position value may not be valid for the new binary log file.
ER_SQL_MODE_NO_EFFECT
'%s' mode no longer has any effect. Use STRICT_ALL_TABLES or STRICT_TRANS_TABLES instead.
ER_AGGREGATE_ORDER_FOR_UNION
Expression #%u of ORDER BY contains aggregate function and applies to a UNION
ER_AGGREGATE_ORDER_NON_AGG_QUERY
Expression #%u of ORDER BY contains aggregate function and applies to the result of a non-aggregated query
ER_SLAVE_WORKER_STOPPED_PREVIOUS_THD_ERROR
Slave worker has stopped after at least one previous worker encountered an error when slave-preserve-commit-order was enabled. To preserve commit order, the last transaction executed by this thread has not been committed. When restarting the slave after fixing any failed threads, you should fix this worker as well.
ER_GIS_DIFFERENT_SRIDS
Binary geometry function %s given two geometries of different srids: %u and %u, which should have been identical.
ER_BOOST_GEOMETRY_CENTROID_EXCEPTION
Unable to calculate centroid because geometry is empty in function %s.
ER_BOOST_GEOMETRY_OVERLAY_INVALID_INPUT_EXCEPTION
Geometry overlay calculation error: geometry data is invalid in function %s.
ER_BOOST_GEOMETRY_TURN_INFO_EXCEPTION
Geometry turn info calculation error: geometry data is invalid in function %s.
ER_BOOST_GEOMETRY_SELF_INTERSECTION_POINT_EXCEPTION
Analysis procedures of intersection points interrupted unexpectedly in function %s.
ER_CHANGE_MASTER_PASSWORD_LENGTH
The password provided for the replication user exceeds the maximum length of 32 characters
ER_USER_LOCK_DEADLOCK
Deadlock found when trying to get user-level lock; try rolling back transaction/releasing locks and restarting lock acquisition.
ER_REPLACE_INACCESSIBLE_ROWS
REPLACE cannot be executed as it requires deleting rows that are not in the view
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_GIS
Do not support online operation on table with GIS index
ER_REF_TO_RECURSIVE_WITH_TABLE_IN_DERIVED
Reference to recursive WITH table '%s' in materialized derived
ER_NOT_STANDARD_COMPLIANT_RECURSIVE
Restrictions imposed on recursive definitions are violated for table '%s'"R_WRONG_WINDOW_SPEC_NAME
ER_PARTITION_LIST_IN_REFERENCING_WINDOW_SPEC
Window specification referencing another one '%s' cannot contain partition list
ER_ORDER_LIST_IN_REFERENCING_WINDOW_SPEC
Referenced window specification '%s' already contains order list
ER_WINDOW_FRAME_IN_REFERENCED_WINDOW_SPEC
Referenced window specification '%s' cannot contain window frame
ER_BAD_COMBINATION_OF_WINDOW_FRAME_BOUND_SPECS
Unacceptable combination of window frame bound specifications
ER_WRONG_PLACEMENT_OF_WINDOW_FUNCTION
Window function is allowed only in SELECT list and ORDER BY clause
ER_RANGE_FRAME_NEEDS_SIMPLE_ORDERBY
RANGE-type frame requires ORDER BY clause with single sort key
ER_EXPRESSION_REFERS_TO_UNINIT_FIELD
Expression for field %-.64s is referring to uninitialized field %s
ER_REFERENCED_TRG_DOES_NOT_EXIST
Referenced trigger '%s' for the given action time and event type does not exist
ER_JSON_DEPTH
Limit of %d on JSON nested strucures depth is reached in argument %d to function '%s' at position %d
ER_JSON_PATH_DEPTH
Limit of %d on JSON path depth is reached in argument %d to function '%s' at position %d
ER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE
CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
ER_SLAVE_SAME_ID
A slave with the same server_uuid/server_id as this slave has connected to the master
ER_ISOLATION_MODE_NOT_SUPPORTED
MyRocks supports only READ COMMITTED and REPEATABLE READ isolation levels. Please change from current isolation level %s
ER_ON_DUPLICATE_DISABLED
When unique checking is disabled in MyRocks, INSERT,UPDATE,LOAD statements with clauses that update or replace the key (i.e. INSERT ON DUPLICATE KEY UPDATE, REPLACE) are not allowed. Query: %s
ER_UPDATES_WITH_CONSISTENT_SNAPSHOT
Can't execute updates when you started a transaction with START TRANSACTION WITH CONSISTENT [ROCKSDB] SNAPSHOT.
ER_ROLLBACK_ONLY
This transaction was rolled back and cannot be committed. Only supported operation is to roll it back, so all pending changes will be discarded. Please restart another transaction.
ER_ROLLBACK_TO_SAVEPOINT
MyRocks currently does not support ROLLBACK TO SAVEPOINT if modifying rows.
ER_ISOLATION_LEVEL_WITH_CONSISTENT_SNAPSHOT
Only REPEATABLE READ isolation level is supported for START TRANSACTION WITH CONSISTENT SNAPSHOT in RocksDB Storage Engine.
ER_UNSUPPORTED_COLLATION
Unsupported collation on string indexed column %s.%s Use binary collation (%s).
ER_METADATA_INCONSISTENCY
Table '%s' does not exist, but metadata information exists inside MyRocks. This is a sign of data inconsistency. Please check if '%s.frm' exists, and try to restore it if it does not exist.
ER_CF_DIFFERENT
Column family ('%s') flag (%d) is different from an existing flag (%d). Assign a new CF flag, or do not change existing CF flag.
ER_RDB_TTL_DURATION_FORMAT
TTL duration (%s) in MyRocks must be an unsigned non-null 64-bit integer.
ER_RDB_TTL_COL_FORMAT
TTL column (%s) in MyRocks must be an unsigned non-null 64-bit integer, exist inside the table, and have an accompanying ttl duration.
ER_SUM_FUNC_WITH_WINDOW_FUNC_AS_ARG
Window functions can not be used as arguments to group functions.
ER_MYROCKS_CANT_NOPAD_COLLATION
MyRocks doesn't currently support collations with "No pad" attribute.
ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION
Illegal parameter data types %s and %s for operation '%s'
ER_UNKNOWN_STRUCTURED_VARIABLE
Unknown structured system variable or ROW routine variable '%-.*s'
ER_WRONG_INSERT_INTO_SEQUENCE
Wrong INSERT into a SEQUENCE. One can only do single table INSERT into a sequence object (like with mysqldump). If you want to change the SEQUENCE, use ALTER SEQUENCE instead.
ER_PACKAGE_ROUTINE_IN_SPEC_NOT_DEFINED_IN_BODY
Subroutine '%-.192s' is declared in the package specification but is not defined in the package body
ER_PACKAGE_ROUTINE_FORWARD_DECLARATION_NOT_DEFINED
Subroutine '%-.192s' has a forward declaration but is not defined
ER_WRONG_NUMBER_OF_VALUES_IN_TVC
The used table value constructor has a different number of values
ER_WRONG_TYPE_OF_ARGUMENT
%s function only accepts arguments that can be converted to numerical types
ER_NOT_AGGREGATE_FUNCTION
Aggregate specific instruction (FETCH GROUP NEXT ROW) used in a wrong context
ER_INVALID_AGGREGATE_FUNCTION
Aggregate specific instruction(FETCH GROUP NEXT ROW) missing from the aggregate function
WARN_VERS_PART_FULL
Versioned table %s.%s: last HISTORY partition (%`s) is out of %s, need more HISTORY partitions
ER_VERS_ALTER_NOT_ALLOWED
Not allowed for system-versioned %s.%s. Change @@system_versioning_alter_history to proceed with ALTER.
ER_VERS_ALTER_ENGINE_PROHIBITED
Not allowed for system-versioned %s.%s. Change to/from native system versioning engine is not supported.
ER_VERS_WRONG_PARTS
Wrong partitions for %`s: must have at least one HISTORY and exactly one last CURRENT
ER_DROP_VERSIONING_SYSTEM_TIME_PARTITION
Can not DROP SYSTEM VERSIONING for table %`s partitioned BY SYSTEM_TIME
ER_VERS_TRX_PART_HISTORIC_ROW_NOT_SUPPORTED
Transaction-precise system-versioned tables do not support partitioning by ROW START or ROW END
ER_UPDATED_COLUMN_ONLY_ONCE
The column %s.%s cannot be changed more than once in a single UPDATE statement
ER_EMPTY_ROW_IN_TVC
Row with no elements is not allowed in table value constructor in this context
ER_ALTER_OPERATION_TABLE_OPTIONS_NEED_REBUILD
Changing table options requires the table to be rebuilt
ER_BACKUP_UNKNOWN_STAGE
Unknown backup stage: '%s'. Stage should be one of START, FLUSH, BLOCK_DDL, BLOCK_COMMIT or END
ER_USER_IS_BLOCKED
User is blocked because of too many credential errors; unblock with 'FLUSH PRIVILEGES'
ER_PART_STARTS_BEYOND_INTERVAL
%`s: STARTS is later than query time, first history partition may exceed INTERVAL value
ER_GALERA_REPLICATION_NOT_SUPPORTED
DDL-statement is forbidden as table storage engine does not support Galera replication
HY000
ER_LOAD_INFILE_CAPABILITY_DISABLED
The used command is not allowed because the MariaDB server or client has disabled the local infile capability
ER_NO_SECURE_TRANSPORTS_CONFIGURED
No secure transports are configured, unable to set --require_secure_transport=ON
ER_DATA_WAS_COMMITED_UNDER_ROLLBACK
Engine %s does not support rollback. Changes were committed during rollback call
ER_JSON_TABLE_SCALAR_EXPECTED
Can't store an array or an object in the scalar column '%s' of JSON_TABLE '%s'.
ER_JSON_TABLE_MULTIPLE_MATCHES
Can't store multiple matches of the path in the column '%s' of JSON_TABLE '%s'.
ER_REMOVED_ORPHAN_TRIGGER
Dropped orphan trigger '%-.64s', originally created for table: '%-.192s'
ER_SLAVE_STATEMENT_TIMEOUT
Slave log event execution was interrupted (slave_max_statement_time exceeded)
ER_PSEUDO_THREAD_ID_OVERWRITE
Pseudo thread id should not be modified by the client as it will be overwritten
ER_VARIABLE_IGNORED
The variable '%s' is ignored. It only exists for compatibility with old installations and will be removed in a future release
WARN_SORTING_ON_TRUNCATED_LENGTH
Values were longer than max_sort_length. Sorting used only the first bytes.
ER_VECTOR_BINARY_FORMAT_INVALID
Invalid binary vector format. Must use IEEE standard float representation in little-endian format. Use VEC_FromText() to generate it.
ER_VECTOR_FORMAT_INVALID
Invalid vector format at offset: %d for '%-.100s'. Must be a valid JSON array of numbers.
This page is licensed: CC BY-SA / Gnu FDL
Below is a partial list of more common Linux and Windows operating system error codes.
The perror tool can be used to find the error message which is associated with a given error code.
1
EPERM
Operation not permitted
2
ENOENT
No such file or directory
3
ESRCH
No such process
4
EINTR
Interrupted system call
5
EIO
I/O error
6
ENXIO
No such device or address
7
E2BIG
Argument list too long
8
ENOEXEC
Exec format error
9
EBADF
Bad file number
10
ECHILD
No child processes
11
EAGAIN
Try again
12
ENOMEM
Out of memory
13
EACCES
Permission denied
14
EFAULT
Bad address
15
ENOTBLK
Block device required
16
EBUSY
Device or resource busy
17
EEXIST
File exists
18
EXDEV
Cross-device link
19
ENODEV
No such device
20
ENOTDIR
Not a directory
21
EISDIR
Is a directory
22
EINVAL
Invalid argument
23
ENFILE
File table overflow
24
EMFILE
Too many open files
25
ENOTTY
Not a typewriter
26
ETXTBSY
Text file busy
27
EFBIG
File too large
28
ENOSPC
No space left on device
29
ESPIPE
Illegal seek
30
EROFS
Read-only file system
31
EMLINK
Too many links
32
EPIPE
Broken pipe
33
EDOM
Math argument out of domain of func
34
ERANGE
Math result not representable
35
EDEADLK
Resource deadlock would occur
36
ENAMETOOLONG
File name too long
37
ENOLCK
No record locks available
38
ENOSYS
Function not implemented
39
ENOTEMPTY
Directory not empty
40
ELOOP
Too many symbolic links encountered
42
ENOMSG
No message of desired type
43
EIDRM
Identifier removed
44
ECHRNG
Channel number out of range
45
EL2NSYNC
Level 2 not synchronized
46
EL3HLT
Level 3 halted
47
EL3RST
Level 3 reset
48
ELNRNG
Link number out of range
49
EUNATCH
Protocol driver not attached
50
ENOCSI
No CSI structure available
51
EL2HLT
Level 2 halted
52
EBADE
Invalid exchange
53
EBADR
Invalid request descriptor
54
EXFULL
Exchange full
55
ENOANO
No anode
56
EBADRQC
Invalid request code
57
EBADSLT
Invalid slot
59
EBFONT
Bad font file format
60
ENOSTR
Device not a stream
61
ENODATA
No data available
62
ETIME
Timer expired
63
ENOSR
Out of streams resources
64
ENONET
Machine is not on the network
65
ENOPKG
Package not installed
66
EREMOTE
Object is remote
67
ENOLINK
Link has been severed
68
EADV
Advertise error
69
ESRMNT
Srmount error
70
ECOMM
Communication error on send
71
EPROTO
Protocol error
72
EMULTIHOP
Multihop attempted
73
EDOTDOT
RFS specific error
74
EBADMSG
Not a data message
75
EOVERFLOW
Value too large for defined data type
76
ENOTUNIQ
Name not unique on network
77
EBADFD
File descriptor in bad state
78
EREMCHG
Remote address changed
79
ELIBACC
Can not access a needed shared library
80
ELIBBAD
Accessing a corrupted shared library
81
ELIBSCN
.lib section in a.out corrupted
82
ELIBMAX
Attempting to link in too many shared libraries
83
ELIBEXEC
Cannot exec a shared library directly
84
EILSEQ
Illegal byte sequence
85
ERESTART
Interrupted system call should be restarted
86
ESTRPIPE
Streams pipe error
87
EUSERS
Too many users
88
ENOTSOCK
Socket operation on non-socket
89
EDESTADDRREQ
Destination address required
90
EMSGSIZE
Message too long
91
EPROTOTYPE
Protocol wrong type for socket
92
ENOPROTOOPT
Protocol not available
93
EPROTONOSUPPORT
Protocol not supported
94
ESOCKTNOSUPPORT
Socket type not supported
95
EOPNOTSUPP
Operation not supported on transport endpoint
96
EPFNOSUPPORT
Protocol family not supported
97
EAFNOSUPPORT
Address family not supported by protocol
98
EADDRINUSE
Address already in use
99
EADDRNOTAVAIL
Cannot assign requested address
100
ENETDOWN
Network is down
101
ENETUNREACH
Network is unreachable
102
ENETRESET
Network dropped connection because of reset
103
ECONNABORTED
Software caused connection abort
104
ECONNRESET
Connection reset by peer
105
ENOBUFS
No buffer space available
106
EISCONN
Transport endpoint is already connected
107
ENOTCONN
Transport endpoint is not connected
108
ESHUTDOWN
Cannot send after transport endpoint shutdown
109
ETOOMANYREFS
Too many references: cannot splice
110
ETIMEDOUT
Connection timed out
111
ECONNREFUSED
Connection refused
112
EHOSTDOWN
Host is down
113
EHOSTUNREACH
No route to host
114
EALREADY
Operation already in progress
115
EINPROGRESS
Operation now in progress
116
ESTALE
Stale NFS file handle
117
EUCLEAN
Structure needs cleaning
118
ENOTNAM
Not a XENIX named type file
119
ENAVAIL
No XENIX semaphores available
120
EISNAM
Is a named type file
121
EREMOTEIO
Remote I/O error
122
EDQUOT
Quota exceeded
123
ENOMEDIUM
No medium found
124
EMEDIUMTYPE
Wrong medium type
125
ECANCELED
Operation Canceled
126
ENOKEY
Required key not available
127
EKEYEXPIRED
Key has expired
128
EKEYREVOKED
Key has been revoked
129
EKEYREJECTED
Key was rejected by service
130
EOWNERDEAD
Owner died
131
ENOTRECOVERABLE
State not recoverable
For a complete list, see ms681381.aspx
1
ERROR_INVALID_FUNCTION
Incorrect function.
2
ERROR_FILE_NOT_FOUND
The system cannot find the file specified.
3
ERROR_PATH_NOT_FOUND
The system cannot find the path specified.
4
ERROR_TOO_MANY_OPEN_FILES
The system cannot open the file.
5
ERROR_ACCESS_DENIED
Access is denied.
6
ERROR_INVALID_HANDLE
The handle is invalid.
7
ERROR_ARENA_TRASHED
The storage control blocks were destroyed.
8
ERROR_NOT_ENOUGH_MEMORY
Not enough storage is available to process this command.
9
ERROR_INVALID_BLOCK
The storage control block address is invalid.
10
ERROR_BAD_ENVIRONMENT
The environment is incorrect.
11
ERROR_BAD_FORMAT
An attempt was made to load a program with an incorrect format.
12
ERROR_INVALID_ACCESS
The access code is invalid.
13
ERROR_INVALID_DATA
The data is invalid.
14
ERROR_OUTOFMEMORY
Not enough storage is available to complete this operation.
15
ERROR_INVALID_DRIVE
The system cannot find the drive specified.
16
ERROR_CURRENT_DIRECTORY
The directory cannot be removed.
17
ERROR_NOT_SAME_DEVICE
The system cannot move the file to a different disk drive.
18
ERROR_NO_MORE_FILES
There are no more files.
19
ERROR_WRITE_PROTECT
The media is write protected.
20
ERROR_BAD_UNIT
The system cannot find the device specified.
21
ERROR_NOT_READY
The device is not ready.
22
ERROR_BAD_COMMAND
The device does not recognize the command.
23
ERROR_CRC
Data error (cyclic redundancy check).
24
ERROR_BAD_LENGTH
The program issued a command but the command length is incorrect.
25
ERROR_SEEK
The drive cannot locate a specific area or track on the disk.
26
ERROR_NOT_DOS_DISK
The specified disk or diskette cannot be accessed.
27
ERROR_SECTOR_NOT_FOUND
The drive cannot find the sector requested.
28
ERROR_OUT_OF_PAPER
The printer is out of paper.
29
ERROR_WRITE_FAULT
The system cannot write to the specified device.
30
ERROR_READ_FAULT
The system cannot read from the specified device.
31
ERROR_GEN_FAILURE
A device attached to the system is not functioning.
32
ERROR_SHARING_VIOLATION
The process cannot access the file because it is being used by another process.
33
ERROR_LOCK_VIOLATION
The process cannot access the file because another process has locked a portion of the file.
34
ERROR_WRONG_DISK
The wrong diskette is in the drive. Insert %2 (Volume Serial Number: %3) into drive %1.
36
ERROR_SHARING_BUFFER_EXCEEDED
Too many files opened for sharing.
38
ERROR_HANDLE_EOF
Reached the end of the file.
39
ERROR_HANDLE_DISK_FULL
The disk is full.
87
ERROR_INVALID_PARAMETER
The parameter is incorrect.
112
ERROR_DISK_FULL
The disk is full.
123
ERROR_INVALID_NAME
The file name, directory name, or volume label syntax is incorrect.
1450
ERROR_NO_SYSTEM_RESOURCES
Insufficient system resources exist to complete the requested service.
This page is licensed: CC BY-SA / Gnu FDL
1000
HY000
ER_HASHCHK
hashchk
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1001
HY000
ER_NISAMCHK
isamchk
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1002
HY000
ER_NO
NO
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1003
HY000
ER_YES
YES
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1004
HY000
ER_CANT_CREATE_FILE
Can't create file '%s' (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1005
HY000
ER_CANT_CREATE_TABLE
Can't create table '%s' (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1006
HY000
ER_CANT_CREATE_DB
Can't create database '%s' (errno: %d)
The server has insufficient free disk space to create the database. Free up space and retry.
There may be a file permission issue on the data directories. Check both the user and group permissions and set accordingly.
This page is licensed: CC BY-SA / Gnu FDL
1007
HY000
ER_DB_CREATE_EXISTS
Can't create database '%s'; database exists
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1008
HY000
ER_DB_DROP_EXISTS
Can't drop database '%s'; database doesn't exist
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1009
HY000
ER_DB_DROP_DELETE
Error dropping database (can't delete '%s', errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1010
HY000
ER_DB_DROP_RMDIR
Error dropping database (can't rmdir '%s', errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1011
HY000
ER_CANT_DELETE_FILE
Error on delete of '%s' (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1012
HY000
ER_CANT_FIND_SYSTEM_REC
Can't read record in system table
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1013
HY000
ER_CANT_GET_STAT
Can't get status of '%s' (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1014
HY000
ER_CANT_GET_WD
Can't get working directory (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1015
HY000
ER_CANT_LOCK
Can't lock file (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1016
HY000
ER_CANT_OPEN_FILE
Can't open file: '%s' (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1017
HY000
ER_FILE_NOT_FOUND
Can't find file: '%s' (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1018
HY000
ER_CANT_READ_DIR
Can't read dir of '%s' (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1019
HY000
ER_CANT_SET_WD
Can't change dir to '%s' (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1020
HY000
ER_CHECKREAD
Record has changed since last read in table '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1021
HY000
ER_DISK_FULL
Disk full (%s); waiting for someone to free some space...
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1022
23000
ER_DUP_KEY
Can't write; duplicate key in table '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1023
HY000
ER_ERROR_ON_CLOSE
Error on close of '%s' (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1024
HY000
ER_ERROR_ON_READ
Error reading file '%s' (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1025
HY000
ER_ERROR_ON_RENAME
Error on rename of '%s' to '%s' (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1026
HY000
ER_ERROR_ON_WRITE
Error writing file '%s' (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1027
HY000
ER_FILE_USED
'%s' is locked against change
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1028
HY000
ER_FILSORT_ABORT
Sort aborted
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1029
HY000
ER_FORM_NOT_FOUND
View '%s' doesn't exist for '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1030
HY000
ER_GET_ERRN
Got error %d from storage engine
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1031
HY000
ER_ILLEGAL_HA
Table storage engine for '%s' doesn't have this option
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1032
HY000
ER_KEY_NOT_FOUND
Can't find record in '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1033
HY000
ER_NOT_FORM_FILE
Incorrect information in file: '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1034
HY000
ER_NOT_KEYFILE
Incorrect key file for table '%s'; try to repair it
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1035
HY000
ER_OLD_KEYFILE
Old key file for table '%s'; repair it!
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1036
HY000
ER_OPEN_AS_READONLY
Table '%s' is read only
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1038
HY001
ER_OUT_OF_SORTMEMORY
Out of sort memory, consider increasing server sort buffer size
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1038
HY001
ER_OUT_OF_SORTMEMORY
Out of sort memory, consider increasing server sort buffer size
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1039
HY000
ER_UNEXPECTED_EOF
Unexpected EOF found when reading file '%s' (Errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1040
08004
ER_CON_COUNT_ERROR
Too many connections
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1041
HY000
ER_OUT_OF_RESOURCES
Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1042
08S01
ER_BAD_HOST_ERROR
Can't get hostname for your address
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1043
08S01
ER_HANDSHAKE_ERROR
Bad handshake
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1044
42000
ER_DBACCESS_DENIED_ERROR
Access denied for user '%s'@'%s' to database '%s'
The user is trying to access a database/schema they do not have access to. See Troubleshooting Connection Issues for more, as well as GRANT for details on setting permissions.
This page is licensed: CC BY-SA / Gnu FDL
1045
28000
ER_ACCESS_DENIED_ERROR
Access denied for user '%s'@'%s' (using password: %s)
The user/password combination does not exist or the user does not have privileges to the given database. See Troubleshooting Connection Issues for more, as well as GRANT for details on setting permissions.
This page is licensed: CC BY-SA / Gnu FDL
1046
3D000
ER_NO_DB_ERROR
No database selected
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1047
08S01
ER_UNKNOWN_COM_ERROR
Unknown command
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1048
23000
ER_BAD_NULL_ERROR
Column '%s' cannot be null
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1049
42000
ER_BAD_DB_ERROR
Unknown database '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1050
42S01
ER_TABLE_EXISTS_ERROR
Table '%s' already exists
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1051
42S02
ER_BAD_TABLE_ERROR
Unknown table '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1052
23000
ER_NON_UNIQ_ERROR
Column '%s' in %s is ambiguous
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1053
08S01
ER_SERVER_SHUTDOWN
Server shutdown in progress
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1054
42S22
ER_BAD_FIELD_ERROR
Unknown column '%s' in '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1055
42000
ER_WRONG_FIELD_WITH_GROUP
'%s' isn't in GROUP BY
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1056
42000
ER_WRONG_GROUP_FIELD
Can't group on '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1057
42000
ER_WRONG_SUM_SELECT
Statement has sum functions and columns in same statement
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1058
21S01
ER_WRONG_VALUE_COUNT
Column count doesn't match value count
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1059
42000
ER_TOO_LONG_IDENT
Identifier name '%s' is too long
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1060
42S21
ER_DUP_FIELDNAME
Duplicate column name '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1061
42000
ER_DUP_KEYNAME
Duplicate key name '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1062
23000
ER_DUP_ENTRY
Duplicate entry '%s' for key %d
This error occurs when a key that requires a unique value (unique or primary) instead receives a duplicate. For example:
CREATE TABLE t1 (
id INT AUTO_INCREMENT PRIMARY KEY,
f VARCHAR(10) UNIQUE
);
INSERT INTO t1 (f) VALUES ('a'),('b');
SELECT * FROM t1;
+----+------+
| id | f |
+----+------+
| 1 | a |
| 2 | b |
+----+------+
INSERT INTO t1 (f) VALUES ('b'),('c');
ERROR 1062 (23000): Duplicate entry 'b' for key 'f'Solve the error by either not attempting to insert a duplicate value, or not requiring the key to be unique. For example, the below replaces the unique index with an index permitting duplicates:
ALTER TABLE t1 DROP INDEX f, ADD INDEX (f);
INSERT INTO t1 (f) VALUES ('b'),('c');
SELECT * FROM t1;
+----+------+
| id | f |
+----+------+
| 1 | a |
| 2 | b |
| 3 | b |
| 4 | c |
+----+------+This page is licensed: CC BY-SA / Gnu FDL
1063
42000
ER_WRONG_FIELD_SPEC
Incorrect column specifier for column '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1064
42000
ER_PARSE_ERROR
%s near '%s' at line %d
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1065
42000
ER_EMPTY_QUERY
Query was empty
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1066
42000
ER_NONUNIQ_TABLE
Not unique table/alias: '%s'
In order to avoid ambiguity, a table name or alias must uniquely identify an object. There are many situations where this could occur.
For example, HANDLER statements use unqualified table names, requiring the use of an alias in certain contexts. For example:
CREATE TABLE t1 (f1 INT);
INSERT INTO t1 VALUES (1),(2),(3);
HANDLER t1 OPEN;
HANDLER t1 READ NEXT;
+------+
| f1 |
+------+
| 1 |
+------+
HANDLER t1 READ NEXT;
+------+
| f1 |
+------+
| 2 |
+------+In the previous example, the HANDLER was opened with the t1 table name. Since HANDLERs use unqualified table names, trying to access another table with this same name, even though it's in another database, will result in ambiguity. An alias needs to be used to avoid the ambiguity:
CREATE DATABASE db_new;
CREATE TABLE db_new.t1 (id INT);
INSERT INTO db_new.t1 VALUES (4),(5),(6);
HANDLER db_new.t1 OPEN;
ERROR 1066 (42000): Not unique table/alias: 't1'
HANDLER db_new.t1 OPEN AS db_new_t1;
HANDLER db_new_t1 READ NEXT LIMIT 3;
+------+
| id |
+------+
| 4 |
| 5 |
| 6 |
+------+This page is licensed: CC BY-SA / Gnu FDL
1067
42000
ER_INVALID_DEFAULT
Invalid default value for '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1068
42000
ER_MULTIPLE_PRI_KEY
Multiple primary key defined
No more than one primary key can be defined per table. Attempting to define more in a single table will result in this error. For example:
CREATE TABLE t1(
c1 INT NOT NULL AUTO_INCREMENT,
c2 INT NOT NULL,
PRIMARY KEY(c1),
PRIMARY KEY(c2)
);
ERROR 1068 (42000): Multiple primary key defined
CREATE TABLE t1(
c1 INT NOT NULL AUTO_INCREMENT,
c2 INT NOT NULL,
PRIMARY KEY(c1)
);It's also possible that this error results from a mistaken attempt to define a multi-part primary key. This is an example of the correct definition for such a key.
CREATE TABLE t1(
c1 INT NOT NULL AUTO_INCREMENT,
c2 INT NOT NULL,
PRIMARY KEY(c1, c2)
);This page is licensed: CC BY-SA / Gnu FDL
1069
42000
ER_TOO_MANY_KEYS
Too many keys specified; max %d keys allowed
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1070
42000
ER_TOO_MANY_KEY_PARTS
Too many key parts specified; max %d parts allowed
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1071
42000
ER_TOO_LONG_KEY
Specified key was too long; max key length is %d bytes
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1072
42000
ER_KEY_COLUMN_DOES_NOT_EXITS
Key column '%s' doesn't exist in table
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1073
42000
ER_BLOB_USED_AS_KEY
BLOB column '%s' can't be used in key specification with the used table type
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1074
42000
ER_TOO_BIG_FIELDLENGTH
Column length too big for column '%s' (max = %lu); use BLOB or TEXT instead
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1075
42000
ER_WRONG_AUTO_KEY
Incorrect table definition; there can be only one auto column and it must be defined as a key
There can only be one AUTO_INCREMENT column per table, and the column must be defined as a key. Not adhering to either of these restrictions will result in this error. For example:
CREATE OR REPLACE TABLE animals (
id1 MEDIUMINT NOT NULL AUTO_INCREMENT,
id2 TINYINT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY (id1),
KEY (id2)
);
ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key
CREATE OR REPLACE TABLE animals (
id1 MEDIUMINT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL
);
ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key
CREATE OR REPLACE TABLE animals (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY (id)
);
Query OK, 0 rows affected (0.017 sec)This page is licensed: CC BY-SA / Gnu FDL
1076
HY000
ER_READY
%s: ready for connections. Version: '%s' socket: '%s' port: %d
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1077
HY000
ER_NORMAL_SHUTDOWN
%s: Normal shutdown
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1078
HY000
ER_GOT_SIGNAL
%s: Got signal %d. Aborting!
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1079
HY000
ER_SHUTDOWN_COMPLETE
%s: Shutdown complete
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1080
08S01
ER_FORCING_CLOSE
%s: Forcing close of thread %ld user: '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1081
08S01
ER_IPSOCK_ERROR
Can't create IP socket
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1082
42S12
ER_NO_SUCH_INDEX
Table '%s' has no index like the one used in CREATE INDEX; recreate the table
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1083
42000
ER_WRONG_FIELD_TERMINATORS
Field separator argument is not what is expected; check the manual
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1084
42000
ER_BLOBS_AND_NO_TERMINATED
You can't use fixed rowlength with BLOBs; please use 'fields terminated by'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1085
HY000
ER_TEXTFILE_NOT_READABLE
The file '%s' must be in the database directory or be readable by all
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1086
HY000
ER_FILE_EXISTS_ERROR
File '%s' already exists
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1087
HY000
ER_LOAD_INF
Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1088
HY000
ER_ALTER_INF
Records: %ld Duplicates: %ld
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1089
HY000
ER_WRONG_SUB_KEY
Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1090
42000
ER_CANT_REMOVE_ALL_FIELDS
You can't delete all columns with ALTER TABLE; use DROP TABLE instead
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1091
42000
ER_CANT_DROP_FIELD_OR_KEY
Can't DROP '%s'; check that column/key exists
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1092
HY000
ER_INSERT_INF
Records: %ld Duplicates: %ld Warnings: %ld
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1093
HY000
ER_UPDATE_TABLE_USED
You can't specify target table '%s' for update in FROM clause
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1094
HY000
ER_NO_SUCH_THREAD
Unknown thread id: %lu
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1095
HY000
ER_KILL_DENIED_ERROR
You are not owner of thread %lu
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL