W3cubDocs

/MariaDB

MariaDB Error Codes

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:

MariaDB [(none)]> SELECT * FROM x;
ERROR 1046 (3D000): No database selected

There 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. Also, the perror tool can be used to get the error message which is associated with a given error code.

Shared MariaDB/MySQL error codes

Error Code SQLSTATE Error Description
1000 HY000 ER_HASHCHK hashchk
1001 HY000 ER_NISAMCHK isamchk
1002 HY000 ER_NO NO
1003 HY000 ER_YES YES
1004 HY000 ER_CANT_CREATE_FILE Can't create file '%s' (errno: %d)
1005 HY000 ER_CANT_CREATE_TABLE Can't create table '%s' (errno: %d)
1006 HY000 ER_CANT_CREATE_DB Can't create database '%s' (errno: %d
1007 HY000 ER_DB_CREATE_EXISTS Can't create database '%s'; database exists
1008 HY000 ER_DB_DROP_EXISTS Can't drop database '%s'; database doesn't exist
1009 HY000 ER_DB_DROP_DELETE Error dropping database (can't delete '%s', errno: %d)
1010 HY000 ER_DB_DROP_RMDIR Error dropping database (can't rmdir '%s', errno: %d)
1011 HY000 ER_CANT_DELETE_FILE Error on delete of '%s' (errno: %d)
1012 HY000 ER_CANT_FIND_SYSTEM_REC Can't read record in system table
1013 HY000 ER_CANT_GET_STAT Can't get status of '%s' (errno: %d)
1014 HY000 ER_CANT_GET_WD Can't get working directory (errno: %d)
1015 HY000 ER_CANT_LOCK Can't lock file (errno: %d)
1016 HY000 ER_CANT_OPEN_FILE Can't open file: '%s' (errno: %d)
1017 HY000 ER_FILE_NOT_FOUND Can't find file: '%s' (errno: %d)
1018 HY000 ER_CANT_READ_DIR Can't read dir of '%s' (errno: %d)
1019 HY000 ER_CANT_SET_WD Can't change dir to '%s' (errno: %d)
1020 HY000 ER_CHECKREAD Record has changed since last read in table '%s'
1021 HY000 ER_DISK_FULL Disk full (%s); waiting for someone to free some space...
1022 23000 ER_DUP_KEY Can't write; duplicate key in table '%s'
1023 HY000 ER_ERROR_ON_CLOSE Error on close of '%s' (errno: %d)
1024 HY000 ER_ERROR_ON_READ Error reading file '%s' (errno: %d)
1025 HY000 ER_ERROR_ON_RENAME Error on rename of '%s' to '%s' (errno: %d)
1026 HY000 ER_ERROR_ON_WRITE Error writing file '%s' (errno: %d)
1027 HY000 ER_FILE_USED '%s' is locked against change
1028 HY000 ER_FILSORT_ABORT Sort aborted
1029 HY000 ER_FORM_NOT_FOUND View '%s' doesn't exist for '%s'
1030 HY000 ER_GET_ERRN Got error %d from storage engine
1031 HY000 ER_ILLEGAL_HA Table storage engine for '%s' doesn't have this option
1032 HY000 ER_KEY_NOT_FOUND Can't find record in '%s'
1033 HY000 ER_NOT_FORM_FILE Incorrect information in file: '%s'
1034 HY000 ER_NOT_KEYFILE Incorrect key file for table '%s'; try to repair it
1035 HY000 ER_OLD_KEYFILE Old key file for table '%s'; repair it!
1036 HY000 ER_OPEN_AS_READONLY Table '%s' is read only
1037 HY001 ER_OUTOFMEMORY Out of memory; restart server and try again (needed %d bytes)
1038 HY001 ER_OUT_OF_SORTMEMORY Out of sort memory, consider increasing server sort buffer size
1039 HY000 ER_UNEXPECTED_EOF Unexpected EOF found when reading file '%s' (Errno: %d)
1040 08004 ER_CON_COUNT_ERROR Too many connections
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
1042 08S01 ER_BAD_HOST_ERROR Can't get hostname for your address
1043 08S01 ER_HANDSHAKE_ERROR Bad handshake
1044 42000 ER_DBACCESS_DENIED_ERROR Access denied for user '%s'@'%s' to database '%s'
1045 28000 ER_ACCESS_DENIED_ERROR Access denied for user '%s'@'%s' (using password: %s)
1046 3D000 ER_NO_DB_ERROR No database selected
1047 08S01 ER_UNKNOWN_COM_ERROR Unknown command
1048 23000 ER_BAD_NULL_ERROR Column '%s' cannot be null
1049 42000 ER_BAD_DB_ERROR Unknown database '%s'
1050 42S01 ER_TABLE_EXISTS_ERROR Table '%s' already exists
1051 42S02 ER_BAD_TABLE_ERROR Unknown table '%s'
1052 23000 ER_NON_UNIQ_ERROR Column '%s' in %s is ambiguous
1053 08S01 ER_SERVER_SHUTDOWN Server shutdown in progress
1054 42S22 ER_BAD_FIELD_ERROR Unknown column '%s' in '%s'
1055 42000 ER_WRONG_FIELD_WITH_GROUP '%s' isn't in GROUP BY
1056 42000 ER_WRONG_GROUP_FIELD Can't group on '%s'
1057 42000 ER_WRONG_SUM_SELECT Statement has sum functions and columns in same statement
1058 21S01 ER_WRONG_VALUE_COUNT Column count doesn't match value count
1059 42000 ER_TOO_LONG_IDENT Identifier name '%s' is too long
1060 42S21 ER_DUP_FIELDNAME Duplicate column name '%s'
1061 42000 ER_DUP_KEYNAME Duplicate key name '%s'
1062 23000 ER_DUP_ENTRY Duplicate entry '%s' for key %d
1063 42000 ER_WRONG_FIELD_SPEC Incorrect column specifier for column '%s'
1064 42000 ER_PARSE_ERROR %s near '%s' at line %d
1065 42000 ER_EMPTY_QUERY Query was empty
1066 42000 ER_NONUNIQ_TABLE Not unique table/alias: '%s'
1067 42000 ER_INVALID_DEFAULT Invalid default value for '%s'
1068 42000 ER_MULTIPLE_PRI_KEY Multiple primary key defined
1069 42000 ER_TOO_MANY_KEYS Too many keys specified; max %d keys allowed
1070 42000 ER_TOO_MANY_KEY_PARTS Too many key parts specified; max %d parts allowed
1071 42000 ER_TOO_LONG_KEY Specified key was too long; max key length is %d bytes
1072 42000 ER_KEY_COLUMN_DOES_NOT_EXITS Key column '%s' doesn't exist in table
1073 42000 ER_BLOB_USED_AS_KEY BLOB column '%s' can't be used in key specification with the used table type
1074 42000 ER_TOO_BIG_FIELDLENGTH Column length too big for column '%s' (max = %lu); use BLOB or TEXT instead
1075 42000 ER_WRONG_AUTO_KEY Incorrect table definition; there can be only one auto column and it must be defined as a key
1076 HY000 ER_READY %s: ready for connections. Version: '%s' socket: '%s' port: %d
1077 HY000 ER_NORMAL_SHUTDOWN %s: Normal shutdown
1078 HY000 ER_GOT_SIGNAL %s: Got signal %d. Aborting!
1079 HY000 ER_SHUTDOWN_COMPLETE %s: Shutdown complete
1080 08S01 ER_FORCING_CLOSE %s: Forcing close of thread %ld user: '%s'
1081 08S01 ER_IPSOCK_ERROR Can't create IP socket
1082 42S12 ER_NO_SUCH_INDEX Table '%s' has no index like the one used in CREATE INDEX; recreate the table
1083 42000 ER_WRONG_FIELD_TERMINATORS Field separator argument is not what is expected; check the manual
1084 42000 ER_BLOBS_AND_NO_TERMINATED You can't use fixed rowlength with BLOBs; please use 'fields terminated by'
1085 HY000 ER_TEXTFILE_NOT_READABLE The file '%s' must be in the database directory or be readable by all
1086 HY000 ER_FILE_EXISTS_ERROR File '%s' already exists
1087 HY000 ER_LOAD_INF Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld
1088 HY000 ER_ALTER_INF Records: %ld Duplicates: %ld
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
1090 42000 ER_CANT_REMOVE_ALL_FIELDS You can't delete all columns with ALTER TABLE; use DROP TABLE instead
1091 42000 ER_CANT_DROP_FIELD_OR_KEY Can't DROP '%s'; check that column/key exists
1092 HY000 ER_INSERT_INF Records: %ld Duplicates: %ld Warnings: %ld
1093 HY000 ER_UPDATE_TABLE_USED You can't specify target table '%s' for update in FROM clause
1094 HY000 ER_NO_SUCH_THREAD Unknown thread id: %lu
1095 HY000 ER_KILL_DENIED_ERROR You are not owner of thread %lu
1096 HY000 ER_NO_TABLES_USED No tables used
1097 HY000 ER_TOO_BIG_SET Too many strings for column %s and SET
1098 HY000 ER_NO_UNIQUE_LOGFILE Can't generate a unique log-filename %s.(1-999)
1099 HY000 ER_TABLE_NOT_LOCKED_FOR_WRITE Table '%s' was locked with a READ lock and can't be updated
Error Code SQLSTATE Error Description
1100 HY000 ER_TABLE_NOT_LOCKED Table '%s' was not locked with LOCK TABLES
1101 42000 ER_BLOB_CANT_HAVE_DEFAULT BLOB/TEXT column '%s' can't have a default value
1102 42000 ER_WRONG_DB_NAME Incorrect database name '%s'
1103 42000 ER_WRONG_TABLE_NAME Incorrect table name '%s'
1104 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
1105 HY000 ER_UNKNOWN_ERROR Unknown error
1106 42000 ER_UNKNOWN_PROCEDURE Unknown procedure '%s'
1107 42000 ER_WRONG_PARAMCOUNT_TO_PROCEDURE Incorrect parameter count to procedure '%s'
1108 HY000 ER_WRONG_PARAMETERS_TO_PROCEDURE Incorrect parameters to procedure '%s'
1109 42S02 ER_UNKNOWN_TABLE Unknown table '%s' in %s
1110 42000 ER_FIELD_SPECIFIED_TWICE Column '%s' specified twice
1111 HY000 ER_INVALID_GROUP_FUNC_USE Invalid use of group function
1112 42000 ER_UNSUPPORTED_EXTENSION Table '%s' uses an extension that doesn't exist in this MariaDB version
1113 42000 ER_TABLE_MUST_HAVE_COLUMNS A table must have at least 1 column
1114 HY000 ER_RECORD_FILE_FULL The table '%s' is full
1115 42000 ER_UNKNOWN_CHARACTER_SET Unknown character set: '%s'
1116 HY000 ER_TOO_MANY_TABLES Too many tables; MariaDB can only use %d tables in a join
1117 HY000 ER_TOO_MANY_FIELDS Too many columns
1118 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
1119 HY000 ER_STACK_OVERRUN Thread stack overrun: Used: %ld of a %ld stack. Use 'mysqld --thread_stack=#' to specify a bigger stack if needed
1120 42000 ER_WRONG_OUTER_JOIN Cross dependency found in OUTER JOIN; examine your ON conditions
1121 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
1122 HY000 ER_CANT_FIND_UDF Can't load function '%s'
1123 HY000 ER_CANT_INITIALIZE_UDF Can't initialize function '%s'; %s
1124 HY000 ER_UDF_NO_PATHS No paths allowed for shared library
1125 HY000 ER_UDF_EXISTS Function '%s' already exists
1126 HY000 ER_CANT_OPEN_LIBRARY Can't open shared library '%s' (Errno: %d %s)
1127 HY000 ER_CANT_FIND_DL_ENTRY Can't find symbol '%s' in library
1128 HY000 ER_FUNCTION_NOT_DEFINED Function '%s' is not defined
1129 HY000 ER_HOST_IS_BLOCKED Host '%s' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
1130 HY000 ER_HOST_NOT_PRIVILEGED Host '%s' is not allowed to connect to this MariaDB server
1131 42000 ER_PASSWORD_ANONYMOUS_USER You are using MariaDB as an anonymous user and anonymous users are not allowed to change passwords
1132 42000 ER_PASSWORD_NOT_ALLOWED You must have privileges to update tables in the mysql database to be able to change passwords for others
1133 42000 ER_PASSWORD_NO_MATCH Can't find any matching row in the user table
1134 HY000 ER_UPDATE_INF Rows matched: %ld Changed: %ld Warnings: %ld
1135 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
1136 21S01 ER_WRONG_VALUE_COUNT_ON_ROW Column count doesn't match value count at row %ld
1137 HY000 ER_CANT_REOPEN_TABLE Can't reopen table: '%s'
1138 22004 ER_INVALID_USE_OF_NULL Invalid use of NULL value
1139 42000 ER_REGEXP_ERROR Got error '%s' from regexp
1140 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
1141 42000 ER_NONEXISTING_GRANT There is no such grant defined for user '%s' on host '%s'
1142 42000 ER_TABLEACCESS_DENIED_ERROR %s command denied to user '%s'@'%s' for table '%s'
1143 42000 ER_COLUMNACCESS_DENIED_ERROR %s command denied to user '%s'@'%s' for column '%s' in table '%s'
1144 42000 ER_ILLEGAL_GRANT_FOR_TABLE Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used
1145 42000 ER_GRANT_WRONG_HOST_OR_USER The host or user argument to GRANT is too long
1146 42S02 ER_NO_SUCH_TABLE Table '%s.%s' doesn't exist
1147 42000 ER_NONEXISTING_TABLE_GRANT There is no such grant defined for user '%s' on host '%s' on table '%s'
1148 42000 ER_NOT_ALLOWED_COMMAND The used command is not allowed with this MariaDB version
1149 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
1150 HY000 ER_DELAYED_CANT_CHANGE_LOCK Delayed insert thread couldn't get requested lock for table %s
1151 HY000 ER_TOO_MANY_DELAYED_THREADS Too many delayed threads in use
1152 08S01 ER_ABORTING_CONNECTION Aborted connection %ld to db: '%s' user: '%s' (%s)
1153 08S01 ER_NET_PACKET_TOO_LARGE Got a packet bigger than 'max_allowed_packet' bytes
1154 08S01 ER_NET_READ_ERROR_FROM_PIPE Got a read error from the connection pipe
1155 08S01 ER_NET_FCNTL_ERROR Got an error from fcntl()
1156 08S01 ER_NET_PACKETS_OUT_OF_ORDER Got packets out of order
1157 08S01 ER_NET_UNCOMPRESS_ERROR Couldn't uncompress communication packet
1158 08S01 ER_NET_READ_ERROR Got an error reading communication packets
1159 08S01 ER_NET_READ_INTERRUPTED Got timeout reading communication packets
1160 08S01 ER_NET_ERROR_ON_WRITE Got an error writing communication packets
1161 08S01 ER_NET_WRITE_INTERRUPTED Got timeout writing communication packets
1162 42000 ER_TOO_LONG_STRING Result string is longer than 'max_allowed_packet' bytes
1163 42000 ER_TABLE_CANT_HANDLE_BLOB The used table type doesn't support BLOB/TEXT columns
1164 42000 ER_TABLE_CANT_HANDLE_AUTO_INCREMENT The used table type doesn't support AUTO_INCREMENT columns
1165 HY000 ER_DELAYED_INSERT_TABLE_LOCKED INSERT DELAYED can't be used with table '%s' because it is locked with LOCK TABLES
1166 42000 ER_WRONG_COLUMN_NAME Incorrect column name '%s'
1167 42000 ER_WRONG_KEY_COLUMN The used storage engine can't index column '%s'
1168 HY000 ER_WRONG_MRG_TABLE Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist
1169 23000 ER_DUP_UNIQUE Can't write, because of unique constraint, to table '%s'
1170 42000 ER_BLOB_KEY_WITHOUT_LENGTH BLOB/TEXT column '%s' used in key specification without a key length
1171 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
1172 42000 ER_TOO_MANY_ROWS Result consisted of more than one row
1173 42000 ER_REQUIRES_PRIMARY_KEY This table type requires a primary key
1174 HY000 ER_NO_RAID_COMPILED This version of MariaDB is not compiled with RAID support
1175 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
1176 42000 ER_KEY_DOES_NOT_EXITS Key '%s' doesn't exist in table '%s'
1177 42000 ER_CHECK_NO_SUCH_TABLE Can't open table
1178 42000 ER_CHECK_NOT_IMPLEMENTED The storage engine for the table doesn't support %s
1179 25000 ER_CANT_DO_THIS_DURING_AN_TRANSACTION You are not allowed to execute this command in a transaction
1180 HY000 ER_ERROR_DURING_COMMIT Got error %d during COMMIT
1181 HY000 ER_ERROR_DURING_ROLLBACK Got error %d during ROLLBACK
1182 HY000 ER_ERROR_DURING_FLUSH_LOGS Got error %d during FLUSH_LOGS
1183 HY000 ER_ERROR_DURING_CHECKPOINT Got error %d during CHECKPOINT
1184 08S01 ER_NEW_ABORTING_CONNECTION Aborted connection %ld to db: '%s' user: '%s' host: '%s' (%s)
1185 HY000 ER_DUMP_NOT_IMPLEMENTED The storage engine for the table does not support binary table dump
1186 HY000 ER_FLUSH_MASTER_BINLOG_CLOSED Binlog closed, cannot RESET MASTER
1187 HY000 ER_INDEX_REBUILD Failed rebuilding the index of dumped table '%s'
1188 HY000 ER_MASTER Error from master: '%s'
1189 08S01 ER_MASTER_NET_READ Net error reading from master
1190 08S01 ER_MASTER_NET_WRITE Net error writing to master
1191 HY000 ER_FT_MATCHING_KEY_NOT_FOUND Can't find FULLTEXT index matching the column list
1192 HY000 ER_LOCK_OR_ACTIVE_TRANSACTION Can't execute the given command because you have active locked tables or an active transaction
1193 HY000 ER_UNKNOWN_SYSTEM_VARIABLE Unknown system variable '%s'
1194 HY000 ER_CRASHED_ON_USAGE Table '%s' is marked as crashed and should be repaired
1195 HY000 ER_CRASHED_ON_REPAIR Table '%s' is marked as crashed and last (automatic?) repair failed
1196 HY000 ER_WARNING_NOT_COMPLETE_ROLLBACK Some non-transactional changed tables couldn't be rolled back
1197 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
1198 HY000 ER_SLAVE_MUST_STOP This operation cannot be performed with a running slave; run STOP SLAVE first
1199 HY000 ER_SLAVE_NOT_RUNNING This operation requires a running slave; configure slave and do START SLAVE
Error Code SQLSTATE Error Description
1200 HY000 ER_BAD_SLAVE The server is not configured as slave; fix in config file or with CHANGE MASTER TO
1201 HY000 ER_MASTER_INF Could not initialize master info structure; more error messages can be found in the MariaDB error log
1202 HY000 ER_SLAVE_THREAD Could not create slave thread; check system resources
1203 42000 ER_TOO_MANY_USER_CONNECTIONS User %s already has more than 'max_user_connections' active connections
1204 HY000 ER_SET_CONSTANTS_ONLY You may only use constant expressions with SET
1205 HY000 ER_LOCK_WAIT_TIMEOUT Lock wait timeout exceeded; try restarting transaction
1206 HY000 ER_LOCK_TABLE_FULL The total number of locks exceeds the lock table size
1207 25000 ER_READ_ONLY_TRANSACTION Update locks cannot be acquired during a READ UNCOMMITTED transaction
1208 HY000 ER_DROP_DB_WITH_READ_LOCK DROP DATABASE not allowed while thread is holding global read lock
1209 HY000 ER_CREATE_DB_WITH_READ_LOCK CREATE DATABASE not allowed while thread is holding global read lock
1210 HY000 ER_WRONG_ARGUMENTS Incorrect arguments to %s
1211 42000 ER_NO_PERMISSION_TO_CREATE_USER '%s'@'%s' is not allowed to create new users
1212 HY000 ER_UNION_TABLES_IN_DIFFERENT_DIR Incorrect table definition; all MERGE tables must be in the same database
1213 40001 ER_LOCK_DEADLOCK Deadlock found when trying to get lock; try restarting transaction
1214 HY000 ER_TABLE_CANT_HANDLE_FT The used table type doesn't support FULLTEXT indexes
1215 HY000 ER_CANNOT_ADD_FOREIGN Cannot add foreign key constraint
1216 23000 ER_NO_REFERENCED_ROW Cannot add or update a child row: a foreign key constraint fails
1217 23000 ER_ROW_IS_REFERENCED Cannot delete or update a parent row: a foreign key constraint fails
1218 08S01 ER_CONNECT_TO_MASTER Error connecting to master: %s
1219 HY000 ER_QUERY_ON_MASTER Error running query on master: %s
1220 HY000 ER_ERROR_WHEN_EXECUTING_COMMAND Error when executing command %s: %s
1221 HY000 ER_WRONG_USAGE Incorrect usage of %s and %s
1222 21000 ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT The used SELECT statements have a different number of columns
1223 HY000 ER_CANT_UPDATE_WITH_READLOCK Can't execute the query because you have a conflicting read lock
1224 HY000 ER_MIXING_NOT_ALLOWED Mixing of transactional and non-transactional tables is disabled
1225 HY000 ER_DUP_ARGUMENT Option '%s' used twice in statement
1226 42000 ER_USER_LIMIT_REACHED User '%s' has exceeded the '%s' resource (current value: %ld)
1227 42000 ER_SPECIFIC_ACCESS_DENIED_ERROR Access denied; you need (at least one of) the %s privilege(s) for this operation
1228 HY000 ER_LOCAL_VARIABLE Variable '%s' is a SESSION variable and can't be used with SET GLOBAL
1229 HY000 ER_GLOBAL_VARIABLE Variable '%s' is a GLOBAL variable and should be set with SET GLOBAL
1230 42000 ER_NO_DEFAULT Variable '%s' doesn't have a default value
1231 42000 ER_WRONG_VALUE_FOR_VAR Variable '%s' can't be set to the value of '%s'
1232 42000 ER_WRONG_TYPE_FOR_VAR Incorrect argument type to variable '%s'
1233 HY000 ER_VAR_CANT_BE_READ Variable '%s' can only be set, not read
1234 42000 ER_CANT_USE_OPTION_HERE Incorrect usage/placement of '%s'
1235 42000 ER_NOT_SUPPORTED_YET This version of MariaDB doesn't yet support '%s'
1236 HY000 ER_MASTER_FATAL_ERROR_READING_BINLOG Got fatal error %d from master when reading data from binary log: '%s'
1237 HY000 ER_SLAVE_IGNORED_TABLE Slave SQL thread ignored the query because of replicate-*-table rules
1238 HY000 ER_INCORRECT_GLOBAL_LOCAL_VAR Variable '%s' is a %s variable
1239 42000 ER_WRONG_FK_DEF Incorrect foreign key definition for '%s': %s
1240 HY000 ER_KEY_REF_DO_NOT_MATCH_TABLE_REF Key reference and table reference don't match
1241 21000 ER_OPERAND_COLUMNS Operand should contain %d column(s)
1242 21000 ER_SUBQUERY_NO_1_ROW Subquery returns more than 1 row
1243 HY000 ER_UNKNOWN_STMT_HANDLER Unknown prepared statement handler (%.*s) given to %s
1244 HY000 ER_CORRUPT_HELP_DB Help database is corrupt or does not exist
1245 HY000 ER_CYCLIC_REFERENCE Cyclic reference on subqueries
1246 HY000 ER_AUTO_CONVERT Converting column '%s' from %s to %s
1247 42S22 ER_ILLEGAL_REFERENCE Reference '%s' not supported (%s)
1248 42000 ER_DERIVED_MUST_HAVE_ALIAS Every derived table must have its own alias
1249 01000 ER_SELECT_REDUCED Select %u was reduced during optimization
1250 42000 ER_TABLENAME_NOT_ALLOWED_HERE Table '%s' from one of the SELECTs cannot be used in %s
1251 08004 ER_NOT_SUPPORTED_AUTH_MODE Client does not support authentication protocol requested by server; consider upgrading MariaDB client
1252 42000 ER_SPATIAL_CANT_HAVE_NULL All parts of a SPATIAL index must be NOT NULL
1253 42000 ER_COLLATION_CHARSET_MISMATCH COLLATION '%s' is not valid for CHARACTER SET '%s'
1254 HY000 ER_SLAVE_WAS_RUNNING Slave is already running
1255 HY000 ER_SLAVE_WAS_NOT_RUNNING Slave already has been stopped
1256 HY000 ER_TOO_BIG_FOR_UNCOMPRESS Uncompressed data size too large; the maximum size is %d (probably, length of uncompressed data was corrupted)
1257 HY000 ER_ZLIB_Z_MEM_ERROR ZLIB: Not enough memory
1258 HY000 ER_ZLIB_Z_BUF_ERROR ZLIB: Not enough room in the output buffer (probably, length of uncompressed data was corrupted)
1259 HY000 ER_ZLIB_Z_DATA_ERROR ZLIB: Input data corrupted
1260 HY000 ER_CUT_VALUE_GROUP_CONCAT Row %u was cut by GROUP_CONCAT()
1261 01000 ER_WARN_TOO_FEW_RECORDS Row %ld doesn't contain data for all columns
1262 01000 ER_WARN_TOO_MANY_RECORDS Row %ld was truncated; it contained more data than there were input columns
1263 22004 ER_WARN_NULL_TO_NOTNULL Column set to default value; NULL supplied to NOT NULL column '%s' at row %ld
1264 22003 ER_WARN_DATA_OUT_OF_RANGE Out of range value for column '%s' at row %ld
1265 01000 WARN_DATA_TRUNCATED Data truncated for column '%s' at row %ld
1266 HY000 ER_WARN_USING_OTHER_HANDLER Using storage engine %s for table '%s'
1267 HY000 ER_CANT_AGGREGATE_2COLLATIONS Illegal mix of collations (%s,%s) and (%s,%s) for operation '%s'
1268 HY000 ER_DROP_USER Cannot drop one or more of the requested users
1269 HY000 ER_REVOKE_GRANTS Can't revoke all privileges for one or more of the requested users
1270 HY000 ER_CANT_AGGREGATE_3COLLATIONS Illegal mix of collations (%s,%s), (%s,%s), (%s,%s) for operation '%s'
1271 HY000 ER_CANT_AGGREGATE_NCOLLATIONS Illegal mix of collations for operation '%s'
1272 HY000 ER_VARIABLE_IS_NOT_STRUCT Variable '%s' is not a variable component (can't be used as XXXX.variable_name)
1273 HY000 ER_UNKNOWN_COLLATION Unknown collation: '%s'
1274 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
1275 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
1276 HY000 ER_WARN_FIELD_RESOLVED Field or reference '%s%s%s%s%s' of SELECT #%d was resolved in SELECT #%d
1277 HY000 ER_BAD_SLAVE_UNTIL_COND Incorrect parameter or combination of parameters for START SLAVE UNTIL
1278 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
1279 HY000 ER_UNTIL_COND_IGNORED SQL thread is not to be started so UNTIL options are ignored
1280 42000 ER_WRONG_NAME_FOR_INDEX Incorrect index name '%s'
1281 42000 ER_WRONG_NAME_FOR_CATALOG Incorrect catalog name '%s'
1282 HY000 ER_WARN_QC_RESIZE Query cache failed to set size %lu; new query cache size is %lu
1283 HY000 ER_BAD_FT_COLUMN Column '%s' cannot be part of FULLTEXT index
1284 HY000 ER_UNKNOWN_KEY_CACHE Unknown key cache '%s'
1285 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
1286 42000 ER_UNKNOWN_STORAGE_ENGINE Unknown storage engine '%s'
1287 HY000 ER_WARN_DEPRECATED_SYNTAX '%s' is deprecated and will be removed in a future release. Please use %s instead
1288 HY000 ER_NON_UPDATABLE_TABLE The target table %s of the %s is not updatable
1289 HY000 ER_FEATURE_DISABLED The '%s' feature is disabled; you need MariaDB built with '%s' to have it working
1290 HY000 ER_OPTION_PREVENTS_STATEMENT The MariaDB server is running with the %s option so it cannot execute this statement
1291 HY000 ER_DUPLICATED_VALUE_IN_TYPE Column '%s' has duplicated value '%s' in %s
1292 22007 ER_TRUNCATED_WRONG_VALUE Truncated incorrect %s value: '%s'
1293 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
1294 HY000 ER_INVALID_ON_UPDATE Invalid ON UPDATE clause for '%s' column
1295 HY000 ER_UNSUPPORTED_PS This command is not supported in the prepared statement protocol yet
1296 HY000 ER_GET_ERRMSG Got error %d '%s' from %s
1297 HY000 ER_GET_TEMPORARY_ERRMSG Got temporary error %d '%s' from %s
1298 HY000 ER_UNKNOWN_TIME_ZONE Unknown or incorrect time zone: '%s'
1299 HY000 ER_WARN_INVALID_TIMESTAMP Invalid TIMESTAMP value in column '%s' at row %ld
Error Code SQLSTATE Error Description
1300 HY000 ER_INVALID_CHARACTER_STRING Invalid %s character string: '%s'
1301 HY000 ER_WARN_ALLOWED_PACKET_OVERFLOWED Result of %s() was larger than max_allowed_packet (%ld) - truncated
1302 HY000 ER_CONFLICTING_DECLARATIONS Conflicting declarations: '%s%s' and '%s%s'
1303 2F003 ER_SP_NO_RECURSIVE_CREATE Can't create a %s from within another stored routine
1304 42000 ER_SP_ALREADY_EXISTS %s %s already exists
1305 42000 ER_SP_DOES_NOT_EXIST %s %s does not exist
1306 HY000 ER_SP_DROP_FAILED Failed to DROP %s %s
1307 HY000 ER_SP_STORE_FAILED Failed to CREATE %s %s
1308 42000 ER_SP_LILABEL_MISMATCH %s with no matching label: %s
1309 42000 ER_SP_LABEL_REDEFINE Redefining label %s
1310 42000 ER_SP_LABEL_MISMATCH End-label %s without match
1311 01000 ER_SP_UNINIT_VAR Referring to uninitialized variable %s
1312 0A000 ER_SP_BADSELECT PROCEDURE %s can't return a result set in the given context
1313 42000 ER_SP_BADRETURN RETURN is only allowed in a FUNCTION
1314 0A000 ER_SP_BADSTATEMENT %s is not allowed in stored procedures
1315 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.
1316 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.
1317 70100 ER_QUERY_INTERRUPTED Query execution was interrupted
1318 42000 ER_SP_WRONG_NO_OF_ARGS Incorrect number of arguments for %s %s; expected %u, got %u
1319 42000 ER_SP_COND_MISMATCH Undefined CONDITION: %s
1320 42000 ER_SP_NORETURN No RETURN found in FUNCTION %s
1321 2F005 ER_SP_NORETURNEND FUNCTION %s ended without RETURN
1322 42000 ER_SP_BAD_CURSOR_QUERY Cursor statement must be a SELECT
1323 42000 ER_SP_BAD_CURSOR_SELECT Cursor SELECT must not have INTO
1324 42000 ER_SP_CURSOR_MISMATCH Undefined CURSOR: %s
1325 24000 ER_SP_CURSOR_ALREADY_OPEN Cursor is already open
1326 24000 ER_SP_CURSOR_NOT_OPEN Cursor is not open
1327 42000 ER_SP_UNDECLARED_VAR Undeclared variable: %s
1328 HY000 ER_SP_WRONG_NO_OF_FETCH_ARGS Incorrect number of FETCH variables
1329 02000 ER_SP_FETCH_NO_DATA No data - zero rows fetched, selected, or processed
1330 42000 ER_SP_DUP_PARAM Duplicate parameter: %s
1331 42000 ER_SP_DUP_VAR Duplicate variable: %s
1332 42000 ER_SP_DUP_COND Duplicate condition: %s
1333 42000 ER_SP_DUP_CURS Duplicate cursor: %s
1334 HY000 ER_SP_CANT_ALTER Failed to ALTER %s %s
1335 0A000 ER_SP_SUBSELECT_NYI Subquery value not supported
1336 0A000 ER_STMT_NOT_ALLOWED_IN_SF_OR_TRG %s is not allowed in stored function or trigger
1337 42000 ER_SP_VARCOND_AFTER_CURSHNDLR Variable or condition declaration after cursor or handler declaration
1338 42000 ER_SP_CURSOR_AFTER_HANDLER Cursor declaration after handler declaration
1339 20000 ER_SP_CASE_NOT_FOUND Case not found for CASE statement
1340 HY000 ER_FPARSER_TOO_BIG_FILE Configuration file '%s' is too big
1341 HY000 ER_FPARSER_BAD_HEADER Malformed file type header in file '%s'
1342 HY000 ER_FPARSER_EOF_IN_COMMENT Unexpected end of file while parsing comment '%s'
1343 HY000 ER_FPARSER_ERROR_IN_PARAMETER Error while parsing parameter '%s' (line: '%s')
1344 HY000 ER_FPARSER_EOF_IN_UNKNOWN_PARAMETER Unexpected end of file while skipping unknown parameter '%s'
1345 HY000 ER_VIEW_NO_EXPLAIN EXPLAIN/SHOW can not be issued; lacking privileges for underlying table
1346 HY000 ER_FRM_UNKNOWN_TYPE File '%s' has unknown type '%s' in its header
1347 HY000 ER_WRONG_OBJECT '%s.%s' is not %s
1348 HY000 ER_NONUPDATEABLE_COLUMN Column '%s' is not updatable
1349 HY000 ER_VIEW_SELECT_DERIVED View's SELECT contains a subquery in the FROM clause
1350 HY000 ER_VIEW_SELECT_CLAUSE View's SELECT contains a '%s' clause
1351 HY000 ER_VIEW_SELECT_VARIABLE View's SELECT contains a variable or parameter
1352 HY000 ER_VIEW_SELECT_TMPTABLE View's SELECT refers to a temporary table '%s'
1353 HY000 ER_VIEW_WRONG_LIST View's SELECT and view's field list have different column counts
1354 HY000 ER_WARN_VIEW_MERGE View merge algorithm can't be used here for now (assumed undefined algorithm)
1355 HY000 ER_WARN_VIEW_WITHOUT_KEY View being updated does not have complete key of underlying table in it
1356 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
1357 HY000 ER_SP_NO_DROP_SP Can't drop or alter a %s from within another stored routine
1358 HY000 ER_SP_GOTO_IN_HNDLR GOTO is not allowed in a stored procedure handler
1359 HY000 ER_TRG_ALREADY_EXISTS Trigger already exists
1360 HY000 ER_TRG_DOES_NOT_EXIST Trigger does not exist
1361 HY000 ER_TRG_ON_VIEW_OR_TEMP_TABLE Trigger's '%s' is view or temporary table
1362 HY000 ER_TRG_CANT_CHANGE_ROW Updating of %s row is not allowed in %strigger
1363 HY000 ER_TRG_NO_SUCH_ROW_IN_TRG There is no %s row in %s trigger
1364 HY000 ER_NO_DEFAULT_FOR_FIELD Field '%s' doesn't have a default value
1365 22012 ER_DIVISION_BY_ZER Division by 0
1366 HY000 ER_TRUNCATED_WRONG_VALUE_FOR_FIELD Incorrect %s value: '%s' for column '%s' at row %ld
1367 22007 ER_ILLEGAL_VALUE_FOR_TYPE Illegal %s '%s' value found during parsing
1368 HY000 ER_VIEW_NONUPD_CHECK CHECK OPTION on non-updatable view '%s.%s'
1369 HY000 ER_VIEW_CHECK_FAILED CHECK OPTION failed '%s.%s'
1370 42000 ER_PROCACCESS_DENIED_ERROR %s command denied to user '%s'@'%s' for routine '%s'
1371 HY000 ER_RELAY_LOG_FAIL Failed purging old relay logs: %s
1372 HY000 ER_PASSWD_LENGTH Password hash should be a %d-digit hexadecimal number
1373 HY000 ER_UNKNOWN_TARGET_BINLOG Target log not found in binlog index
1374 HY000 ER_IO_ERR_LOG_INDEX_READ I/O error reading log index file
1375 HY000 ER_BINLOG_PURGE_PROHIBITED Server configuration does not permit binlog purge
1376 HY000 ER_FSEEK_FAIL Failed on fseek()
1377 HY000 ER_BINLOG_PURGE_FATAL_ERR Fatal error during log purge
1378 HY000 ER_LOG_IN_USE A purgeable log is in use, will not purge
1379 HY000 ER_LOG_PURGE_UNKNOWN_ERR Unknown error during log purge
1380 HY000 ER_RELAY_LOG_INIT Failed initializing relay log position: %s
1381 HY000 ER_NO_BINARY_LOGGING You are not using binary logging
1382 HY000 ER_RESERVED_SYNTAX The '%s' syntax is reserved for purposes internal to the MariaDB server
1383 HY000 ER_WSAS_FAILED WSAStartup Failed
1384 HY000 ER_DIFF_GROUPS_PROC Can't handle procedures with different groups yet
1385 HY000 ER_NO_GROUP_FOR_PROC Select must have a group with this procedure
1386 HY000 ER_ORDER_WITH_PROC Can't use ORDER clause with this procedure
1387 HY000 ER_LOGGING_PROHIBIT_CHANGING_OF Binary logging and replication forbid changing the global server %s
1388 HY000 ER_NO_FILE_MAPPING Can't map file: %s, errno: %d
1389 HY000 ER_WRONG_MAGIC Wrong magic in %s
1390 HY000 ER_PS_MANY_PARAM Prepared statement contains too many placeholders
1391 HY000 ER_KEY_PART_0 Key part '%s' length cannot be 0
1392 HY000 ER_VIEW_CHECKSUM View text checksum failed
1393 HY000 ER_VIEW_MULTIUPDATE Can not modify more than one base table through a join view '%s.%s'
1394 HY000 ER_VIEW_NO_INSERT_FIELD_LIST Can not insert into join view '%s.%s' without fields list
1395 HY000 ER_VIEW_DELETE_MERGE_VIEW Can not delete from join view '%s.%s'
1396 HY000 ER_CANNOT_USER Operation %s failed for %s
1397 XAE04 ER_XAER_NOTA XAER_NOTA: Unknown XID
1398 XAE05 ER_XAER_INVAL XAER_INVAL: Invalid arguments (or unsupported command)
1399 XAE07 ER_XAER_RMFAIL XAER_RMFAIL: The command cannot be executed when global transaction is in the %s state
Error Code SQLSTATE Error Description
1400 XAE09 ER_XAER_OUTSIDE XAER_OUTSIDE: Some work is done outside global transaction
1401 XAE03 ER_XAER_RMERR XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency
1402 XA100 ER_XA_RBROLLBACK XA_RBROLLBACK: Transaction branch was rolled back
1403 42000 ER_NONEXISTING_PROC_GRANT There is no such grant defined for user '%s' on host '%s' on routine '%s'
1404 HY000 ER_PROC_AUTO_GRANT_FAIL Failed to grant EXECUTE and ALTER ROUTINE privileges
1405 HY000 ER_PROC_AUTO_REVOKE_FAIL Failed to revoke all privileges to dropped routine
1406 22001 ER_DATA_TOO_LONG Data too long for column '%s' at row %ld
1407 42000 ER_SP_BAD_SQLSTATE Bad SQLSTATE: '%s'
1408 HY000 ER_STARTUP %s: ready for connections. Version: '%s' socket: '%s' port: %d %s
1409 HY000 ER_LOAD_FROM_FIXED_SIZE_ROWS_TO_VAR Can't load value from file with fixed size rows to variable
1410 42000 ER_CANT_CREATE_USER_WITH_GRANT You are not allowed to create a user with GRANT
1411 HY000 ER_WRONG_VALUE_FOR_TYPE Incorrect %s value: '%s' for function %s
1412 HY000 ER_TABLE_DEF_CHANGED Table definition has changed, please retry transaction
1413 42000 ER_SP_DUP_HANDLER Duplicate handler declared in the same block
1414 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
1415 0A000 ER_SP_NO_RETSET Not allowed to return a result set from a %s
1416 22003 ER_CANT_CREATE_GEOMETRY_OBJECT Cannot get geometry object from data you send to the GEOMETRY field
1417 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
1418 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)
1419 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)
1420 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.
1421 HY000 ER_STMT_HAS_NO_OPEN_CURSOR The statement (%lu) has no open cursor.
1422 HY000 ER_COMMIT_NOT_ALLOWED_IN_SF_OR_TRG Explicit or implicit commit is not allowed in stored function or trigger.
1423 HY000 ER_NO_DEFAULT_FOR_VIEW_FIELD Field of view '%s.%s' underlying table doesn't have a default value
1424 HY000 ER_SP_NO_RECURSION Recursive stored functions and triggers are not allowed.
1425 42000 ER_TOO_BIG_SCALE Too big scale %d specified for column '%s'. Maximum is %lu.
1426 42000 ER_TOO_BIG_PRECISION Too big precision %d specified for column '%s'. Maximum is %lu.
1427 42000 ER_M_BIGGER_THAN_D For float(M,D, double(M,D or decimal(M,D, M must be >= D (column '%s').
1428 HY000 ER_WRONG_LOCK_OF_SYSTEM_TABLE You can't combine write-locking of system tables with other tables or lock types
1429 HY000 ER_CONNECT_TO_FOREIGN_DATA_SOURCE Unable to connect to foreign data source: %s
1430 HY000 ER_QUERY_ON_FOREIGN_DATA_SOURCE There was a problem processing the query on the foreign data source. Data source error: %s
1431 HY000 ER_FOREIGN_DATA_SOURCE_DOESNT_EXIST The foreign data source you are trying to reference does not exist. Data source error: %s
1432 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
1433 HY000 ER_FOREIGN_DATA_STRING_INVALID The data source connection string '%s' is not in the correct format
1434 HY000 ER_CANT_CREATE_FEDERATED_TABLE Can't create federated table. Foreign data src error: %s
1435 HY000 ER_TRG_IN_WRONG_SCHEMA Trigger in wrong schema
1436 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.
1437 42000 ER_TOO_LONG_BODY Routine body for '%s' is too long
1438 HY000 ER_WARN_CANT_DROP_DEFAULT_KEYCACHE Cannot drop default keycache
1439 42000 ER_TOO_BIG_DISPLAYWIDTH Display width out of range for column '%s' (max = %lu)
1440 XAE08 ER_XAER_DUPID XAER_DUPID: The XID already exists
1441 22008 ER_DATETIME_FUNCTION_OVERFLOW Datetime function: %s field overflow
1442 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.
1443 HY000 ER_VIEW_PREVENT_UPDATE The definition of table '%s' prevents operation %s on table '%s'.
1444 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
1445 HY000 ER_SP_CANT_SET_AUTOCOMMIT Not allowed to set autocommit from a stored function or trigger
1446 HY000 ER_MALFORMED_DEFINER Definer is not fully qualified
1447 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!
1448 HY000 ER_VIEW_OTHER_USER You need the SUPER privilege for creation view with '%s'@'%s' definer
1449 HY000 ER_NO_SUCH_USER The user specified as a definer ('%s'@'%s') does not exist
1450 HY000 ER_FORBID_SCHEMA_CHANGE Changing schema from '%s' to '%s' is not allowed.
1451 23000 ER_ROW_IS_REFERENCED_2 Cannot delete or update a parent row: a foreign key constraint fails (%s)
1452 23000 ER_NO_REFERENCED_ROW_2 Cannot add or update a child row: a foreign key constraint fails (%s)
1453 42000 ER_SP_BAD_VAR_SHADOW Variable '%s' must be quoted with `...`, or renamed
1454 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.
1455 HY000 ER_OLD_FILE_FORMAT '%s' has an old format, you should re-create the '%s' object(s)
1456 HY000 ER_SP_RECURSION_LIMIT Recursive limit %d (as set by the max_sp_recursion_depth variable) was exceeded for routine %s
1457 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)
1458 42000 ER_SP_WRONG_NAME Incorrect routine name '%s'
1459 HY000 ER_TABLE_NEEDS_UPGRADE Table upgrade required. Please do "REPAIR TABLE `%s`" or dump/reload to fix it!
1460 42000 ER_SP_NO_AGGREGATE AGGREGATE is not supported for stored functions
1461 42000 ER_MAX_PREPARED_STMT_COUNT_REACHED Can't create more than max_prepared_stmt_count statements (current value: %lu)
1462 HY000 ER_VIEW_RECURSIVE `%s`.`%s` contains view recursion
1463 42000 ER_NON_GROUPING_FIELD_USED Non-grouping field '%s' is used in %s clause
1464 HY000 ER_TABLE_CANT_HANDLE_SPKEYS The used table type doesn't support SPATIAL indexes
1465 HY000 ER_NO_TRIGGERS_ON_SYSTEM_SCHEMA Triggers can not be created on system tables
1466 HY000 ER_REMOVED_SPACES Leading spaces are removed from name '%s'
1467 HY000 ER_AUTOINC_READ_FAILED Failed to read auto-increment value from storage engine
1468 HY000 ER_USERNAME user name
1469 HY000 ER_HOSTNAME host name
1470 HY000 ER_WRONG_STRING_LENGTH String '%s' is too long for %s (should be no longer than %d)
1471 HY000 ER_NON_INSERTABLE_TABLE The target table %s of the %s is not insertable-into
1472 HY000 ER_ADMIN_WRONG_MRG_TABLE Table '%s' is differently defined or of non-MyISAM type or doesn't exist
1473 HY000 ER_TOO_HIGH_LEVEL_OF_NESTING_FOR_SELECT Too high level of nesting for select
1474 HY000 ER_NAME_BECOMES_EMPTY Name '%s' has become ''
1475 HY000 ER_AMBIGUOUS_FIELD_TERM First character of the FIELDS TERMINATED string is ambiguous; please use non-optional and non-empty FIELDS ENCLOSED BY
1476 HY000 ER_FOREIGN_SERVER_EXISTS The foreign server, %s, you are trying to create already exists.
1477 HY000 ER_FOREIGN_SERVER_DOESNT_EXIST The foreign server name you are trying to reference does not exist. Data source error: %s
1478 HY000 ER_ILLEGAL_HA_CREATE_OPTION Table storage engine '%s' does not support the create option '%s'
1479 HY000 ER_PARTITION_REQUIRES_VALUES_ERROR Syntax error: %s PARTITIONING requires definition of VALUES %s for each partition
1480 HY000 ER_PARTITION_WRONG_VALUES_ERROR Only %s PARTITIONING can use VALUES %s in partition definition
1481 HY000 ER_PARTITION_MAXVALUE_ERROR MAXVALUE can only be used in last partition definition
1482 HY000 ER_PARTITION_SUBPARTITION_ERROR Subpartitions can only be hash partitions and by key
1483 HY000 ER_PARTITION_SUBPART_MIX_ERROR Must define subpartitions on all partitions if on one partition
1484 HY000 ER_PARTITION_WRONG_NO_PART_ERROR Wrong number of partitions defined, mismatch with previous setting
1485 HY000 ER_PARTITION_WRONG_NO_SUBPART_ERROR Wrong number of subpartitions defined, mismatch with previous setting
1486 HY000 ER_CONST_EXPR_IN_PARTITION_FUNC_ERROR Constant/Random expression in (sub)partitioning function is not allowed
1486 HY000 ER_WRONG_EXPR_IN_PARTITION_FUNC_ERROR Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed
1487 HY000 ER_NO_CONST_EXPR_IN_RANGE_OR_LIST_ERROR Expression in RANGE/LIST VALUES must be constant
1488 HY000 ER_FIELD_NOT_FOUND_PART_ERROR Field in list of fields for partition function not found in table
1489 HY000 ER_LIST_OF_FIELDS_ONLY_IN_HASH_ERROR List of fields is only allowed in KEY partitions
1490 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
1491 HY000 ER_PARTITION_FUNC_NOT_ALLOWED_ERROR The %s function returns the wrong type
1492 HY000 ER_PARTITIONS_MUST_BE_DEFINED_ERROR For %s partitions each partition must be defined
1493 HY000 ER_RANGE_NOT_INCREASING_ERROR VALUES LESS THAN value must be strictly increasing for each partition
1494 HY000 ER_INCONSISTENT_TYPE_OF_FUNCTIONS_ERROR VALUES value must be of same type as partition function
1495 HY000 ER_MULTIPLE_DEF_CONST_IN_LIST_PART_ERROR Multiple definition of same constant in list partitioning
1496 HY000 ER_PARTITION_ENTRY_ERROR Partitioning can not be used stand-alone in query
1497 HY000 ER_MIX_HANDLER_ERROR The mix of handlers in the partitions is not allowed in this version of MariaDB
1498 HY000 ER_PARTITION_NOT_DEFINED_ERROR For the partitioned engine it is necessary to define all %s
1499 HY000 ER_TOO_MANY_PARTITIONS_ERROR Too many partitions (including subpartitions) were defined
Error Code SQLSTATE Error Description
1500 HY000 ER_SUBPARTITION_ERROR It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning
1501 HY000 ER_CANT_CREATE_HANDLER_FILE Failed to create specific handler file
1502 HY000 ER_BLOB_FIELD_IN_PART_FUNC_ERROR A BLOB field is not allowed in partition function
1503 HY000 ER_UNIQUE_KEY_NEED_ALL_FIELDS_IN_PF A %s must include all columns in the table's partitioning function
1504 HY000 ER_NO_PARTS_ERROR Number of %s = 0 is not an allowed value
1505 HY000 ER_PARTITION_MGMT_ON_NONPARTITIONED Partition management on a not partitioned table is not possible
1506 HY000 ER_FOREIGN_KEY_ON_PARTITIONED Foreign key clause is not yet supported in conjunction with partitioning
1507 HY000 ER_DROP_PARTITION_NON_EXISTENT Error in list of partitions to %s
1508 HY000 ER_DROP_LAST_PARTITION Cannot remove all partitions, use DROP TABLE instead
1509 HY000 ER_COALESCE_ONLY_ON_HASH_PARTITION COALESCE PARTITION can only be used on HASH/KEY partitions
1510 HY000 ER_REORG_HASH_ONLY_ON_SAME_N REORGANIZE PARTITION can only be used to reorganize partitions not to change their numbers
1511 HY000 ER_REORG_NO_PARAM_ERROR REORGANIZE PARTITION without parameters can only be used on auto-partitioned tables using HASH PARTITIONs
1512 HY000 ER_ONLY_ON_RANGE_LIST_PARTITION %s PARTITION can only be used on RANGE/LIST partitions
1513 HY000 ER_ADD_PARTITION_SUBPART_ERROR Trying to Add partition(s) with wrong number of subpartitions
1514 HY000 ER_ADD_PARTITION_NO_NEW_PARTITION At least one partition must be added
1515 HY000 ER_COALESCE_PARTITION_NO_PARTITION At least one partition must be coalesced
1516 HY000 ER_REORG_PARTITION_NOT_EXIST More partitions to reorganize than there are partitions
1517 HY000 ER_SAME_NAME_PARTITION Duplicate partition name %s
1518 HY000 ER_NO_BINLOG_ERROR It is not allowed to shut off binlog on this command
1519 HY000 ER_CONSECUTIVE_REORG_PARTITIONS When reorganizing a set of partitions they must be in consecutive order
1520 HY000 ER_REORG_OUTSIDE_RANGE Reorganize of range partitions cannot change total ranges except for last partition where it can extend the range
1521 HY000 ER_PARTITION_FUNCTION_FAILURE Partition function not supported in this version for this handler
1522 HY000 ER_PART_STATE_ERROR Partition state cannot be defined from CREATE/ALTER TABLE
1523 HY000 ER_LIMITED_PART_RANGE The %s handler only supports 32 bit integers in VALUES
1524 HY000 ER_PLUGIN_IS_NOT_LOADED Plugin '%s' is not loaded
1525 HY000 ER_WRONG_VALUE Incorrect %s value: '%s'
1526 HY000 ER_NO_PARTITION_FOR_GIVEN_VALUE Table has no partition for value %s
1527 HY000 ER_FILEGROUP_OPTION_ONLY_ONCE It is not allowed to specify %s more than once
1528 HY000 ER_CREATE_FILEGROUP_FAILED Failed to create %s
1529 HY000 ER_DROP_FILEGROUP_FAILED Failed to drop %s
1530 HY000 ER_TABLESPACE_AUTO_EXTEND_ERROR The handler doesn't support autoextend of tablespaces
1531 HY000 ER_WRONG_SIZE_NUMBER A size parameter was incorrectly specified, either number or on the form 10M
1532 HY000 ER_SIZE_OVERFLOW_ERROR The size number was correct but we don't allow the digit part to be more than 2 billion
1533 HY000 ER_ALTER_FILEGROUP_FAILED Failed to alter: %s
1534 HY000 ER_BINLOG_ROW_LOGGING_FAILED Writing one row to the row-based binary log failed
1535 HY000 ER_BINLOG_ROW_WRONG_TABLE_DEF Table definition on master and slave does not match: %s
1536 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
1537 HY000 ER_EVENT_ALREADY_EXISTS Event '%s' already exists
1538 HY000 ER_EVENT_STORE_FAILED Failed to store event %s. Error code %d from storage engine.
1539 HY000 ER_EVENT_DOES_NOT_EXIST Unknown event '%s'
1540 HY000 ER_EVENT_CANT_ALTER Failed to alter event '%s'
1541 HY000 ER_EVENT_DROP_FAILED Failed to drop %s
1542 HY000 ER_EVENT_INTERVAL_NOT_POSITIVE_OR_TOO_BIG INTERVAL is either not positive or too big
1543 HY000 ER_EVENT_ENDS_BEFORE_STARTS ENDS is either invalid or before STARTS
1544 HY000 ER_EVENT_EXEC_TIME_IN_THE_PAST Event execution time is in the past. Event has been disabled
1545 HY000 ER_EVENT_OPEN_TABLE_FAILED Failed to open mysql.event
1546 HY000 ER_EVENT_NEITHER_M_EXPR_NOR_M_AT No datetime expression provided
1547 HY000 ER_COL_COUNT_DOESNT_MATCH_CORRUPTED Column count of mysql.%s is wrong. Expected %d, found %d. The table is probably corrupted
1548 HY000 ER_CANNOT_LOAD_FROM_TABLE Cannot load from mysql.%s. The table is probably corrupted
1549 HY000 ER_EVENT_CANNOT_DELETE Failed to delete the event from mysql.event
1550 HY000 ER_EVENT_COMPILE_ERROR Error during compilation of event's body
1551 HY000 ER_EVENT_SAME_NAME Same old and new event name
1552 HY000 ER_EVENT_DATA_TOO_LONG Data for column '%s' too long
1553 HY000 ER_DROP_INDEX_FK Cannot drop index '%s': needed in a foreign key constraint
1554 HY000 ER_WARN_DEPRECATED_SYNTAX_WITH_VER The syntax '%s' is deprecated and will be removed in MariaDB %s. Please use %s instead
1555 HY000 ER_CANT_WRITE_LOCK_LOG_TABLE You can't write-lock a log table. Only read access is possible
1556 HY000 ER_CANT_LOCK_LOG_TABLE You can't use locks with log tables.
1557 23000 ER_FOREIGN_DUPLICATE_KEY Upholding foreign key constraints for table '%s', entry '%s', key %d would lead to a duplicate entry
1558 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.
1559 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
1560 HY000 ER_STORED_FUNCTION_ PREVENTS_SWITCH_BINLOG_FORMAT Cannot change the binary logging format inside a stored function or trigger
1561 HY000 ER_NDB_CANT_SWITCH_BINLOG_FORMAT The NDB cluster engine does not support changing the binlog format on the fly yet
1562 HY000 ER_PARTITION_NO_TEMPORARY Cannot create temporary table with partitions
1563 HY000 ER_PARTITION_CONST_DOMAIN_ERROR Partition constant is out of partition function domain
1564 HY000 ER_PARTITION_FUNCTION_IS_NOT_ALLOWED This partition function is not allowed
1565 HY000 ER_DDL_LOG_ERROR Error in DDL log
1566 HY000 ER_NULL_IN_VALUES_LESS_THAN Not allowed to use NULL value in VALUES LESS THAN
1567 HY000 ER_WRONG_PARTITION_NAME Incorrect partition name
1568 25001 ER_CANT_CHANGE_TX_ISOLATION Transaction isolation level can't be changed while a transaction is in progress
1569 HY000 ER_DUP_ENTRY_AUTOINCREMENT_CASE ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '%s' for key '%s'
1570 HY000 ER_EVENT_MODIFY_QUEUE_ERROR Internal scheduler error %d
1571 HY000 ER_EVENT_SET_VAR_ERROR Error during starting/stopping of the scheduler. Error code %u
1572 HY000 ER_PARTITION_MERGE_ERROR Engine cannot be used in partitioned tables
1573 HY000 ER_CANT_ACTIVATE_LOG Cannot activate '%s' log
1574 HY000 ER_RBR_NOT_AVAILABLE The server was not built with row-based replication
1575 HY000 ER_BASE64_DECODE_ERROR Decoding of base64 string failed
1576 HY000 ER_EVENT_RECURSION_FORBIDDEN Recursion of EVENT DDL statements is forbidden when body is present
1577 HY000 ER_EVENTS_DB_ERROR Cannot proceed because system tables used by Event Scheduler were found damaged at server start
1578 HY000 ER_ONLY_INTEGERS_ALLOWED Only integers allowed as number here
1579 HY000 ER_UNSUPORTED_LOG_ENGINE This storage engine cannot be used for log tables"
1580 HY000 ER_BAD_LOG_STATEMENT You cannot '%s' a log table if logging is enabled
1581 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'
1582 42000 ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT Incorrect parameter count in the call to native function '%s'
1583 42000 ER_WRONG_PARAMETERS_TO_NATIVE_FCT Incorrect parameters in the call to native function '%s'
1584 42000 ER_WRONG_PARAMETERS_TO_STORED_FCT Incorrect parameters in the call to stored function '%s'
1585 HY000 ER_NATIVE_FCT_NAME_COLLISION This function '%s' has the same name as a native function
1586 23000 ER_DUP_ENTRY_WITH_KEY_NAME Duplicate entry '%s' for key '%s'
1587 HY000 ER_BINLOG_PURGE_EMFILE Too many files opened, please execute the command again
1588 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.
1589 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.
1590 HY000 ER_SLAVE_INCIDENT The incident %s occured on the master. Message: %s
1591 HY000 ER_NO_PARTITION_FOR_GIVEN_VALUE_SILENT Table has no partition for some existing values
1592 HY000 ER_BINLOG_UNSAFE_STATEMENT Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. %s
1593 HY000 ER_SLAVE_FATAL_ERROR Fatal error: %s
1594 HY000 ER_SLAVE_RELAY_LOG_READ_FAILURE Relay log read failure: %s
1595 HY000 ER_SLAVE_RELAY_LOG_WRITE_FAILURE Relay log write failure: %s
1596 HY000 ER_SLAVE_CREATE_EVENT_FAILURE Failed to create %s
1597 HY000 ER_SLAVE_MASTER_COM_FAILURE Master command %s failed: %s
1598 HY000 ER_BINLOG_LOGGING_IMPOSSIBLE Binary logging not possible. Message: %s
1599 HY000 ER_VIEW_NO_CREATION_CTX View `%s`.`%s` has no creation context
Error Code SQLSTATE Error Description
1600 HY000 ER_VIEW_INVALID_CREATION_CTX Creation context of view `%s`.`%s' is invalid
1601 HY000 ER_SR_INVALID_CREATION_CTX Creation context of stored routine `%s`.`%s` is invalid
1602 HY000 ER_TRG_CORRUPTED_FILE Corrupted TRG file for table `%s`.`%s`
1603 HY000 ER_TRG_NO_CREATION_CTX Triggers for table `%s`.`%s` have no creation context
1604 HY000 ER_TRG_INVALID_CREATION_CTX Trigger creation context of table `%s`.`%s` is invalid
1605 HY000 ER_EVENT_INVALID_CREATION_CTX Creation context of event `%s`.`%s` is invalid
1606 HY000 ER_TRG_CANT_OPEN_TABLE Cannot open table for trigger `%s`.`%s`
1607 HY000 ER_CANT_CREATE_SROUTINE Cannot create stored routine `%s`. Check warnings
1608 ER_UNUSED_11 You should never see it
1609 HY000 ER_NO_FORMAT_DESCRIPTION_EVENT _BEFORE_BINLOG_STATEMENT The BINLOG statement of type `%s` was not preceded by a format description BINLOG statement.
1610 HY000 ER_SLAVE_CORRUPT_EVENT Corrupted replication event was detected
1611 HY000 ER_LOAD_DATA_INVALID_COLUMN Invalid column reference (%s) in LOAD DATA
1612 HY000 ER_LOG_PURGE_NO_FILE Being purged log %s was not found
1613 XA106 ER_XA_RBTIMEOUT XA_RBTIMEOUT: Transaction branch was rolled back: took too long
1614 XA102 ER_XA_RBDEADLOCK XA_RBDEADLOCK: Transaction branch was rolled back: deadlock was detected
1615 HY000 ER_NEED_REPREPARE Prepared statement needs to be re-prepared
1616 HY000 ER_DELAYED_NOT_SUPPORTED DELAYED option not supported for table '%s'
1617 HY000 WARN_NO_MASTER_INF The master info structure does not exist
1618 HY000 WARN_OPTION_IGNORED <%s> option ignored
1619 HY000 WARN_PLUGIN_DELETE_BUILTIN Built-in plugins cannot be deleted
1620 HY000 WARN_PLUGIN_BUSY Plugin is busy and will be uninstalled on shutdown
1621 HY000 ER_VARIABLE_IS_READONLY %s variable '%s' is read-only. Use SET %s to assign the value
1622 HY000 ER_WARN_ENGINE_TRANSACTION_ROLLBACK Storage engine %s does not support rollback for this statement. Transaction rolled back and must be restarted
1623 HY000 ER_SLAVE_HEARTBEAT_FAILURE Unexpected master's heartbeat data: %s
1624 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).
1625 HY000 ER_NDB_REPLICATION_SCHEMA_ERROR Bad schema for mysql.ndb_replication table. Message: %s
1626 HY000 ER_CONFLICT_FN_PARSE_ERROR Error in parsing conflict function. Message: %s
1627 HY000 ER_EXCEPTIONS_WRITE_ERROR Write to exceptions table failed. Message: %s"
1628 HY000 ER_TOO_LONG_TABLE_COMMENT Comment for table '%s' is too long (max = %lu)
1629 HY000 ER_TOO_LONG_FIELD_COMMENT Comment for field '%s' is too long (max = %lu)
1630 42000 ER_FUNC_INEXISTENT_NAME_COLLISION FUNCTION %s does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual
1631 HY000 ER_DATABASE_NAME Database
1632 HY000 ER_TABLE_NAME Table
1633 HY000 ER_PARTITION_NAME Partition
1634 HY000 ER_SUBPARTITION_NAME Subpartition
1635 HY000 ER_TEMPORARY_NAME Temporary
1636 HY000 ER_RENAMED_NAME Renamed
1637 HY000 ER_TOO_MANY_CONCURRENT_TRXS Too many active concurrent transactions
1638 HY000 WARN_NON_ASCII_SEPARATOR_NOT_IMPLEMENTED Non-ASCII separator arguments are not fully supported
1639 HY000 ER_DEBUG_SYNC_TIMEOUT debug sync point wait timed out
1640 HY000 ER_DEBUG_SYNC_HIT_LIMIT debug sync point hit limit reached
1641 42000 ER_DUP_SIGNAL_SET Duplicate condition information item '%s'
1642 01000 ER_SIGNAL_WARN Unhandled user-defined warning condition
1643 02000 ER_SIGNAL_NOT_FOUND Unhandled user-defined not found condition
1644 HY000 ER_SIGNAL_EXCEPTION Unhandled user-defined exception condition
1645 0K000 ER_RESIGNAL_WITHOUT_ACTIVE_HANDLER RESIGNAL when handler not active
1646 HY000 ER_SIGNAL_BAD_CONDITION_TYPE SIGNAL/RESIGNAL can only use a CONDITION defined with SQLSTATE
1647 HY000 WARN_COND_ITEM_TRUNCATED Data truncated for condition item '%s'
1648 HY000 ER_COND_ITEM_TOO_LONG Data too long for condition item '%s'
1649 HY000 ER_UNKNOWN_LOCALE Unknown locale: '%s'
1650 HY000 ER_SLAVE_IGNORE_SERVER_IDS The requested server id %d clashes with the slave startup option --replicate-same-server-id
1651 HY000 ER_QUERY_CACHE_DISABLED Query cache is disabled; restart the server with query_cache_type=1 to enable it
1652 HY000 ER_SAME_NAME_PARTITION_FIELD Duplicate partition field name '%s'
1653 HY000 ER_PARTITION_COLUMN_LIST_ERROR Inconsistency in usage of column lists for partitioning
1654 HY000 ER_WRONG_TYPE_COLUMN_VALUE_ERROR Partition column values of incorrect type
1655 HY000 ER_TOO_MANY_PARTITION_FUNC_FIELDS_ERROR Too many fields in '%s'
1656 HY000 ER_MAXVALUE_IN_VALUES_IN Cannot use MAXVALUE as value in VALUES IN
1657 HY000 ER_TOO_MANY_VALUES_ERROR Cannot have more than one value for this type of %s partitioning
1658 HY000 ER_ROW_SINGLE_PARTITION_FIELD_ERROR Row expressions in VALUES IN only allowed for multi-field column partitioning
1659 HY000 ER_FIELD_TYPE_NOT_ALLOWED_AS_PARTITION_FIELD Field '%s' is of a not allowed type for this type of partitioning
1660 HY000 ER_PARTITION_FIELDS_TOO_LONG The total length of the partitioning fields is too large
1661 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.
1662 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.
1663 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
1664 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.
1665 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
1666 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.
1667 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.
1668 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.
1669 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.
1670 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.
1671 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.
1672 HY000 ER_BINLOG_UNSAFE_UDF Statement is unsafe because it uses a UDF which may not return the same value on the slave.
1673 HY000 ER_BINLOG_UNSAFE_SYSTEM_VARIABLE Statement is unsafe because it uses a system variable that may have a different value on the slave.
1674 HY000 ER_BINLOG_UNSAFE_SYSTEM_FUNCTION Statement is unsafe because it uses a system function that may return a different value on the slave.
1675 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.
1676 HY000 ER_MESSAGE_AND_STATEMENT %s Statement: %s
1677 HY000 ER_SLAVE_CONVERSION_FAILED Column %d of table '%s.%s' cannot be converted from type '%s' to type '%s'
1678 HY000 ER_SLAVE_CANT_CREATE_CONVERSION Can't create conversion table for table '%s.%s'
1679 HY000 ER_INSIDE_TRANSACTION _PREVENTS_SWITCH_BINLOG_FORMAT Cannot modify @@session.binlog_format inside a transaction
1680 HY000 ER_PATH_LENGTH The path specified for %s is too long.
1681 HY000 ER_WARN_DEPRECATED_SYNTAX_NO_REPLACEMENT '%s' is deprecated and will be removed in a future release.
1682 HY000 ER_WRONG_NATIVE_TABLE_STRUCTURE Native table '%s'.'%s' has the wrong structure
1683 HY000 ER_WRONG_PERFSCHEMA_USAGE Invalid performance_schema usage.
1684 HY000 ER_WARN_I_S_SKIPPED_TABLE Table '%s'.'%s' was skipped since its definition is being modified by concurrent DDL statement
1685 HY000 ER_INSIDE_TRANSACTION _PREVENTS_SWITCH_BINLOG_DIRECT Cannot modify @@session.binlog_direct_non_transactional_updates inside a transaction
1686 HY000 ER_STORED_FUNCTION_PREVENTS _SWITCH_BINLOG_DIRECT Cannot change the binlog direct flag inside a stored function or trigger
1687 42000 ER_SPATIAL_MUST_HAVE_GEOM_COL A SPATIAL index may only contain a geometrical type column
1688 HY000 ER_TOO_LONG_INDEX_COMMENT Comment for index '%s' is too long (max = %lu)
1689 HY000 ER_LOCK_ABORTED Wait on a lock was aborted due to a pending exclusive lock
1690 22003 ER_DATA_OUT_OF_RANGE %s value is out of range in '%s'
1691 HY000 ER_WRONG_SPVAR_TYPE_IN_LIMIT A variable of a non-integer based type in LIMIT clause
1692 HY000 ER_BINLOG_UNSAFE_MULTIPLE_ENGINES _AND_SELF_LOGGING_ENGINE Mixing self-logging and non-self-logging engines in a statement is unsafe.
1693 HY000 ER_BINLOG_UNSAFE_MIXED_STATEMENT Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them.
1694 HY000 ER_INSIDE_TRANSACTION_ PREVENTS_SWITCH_SQL_LOG_BIN Cannot modify @@session.sql_log_bin inside a transaction
1695 HY000 ER_STORED_FUNCTION_ PREVENTS_SWITCH_SQL_LOG_BIN Cannot change the sql_log_bin inside a stored function or trigger
1696 HY000 ER_FAILED_READ_FROM_PAR_FILE Failed to read from the .par file
1697 HY000 ER_VALUES_IS_NOT_INT_TYPE_ERROR VALUES value for partition '%s' must have type INT
1698 28000 ER_ACCESS_DENIED_NO_PASSWORD_ERROR Access denied for user '%s'@'%s'
1699 HY000 ER_SET_PASSWORD_AUTH_PLUGIN SET PASSWORD has no significance for users authenticating via plugins
Error Code SQLSTATE Error Description
1700 HY000 ER_GRANT_PLUGIN_USER_EXISTS GRANT with IDENTIFIED WITH is illegal because the user %-.*s already exists
1701 42000 ER_TRUNCATE_ILLEGAL_FK Cannot truncate a table referenced in a foreign key constraint (%s)
1702 HY000 ER_PLUGIN_IS_PERMANENT Plugin '%s' is force_plus_permanent and can not be unloaded
1703 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.
1704 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.
1705 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
1706 HY000 ER_MULTI_UPDATE_KEY_CONFLICT Primary key/partition key update is not allowed since the table is updated both as '%s' and '%s'.
1707 HY000 ER_TABLE_NEEDS_REBUILD Table rebuild required. Please do "ALTER TABLE `%s` FORCE" or dump/reload to fix it!
1708 HY000 WARN_OPTION_BELOW_LIMIT The value of '%s' should be no less than the value of '%s'
1709 HY000 ER_INDEX_COLUMN_TOO_LONG Index column size too large. The maximum column size is %lu bytes.
1710 HY000 ER_ERROR_IN_TRIGGER_BODY Trigger '%s' has an error in its body: '%s'
1711 HY000 ER_ERROR_IN_UNKNOWN_TRIGGER_BODY Unknown trigger has an error in its body: '%s'
1712 HY000 ER_INDEX_CORRUPT Index %s is corrupted
1713 HY000 ER_UNDO_RECORD_TOO_BIG Undo log record is too big.
1714 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.
1715 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.
1716 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.
1717 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.
1718 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.
1719 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.
1720 HY000 ER_PLUGIN_NO_UNINSTALL Plugin '%s' is marked as not dynamically uninstallable. You have to stop the server to uninstall it.
1721 HY000 ER_PLUGIN_NO_INSTALL Plugin '%s' is marked as not dynamically installable. You have to stop the server to install it.
1722 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.
1723 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.
1724 HY000 ER_BINLOG_UNSAFE_INSERT_TWO_KEYS INSERT... ON DUPLICATE KEY UPDATE on a table with more than one UNIQUE KEY is unsafe
1725 HY000 ER_TABLE_IN_FK_CHECK Table is being used in foreign key check.
1726 HY000 ER_UNSUPPORTED_ENGINE Storage engine '%s' does not support system tables. [%s.%s]
1727 HY000 ER_BINLOG_UNSAFE_AUTOINC_NOT_FIRST INSERT into autoincrement field which is not the first part in the composed primary key is unsafe.
1728 HY000 ER_CANNOT_LOAD_FROM_TABLE_V2 Cannot load from %s.%s. The table is probably corrupted
1729 HY000 ER_MASTER_DELAY_VALUE_OUT_OF_RANGE The requested value %s for the master delay exceeds the maximum %u
1730 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
1731 HY000 ER_PARTITION_EXCHANGE_DIFFERENT_OPTION Non matching attribute '%s' between partition and table
1732 HY000 ER_PARTITION_EXCHANGE_PART_TABLE Table to exchange with partition is partitioned: '%s'
1733 HY000 ER_PARTITION_EXCHANGE_TEMP_TABLE Table to exchange with partition is temporary: '%s'
1734 HY000 ER_PARTITION_INSTEAD_OF_SUBPARTITION Subpartitioned table, use subpartition instead of partition
1735 HY000 ER_UNKNOWN_PARTITION Unknown partition '%s' in table '%s'
1736 HY000 ER_TABLES_DIFFERENT_METADATA Tables have different definitions
1737 HY000 ER_ROW_DOES_NOT_MATCH_PARTITION Found a row that does not match the partition
1738 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.
1739 HY000 ER_WARN_INDEX_NOT_APPLICABLE Cannot use %s access on index '%s' due to type or collation conversion on field '%s'
1740 HY000 ER_PARTITION_EXCHANGE_FOREIGN_KEY Table to exchange with partition has foreign key references: '%s'
1741 HY000 ER_NO_SUCH_KEY_VALUE Key value '%s' was not found in table '%s.%s'
1742 HY000 ER_RPL_INFO_DATA_TOO_LONG Data for column '%s' too long
1743 HY000 ER_NETWORK_READ_EVENT_CHECKSUM_FAILURE Replication event checksum verification failed while reading from network.
1744 HY000 ER_BINLOG_READ_EVENT_CHECKSUM_FAILURE Replication event checksum verification failed while reading from a log file.
1745 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.
1746 HY000 ER_CANT_UPDATE_TABLE_IN_CREATE_TABLE_SELECT Can't update table '%s' while '%s' is being created.
1747 HY000 ER_PARTITION_CLAUSE_ON_NONPARTITIONED PARTITION () clause on non partitioned table
1748 HY000 ER_ROW_DOES_NOT_MATCH_GIVEN_PARTITION_SET Found a row not matching the given partition set
1749 HY000 ER_NO_SUCH_PARTITION_UNUSED partition '%s' doesn't exist
1750 HY000 ER_CHANGE_RPL_INFO_REPOSITORY_FAILURE Failure while changing the type of replication repository: %s.
1751 HY000 ER_WARNING_NOT_COMPLETE_ROLLBACK_WITH_CREATED_TEMP_TABLE The creation of some temporary tables could not be rolled back.
1752 HY000 ER_WARNING_NOT_COMPLETE_ROLLBACK_WITH_DROPPED_TEMP_TABLE Some temporary tables were dropped, but these operations could not be rolled back.
1753 HY000 ER_MTS_FEATURE_IS_NOT_SUPPORTED %s is not supported in multi-threaded slave mode. %s
1754 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.
1755 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.
1756 HY000 ER_MTS_INCONSISTENT_DATA %s
1757 HY000 ER_FULLTEXT_NOT_SUPPORTED_WITH_PARTITIONING FULLTEXT index is not supported for partitioned tables.
1758 35000 ER_DA_INVALID_CONDITION_NUMBER Invalid condition number
1759 HY000 ER_INSECURE_PLAIN_TEXT Sending passwords in plain text without SSL/TLS is extremely insecure.
1760 HY000 ER_INSECURE_CHANGE_MASTER Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
1761 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'
1762 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
1763 HY000 ER_SQLTHREAD_WITH_SECURE_SLAVE Setting authentication options is not possible when only the Slave SQL Thread is being started.
1764 HY000 ER_TABLE_HAS_NO_FT The table does not have FULLTEXT index to support this query
1765 HY000 ER_VARIABLE_NOT_SETTABLE_IN_SF_OR_TRIGGER The system variable %s cannot be set in stored functions or triggers.
1766 HY000 ER_VARIABLE_NOT_SETTABLE_IN_TRANSACTION The system variable %s cannot be set when there is an ongoing transaction.
1767 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.
1768 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.
1769 HY000 ER_SET_STATEMENT_CANNOT_INVOKE_FUNCTION The statement 'SET %s' cannot invoke a stored function.
1770 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.
1771 HY000 ER_SKIPPING_LOGGED_TRANSACTION Skipping transaction %s because it has already been executed and logged.
1772 HY000 ER_MALFORMED_GTID_SET_SPECIFICATION Malformed GTID set specification '%s'.
1773 HY000 ER_MALFORMED_GTID_SET_ENCODING Malformed GTID set encoding.
1774 HY000 ER_MALFORMED_GTID_SPECIFICATION Malformed GTID specification '%s'.
1775 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.
1776 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.
1777 HY000 ER_AUTO_POSITION_REQUIRES_GTID_MODE_ON CHANGE MASTER TO MASTER_AUTO_POSITION = 1 can only be executed when @@GLOBAL.GTID_MODE = ON.
1778 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.
1779 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.
1779 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.
1780 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.
1781 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.
1782 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.
1783 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.
1784 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.
1785 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.
1786 HY000 ER_GTID_UNSAFE_CREATE_SELECT CREATE TABLE ... SELECT is forbidden when @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1.
1787 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.
1788 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.
1789 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.
1790 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.
1791 HY000 ER_UNKNOWN_EXPLAIN_FORMAT Unknown EXPLAIN format name: '%s'
1792 25006 ER_CANT_EXECUTE_IN_READ_ONLY_TRANSACTION Cannot execute statement in a READ ONLY transaction.
1793 HY000 ER_TOO_LONG_TABLE_PARTITION_COMMENT Comment for table partition '%s' is too long (max = %lu
1794 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 MySQL error log.
1795 HY000 ER_INNODB_FT_LIMIT InnoDB presently supports one FULLTEXT index creation at a time
1796 HY000 ER_INNODB_NO_FT_TEMP_TABLE Cannot create FULLTEXT index on temporary InnoDB table
1797 HY000 ER_INNODB_FT_WRONG_DOCID_COLUMN Column '%s' is of wrong type for an InnoDB FULLTEXT index
1798 HY000 ER_INNODB_FT_WRONG_DOCID_INDEX Index '%s' is of wrong type for an InnoDB FULLTEXT index
1799 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.
Error Code SQLSTATE Error Description
1800 HY000 ER_UNKNOWN_ALTER_ALGORITHM Unknown ALGORITHM '%s'
1801 HY000 ER_UNKNOWN_ALTER_LOCK Unknown LOCK type '%s'
1802 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.
1803 HY000 ER_MTS_RECOVERY_FAILURE Cannot recover after SLAVE errored out in parallel execution mode. Additional error messages can be found in the MySQL error log.
1804 HY000 ER_MTS_RESET_WORKERS Cannot clean up worker info tables. Additional error messages can be found in the MySQL error log.
1805 HY000 ER_COL_COUNT_DOESNT_MATCH_CORRUPTED_V2 Column count of %s.%s is wrong. Expected %d, found %d. The table is probably corrupted
1806 HY000 ER_SLAVE_SILENT_RETRY_TRANSACTION Slave must silently retry current transaction
1807 HY000 ER_DISCARD_FK_CHECKS_RUNNING There is a foreign key check running on table '%s'. Cannot discard the table.
1808 HY000 ER_TABLE_SCHEMA_MISMATCH Schema mismatch (%s
1809 HY000 ER_TABLE_IN_SYSTEM_TABLESPACE Table '%s' in system tablespace
1810 HY000 ER_IO_READ_ERROR IO Read error: (%lu, %s) %s
1811 HY000 ER_IO_WRITE_ERROR IO Write error: (%lu, %s) %s
1812 HY000 ER_TABLESPACE_MISSING Tablespace is missing for table '%s'
1813 HY000 ER_TABLESPACE_EXISTS Tablespace for table '%s' exists. Please DISCARD the tablespace before IMPORT.
1814 HY000 ER_TABLESPACE_DISCARDED Tablespace has been discarded for table '%s'
1815 HY000 ER_INTERNAL_ERROR Internal error: %s
1816 HY000 ER_INNODB_IMPORT_ERROR ALTER TABLE '%s' IMPORT TABLESPACE failed with error %lu : '%s'
1817 HY000 ER_INNODB_INDEX_CORRUPT Index corrupt: %s
1818 HY000 ER_INVALID_YEAR_COLUMN_LENGTH YEAR(%lu) column type is deprecated. Creating YEAR(4) column instead.
1819 HY000 ER_NOT_VALID_PASSWORD Your password does not satisfy the current policy requirements
1820 HY000 ER_MUST_CHANGE_PASSWORD You must SET PASSWORD before executing this statement
1821 HY000 ER_FK_NO_INDEX_CHILD Failed to add the foreign key constaint. Missing index for constraint '%s' in the foreign table '%s'
1822 HY000 ER_FK_NO_INDEX_PARENT Failed to add the foreign key constaint. Missing index for constraint '%s' in the referenced table '%s'
1823 HY000 ER_FK_FAIL_ADD_SYSTEM Failed to add the foreign key constraint '%s' to system tables
1824 HY000 ER_FK_CANNOT_OPEN_PARENT Failed to open the referenced table '%s'
1825 HY000 ER_FK_INCORRECT_OPTION Failed to add the foreign key constraint on table '%s'. Incorrect options in FOREIGN KEY constraint '%s'
1826 HY000 ER_FK_DUP_NAME Duplicate foreign key constraint name '%s'
1827 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.
1828 HY000 ER_FK_COLUMN_CANNOT_DROP Cannot drop column '%s': needed in a foreign key constraint '%s'
1829 HY000 ER_FK_COLUMN_CANNOT_DROP_CHILD Cannot drop column '%s': needed in a foreign key constraint '%s' of table '%s'
1830 HY000 ER_FK_COLUMN_NOT_NULL Column '%s' cannot be NOT NULL: needed in a foreign key constraint '%s' SET NULL
1831 HY000 ER_DUP_INDEX Duplicate index '%s' defined on the table '%s.%s'. This is deprecated and will be disallowed in a future release.
1832 HY000 ER_FK_COLUMN_CANNOT_CHANGE Cannot change column '%s': used in a foreign key constraint '%s'
1833 HY000 ER_FK_COLUMN_CANNOT_CHANGE_CHILD Cannot change column '%s': used in a foreign key constraint '%s' of table '%s'
1834 HY000 ER_FK_CANNOT_DELETE_PARENT Cannot delete rows from table which is parent in a foreign key constraint '%s' of table '%s'
1835 HY000 ER_MALFORMED_PACKET Malformed communication packet.
1836 HY000 ER_READ_ONLY_MODE Running in read-only mode
1837 HY000 ER_GTID_NEXT_TYPE_UNDEFINED_GROUP When @@SESSION.GTID_NEXT is set to a GTID, you must explicitly set it to a different value after a COMMIT or ROLLBACK. Please check GTID_NEXT variable manual page for detailed explanation. Current @@SESSION.GTID_NEXT is '%s'.
1838 HY000 ER_VARIABLE_NOT_SETTABLE_IN_SP The system variable %s cannot be set in stored procedures.
1839 HY000 ER_CANT_SET_GTID_PURGED_WHEN_GTID_MODE_IS_OFF @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_MODE = ON.
1840 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.
1841 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).
1842 HY000 ER_GTID_PURGED_WAS_CHANGED @@GLOBAL.GTID_PURGED was changed from '%s' to '%s'.
1843 HY000 ER_GTID_EXECUTED_WAS_CHANGED @@GLOBAL.GTID_EXECUTED was changed from '%s' to '%s'.
1844 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.
1845 0A000 ER_ALTER_OPERATION_NOT_SUPPORTED %s is not supported for this operation. Try %s.
1846 0A000 ER_ALTER_OPERATION_NOT_SUPPORTED_REASON %s is not supported. Reason: %s. Try %s.
1847 HY000 ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_COPY COPY algorithm requires a lock
1848 HY000 ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_PARTITION Partition specific operations do not yet support LOCK/ALGORITHM
1849 HY000 ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_FK_RENAME Columns participating in a foreign key are renamed
1850 HY000 ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_COLUMN_TYPE Cannot change column type INPLACE
1851 HY000 ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_FK_CHECK Adding foreign keys needs foreign_key_checks=OFF
1852 HY000 ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_IGNORE Creating unique indexes with IGNORE requires COPY algorithm to remove duplicate rows
1853 HY000 ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_NOPK Dropping a primary key is not allowed without also adding a new primary key
1854 HY000 ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_AUTOINC Adding an auto-increment column requires a lock
1855 HY000 ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_HIDDEN_FTS Cannot replace hidden FTS_DOC_ID with a user-visible one
1856 HY000 ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_CHANGE_FTS Cannot drop or rename FTS_DOC_ID
1857 HY000 ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_FTS Fulltext index creation requires a lock
1858 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
1859 23000 ER_DUP_UNKNOWN_IN_INDEX Duplicate entry for key '%s'
1860 HY000 ER_IDENT_CAUSES_TOO_LONG_PATH Long database name and identifier for object resulted in path length exceeding %d characters. Path: '%s'.
1861 HY000 ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_NOT_NULL cannot silently convert NULL values, as required in this SQL_MODE
1862 HY000 ER_MUST_CHANGE_PASSWORD_LOGIN Your password has expired. To log in you must change it using a client that supports expired passwords.
1863 HY000 ER_ROW_IN_WRONG_PARTITION Found a row in wrong partition %s
1864 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.
1865 HY000 ER_INNODB_NO_FT_USES_PARSER Cannot CREATE FULLTEXT INDEX WITH PARSER on InnoDB table
1866 HY000 ER_BINLOG_LOGICAL_CORRUPTION The binary log file '%s' is logically corrupted: %s
1867 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.
1868 HY000 ER_WARN_PURGE_LOG_IS_ACTIVE file %s was not purged because it is the active log file.
1869 HY000 ER_AUTO_INCREMENT_CONFLICT Auto-increment value in UPDATE conflicts with internally generated values
1870 HY000 WARN_ON_BLOCKHOLE_IN_RBR Row events are not logged for %s statements that modify BLACKHOLE tables in row format. Table(s): '%s'
1871 HY000 ER_SLAVE_MI_INIT_REPOSITORY Slave failed to initialize master info structure from the repository
1872 HY000 ER_SLAVE_RLI_INIT_REPOSITORY Slave failed to initialize relay log info structure from the repository
1873 28000 ER_ACCESS_DENIED_CHANGE_USER_ERROR Access denied trying to change to user '%s'@'%s' (using password: %s). Disconnecting.
1874 HY000 ER_INNODB_READ_ONLY InnoDB is in read only mode.
1875 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.
1876 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.
1877 HY000 ER_TABLE_CORRUPT Operation cannot be performed. The table '%s.%s' is missing, corrupt or contains bad data.
1878 HY000 ER_TEMP_FILE_WRITE_FAILURE Temporary file write failure.
1879 HY000 ER_INNODB_FT_AUX_NOT_HEX_ID Upgrade index name failed, please use create index(alter table) algorithm copy to rebuild index.
1880 HY000 ER_OLD_TEMPORALS_UPGRADED TIME/TIMESTAMP/DATETIME columns of old format have been upgraded to the new format.
1881 HY000 ER_INNODB_FORCED_RECOVERY Operation not allowed when innodb_forced_recovery > 0.
1882 HY000 ER_AES_INVALID_IV The initialization vector supplied to %s is too short. Must be at least %d bytes long
1883 HY000 ER_PLUGIN_CANNOT_BE_UNINSTALLED Plugin '%s' cannot be uninstalled now. %s
1884 HY000 ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_GTID_GROUP Cannot execute statement because it needs to be written to the binary log as multiple statements, and this is not allowed when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
1885 HY000 ER_SLAVE_HAS_MORE_GTIDS_THAN_MASTER Slave has more GTIDs than the master has, using the master's SERVER_UUID. This may indicate that the end of the binary log was truncated or that the last binary log file was lost, e.g., after a power or disk failure when sync_binlog != 1. The master may or may not have rolled back transactions that were already replicated to the slave. Suggest to replicate any transactions that master has rolled back from slave to master, and/or commit empty transactions on master to account for transactions that have been committed on master but are not included in GTID_EXECUTED.

MariaDB-specific error codes

Error Code SQLSTATE Error Description
1900 ER_VCOL_BASED_ON_VCOL A computed column cannot be based on a computed column
1901 ER_VIRTUAL_COLUMN_FUNCTION_IS_NOT_ALLOWED Function or expression is not allowed for column '%s'
1902 ER_DATA_CONVERSION_ERROR_FOR_VIRTUAL_COLUMN Generated value for computed column '%s' cannot be converted to type '%s'
1903 ER_PRIMARY_KEY_BASED_ON_VIRTUAL_COLUMN Primary key cannot be defined upon a computed column
1904 ER_KEY_BASED_ON_GENERATED_VIRTUAL_COLUMN Key/Index cannot be defined on a non-stored computed column
1905 ER_WRONG_FK_OPTION_FOR_VIRTUAL_COLUMN Cannot define foreign key with %s clause on a computed column
1906 ER_WARNING_NON_DEFAULT_VALUE_FOR_VIRTUAL_COLUMN The value specified for computed column '%s' in table '%s' ignored
1907 ER_UNSUPPORTED_ACTION_ON_VIRTUAL_COLUMN This is not yet supported for computed columns
1908 ER_CONST_EXPR_IN_VCOL Constant expression in computed column function is not allowed
1909 ER_ROW_EXPR_FOR_VCOL Expression for computed column cannot return a row
1910 ER_UNSUPPORTED_ENGINE_FOR_VIRTUAL_COLUMNS %s storage engine does not support computed columns
1911 ER_UNKNOWN_OPTION Unknown option '%-.64s'
1912 ER_BAD_OPTION_VALUE Incorrect value '%-.64s' for option '%-.64s'
1913 ER_NETWORK_READ_EVENT_CHECKSUM_FAILURE Replication event checksum verification failed while reading from network.
1914 ER_BINLOG_READ_EVENT_CHECKSUM_FAILURE Replication event checksum verification failed while reading from a log file.
1915 ER_CANT_DO_ONLINE Can't execute the given '%s' command as online
1916 ER_DATA_OVERFLOW 22003 Got overflow when converting '%-.128s' to %-.32s. Value truncated.
1917 ER_DATA_TRUNCATED 22003 Truncated value '%-.128s' when converting to %-.32s
1918 ER_BAD_DATA 22007 Encountered illegal value '%-.128s' when converting to %-.32s
1919 ER_DYN_COL_WRONG_FORMAT Encountered illegal format of dynamic column string
1920 ER_DYN_COL_IMPLEMENTATION_LIMIT Dynamic column implementation limit reached
1921 ER_DYN_COL_DATA 22007 Illegal value used as argument of dynamic column function
1922 ER_DYN_COL_WRONG_CHARSET Dynamic column contains unknown character set
1923 ER_ILLEGAL_SUBQUERY_OPTIMIZER_SWITCHES At least one of the 'in_to_exists' or 'materialization' optimizer_switch flags must be 'on'.
1924 ER_QUERY_CACHE_IS_DISABLED Query cache is disabled (resize or similar command in progress); repeat this command later
1925 ER_QUERY_CACHE_IS_GLOBALY_DISABLED Query cache is globally disabled and you can't enable it only for this session
1926 ER_VIEW_ORDERBY_IGNORED View '%-.192s'.'%-.192s' ORDER BY clause ignored because there is other ORDER BY clause already.
1927 ER_CONNECTION_KILLED 70100 Connection was killed
1928 ER_INTERNAL_ERROR Internal error: '%-.192s'
1929 ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_SKIP_REPLICATION Cannot modify @@session.skip_replication inside a transaction
1930 ER_STORED_FUNCTION_PREVENTS_SWITCH_SKIP_REPLICATION Cannot modify @@session.skip_replication inside a stored function or trigger
1931 ER_QUERY_EXCEEDED_ROWS_EXAMINED_LIMIT Query execution was interrupted. The query examined at least %llu rows, which exceeds LIMIT ROWS EXAMINED (%llu). The query result may be incomplete.
1932 ER_NO_SUCH_TABLE_IN_ENGINE 42S02 Table '%-.192s.%-.192s' doesn't exist in engine
1933 ER_TARGET_NOT_EXPLAINABLE Target is not running an EXPLAINable command
1934 ER_CONNECTION_ALREADY_EXISTS Connection '%.*s' conflicts with existing connection '%.*s'
1935 ER_MASTER_LOG_PREFIX Master '%.*s':
1936 ER_CANT_START_STOP_SLAVE Can't %s SLAVE '%.*s'
1937 ER_SLAVE_STARTED SLAVE '%.*s' started
1938 ER_SLAVE_STOPPED SLAVE '%.*s' stopped
1939 ER_SQL_DISCOVER_ERROR Engine %s failed to discover table %`-.192s.%`-.192s with '%s'
1940 ER_FAILED_GTID_STATE_INIT Failed initializing replication GTID state
1941 ER_INCORRECT_GTID_STATE Could not parse GTID list
1942 ER_CANNOT_UPDATE_GTID_STATE Could not update replication slave gtid state
1943 ER_DUPLICATE_GTID_DOMAIN GTID %u-%u-%llu and %u-%u-%llu conflict (duplicate domain id %u)
1944 ER_GTID_OPEN_TABLE_FAILED Failed to open %s.%s
1945 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
1946 ER_CANNOT_LOAD_SLAVE_GTID_STATE Failed to load replication slave GTID position from table %s.%s
1947 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.
1948 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.
1949 ER_UNTIL_REQUIRES_USING_GTID START SLAVE UNTIL master_gtid_pos requires that slave is using GTID
1950 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.
1951 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
1952 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
1953 ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_GTID_DOMAIN_ID_SEQ_NO Cannot modify @@session.gtid_domain_id or @@session.gtid_seq_no inside a transaction
1954 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
1955 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
1956 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
1957 ER_NO_SUCH_QUERY Unknown query id: %lld
1958 ER_BAD_BASE64_DATA Bad base64 data as position %u
1959 ER_INVALID_ROLE Invalid role specification %`s.
1960 ER_INVALID_CURRENT_USER The current user is invalid.
1961 ER_CANNOT_GRANT_ROLE Cannot grant role '%s' to: %s.
1962 ER_CANNOT_REVOKE_ROLE Cannot revoke role '%s' from: %s.
1963 ER_CHANGE_SLAVE_PARALLEL_THREADS_ACTIVE Cannot change @@slave_parallel_threads while another change is in progress
1964 ER_PRIOR_COMMIT_FAILED Commit failed due to failure of an earlier commit on which this one depends
1965 ER_IT_IS_A_VIEW '%-.192s' is a view
1966 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.
1967 ER_TABLE_DEFINITION_TOO_BIG The definition for table %`s is too big
1968 ER_PLUGIN_INSTALLED Plugin '%-.192s' already installed
1969 ER_STATEMENT_TIMEOUT Query execution was interrupted (max_statement_time exceeded)
1970 ER_SUBQUERIES_NOT_SUPPORTED %s does not support subqueries or stored functions.
1971 ER_SET_STATEMENT_NOT_SUPPORTED The system variable %.200s cannot be set in SET STATEMENT.
1972 ER_UNUSED_17 You should never see it
1973 ER_USER_CREATE_EXISTS Can't create user '%-.64s'@'%-.64s'; it already exists
1974 ER_USER_DROP_EXISTS Can't drop user '%-.64s'@'%-.64s'; it doesn't exist
1975 ER_ROLE_CREATE_EXISTS Can't create role '%-.64s'; it already exists
1976 ER_ROLE_DROP_EXISTS Can't drop role '%-.64s'; it doesn't exist
1977 ER_CANNOT_CONVERT_CHARACTER Cannot convert '%s' character 0x%-.64s to '%s'
1978 ER_INVALID_DEFAULT_VALUE_FOR_FIELD Incorrect default value '%-.128s' for column '%.192s'
1979 ER_KILL_QUERY_DENIED_ERROR You are not owner of query %lu
1980 ER_NO_EIS_FOR_FIELD Engine-independent statistics are not collected for column '%s'
1981 ER_WARN_AGGFUNC_DEPENDENCE Aggregate function '%-.192s)' of SELECT #%d belongs to SELECT #%d
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/mariadb-error-codes/