Documented MySQL 5.5 Server Errors

from the Artful MySQL Tips List

Here is a tabulation of known MySQL Server error codes, numbers, SqlStates and messages. Many are self-explanatory. Some aren't, and that's what the Notes column is for. If you would like to contribute more info, please click here.

Error Code Error No. SqlState Error Message Notes
NoneNoneFound wrong password for user 'username'@'hostname'; ignoring user
NoneNone'filename' not found, or Can't open file: filename, or errno 23, or errno 24
CANT_CREATE_FILE1004HY000Can't create file 'str' (errno: #)
CANT_CREATE_TABLE1005HY000Can't create table 'str' (errno: #)
CANT_CREATE_DB1006HY000Can't create database 'str' (errno: #)
DB_CREATE_EXISTS1007HY000Can't create database 'str'; database exists
DB_DROP_EXISTS1008HY000Can't drop database 'str'; database doesn't exist
DB_DROP_DELETE1009HY000Error dropping database (can't delete 'str', errno: #)
DB_DROP_RMDIR1010HY000Error dropping database (can't rmdir 'str', errno: #)
CANT_DELETE_FILE1011HY000Error on delete of 'str' (errno: #)
CANT_FIND_SYSTEM_REC1012HY000Can't read record in system table
CANT_GET_STAT1013HY000Can't get status of 'str' (errno: #)
CANT_GET_WD1014HY000Can't get working directory (errno: #)
CANT_LOCK1015HY000Can't lock file (errno: #)
CANT_OPEN_FILE1016HY000Can't open file: 'str' (errno: #)
FILE_NOT_FOUND1017HY000Can't find file: 'str' (errno: #)
CANT_READ_DIR1018HY000Can't read dir of 'str' (errno: #)
CANT_SET_WD1019HY000Can't change dir to 'str' (errno: #)
CHECKREAD1020HY000Record has changed since last read in table 'str'
DISK_FULL1021HY000Disk full (str); waiting for someone to free some space...
DUP_KEY102223000Can't write; duplicate key in table 'str'
ERROR_ON_CLOSE1023HY000Error on close of 'str' (errno: #)
ERROR_ON_READ1024HY000Error reading file 'str' (errno: #)
ERROR_ON_RENAME1025HY000Error on rename of 'str' to 'str' (errno: #)
ERROR_ON_WRITE1026HY000Error writing file 'str' (errno: #)
FILE_USED1027HY000'str' is locked against change
FILSORT_ABORT1028HY000Sort aborted
FORM_NOT_FOUND1029HY000View 'str' doesn't exist for 'str'
GET_ERRNO1030HY000Got error # from storage engine
ILLEGAL_HA1031HY000Table storage engine for 'str' doesn't have this option
KEY_NOT_FOUND1032HY000Can't find record in 'str'
NOT_FORM_FILE1033HY000Incorrect information in file: 'str'
NOT_KEYFILE1034HY000Incorrect key file for table 'str'; try to repair it
OLD_KEYFILE1035HY000Old key file for table 'str'; repair it!
OPEN_AS_READONLY1036HY000Table 'str' is read only
OUTOFMEMORY1037HY001Out of memory; restart server and try again (needed # bytes)
OUT_OF_SORTMEMORY1038HY001Out of sort memory; increase server sort buffer size
UNEXPECTED_EOF1039HY000Unexpected EOF found when reading file 'str' (errno: #)
CON_COUNT_ERROR104008004Too many connections
OUT_OF_RESOURCES1041HY000Out 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
BAD_HOST_ERROR104208S01Can't get hostname for your addressCauses not documented. Looks like a bug that's not had enough attention. One fix that usually works is to set skip-name-resolve in my.cnf/ini of the target MySQL installation.
HANDSHAKE_ERROR104308S01Bad handshake
DBACCESS_DENIED_ERROR104442000Access denied for user 'str'@'str' to database 'str'
ACCESS_DENIED_ERROR104528000Access denied for user 'str'@'str' (using password: str)
NO_DB_ERROR10463D000No database selectedAdd a USE command before the offending call.
UNKNOWN_COM_ERROR104708S01Unknown command
BAD_NULL_ERROR104823000Column 'str' cannot be null
BAD_DB_ERROR104942000Unknown database 'str'
TABLE_EXISTS_ERROR105042S01Table 'str' already exists
BAD_TABLE_ERROR105142S02Unknown table 'str'
NON_UNIQ_ERROR105223000Column 'str' in str is ambiguous
SERVER_SHUTDOWN105308S01Server shutdown in progress
BAD_FIELD_ERROR105442S22Unknown column 'str' in 'str'
WRONG_FIELD_WITH_GROUP105542000'str' isn't in GROUP BY
WRONG_GROUP_FIELD105642000Can't group on 'str'
WRONG_SUM_SELECT105742000Statement has sum functions and columns in same statement
WRONG_VALUE_COUNT105821S01Column count doesn't match value count
TOO_LONG_IDENT105942000Identifier name 'str' is too long
DUP_FIELDNAME106042S21Duplicate column name 'str'
DUP_KEYNAME106142000Duplicate key name 'str'
DUP_ENTRY106223000Duplicate entry 'str' for key #
WRONG_FIELD_SPEC106342000Incorrect column specifier for column 'str'
PARSE_ERROR106442000str near 'str' at line #
EMPTY_QUERY106542000Query was empty
NONUNIQ_TABLE106642000Not unique table/alias: 'str'
INVALID_DEFAULT106742000Invalid default value for 'str'
MULTIPLE_PRI_KEY106842000Multiple primary key defined
TOO_MANY_KEYS106942000Too many keys specified; max # keys allowed
TOO_MANY_KEY_PARTS107042000Too many key parts specified; max # parts allowed
TOO_LONG_KEY107142000Specified key was too long; max key length is # bytes
KEY_COLUMN_DOES_NOT_EXITS107242000Key column 'str' doesn't exist in table
BLOB_USED_AS_KEY107342000BLOB column 'str' can't be used in key specification with the used table type
TOO_BIG_FIELDLENGTH107442000Column length too big for column 'str' (max = %lu); use BLOB or TEXT instead
WRONG_AUTO_KEY107542000Incorrect table definition; there can be only one auto column and it must be defined as a key
READY1076HY000str: ready for connections. Version: 'str' socket: 'str' port: #
NORMAL_SHUTDOWN1077HY000str: Normal shutdown
GOT_SIGNAL1078HY000str: Got signal #. Aborting!
SHUTDOWN_COMPLETE1079HY000str: Shutdown complete
FORCING_CLOSE108008S01str: Forcing close of thread %ld user: 'str'
IPSOCK_ERROR108108S01Can't create IP socket
NO_SUCH_INDEX108242S12Table 'str' has no index like the one used in CREATE INDEX; recreate the table
WRONG_FIELD_TERMINATORS108342000Field separator argument is not what is expected; check the manual
BLOBS_AND_NO_TERMINATED108442000You can't use fixed rowlength with BLOBs; please use 'fields terminated by'
TEXTFILE_NOT_READABLE1085HY000The file 'str' must be in the database directory or be readable by all
FILE_EXISTS_ERROR1086HY000File 'str' already exists
LOAD_INFO1087HY000Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld
ALTER_INFO1088HY000Records: %ld Duplicates: %ld
WRONG_SUB_KEY1089HY000Incorrect 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
CANT_REMOVE_ALL_FIELDS109042000You can't delete all columns with ALTER TABLE; use DROP TABLE instead
CANT_DROP_FIELD_OR_KEY109142000Can't DROP 'str'; check that column/key exists
INSERT_INFO1092HY000Records: %ld Duplicates: %ld Warnings: %ld
UPDATE_TABLE_USED1093HY000You can't specify target table 'str' for update in FROM clause
NO_SUCH_THREAD1094HY000Unknown thread id: %lu
KILL_DENIED_ERROR1095HY000You are not owner of thread %lu
NO_TABLES_USED1096HY000No tables used
TOO_BIG_SET1097HY000Too many strings for column str and SET
NO_UNIQUE_LOGFILE1098HY000Can't generate a unique log-filename str.(1-999)
TABLE_NOT_LOCKED_FOR_WRITE1099HY000Table 'str' was locked with a READ lock and can't be updated
TABLE_NOT_LOCKED1100HY000Table 'str' was not locked with LOCK TABLES
BLOB_CANT_HAVE_DEFAULT110142000BLOB/TEXT column 'str' can't have a default value
WRONG_DB_NAME110242000Incorrect database name 'str'
WRONG_TABLE_NAME110342000Incorrect table name 'str'
TOO_BIG_SELECT110442000The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
UNKNOWN_ERROR1105HY000Unknown error
UNKNOWN_PROCEDURE110642000Unknown procedure 'str'
WRONG_PARAMCOUNT_TO_PROCEDURE110742000Incorrect parameter count to procedure 'str'
WRONG_PARAMETERS_TO_PROCEDURE1108HY000Incorrect parameters to procedure 'str'
UNKNOWN_TABLE110942S02Unknown table 'str' in str
FIELD_SPECIFIED_TWICE111042000Column 'str' specified twice
INVALID_GROUP_FUNC_USE1111HY000Invalid use of group function
UNSUPPORTED_EXTENSION111242000Table 'str' uses an extension that doesn't exist in this MySQL version
TABLE_MUST_HAVE_COLUMNS111342000A table must have at least 1 column
RECORD_FILE_FULL1114HY000The table 'str' is full
UNKNOWN_CHARACTER_SET111542000Unknown character set: 'str'
TOO_MANY_TABLES1116HY000Too many tables; MySQL can only use # tables in a join
TOO_MANY_FIELDS1117HY000Too many columns
TOO_BIG_ROWSIZE111842000Row 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
STACK_OVERRUN1119HY000Thread stack overrun: Used: %ld of a %ld stack. Use 'mysqld --thread_stack=#' to specify a bigger stack if needed
WRONG_OUTER_JOIN112042000Cross dependency found in OUTER JOIN; examine your ON conditions
NULL_COLUMN_IN_INDEX112142000Table handler doesn't support NULL in given index. Please change column 'str' to be NOT NULL or use another handler
CANT_FIND_UDF1122HY000Can't load function 'str'
CANT_INITIALIZE_UDF1123HY000Can't initialize function 'str'; str
UDF_NO_PATHS1124HY000No paths allowed for shared library
UDF_EXISTS1125HY000Function 'str' already exists
CANT_OPEN_LIBRARY1126HY000Can't open shared library 'str' (errno: # str)
CANT_FIND_DL_ENTRY1127HY000Can't find symbol 'str' in library
FUNCTION_NOT_DEFINED1128HY000Function 'str' is not defined
HOST_IS_BLOCKED1129HY000Host 'str' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
HOST_NOT_PRIVILEGED1130HY000Host 'str' is not allowed to connect to this MySQL server
PASSWORD_ANONYMOUS_USER113142000You are using MySQL as an anonymous user and anonymous users are not allowed to change passwords
PASSWORD_NOT_ALLOWED113242000You must have privileges to update tables in the mysql database to be able to change passwords for others
PASSWORD_NO_MATCH113342000Can't find any matching row in the user table
UPDATE_INFO1134HY000Rows matched: %ld Changed: %ld Warnings: %ld
CANT_CREATE_THREAD1135HY000Can't create a new thread (errno #); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug
WRONG_VALUE_COUNT_ON_ROW113621S01Column count doesn't match value count at row %ld
CANT_REOPEN_TABLE1137HY000Can't reopen table: 'str'
INVALID_USE_OF_NULL113822004Invalid use of NULL value
REGEXP_ERROR113942000Got error 'str' from regexp
MIX_OF_GROUP_FUNC_AND_FIELDS114042000Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
NONEXISTING_GRANT114142000There is no such grant defined for user 'str' on host 'str'
TABLEACCESS_DENIED_ERROR114242000str command denied to user 'str'@'str' for table 'str'
COLUMNACCESS_DENIED_ERROR114342000str command denied to user 'str'@'str' for column 'str' in table 'str'
ILLEGAL_GRANT_FOR_TABLE114442000Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used
GRANT_WRONG_HOST_OR_USER114542000The host or user argument to GRANT is too long
NO_SUCH_TABLE114642S02Table 'str.str' doesn't exist
NONEXISTING_TABLE_GRANT114742000There is no such grant defined for user 'str' on host 'str' on table 'str'
NOT_ALLOWED_COMMAND114842000The used command is not allowed with this MySQL version
SYNTAX_ERROR114942000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use
DELAYED_CANT_CHANGE_LOCK1150HY000Delayed insert thread couldn't get requested lock for table str
TOO_MANY_DELAYED_THREADS1151HY000Too many delayed threads in use
ABORTING_CONNECTION115208S01Aborted connection %ld to db: 'str' user: 'str' (str)
NET_PACKET_TOO_LARGE115308S01Got a packet bigger than 'max_allowed_packet' bytes
NET_READ_ERROR_FROM_PIPE115408S01Got a read error from the connection pipe
NET_FCNTL_ERROR115508S01Got an error from fcntl()
NET_PACKETS_OUT_OF_ORDER115608S01Got packets out of order
NET_UNCOMPRESS_ERROR115708S01Couldn't uncompress communication packet
NET_READ_ERROR115808S01Got an error reading communication packets
NET_READ_INTERRUPTED115908S01Got timeout reading communication packets
NET_ERROR_ON_WRITE116008S01Got an error writing communication packets
NET_WRITE_INTERRUPTED116108S01Got timeout writing communication packets
TOO_LONG_STRING116242000Result string is longer than 'max_allowed_packet' bytes
TABLE_CANT_HANDLE_BLOB116342000The used table type doesn't support BLOB/TEXT columns
TABLE_CANT_HANDLE_AUTO_INCREMENT116442000The used table type doesn't support AUTO_INCREMENT columns
DELAYED_INSERT_TABLE_LOCKED1165HY000INSERT DELAYED can't be used with table 'str' because it is locked with LOCK TABLES
WRONG_COLUMN_NAME116642000Incorrect column name 'str'
WRONG_KEY_COLUMN116742000The used storage engine can't index column 'str'
WRONG_MRG_TABLE1168HY000Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist
DUP_UNIQUE116923000Can't write, because of unique constraint, to table 'str'
BLOB_KEY_WITHOUT_LENGTH117042000BLOB/TEXT column 'str' used in key specification without a key length
PRIMARY_CANT_HAVE_NULL117142000All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
TOO_MANY_ROWS117242000Result consisted of more than one row
REQUIRES_PRIMARY_KEY117342000This table type requires a primary key
NO_RAID_COMPILED1174HY000This version of MySQL is not compiled with RAID support
UPDATE_WITHOUT_KEY_IN_SAFE_MODE1175HY000You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
KEY_DOES_NOT_EXITS117642000Key 'str' doesn't exist in table 'str'
CHECK_NO_SUCH_TABLE117742000Can't open table
CHECK_NOT_IMPLEMENTED117842000The storage engine for the table doesn't support str
CANT_DO_THIS_DURING_AN_TRANSACTION117925000You are not allowed to execute this command in a transaction
ERROR_DURING_COMMIT1180HY000Got error # during COMMIT
NEW_ABORTING_CONNECTION118408S01Aborted connection %ld to db: 'str' user: 'str' host: 'str' (str)
DUMP_NOT_IMPLEMENTED1185HY000The storage engine for the table does not support binary table dump
INDEX_REBUILD1187HY000Failed rebuilding the index of dumped table 'str'
MASTER1188HY000Error from master: 'str'
MASTER_NET_READ118908S01Net error reading from master
MASTER_NET_WRITE119008S01Net error writing to master
FT_MATCHING_KEY_NOT_FOUND1191HY000Can't find FULLTEXT index matching the column list
LOCK_OR_ACTIVE_TRANSACTION1192HY000Can't execute the given command because you have active locked tables or an active transaction
UNKNOWN_SYSTEM_VARIABLE1193HY000Unknown system variable 'str'
CRASHED_ON_USAGE1194HY000Table 'str' is marked as crashed and should be repaired
CRASHED_ON_REPAIR1195HY000Table 'str' is marked as crashed and last (automatic?) repair failed
WARNING_NOT_COMPLETE_ROLLBACK1196HY000Some non-transactional changed tables couldn't be rolled back
TRANS_CACHE_FULL1197HY000Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again
SLAVE_MUST_STOP1198HY000This operation cannot be performed with a running slave; run STOP SLAVE first
SLAVE_NOT_RUNNING1199HY000This operation requires a running slave; configure slave and do START SLAVE
BAD_SLAVE1200HY000The server is not configured as slave; fix in config file or with CHANGE MASTER TO
MASTER_INFO1201HY000Could not initialize master info structure; more error messages can be found in the MySQL error log
SLAVE_THREAD1202HY000Could not create slave thread; check system resources
TOO_MANY_USER_CONNECTIONS120342000User str already has more than 'max_user_connections' active connections
SET_CONSTANTS_ONLY1204HY000You may only use constant expressions with SET
LOCK_WAIT_TIMEOUT1205HY000Lock wait timeout exceeded; try restarting transaction
LOCK_TABLE_FULL1206HY000The total number of locks exceeds the lock table size
READ_ONLY_TRANSACTION120725000Update locks cannot be acquired during a READ UNCOMMITTED transaction
DROP_DB_WITH_READ_LOCK1208HY000DROP DATABASE not allowed while thread is holding global read lock
CREATE_DB_WITH_READ_LOCK1209HY000CREATE DATABASE not allowed while thread is holding global read lock
WRONG_ARGUMENTS1210HY000Incorrect arguments to str
NO_PERMISSION_TO_CREATE_USER121142000'str'@'str' is not allowed to create new users
UNION_TABLES_IN_DIFFERENT_DIR1212HY000Incorrect table definition; all MERGE tables must be in the same database
LOCK_DEADLOCK121340001Deadlock found when trying to get lock; try restarting transaction
TABLE_CANT_HANDLE_FT1214HY000The used table type doesn't support FULLTEXT indexes
CANNOT_ADD_FOREIGN1215HY000Cannot add foreign key constraint
NO_REFERENCED_ROW121623000Cannot add or update a child row: a foreign key constraint fails
ROW_IS_REFERENCED121723000Cannot delete or update a parent row: a foreign key constraint fails
CONNECT_TO_MASTER121808S01Error connecting to master: str
QUERY_ON_MASTER1219HY000Error running query on master: str
ERROR_WHEN_EXECUTING_COMMAND1220HY000Error when executing command str: str
WRONG_USAGE1221HY000Incorrect usage of str and str
WRONG_NUMBER_OF_COLUMNS_IN_SELECT122221000The used SELECT statements have a different number of columns
CANT_UPDATE_WITH_READLOCK1223HY000Can't execute the query because you have a conflicting read lock
MIXING_NOT_ALLOWED1224HY000Mixing of transactional and non-transactional tables is disabled
DUP_ARGUMENT1225HY000Option 'str' used twice in statement
USER_LIMIT_REACHED122642000User 'str' has exceeded the 'str' resource (current value: %ld)
SPECIFIC_ACCESS_DENIED_ERROR122742000Access denied; you need (at least one of) the str privilege(s) for this operation
LOCAL_VARIABLE1228HY000Variable 'str' is a SESSION variable and can't be used with SET GLOBAL
GLOBAL_VARIABLE1229HY000Variable 'str' is a GLOBAL variable and should be set with SET GLOBAL
NO_DEFAULT123042000Variable 'str' doesn't have a default value
WRONG_VALUE_FOR_VAR123142000Variable 'str' can't be set to the value of 'str'
WRONG_TYPE_FOR_VAR123242000Incorrect argument type to variable 'str'
VAR_CANT_BE_READ1233HY000Variable 'str' can only be set, not read
CANT_USE_OPTION_HERE123442000Incorrect usage/placement of 'str'
NOT_SUPPORTED_YET123542000This version of MySQL doesn't yet support 'str'
MASTER_FATAL_ERROR_READING_BINLOG1236HY000Got fatal error # from master when reading data from binary log: 'str'
SLAVE_IGNORED_TABLE1237HY000Slave SQL thread ignored the query because of replicate-*-table rules
INCORRECT_GLOBAL_LOCAL_VAR1238HY000Variable 'str' is a str variable
WRONG_FK_DEF123942000Incorrect foreign key definition for 'str': str
KEY_REF_DO_NOT_MATCH_TABLE_REF1240HY000Key reference and table reference don't match
OPERAND_COLUMNS124121000Operand should contain # column(s)
SUBQUERY_NO_1_ROW124221000Subquery returns more than 1 row
UNKNOWN_STMT_HANDLER1243HY000Unknown prepared statement handler (%.*s) given to str
CORRUPT_HELP_DB1244HY000Help database is corrupt or does not exist
CYCLIC_REFERENCE1245HY000Cyclic reference on subqueries
AUTO_CONVERT1246HY000Converting column 'str' from str to str
ILLEGAL_REFERENCE124742S22Reference 'str' not supported (str)
DERIVED_MUST_HAVE_ALIAS124842000Every derived table must have its own alias
SELECT_REDUCED124901000Select %u was reduced during optimization
TABLENAME_NOT_ALLOWED_HERE125042000Table 'str' from one of the SELECTs cannot be used in str
NOT_SUPPORTED_AUTH_MODE125108004Client does not support authentication protocol requested by server; consider upgrading MySQL client
SPATIAL_CANT_HAVE_NULL125242000All parts of a SPATIAL index must be NOT NULL
SLAVE_WAS_RUNNING1254HY000Slave is already running
SLAVE_WAS_NOT_RUNNING1255HY000Slave already has been stopped
TOO_BIG_FOR_UNCOMPRESS1256HY000Uncompressed data size too large; the maximum size is # (probably, length of uncompressed data was corrupted)
ZLIB_Z_MEM_ERROR1257HY000ZLIB: Not enough memory
ZLIB_Z_BUF_ERROR1258HY000ZLIB: Not enough room in the output buffer (probably, length of uncompressed data was corrupted)
ZLIB_Z_DATA_ERROR1259HY000ZLIB: Input data corrupted
WARN_TOO_FEW_RECORDS126101000Row %ld doesn't contain data for all columns
WARN_TOO_MANY_RECORDS126201000Row %ld was truncated; it contained more data than there were input columns
WARN_NULL_TO_NOTNULL126322004Column set to default value; NULL supplied to NOT NULL column 'str' at row %ld
WARN_DATA_OUT_OF_RANGE126422003Out of range value for column 'str' at row %ld
WARN_DATA_TRUNCATED126501000Data truncated for column 'str' at row %ld
WARN_USING_OTHER_HANDLER1266HY000Using storage engine str for table 'str'
CANT_AGGREGATE_2COLLATIONS1267HY000Illegal mix of collations (str,str) and (str,str) for operation 'str'
DROP_USER1268HY000Cannot drop one or more of the requested users
REVOKE_GRANTS1269HY000Can't revoke all privileges for one or more of the requested users
CANT_AGGREGATE_3COLLATIONS1270HY000Illegal mix of collations (str,str), (str,str), (str,str) for operation 'str'
CANT_AGGREGATE_NCOLLATIONS1271HY000Illegal mix of collations for operation 'str'
VARIABLE_IS_NOT_STRUCT1272HY000Variable 'str' is not a variable component (can't be used as XXXX.variable_name)
UNKNOWN_COLLATION1273HY000Unknown collation: 'str'
SLAVE_IGNORED_SSL_PARAMS1274HY000SSL parameters in CHANGE MASTER are ignored because this MySQL slave was compiled without SSL support; they can be used later if MySQL slave with SSL is started
SERVER_IS_IN_SECURE_AUTH_MODE1275HY000Server is running in --secure-auth mode, but 'str'@'str' has a password in the old format; please change the password to the new format
WARN_FIELD_RESOLVED1276HY000Field or reference 'strstrstrstrstr' of SELECT ## was resolved in SELECT ##
BAD_SLAVE_UNTIL_COND1277HY000Incorrect parameter or combination of parameters for START SLAVE UNTIL
MISSING_SKIP_SLAVE1278HY000It 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
UNTIL_COND_IGNORED1279HY000SQL thread is not to be started so UNTIL options are ignored
WRONG_NAME_FOR_INDEX128042000Incorrect index name 'str'
WRONG_NAME_FOR_CATALOG128142000Incorrect catalog name 'str'
WARN_QC_RESIZE1282HY000Query cache failed to set size %lu; new query cache size is %lu
BAD_FT_COLUMN1283HY000Column 'str' cannot be part of FULLTEXT index
UNKNOWN_KEY_CACHE1284HY000Unknown key cache 'str'
WARN_HOSTNAME_WONT_WORK1285HY000MySQL is started in --skip-name-resolve mode; you must restart it without this switch for this grant to work
UNKNOWN_STORAGE_ENGINE128642000Unknown storage engine 'str'
WARN_DEPRECATED_SYNTAX1287HY000'str' is deprecated and will be removed in a future release. Please use str instead
NON_UPDATABLE_TABLE1288HY000The target table str of the str is not updatable
FEATURE_DISABLED1289HY000The 'str' feature is disabled; you need MySQL built with 'str' to have it working
OPTION_PREVENTS_STATEMENT1290HY000The MySQL server is running with the str option so it cannot execute this statement
DUPLICATED_VALUE_IN_TYPE1291HY000Column 'str' has duplicated value 'str' in str
TRUNCATED_WRONG_VALUE129222007Truncated incorrect str value: 'str'
TOO_MUCH_AUTO_TIMESTAMP_COLS1293HY000Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
INVALID_ON_UPDATE1294HY000Invalid ON UPDATE clause for 'str' column
UNSUPPORTED_PS1295HY000This command is not supported in the prepared statement protocol yet
GET_ERRMSG1296HY000Got error # 'str' from str
GET_TEMPORARY_ERRMSG1297HY000Got temporary error # 'str' from str
UNKNOWN_TIME_ZONE1298HY000Unknown or incorrect time zone: 'str'
WARN_INVALID_TIMESTAMP1299HY000Invalid TIMESTAMP value in column 'str' at row %ld
INVALID_CHARACTER_STRING1300HY000Invalid str character string: 'str'
WARN_ALLOWED_PACKET_OVERFLOWED1301HY000Result of str() was larger than max_allowed_packet (%ld) - truncated
CONFLICTING_DECLARATIONS1302HY000Conflicting declarations: 'strstr' and 'strstr'
SP_NO_RECURSIVE_CREATE13032F003Can't create a str from within another stored routine
SP_ALREADY_EXISTS130442000str str already exists
SP_DOES_NOT_EXIST130542000str str does not exist
SP_DROP_FAILED1306HY000Failed to DROP str str
SP_STORE_FAILED1307HY000Failed to CREATE str str
SP_LILABEL_MISMATCH130842000str with no matching label: str
SP_LABEL_REDEFINE130942000Redefining label str
SP_LABEL_MISMATCH131042000End-label str without match
SP_UNINIT_VAR131101000Referring to uninitialized variable str
SP_BADSELECT13120A000PROCEDURE str can't return a result set in the given context
SP_BADRETURN131342000RETURN is only allowed in a FUNCTION
SP_BADSTATEMENT13140A000str is not allowed in stored procedures
UPDATE_LOG_DEPRECATED_IGNORED131542000The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been ignored. This option will be removed in MySQL 5.6.
UPDATE_LOG_DEPRECATED_TRANSLATED131642000The 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 MySQL 5.6.
QUERY_INTERRUPTED131770100Query execution was interrupted
SP_WRONG_NO_OF_ARGS131842000Incorrect number of arguments for str str; expected %u, got %u
SP_COND_MISMATCH131942000Undefined CONDITION: str
SP_NORETURN132042000No RETURN found in FUNCTION str
SP_NORETURNEND13212F005FUNCTION str ended without RETURN
SP_BAD_CURSOR_QUERY132242000Cursor statement must be a SELECT
SP_BAD_CURSOR_SELECT132342000Cursor SELECT must not have INTO
SP_CURSOR_MISMATCH132442000Undefined CURSOR: str
SP_CURSOR_ALREADY_OPEN132524000Cursor is already open
SP_CURSOR_NOT_OPEN132624000Cursor is not open
SP_UNDECLARED_VAR132742000Undeclared variable: str
SP_WRONG_NO_OF_FETCH_ARGS1328HY000Incorrect number of FETCH variables
SP_FETCH_NO_DATA132902000No data - zero rows fetched, selected, or processed
SP_DUP_PARAM133042000Duplicate parameter: str
SP_DUP_VAR133142000Duplicate variable: str
SP_DUP_COND133242000Duplicate condition: str
SP_DUP_CURS133342000Duplicate cursor: str
SP_CANT_ALTER1334HY000Failed to ALTER str str
SP_SUBSELECT_NYI13350A000Subquery value not supported
STMT_NOT_ALLOWED_IN_SF_OR_TRG13360A000str is not allowed in stored function or trigger
SP_VARCOND_AFTER_CURSHNDLR133742000Variable or condition declaration after cursor or handler declaration
SP_CURSOR_AFTER_HANDLER133842000Cursor declaration after handler declaration
SP_CASE_NOT_FOUND133920000Case not found for CASE statement
FPARSER_TOO_BIG_FILE1340HY000Configuration file 'str' is too big
FPARSER_BAD_HEADER1341HY000Malformed file type header in file 'str'
FPARSER_EOF_IN_COMMENT1342HY000Unexpected end of file while parsing comment 'str'
FPARSER_ERROR_IN_PARAMETER1343HY000Error while parsing parameter 'str' (line: 'str')
FPARSER_EOF_IN_UNKNOWN_PARAMETER1344HY000Unexpected end of file while skipping unknown parameter 'str'
VIEW_NO_EXPLAIN1345HY000EXPLAIN/SHOW can not be issued; lacking privileges for underlying table
FRM_UNKNOWN_TYPE1346HY000File 'str' has unknown type 'str' in its header
WRONG_OBJECT1347HY000'str.str' is not str
NONUPDATEABLE_COLUMN1348HY000Column 'str' is not updatable
VIEW_SELECT_DERIVED1349HY000View's SELECT contains a subquery in the FROM clause
VIEW_SELECT_CLAUSE1350HY000View's SELECT contains a 'str' clause
VIEW_SELECT_VARIABLE1351HY000View's SELECT contains a variable or parameter
VIEW_SELECT_TMPTABLE1352HY000View's SELECT refers to a temporary table 'str'
VIEW_WRONG_LIST1353HY000View's SELECT and view's field list have different column counts
WARN_VIEW_MERGE1354HY000View merge algorithm can't be used here for now (assumed undefined algorithm)
WARN_VIEW_WITHOUT_KEY1355HY000View being updated does not have complete key of underlying table in it
VIEW_INVALID1356HY000View 'str.str' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
SP_NO_DROP_SP1357HY000Can't drop or alter a str from within another stored routine
SP_GOTO_IN_HNDLR1358HY000GOTO is not allowed in a stored procedure handler
TRG_ALREADY_EXISTS1359HY000Trigger already exists
TRG_DOES_NOT_EXIST1360HY000Trigger does not exist
TRG_ON_VIEW_OR_TEMP_TABLE1361HY000Trigger's 'str' is view or temporary table
TRG_CANT_CHANGE_ROW1362HY000Updating of str row is not allowed in strtrigger
TRG_NO_SUCH_ROW_IN_TRG1363HY000There is no str row in str trigger
NO_DEFAULT_FOR_FIELD1364HY000Field 'str' doesn't have a default value
DIVISION_BY_ZERO136522012Division by 0
TRUNCATED_WRONG_VALUE_FOR_FIELD1366HY000Incorrect str value: 'str' for column 'str' at row %ld
ILLEGAL_VALUE_FOR_TYPE136722007Illegal str 'str' value found during parsing
VIEW_NONUPD_CHECK1368HY000CHECK OPTION on non-updatable view 'str.str'
PROCACCESS_DENIED_ERROR137042000str command denied to user 'str'@'str' for routine 'str'
RELAY_LOG_FAIL1371HY000Failed purging old relay logs: str
PASSWD_LENGTH1372HY000Password hash should be a #-digit hexadecimal number
UNKNOWN_TARGET_BINLOG1373HY000Target log not found in binlog index
IO_ERR_LOG_INDEX_READ1374HY000I/O error reading log index file
BINLOG_PURGE_PROHIBITED1375HY000Server configuration does not permit binlog purge
FSEEK_FAIL1376HY000Failed on fseek()
BINLOG_PURGE_FATAL_ERR1377HY000Fatal error during log purge
LOG_IN_USE1378HY000A purgeable log is in use, will not purge
LOG_PURGE_UNKNOWN_ERR1379HY000Unknown error during log purge
RELAY_LOG_INIT1380HY000Failed initializing relay log position: str
NO_BINARY_LOGGING1381HY000You are not using binary logging
RESERVED_SYNTAX1382HY000The 'str' syntax is reserved for purposes internal to the MySQL server
WSAS_FAILED1383HY000WSAStartup Failed
DIFF_GROUPS_PROC1384HY000Can't handle procedures with different groups yet
NO_GROUP_FOR_PROC1385HY000Select must have a group with this procedure
ORDER_WITH_PROC1386HY000Can't use ORDER clause with this procedure
LOGGING_PROHIBIT_CHANGING_OF1387HY000Binary logging and replication forbid changing the global server str
NO_FILE_MAPPING1388HY000Can't map file: str, errno: #
WRONG_MAGIC1389HY000Wrong magic in str
PS_MANY_PARAM1390HY000Prepared statement contains too many placeholders
KEY_PART_01391HY000Key part 'str' length cannot be 0
VIEW_CHECKSUM1392HY000View text checksum failed
VIEW_MULTIUPDATE1393HY000Can not modify more than one base table through a join view 'str.str'
VIEW_NO_INSERT_FIELD_LIST1394HY000Can not insert into join view 'str.str' without fields list
VIEW_DELETE_MERGE_VIEW1395HY000Can not delete from join view 'str.str'
CANNOT_USER1396HY000Operation str failed for str
XAER_INVAL1398XAE05XAER_INVAL: Invalid arguments (or unsupported command)
XAER_RMFAIL1399XAE07XAER_RMFAIL: The command cannot be executed when global transaction is in the str state
XAER_OUTSIDE1400XAE09XAER_OUTSIDE: Some work is done outside global transaction
XAER_RMERR1401XAE03XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency
XA_RBROLLBACK1402XA100XA_RBROLLBACK: Transaction branch was rolled back
NONEXISTING_PROC_GRANT140342000There is no such grant defined for user 'str' on host 'str' on routine 'str'
PROC_AUTO_GRANT_FAIL1404HY000Failed to grant EXECUTE and ALTER ROUTINE privileges
PROC_AUTO_REVOKE_FAIL1405HY000Failed to revoke all privileges to dropped routine
DATA_TOO_LONG140622001Data too long for column 'str' at row %ld
SP_BAD_SQLSTATE140742000Bad 'str'
STARTUP1408HY000str: ready for connections. Version: 'str' socket: 'str' port: # str
LOAD_FROM_FIXED_SIZE_ROWS_TO_VAR1409HY000Can't load value from file with fixed size rows to variable
CANT_CREATE_USER_WITH_GRANT141042000You are not allowed to create a user with GRANT
WRONG_VALUE_FOR_TYPE1411HY000Incorrect str value: 'str' for function str
TABLE_DEF_CHANGED1412HY000Table definition has changed, please retry transaction
SP_DUP_HANDLER141342000Duplicate handler declared in the same block
SP_NOT_VAR_ARG141442000OUT or INOUT argument # for routine str is not a variable or NEW pseudo-variable in BEFORE trigger
SP_NO_RETSET14150A000Not allowed to return a result set from a str
CANT_CREATE_GEOMETRY_OBJECT141622003Cannot get geometry object from data you send to the GEOMETRY field
FAILED_ROUTINE_BREAK_BINLOG1417HY000A 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
BINLOG_UNSAFE_ROUTINE1418HY000This 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)
BINLOG_CREATE_ROUTINE_NEED_SUPER1419HY000You 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)
EXEC_STMT_WITH_OPEN_CURSOR1420HY000You can't execute a prepared statement which has an open cursor associated with it. Reset the statement to re-execute it.
STMT_HAS_NO_OPEN_CURSOR1421HY000The statement (%lu) has no open cursor.
COMMIT_NOT_ALLOWED_IN_SF_OR_TRG1422HY000Explicit or implicit commit is not allowed in stored function or trigger.
NO_DEFAULT_FOR_VIEW_FIELD1423HY000Field of view 'str.str' underlying table doesn't have a default value
SP_NO_RECURSION1424HY000Recursive stored functions and triggers are not allowed.
TOO_BIG_SCALE142542000Too big scale # specified for column 'str'. Maximum is %lu.
TOO_BIG_PRECISION142642000Too big precision # specified for column 'str'. Maximum is %lu.
M_BIGGER_THAN_D142742000For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column 'str').
WRONG_LOCK_OF_SYSTEM_TABLE1428HY000You can't combine write-locking of system tables with other tables or lock types
CONNECT_TO_FOREIGN_DATA_SOURCE1429HY000Unable to connect to foreign data source: str
QUERY_ON_FOREIGN_DATA_SOURCE1430HY000There was a problem processing the query on the foreign data source. Data source str
FOREIGN_DATA_SOURCE_DOESNT_EXIST1431HY000The foreign data source you are trying to reference does not exist. Data source str
FOREIGN_DATA_STRING_INVALID_CANT_CREATE1432HY000Can't create federated table. The data source connection string 'str' is not in the correct format
FOREIGN_DATA_STRING_INVALID1433HY000The data source connection string 'str' is not in the correct format
CANT_CREATE_FEDERATED_TABLE1434HY000Can't create federated table. Foreign data src str
TRG_IN_WRONG_SCHEMA1435HY000Trigger in wrong schema
STACK_OVERRUN_NEED_MORE1436HY000Thread stack overrun: %ld bytes used of a %ld byte stack, and %ld bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.
TOO_LONG_BODY143742000Routine body for 'str' is too long
WARN_CANT_DROP_DEFAULT_KEYCACHE1438HY000Cannot drop default keycache
TOO_BIG_DISPLAYWIDTH143942000Display width out of range for column 'str' (max = %lu)
XAER_DUPID1440XAE08XAER_DUPID: The XID already exists
DATETIME_FUNCTION_OVERFLOW144122008Datetime function: str field overflow
CANT_UPDATE_USED_TABLE_IN_SF_OR_TRG1442HY000Can't update table 'str' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
VIEW_PREVENT_UPDATE1443HY000The definition of table 'str' prevents operation str on table 'str'.
PS_NO_RECURSION1444HY000The 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
SP_CANT_SET_AUTOCOMMIT1445HY000Not allowed to set autocommit from a stored function or trigger
MALFORMED_DEFINER1446HY000Definer is not fully qualified
VIEW_FRM_NO_USER1447HY000View 'str'.'str' has no definer information (old table format). Current user is used as definer. Please recreate the view!
VIEW_OTHER_USER1448HY000You need the SUPER privilege for creation view with 'str'@'str' definer
NO_SUCH_USER1449HY000The user specified as a definer ('str'@'str') does not exist
FORBID_SCHEMA_CHANGE1450HY000Changing schema from 'str' to 'str' is not allowed.
ROW_IS_REFERENCED_2145123000Cannot delete or update a parent row: a foreign key constraint fails (str)
NO_REFERENCED_ROW_2145223000Cannot add or update a child row: a foreign key constraint fails (str)
SP_BAD_VAR_SHADOW145342000Variable 'str' must be quoted with `...`, or renamed
TRG_NO_DEFINER1454HY000No definer attribute for trigger 'str'.'str'. The trigger will be activated under the authorization of the invoker, which may have insufficient privileges. Please recreate the trigger.
OLD_FILE_FORMAT1455HY000'str' has an old format, you should re-create the 'str' object(s)
SP_RECURSION_LIMIT1456HY000Recursive limit # (as set by the max_sp_recursion_depth variable) was exceeded for routine str
SP_PROC_TABLE_CORRUPT1457HY000Failed to load routine str. The table mysql.proc is missing, corrupt, or contains bad data (internal code #)
SP_WRONG_NAME145842000Incorrect routine name 'str'
TABLE_NEEDS_UPGRADE1459HY000Table upgrade required. Please do "REPAIR TABLE `str`" or dump/reload to fix it!
SP_NO_AGGREGATE146042000AGGREGATE is not supported for stored functions
MAX_PREPARED_STMT_COUNT_REACHED146142000Can't create more than max_prepared_stmt_count statements (current value: %lu)
VIEW_RECURSIVE1462HY000`str`.`str` contains view recursion
NON_GROUPING_FIELD_USED146342000non-grouping field 'str' is used in str clause
TABLE_CANT_HANDLE_SPKEYS1464HY000The used table type doesn't support SPATIAL indexes
NO_TRIGGERS_ON_SYSTEM_SCHEMA1465HY000Triggers can not be created on system tables
REMOVED_SPACES1466HY000Leading spaces are removed from name 'str'
AUTOINC_READ_FAILED1467HY000Failed to read auto-increment value from storage engine
USERNAME1468HY000user name
HOSTNAME1469HY000host name
WRONG_STRING_LENGTH1470HY000String 'str' is too long for str (should be no longer than #)
NON_INSERTABLE_TABLE1471HY000The target table str of the str is not insertable-into
ADMIN_WRONG_MRG_TABLE1472HY000Table 'str' is differently defined or of non-MyISAM type or doesn't exist
TOO_HIGH_LEVEL_OF_NESTING_FOR_SELECT1473HY000Too high level of nesting for select
NAME_BECOMES_EMPTY1474HY000Name 'str' has become ''
AMBIGUOUS_FIELD_TERM1475HY000First character of the FIELDS TERMINATED string is ambiguous; please use non-optional and non-empty FIELDS ENCLOSED BY
FOREIGN_SERVER_EXISTS1476HY000The foreign server, str, you are trying to create already exists.
FOREIGN_SERVER_DOESNT_EXIST1477HY000The foreign server name you are trying to reference does not exist. Data source str
ILLEGAL_HA_CREATE_OPTION1478HY000Table storage engine 'str' does not support the create option 'str'
PARTITION_REQUIRES_VALUES_ERROR1479HY000Syntax str PARTITIONING requires definition of VALUES str for each partition
PARTITION_WRONG_VALUES_ERROR1480HY000Only str PARTITIONING can use VALUES str in partition definition
PARTITION_MAXVALUE_ERROR1481HY000MAXVALUE can only be used in last partition definition
PARTITION_SUBPARTITION_ERROR1482HY000Subpartitions can only be hash partitions and by key
PARTITION_SUBPART_MIX_ERROR1483HY000Must define subpartitions on all partitions if on one partition
PARTITION_WRONG_NO_PART_ERROR1484HY000Wrong number of partitions defined, mismatch with previous setting
PARTITION_WRONG_NO_SUBPART_ERROR1485HY000Wrong number of subpartitions defined, mismatch with previous setting
WRONG_EXPR_IN_PARTITION_FUNC_ERROR1486HY000Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed
FIELD_NOT_FOUND_PART_ERROR1488HY000Field in list of fields for partition function not found in table
LIST_OF_FIELDS_ONLY_IN_HASH_ERROR1489HY000List of fields is only allowed in KEY partitions
INCONSISTENT_PARTITION_INFO_ERROR1490HY000The partition info in the frm file is not consistent with what can be written into the frm file
PARTITION_FUNC_NOT_ALLOWED_ERROR1491HY000The str function returns the wrong type
PARTITIONS_MUST_BE_DEFINED_ERROR1492HY000For str partitions each partition must be defined
RANGE_NOT_INCREASING_ERROR1493HY000VALUES LESS THAN value must be strictly increasing for each partition
INCONSISTENT_TYPE_OF_FUNCTIONS_ERROR1494HY000VALUES value must be of same type as partition function
MULTIPLE_DEF_CONST_IN_LIST_PART_ERROR1495HY000Multiple definition of same constant in list partitioning
PARTITION_ENTRY_ERROR1496HY000Partitioning can not be used stand-alone in query
MIX_HANDLER_ERROR1497HY000The mix of handlers in the partitions is not allowed in this version of MySQL
PARTITION_NOT_DEFINED_ERROR1498HY000For the partitioned engine it is necessary to define all str
TOO_MANY_PARTITIONS_ERROR1499HY000Too many partitions (including subpartitions) were defined
SUBPARTITION_ERROR1500HY000It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning
CANT_CREATE_HANDLER_FILE1501HY000Failed to create specific handler file
BLOB_FIELD_IN_PART_FUNC_ERROR1502HY000A BLOB field is not allowed in partition function
UNIQUE_KEY_NEED_ALL_FIELDS_IN_PF1503HY000A str must include all columns in the table's partitioning function
NO_PARTS_ERROR1504HY000Number of str = 0 is not an allowed value
PARTITION_MGMT_ON_NONPARTITIONED1505HY000Partition management on a not partitioned table is not possible
FOREIGN_KEY_ON_PARTITIONED1506HY000Foreign key clause is not yet supported in conjunction with partitioning
DROP_PARTITION_NON_EXISTENT1507HY000Error in list of partitions to str
DROP_LAST_PARTITION1508HY000Cannot remove all partitions, use DROP TABLE instead
REORG_HASH_ONLY_ON_SAME_NO1510HY000REORGANIZE PARTITION can only be used to reorganize partitions not to change their numbers
REORG_NO_PARAM_ERROR1511HY000REORGANIZE PARTITION without parameters can only be used on auto-partitioned tables using HASH PARTITIONs
ONLY_ON_RANGE_LIST_PARTITION1512HY000str PARTITION can only be used on RANGE/LIST partitions
ADD_PARTITION_SUBPART_ERROR1513HY000Trying to Add partition(s) with wrong number of subpartitions
ADD_PARTITION_NO_NEW_PARTITION1514HY000At least one partition must be added
COALESCE_PARTITION_NO_PARTITION1515HY000At least one partition must be coalesced
REORG_PARTITION_NOT_EXIST1516HY000More partitions to reorganize than there are partitions
SAME_NAME_PARTITION1517HY000Duplicate partition name str
NO_BINLOG_ERROR1518HY000It is not allowed to shut off binlog on this command
CONSECUTIVE_REORG_PARTITIONS1519HY000When reorganizing a set of partitions they must be in consecutive order
REORG_OUTSIDE_RANGE1520HY000Reorganize of range partitions cannot change total ranges except for last partition where it can extend the range
PARTITION_FUNCTION_FAILURE1521HY000Partition function not supported in this version for this handler
PART_STATE_ERROR1522HY000Partition state cannot be defined from CREATE/ALTER TABLE
LIMITED_PART_RANGE1523HY000The str handler only supports 32 bit integers in VALUES
PLUGIN_IS_NOT_LOADED1524HY000Plugin 'str' is not loaded
WRONG_VALUE1525HY000Incorrect str value: 'str'
NO_PARTITION_FOR_GIVEN_VALUE1526HY000Table has no partition for value str
FILEGROUP_OPTION_ONLY_ONCE1527HY000It is not allowed to specify str more than once
CREATE_FILEGROUP_FAILED1528HY000Failed to create str
DROP_FILEGROUP_FAILED1529HY000Failed to drop str
TABLESPACE_AUTO_EXTEND_ERROR1530HY000The handler doesn't support autoextend of tablespaces
WRONG_SIZE_NUMBER1531HY000A size parameter was incorrectly specified, either number or on the form 10M
SIZE_OVERFLOW_ERROR1532HY000The size number was correct but we don't allow the digit part to be more than 2 billion
ALTER_FILEGROUP_FAILED1533HY000Failed to alter: str
BINLOG_ROW_LOGGING_FAILED1534HY000Writing one row to the row-based binary log failed
BINLOG_ROW_WRONG_TABLE_DEF1535HY000Table definition on master and slave does not match: str
BINLOG_ROW_RBR_TO_SBR1536HY000Slave running with --log-slave-updates must use row-based binary logging to be able to replicate row-based binary log events
EVENT_ALREADY_EXISTS1537HY000Event 'str' already exists
EVENT_STORE_FAILED1538HY000Failed to store event str. Error code # from storage engine.
EVENT_DOES_NOT_EXIST1539HY000Unknown event 'str'
EVENT_CANT_ALTER1540HY000Failed to alter event 'str'
EVENT_DROP_FAILED1541HY000Failed to drop str
EVENT_INTERVAL_NOT_POSITIVE_OR_TOO_BIG1542HY000INTERVAL is either not positive or too big
EVENT_ENDS_BEFORE_STARTS1543HY000ENDS is either invalid or before STARTS
EVENT_EXEC_TIME_IN_THE_PAST1544HY000Event execution time is in the past. Event has been disabled
EVENT_OPEN_TABLE_FAILED1545HY000Failed to open mysql.event
EVENT_NEITHER_M_EXPR_NOR_M_AT1546HY000No datetime expression provided
COL_COUNT_DOESNT_MATCH_CORRUPTED1547HY000Column count of mysql.str is wrong. Expected #, found #. The table is probably corrupted
CANNOT_LOAD_FROM_TABLE1548HY000Cannot load from mysql.str. The table is probably corrupted
EVENT_CANNOT_DELETE1549HY000Failed to delete the event from mysql.event
EVENT_COMPILE_ERROR1550HY000Error during compilation of event's body
EVENT_SAME_NAME1551HY000Same old and new event name
EVENT_DATA_TOO_LONG1552HY000Data for column 'str' too long
DROP_INDEX_FK1553HY000Cannot drop index 'str': needed in a foreign key constraint
WARN_DEPRECATED_SYNTAX_WITH_VER1554HY000The syntax 'str' is deprecated and will be removed in MySQL str. Please use str instead
CANT_WRITE_LOCK_LOG_TABLE1555HY000You can't write-lock a log table. Only read access is possible
CANT_LOCK_LOG_TABLE1556HY000You can't use locks with log tables.
FOREIGN_DUPLICATE_KEY155723000Upholding foreign key constraints for table 'str', entry 'str', key # would lead to a duplicate entry
COL_COUNT_DOESNT_MATCH_PLEASE_UPDATE1558HY000Column count of mysql.str is wrong. Expected #, found #. Created with MySQL #, now running #. Please use mysql_upgrade to fix this error.
TEMP_TABLE_PREVENTS_SWITCH_OUT_OF_RBR1559HY000Cannot switch out of the row-based binary log format when the session has open temporary tables
STORED_FUNCTION_PREVENTS_SWITCH_BINLOG_FORMAT1560HY000Cannot change the binary logging format inside a stored function or trigger
NDB_CANT_SWITCH_BINLOG_FORMAT1561HY000The NDB cluster engine does not support changing the binlog format on the fly yet
PARTITION_NO_TEMPORARY1562HY000Cannot create temporary table with partitions
PARTITION_CONST_DOMAIN_ERROR1563HY000Partition constant is out of partition function domain
PARTITION_FUNCTION_IS_NOT_ALLOWED1564HY000This partition function is not allowed
DDL_LOG_ERROR1565HY000Error in DDL log
NULL_IN_VALUES_LESS_THAN1566HY000Not allowed to use NULL value in VALUES LESS THAN
WRONG_PARTITION_NAME1567HY000Incorrect partition name
CANT_CHANGE_TX_ISOLATION156825001Transaction isolation level can't be changed while a transaction is in progress
DUP_ENTRY_AUTOINCREMENT_CASE1569HY000ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry 'str' for key 'str'
EVENT_MODIFY_QUEUE_ERROR1570HY000Internal scheduler error #
EVENT_SET_VAR_ERROR1571HY000Error during starting/stopping of the scheduler. Error code %u
PARTITION_MERGE_ERROR1572HY000Engine cannot be used in partitioned tables
CANT_ACTIVATE_LOG1573HY000Cannot activate 'str' log
RBR_NOT_AVAILABLE1574HY000The server was not built with row-based replication
BASE64_DECODE_ERROR1575HY000Decoding of base64 string failed
EVENT_RECURSION_FORBIDDEN1576HY000Recursion of EVENT DDL statements is forbidden when body is present
EVENTS_DB_ERROR1577HY000Cannot proceed because system tables used by Event Scheduler were found damaged at server start
ONLY_INTEGERS_ALLOWED1578HY000Only integers allowed as number here
UNSUPORTED_LOG_ENGINE1579HY000This storage engine cannot be used for log tables"
BAD_LOG_STATEMENT1580HY000You cannot 'str' a log table if logging is enabled
CANT_RENAME_LOG_TABLE1581HY000Cannot rename 'str'. When logging enabled, rename to/from log table must rename two tables: the log table to an archive table and another table back to 'str'
WRONG_PARAMCOUNT_TO_NATIVE_FCT158242000Incorrect parameter count in the call to native function 'str'
WRONG_PARAMETERS_TO_NATIVE_FCT158342000Incorrect parameters in the call to native function 'str'
WRONG_PARAMETERS_TO_STORED_FCT158442000Incorrect parameters in the call to stored function 'str'
NATIVE_FCT_NAME_COLLISION1585HY000This function 'str' has the same name as a native function
DUP_ENTRY_WITH_KEY_NAME158623000Duplicate entry 'str' for key 'str'
BINLOG_PURGE_EMFILE1587HY000Too many files opened, please execute the command again
EVENT_CANNOT_CREATE_IN_THE_PAST1588HY000Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was dropped immediately after creation.
EVENT_CANNOT_ALTER_IN_THE_PAST1589HY000Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was dropped immediately after creation.
SLAVE_INCIDENT1590HY000The incident str occured on the master. Message: str
NO_PARTITION_FOR_GIVEN_VALUE_SILENT1591HY000Table has no partition for some existing values
BINLOG_UNSAFE_STATEMENT1592HY000Unsafe statement binlogged in statement format since BINLOG_FORMAT = STATEMENT. Reason for unsafeness: str
SLAVE_RELAY_LOG_READ_FAILURE1594HY000Relay log read failure: str
SLAVE_RELAY_LOG_WRITE_FAILURE1595HY000Relay log write failure: str
SLAVE_CREATE_EVENT_FAILURE1596HY000Failed to create str
SLAVE_MASTER_COM_FAILURE1597HY000Master command str failed: str
BINLOG_LOGGING_IMPOSSIBLE1598HY000Binary logging not possible. Message: str
VIEW_NO_CREATION_CTX1599HY000View `str`.`str` has no creation context
VIEW_INVALID_CREATION_CTX1600HY000Creation context of view `str`.`str' is invalid
SR_INVALID_CREATION_CTX1601HY000Creation context of stored routine `str`.`str` is invalid
TRG_CORRUPTED_FILE1602HY000Corrupted TRG file for table `str`.`str`
TRG_NO_CREATION_CTX1603HY000Triggers for table `str`.`str` have no creation context
TRG_INVALID_CREATION_CTX1604HY000Trigger creation context of table `str`.`str` is invalid
EVENT_INVALID_CREATION_CTX1605HY000Creation context of event `str`.`str` is invalid
TRG_CANT_OPEN_TABLE1606HY000Cannot open table for trigger `str`.`str`
CANT_CREATE_SROUTINE1607HY000Cannot create stored routine `str`. Check warnings
NEVER_USED1608HY000Ambiguous slave modes combination. str
NO_FORMAT_DESCRIPTION_EVENT_BEFORE_BINLOG_STATEMENT1609HY000The BINLOG statement of type `str` was not preceded by a format description BINLOG statement.
SLAVE_CORRUPT_EVENT1610HY000Corrupted replication event was detected
LOAD_DATA_INVALID_COLUMN1611HY000Invalid column reference (str) in LOAD DATA
LOG_PURGE_NO_FILE1612HY000Being purged log str was not found
XA_RBTIMEOUT1613XA106XA_RBTIMEOUT: Transaction branch was rolled back: took too long
XA_RBDEADLOCK1614XA102XA_RBDEADLOCK: Transaction branch was rolled back: deadlock was detected
NEED_REPREPARE1615HY000Prepared statement needs to be re-prepared
DELAYED_NOT_SUPPORTED1616HY000DELAYED option not supported for table 'str'
WARN_NO_MASTER_INFO1617HY000The master info structure does not exist
WARN_OPTION_IGNORED1618HY000<str> option ignored
WARN_PLUGIN_DELETE_BUILTIN1619HY000Built-in plugins cannot be deleted
WARN_PLUGIN_BUSY1620HY000Plugin is busy and will be uninstalled on shutdown
VARIABLE_IS_READONLY1621HY000str variable 'str' is read-only. Use SET str to assign the value
WARN_ENGINE_TRANSACTION_ROLLBACK1622HY000Storage engine str does not support rollback for this statement. Transaction rolled back and must be restarted
SLAVE_HEARTBEAT_FAILURE1623HY000Unexpected master's heartbeat data: str
SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE1624HY000The requested value for the heartbeat period str str
NDB_REPLICATION_SCHEMA_ERROR1625HY000Bad schema for mysql.ndb_replication table. Message: str
CONFLICT_FN_PARSE_ERROR1626HY000Error in parsing conflict function. Message: str
EXCEPTIONS_WRITE_ERROR1627HY000Write to exceptions table failed. Message: str"
TOO_LONG_TABLE_COMMENT1628HY000Comment for table 'str' is too long (max = %lu)
TOO_LONG_FIELD_COMMENT1629HY000Comment for field 'str' is too long (max = %lu)
FUNC_INEXISTENT_NAME_COLLISION163042000FUNCTION str does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual
TOO_MANY_CONCURRENT_TRXS1637HY000Too many active concurrent transactions
WARN_NON_ASCII_SEPARATOR_NOT_IMPLEMENTED1638HY000Non-ASCII separator arguments are not fully supported
DEBUG_SYNC_TIMEOUT1639HY000debug sync point wait timed out
DEBUG_SYNC_HIT_LIMIT1640HY000debug sync point hit limit reached
DUP_SIGNAL_SET164142000Duplicate condition information item 'str'
SIGNAL_WARN164201000Unhandled user-defined warning condition
SIGNAL_NOT_FOUND164302000Unhandled user-defined not found condition
SIGNAL_EXCEPTION1644HY000Unhandled user-defined exception condition
WARN_COND_ITEM_TRUNCATED1647HY000Data truncated for condition item 'str'
COND_ITEM_TOO_LONG1648HY000Data too long for condition item 'str'
UNKNOWN_LOCALE1649HY000Unknown locale: 'str'
SLAVE_IGNORE_SERVER_IDS1650HY000The requested server id # clashes with the slave startup option --replicate-same-server-id
QUERY_CACHE_DISABLED1651HY000Query cache is disabled; restart the server with query_cache_type=1 to enable it
SAME_NAME_PARTITION_FIELD1652HY000Duplicate partition field name 'str'
PARTITION_COLUMN_LIST_ERROR1653HY000Inconsistency in usage of column lists for partitioning
WRONG_TYPE_COLUMN_VALUE_ERROR1654HY000Partition column values of incorrect type
TOO_MANY_PARTITION_FUNC_FIELDS_ERROR1655HY000Too many fields in 'str'
TOO_MANY_VALUES_ERROR1657HY000Cannot have more than one value for this type of str partitioning
ROW_SINGLE_PARTITION_FIELD_ERROR1658HY000Row expressions in VALUES IN only allowed for multi-field column partitioning
FIELD_TYPE_NOT_ALLOWED_AS_PARTITION_FIELD1659HY000Field 'str' is of a not allowed type for this type of partitioning
PARTITION_FIELDS_TOO_LONG1660HY000The total length of the partitioning fields is too large
BINLOG_ROW_ENGINE_AND_STMT_ENGINE1661HY000Cannot execute statement: binlogging impossible since both row-incapable engines and statement-incapable engines are involved.
BINLOG_ROW_MODE_AND_STMT_ENGINE1662HY000Cannot execute statement: binlogging impossible since BINLOG_FORMAT = ROW and at least one table uses a storage engine limited to statement-logging.
BINLOG_UNSAFE_AND_STMT_ENGINE1663HY000Cannot execute statement: binlogging of unsafe statement is impossible when storage engine is limited to statement-logging and BINLOG_FORMAT = MIXED. Reason for unsafeness: str
BINLOG_ROW_INJECTION_AND_STMT_ENGINE1664HY000Cannot execute row injection: binlogging impossible since at least one table uses a storage engine limited to statement-logging.
BINLOG_STMT_MODE_AND_ROW_ENGINE1665HY000Cannot execute statement: binlogging impossible since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-logging.str
BINLOG_ROW_INJECTION_AND_STMT_MODE1666HY000Cannot execute row injection: binlogging impossible since BINLOG_FORMAT = STATEMENT.
BINLOG_MULTIPLE_ENGINES_AND_SELF_LOGGING_ENGINE1667HY000Cannot execute statement: binlogging impossible since more than one engine is involved and at least one engine is self-logging.
BINLOG_UNSAFE_LIMIT1668HY000Statement uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
BINLOG_UNSAFE_INSERT_DELAYED1669HY000Statement uses INSERT DELAYED. This is unsafe because the time when rows are inserted cannot be predicted.
BINLOG_UNSAFE_SYSTEM_TABLE1670HY000Statement uses the general_log, slow_log or performance_schema table(s). This is unsafe because system tables may differ on slave.
BINLOG_UNSAFE_AUTOINC_COLUMNS1671HY000Statement invokes a trigger or a stored function that inserts into AUTO_INCREMENT column which is unsafe to binlog in STATEMENT format because slave may execute it non-deterministically.
BINLOG_UNSAFE_UDF1672HY000Statement uses a UDF. It cannot be determined if the UDF will return the same value on slave.
BINLOG_UNSAFE_SYSTEM_VARIABLE1673HY000Statement uses a system variable whose value may differ on slave.
BINLOG_UNSAFE_SYSTEM_FUNCTION1674HY000Statement uses a system function whose value may differ on slave.
BINLOG_UNSAFE_NONTRANS_AFTER_TRANS1675HY000Non-transactional reads or writes are unsafe if they occur after transactional reads or writes inside a transaction.
MESSAGE_AND_STATEMENT1676HY000str Statement: str
SLAVE_CONVERSION_FAILED1677HY000Column # of table 'str.str' cannot be converted from type 'str' to type 'str'
SLAVE_CANT_CREATE_CONVERSION1678HY000Can't create conversion table for table 'str.str'
INSIDE_TRANSACTION_PREVENTS_SWITCH_BINLOG_FORMAT1679HY000Cannot modify @@session.binlog_format inside a transaction
PATH_LENGTH1680HY000The path specified for str is too long.
WARN_DEPRECATED_SYNTAX_NO_REPLACEMENT1681HY000The syntax 'str' is deprecated and will be removed in MySQL str.
WRONG_NATIVE_TABLE_STRUCTURE1682HY000Native table 'str'.'str' has the wrong structure
WRONG_PERFSCHEMA_USAGE1683HY000Invalid performance_schema usage.
WARN_I_S_SKIPPED_TABLE1684HY000Table 'str'.'str' was skipped since its definition is being modified by concurrent DDL statement
INSIDE_TRANSACTION_PREVENTS_SWITCH_BINLOG_DIRECT1685HY000Cannot modify @@session.binlog_direct_non_transactional_updates inside a transaction
STORED_FUNCTION_PREVENTS_SWITCH_BINLOG_DIRECT1686HY000Cannot change the binlog direct flag inside a stored function or trigger
SPATIAL_MUST_HAVE_GEOM_COL168742000A SPATIAL index may only contain a geometrical type column
TOO_LONG_INDEX_COMMENT1688HY000Comment for index 'str' is too long (max = %lu)
LOCK_ABORTED1689HY000Wait on a lock was aborted due to a pending exclusive lock
DATA_OUT_OF_RANGE169022003str value is out of range in 'str'

Return to the Artful MySQL tips page