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