Documentation Home
MySQL 5.5 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 27.1Mb
PDF (A4) - 27.2Mb
PDF (RPM) - 25.7Mb
HTML Download (TGZ) - 6.5Mb
HTML Download (Zip) - 6.6Mb
HTML Download (RPM) - 5.6Mb
Man Pages (TGZ) - 158.5Kb
Man Pages (Zip) - 262.1Kb
Info (Gzip) - 2.6Mb
Info (Zip) - 2.6Mb
Excerpts from this Manual

MySQL 5.5 Reference Manual  /  Errors, Error Codes, and Common Problems  /  Server Error Message Reference

B.3 Server Error Message Reference

The MySQL server writes some error messages to its error log, and sends others to client programs.

Example server-side error messages written to the error log:

181009  7:43:37 [Note] Event Scheduler: scheduler
thread started with id 1

181009 3:20:39 [ERROR] Can't open the mysql.plugin
table. Please run mysql_upgrade to create it.

Example server-side error message sent to client programs, as displayed by the mysql client:

mysql> SELECT * FROM no_such_table;
ERROR 1146 (42S02): Table 'test.no_such_table' doesn't exist

Each server error message includes an error code, SQLSTATE value, and message string, as described in Section B.1, “Error Message Sources and Components”. These components are available as described in Section B.2, “Error Information Interfaces”.

  • Error number: 1; Symbol: EE_CANTCREATEFILE; SQLSTATE: HY000

    Message: Can't create/write to file '%s' (Errcode: %d)

  • Error number: 2; Symbol: EE_READ; SQLSTATE: HY000

    Message: Error reading file '%s' (Errcode: %d)

  • Error number: 3; Symbol: EE_WRITE; SQLSTATE: HY000

    Message: Error writing file '%s' (Errcode: %d)

  • Error number: 4; Symbol: EE_BADCLOSE; SQLSTATE: HY000

    Message: Error on close of '%s' (Errcode: %d)

  • Error number: 5; Symbol: EE_OUTOFMEMORY; SQLSTATE: HY000

    Message: Out of memory (Needed %u bytes)

  • Error number: 6; Symbol: EE_DELETE; SQLSTATE: HY000

    Message: Error on delete of '%s' (Errcode: %d)

  • Error number: 7; Symbol: EE_LINK; SQLSTATE: HY000

    Message: Error on rename of '%s' to '%s' (Errcode: %d)

  • Error number: 9; Symbol: EE_EOFERR; SQLSTATE: HY000

    Message: Unexpected eof found when reading file '%s' (Errcode: %d)

  • Error number: 10; Symbol: EE_CANTLOCK; SQLSTATE: HY000

    Message: Can't lock file (Errcode: %d)

  • Error number: 11; Symbol: EE_CANTUNLOCK; SQLSTATE: HY000

    Message: Can't unlock file (Errcode: %d)

  • Error number: 12; Symbol: EE_DIR; SQLSTATE: HY000

    Message: Can't read dir of '%s' (Errcode: %d)

  • Error number: 13; Symbol: EE_STAT; SQLSTATE: HY000

    Message: Can't get stat of '%s' (Errcode: %d)

  • Error number: 14; Symbol: EE_CANT_CHSIZE; SQLSTATE: HY000

    Message: Can't change size of file (Errcode: %d)

  • Error number: 15; Symbol: EE_CANT_OPEN_STREAM; SQLSTATE: HY000

    Message: Can't open stream from handle (Errcode: %d)

  • Error number: 16; Symbol: EE_GETWD; SQLSTATE: HY000

    Message: Can't get working dirctory (Errcode: %d)

  • Error number: 17; Symbol: EE_SETWD; SQLSTATE: HY000

    Message: Can't change dir to '%s' (Errcode: %d)

  • Error number: 18; Symbol: EE_LINK_WARNING; SQLSTATE: HY000

    Message: Warning: '%s' had %d links

  • Error number: 19; Symbol: EE_OPEN_WARNING; SQLSTATE: HY000

    Message: Warning: %d files and %d streams is left open

  • Error number: 20; Symbol: EE_DISK_FULL; SQLSTATE: HY000

    Message: Disk is full writing '%s' (Errcode: %d). Waiting for someone to free space... (Expect up to %d secs delay for server to continue after freeing disk space)

  • Error number: 21; Symbol: EE_CANT_MKDIR; SQLSTATE: HY000

    Message: Can't create directory '%s' (Errcode: %d)

  • Error number: 22; Symbol: EE_UNKNOWN_CHARSET; SQLSTATE: HY000

    Message: Character set '%s' is not a compiled character set and is not specified in the '%s' file

  • Error number: 23; Symbol: EE_OUT_OF_FILERESOURCES; SQLSTATE: HY000

    Message: Out of resources when opening file '%s' (Errcode: %d)

  • Error number: 24; Symbol: EE_CANT_READLINK; SQLSTATE: HY000

    Message: Can't read value for symlink '%s' (Error %d)

  • Error number: 25; Symbol: EE_CANT_SYMLINK; SQLSTATE: HY000

    Message: Can't create symlink '%s' pointing at '%s' (Error %d)

  • Error number: 26; Symbol: EE_REALPATH; SQLSTATE: HY000

    Message: Error on realpath() on '%s' (Error %d)

  • Error number: 27; Symbol: EE_SYNC; SQLSTATE: HY000

    Message: Can't sync file '%s' to disk (Errcode: %d)

  • Error number: 28; Symbol: EE_UNKNOWN_COLLATION; SQLSTATE: HY000

    Message: Collation '%s' is not a compiled collation and is not specified in the '%s' file

  • Error number: 29; Symbol: EE_FILENOTFOUND; SQLSTATE: HY000

    Message: File '%s' not found (Errcode: %d)

  • Error number: 30; Symbol: EE_FILE_NOT_CLOSED; SQLSTATE: HY000

    Message: File '%s' (fileno: %d) was not closed

  • Error number: 31; Symbol: EE_CHANGE_OWNERSHIP; SQLSTATE: HY000

    Message: Can't change ownership of the file '%s' (Errcode: %d)

    EE_CHANGE_OWNERSHIP was added in 5.5.6.

  • Error number: 32; Symbol: EE_CHANGE_PERMISSIONS; SQLSTATE: HY000

    Message: Can't change permissions of the file '%s' (Errcode: %d)

    EE_CHANGE_PERMISSIONS was added in 5.5.6.

  • Error number: 33; Symbol: EE_CANT_SEEK; SQLSTATE: HY000

    Message: Can't seek in file '%s' (Errcode: %d)

    EE_CANT_SEEK was added in 5.5.9.

  • Error number: 1000; Symbol: ER_HASHCHK; SQLSTATE: HY000

    Message: hashchk

    Unused.

  • Error number: 1001; Symbol: ER_NISAMCHK; SQLSTATE: HY000

    Message: isamchk

    Unused.

  • Error number: 1002; Symbol: ER_NO; SQLSTATE: HY000

    Message: NO

    Used in the construction of other messages.

  • Error number: 1003; Symbol: ER_YES; SQLSTATE: HY000

    Message: YES

    Used in the construction of other messages.

    Extended EXPLAIN format generates Note messages. ER_YES is used in the Code column for these messages in subsequent SHOW WARNINGS output.

  • Error number: 1004; Symbol: ER_CANT_CREATE_FILE; SQLSTATE: HY000

    Message: Can't create file '%s' (errno: %d)

    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 number: 1005; Symbol: ER_CANT_CREATE_TABLE; SQLSTATE: HY000

    Message: Can't create table '%s' (errno: %d)

    InnoDB reports 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 internal InnoDB table.

  • Error number: 1006; Symbol: ER_CANT_CREATE_DB; SQLSTATE: HY000

    Message: Can't create database '%s' (errno: %d)

  • Error number: 1007; Symbol: ER_DB_CREATE_EXISTS; SQLSTATE: HY000

    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 EXISTS clause to the CREATE DATABASE statement if to retain an existing database without having the statement produce an error.

  • Error number: 1008; Symbol: ER_DB_DROP_EXISTS; SQLSTATE: HY000

    Message: Can't drop database '%s'; database doesn't exist

  • Error number: 1009; Symbol: ER_DB_DROP_DELETE; SQLSTATE: HY000

    Message: Error dropping database (can't delete '%s', errno: %d)

  • Error number: 1010; Symbol: ER_DB_DROP_RMDIR; SQLSTATE: HY000

    Message: Error dropping database (can't rmdir '%s', errno: %d)

  • Error number: 1011; Symbol: ER_CANT_DELETE_FILE; SQLSTATE: HY000

    Message: Error on delete of '%s' (errno: %d)

  • Error number: 1012; Symbol: ER_CANT_FIND_SYSTEM_REC; SQLSTATE: HY000

    Message: Can't read record in system table

    Returned by InnoDB for attempts to access InnoDB INFORMATION_SCHEMA tables when InnoDB is unavailable.

  • Error number: 1013; Symbol: ER_CANT_GET_STAT; SQLSTATE: HY000

    Message: Can't get status of '%s' (errno: %d)

  • Error number: 1014; Symbol: ER_CANT_GET_WD; SQLSTATE: HY000

    Message: Can't get working directory (errno: %d)

  • Error number: 1015; Symbol: ER_CANT_LOCK; SQLSTATE: HY000

    Message: Can't lock file (errno: %d)

  • Error number: 1016; Symbol: ER_CANT_OPEN_FILE; SQLSTATE: HY000

    Message: Can't open file: '%s' (errno: %d)

    InnoDB reports this error when the table from the InnoDB data files cannot be found, even though the .frm file for the table exists. See Section 14.23.3, “Troubleshooting InnoDB Data Dictionary Operations”.

  • Error number: 1017; Symbol: ER_FILE_NOT_FOUND; SQLSTATE: HY000

    Message: Can't find file: '%s' (errno: %d)

  • Error number: 1018; Symbol: ER_CANT_READ_DIR; SQLSTATE: HY000

    Message: Can't read dir of '%s' (errno: %d)

  • Error number: 1019; Symbol: ER_CANT_SET_WD; SQLSTATE: HY000

    Message: Can't change dir to '%s' (errno: %d)

  • Error number: 1020; Symbol: ER_CHECKREAD; SQLSTATE: HY000

    Message: Record has changed since last read in table '%s'

  • Error number: 1021; Symbol: ER_DISK_FULL; SQLSTATE: HY000

    Message: Disk full (%s); waiting for someone to free some space...

  • Error number: 1022; Symbol: ER_DUP_KEY; SQLSTATE: 23000

    Message: Can't write; duplicate key in table '%s'

  • Error number: 1023; Symbol: ER_ERROR_ON_CLOSE; SQLSTATE: HY000

    Message: Error on close of '%s' (errno: %d)

  • Error number: 1024; Symbol: ER_ERROR_ON_READ; SQLSTATE: HY000

    Message: Error reading file '%s' (errno: %d)

  • Error number: 1025; Symbol: ER_ERROR_ON_RENAME; SQLSTATE: HY000

    Message: Error on rename of '%s' to '%s' (errno: %d)

    InnoDB reports this error if you attempt to drop the last index that can enforce a particular referential constraint. As of MySQL 5.5, this error message is replaced by ERROR 1553.

  • Error number: 1026; Symbol: ER_ERROR_ON_WRITE; SQLSTATE: HY000

    Message: Error writing file '%s' (errno: %d)

  • Error number: 1027; Symbol: ER_FILE_USED; SQLSTATE: HY000

    Message: '%s' is locked against change

  • Error number: 1028; Symbol: ER_FILSORT_ABORT; SQLSTATE: HY000

    Message: Sort aborted

  • Error number: 1029; Symbol: ER_FORM_NOT_FOUND; SQLSTATE: HY000

    Message: View '%s' doesn't exist for '%s'

  • Error number: 1030; Symbol: ER_GET_ERRNO; SQLSTATE: HY000

    Message: Got error %d from storage engine

    Check the %d value to see what the OS error means. For example, 28 indicates that you have run out of disk space.

  • Error number: 1031; Symbol: ER_ILLEGAL_HA; SQLSTATE: HY000

    Message: Table storage engine for '%s' doesn't have this option

  • Error number: 1032; Symbol: ER_KEY_NOT_FOUND; SQLSTATE: HY000

    Message: Can't find record in '%s'

  • Error number: 1033; Symbol: ER_NOT_FORM_FILE; SQLSTATE: HY000

    Message: Incorrect information in file: '%s'

  • Error number: 1034; Symbol: ER_NOT_KEYFILE; SQLSTATE: HY000

    Message: Incorrect key file for table '%s'; try to repair it

  • Error number: 1035; Symbol: ER_OLD_KEYFILE; SQLSTATE: HY000

    Message: Old key file for table '%s'; repair it!

  • Error number: 1036; Symbol: ER_OPEN_AS_READONLY; SQLSTATE: HY000

    Message: Table '%s' is read only

  • Error number: 1037; Symbol: ER_OUTOFMEMORY; SQLSTATE: HY001

    Message: Out of memory; restart server and try again (needed %d bytes)

  • Error number: 1038; Symbol: ER_OUT_OF_SORTMEMORY; SQLSTATE: HY001

    Message: Out of sort memory, consider increasing server sort buffer size

  • Error number: 1039; Symbol: ER_UNEXPECTED_EOF; SQLSTATE: HY000

    Message: Unexpected EOF found when reading file '%s' (errno: %d)

  • Error number: 1040; Symbol: ER_CON_COUNT_ERROR; SQLSTATE: 08004

    Message: Too many connections

  • Error number: 1041; Symbol: ER_OUT_OF_RESOURCES; SQLSTATE: HY000

    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 number: 1042; Symbol: ER_BAD_HOST_ERROR; SQLSTATE: 08S01

    Message: Can't get hostname for your address

  • Error number: 1043; Symbol: ER_HANDSHAKE_ERROR; SQLSTATE: 08S01

    Message: Bad handshake

  • Error number: 1044; Symbol: ER_DBACCESS_DENIED_ERROR; SQLSTATE: 42000

    Message: Access denied for user '%s'@'%s' to database '%s'

  • Error number: 1045; Symbol: ER_ACCESS_DENIED_ERROR; SQLSTATE: 28000

    Message: Access denied for user '%s'@'%s' (using password: %s)

  • Error number: 1046; Symbol: ER_NO_DB_ERROR; SQLSTATE: 3D000

    Message: No database selected

  • Error number: 1047; Symbol: ER_UNKNOWN_COM_ERROR; SQLSTATE: 08S01

    Message: Unknown command

  • Error number: 1048; Symbol: ER_BAD_NULL_ERROR; SQLSTATE: 23000

    Message: Column '%s' cannot be null

  • Error number: 1049; Symbol: ER_BAD_DB_ERROR; SQLSTATE: 42000

    Message: Unknown database '%s'

  • Error number: 1050; Symbol: ER_TABLE_EXISTS_ERROR; SQLSTATE: 42S01

    Message: Table '%s' already exists

  • Error number: 1051; Symbol: ER_BAD_TABLE_ERROR; SQLSTATE: 42S02

    Message: Unknown table '%s'

  • Error number: 1052; Symbol: ER_NON_UNIQ_ERROR; SQLSTATE: 23000

    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 ambiguous

    Resolution:

    • 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 number: 1053; Symbol: ER_SERVER_SHUTDOWN; SQLSTATE: 08S01

    Message: Server shutdown in progress

  • Error number: 1054; Symbol: ER_BAD_FIELD_ERROR; SQLSTATE: 42S22

    Message: Unknown column '%s' in '%s'

  • Error number: 1055; Symbol: ER_WRONG_FIELD_WITH_GROUP; SQLSTATE: 42000

    Message: '%s' isn't in GROUP BY

  • Error number: 1056; Symbol: ER_WRONG_GROUP_FIELD; SQLSTATE: 42000

    Message: Can't group on '%s'

  • Error number: 1057; Symbol: ER_WRONG_SUM_SELECT; SQLSTATE: 42000

    Message: Statement has sum functions and columns in same statement

  • Error number: 1058; Symbol: ER_WRONG_VALUE_COUNT; SQLSTATE: 21S01

    Message: Column count doesn't match value count

  • Error number: 1059; Symbol: ER_TOO_LONG_IDENT; SQLSTATE: 42000

    Message: Identifier name '%s' is too long

  • Error number: 1060; Symbol: ER_DUP_FIELDNAME; SQLSTATE: 42S21

    Message: Duplicate column name '%s'

  • Error number: 1061; Symbol: ER_DUP_KEYNAME; SQLSTATE: 42000

    Message: Duplicate key name '%s'

  • Error number: 1062; Symbol: ER_DUP_ENTRY; SQLSTATE: 23000

    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 number: 1063; Symbol: ER_WRONG_FIELD_SPEC; SQLSTATE: 42000

    Message: Incorrect column specifier for column '%s'

  • Error number: 1064; Symbol: ER_PARSE_ERROR; SQLSTATE: 42000

    Message: %s near '%s' at line %d

  • Error number: 1065; Symbol: ER_EMPTY_QUERY; SQLSTATE: 42000

    Message: Query was empty

  • Error number: 1066; Symbol: ER_NONUNIQ_TABLE; SQLSTATE: 42000

    Message: Not unique table/alias: '%s'

  • Error number: 1067; Symbol: ER_INVALID_DEFAULT; SQLSTATE: 42000

    Message: Invalid default value for '%s'

  • Error number: 1068; Symbol: ER_MULTIPLE_PRI_KEY; SQLSTATE: 42000

    Message: Multiple primary key defined

  • Error number: 1069; Symbol: ER_TOO_MANY_KEYS; SQLSTATE: 42000

    Message: Too many keys specified; max %d keys allowed

  • Error number: 1070; Symbol: ER_TOO_MANY_KEY_PARTS; SQLSTATE: 42000

    Message: Too many key parts specified; max %d parts allowed

  • Error number: 1071; Symbol: ER_TOO_LONG_KEY; SQLSTATE: 42000

    Message: Specified key was too long; max key length is %d bytes

  • Error number: 1072; Symbol: ER_KEY_COLUMN_DOES_NOT_EXITS; SQLSTATE: 42000

    Message: Key column '%s' doesn't exist in table

  • Error number: 1073; Symbol: ER_BLOB_USED_AS_KEY; SQLSTATE: 42000

    Message: BLOB column '%s' can't be used in key specification with the used table type

  • Error number: 1074; Symbol: ER_TOO_BIG_FIELDLENGTH; SQLSTATE: 42000

    Message: Column length too big for column '%s' (max = %lu); use BLOB or TEXT instead

  • Error number: 1075; Symbol: ER_WRONG_AUTO_KEY; SQLSTATE: 42000

    Message: Incorrect table definition; there can be only one auto column and it must be defined as a key

  • Error number: 1076; Symbol: ER_READY; SQLSTATE: HY000

    Message: %s: ready for connections. Version: '%s' socket: '%s' port: %d

  • Error number: 1077; Symbol: ER_NORMAL_SHUTDOWN; SQLSTATE: HY000

    Message: %s: Normal shutdown

  • Error number: 1078; Symbol: ER_GOT_SIGNAL; SQLSTATE: HY000

    Message: %s: Got signal %d. Aborting!

  • Error number: 1079; Symbol: ER_SHUTDOWN_COMPLETE; SQLSTATE: HY000

    Message: %s: Shutdown complete

  • Error number: 1080; Symbol: ER_FORCING_CLOSE; SQLSTATE: 08S01

    Message: %s: Forcing close of thread %ld user: '%s'

  • Error number: 1081; Symbol: ER_IPSOCK_ERROR; SQLSTATE: 08S01

    Message: Can't create IP socket

  • Error number: 1082; Symbol: ER_NO_SUCH_INDEX; SQLSTATE: 42S12

    Message: Table '%s' has no index like the one used in CREATE INDEX; recreate the table

  • Error number: 1083; Symbol: ER_WRONG_FIELD_TERMINATORS; SQLSTATE: 42000

    Message: Field separator argument is not what is expected; check the manual

  • Error number: 1084; Symbol: ER_BLOBS_AND_NO_TERMINATED; SQLSTATE: 42000

    Message: You can't use fixed rowlength with BLOBs; please use 'fields terminated by'

  • Error number: 1085; Symbol: ER_TEXTFILE_NOT_READABLE; SQLSTATE: HY000

    Message: The file '%s' must be in the database directory or be readable by all

  • Error number: 1086; Symbol: ER_FILE_EXISTS_ERROR; SQLSTATE: HY000

    Message: File '%s' already exists

  • Error number: 1087; Symbol: ER_LOAD_INFO; SQLSTATE: HY000

    Message: Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld

  • Error number: 1088; Symbol: ER_ALTER_INFO; SQLSTATE: HY000

    Message: Records: %ld Duplicates: %ld

  • Error number: 1089; Symbol: ER_WRONG_SUB_KEY; SQLSTATE: HY000

    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 number: 1090; Symbol: ER_CANT_REMOVE_ALL_FIELDS; SQLSTATE: 42000

    Message: You can't delete all columns with ALTER TABLE; use DROP TABLE instead

  • Error number: 1091; Symbol: ER_CANT_DROP_FIELD_OR_KEY; SQLSTATE: 42000

    Message: Can't DROP '%s'; check that column/key exists

  • Error number: 1092; Symbol: ER_INSERT_INFO; SQLSTATE: HY000

    Message: Records: %ld Duplicates: %ld Warnings: %ld

  • Error number: 1093; Symbol: ER_UPDATE_TABLE_USED; SQLSTATE: HY000

    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 number: 1094; Symbol: ER_NO_SUCH_THREAD; SQLSTATE: HY000

    Message: Unknown thread id: %lu

  • Error number: 1095; Symbol: ER_KILL_DENIED_ERROR; SQLSTATE: HY000

    Message: You are not owner of thread %lu

  • Error number: 1096; Symbol: ER_NO_TABLES_USED; SQLSTATE: HY000

    Message: No tables used

  • Error number: 1097; Symbol: ER_TOO_BIG_SET; SQLSTATE: HY000

    Message: Too many strings for column %s and SET

  • Error number: 1098; Symbol: ER_NO_UNIQUE_LOGFILE; SQLSTATE: HY000

    Message: Can't generate a unique log-filename %s.(1-999)

  • Error number: 1099; Symbol: ER_TABLE_NOT_LOCKED_FOR_WRITE; SQLSTATE: HY000

    Message: Table '%s' was locked with a READ lock and can't be updated

  • Error number: 1100; Symbol: ER_TABLE_NOT_LOCKED; SQLSTATE: HY000

    Message: Table '%s' was not locked with LOCK TABLES

  • Error number: 1101; Symbol: ER_BLOB_CANT_HAVE_DEFAULT; SQLSTATE: 42000

    Message: BLOB/TEXT column '%s' can't have a default value

  • Error number: 1102; Symbol: ER_WRONG_DB_NAME; SQLSTATE: 42000

    Message: Incorrect database name '%s'

  • Error number: 1103; Symbol: ER_WRONG_TABLE_NAME; SQLSTATE: 42000

    Message: Incorrect table name '%s'

  • Error number: 1104; Symbol: ER_TOO_BIG_SELECT; SQLSTATE: 42000

    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 number: 1105; Symbol: ER_UNKNOWN_ERROR; SQLSTATE: HY000

    Message: Unknown error

  • Error number: 1106; Symbol: ER_UNKNOWN_PROCEDURE; SQLSTATE: 42000

    Message: Unknown procedure '%s'

  • Error number: 1107; Symbol: ER_WRONG_PARAMCOUNT_TO_PROCEDURE; SQLSTATE: 42000

    Message: Incorrect parameter count to procedure '%s'

  • Error number: 1108; Symbol: ER_WRONG_PARAMETERS_TO_PROCEDURE; SQLSTATE: HY000

    Message: Incorrect parameters to procedure '%s'

  • Error number: 1109; Symbol: ER_UNKNOWN_TABLE; SQLSTATE: 42S02

    Message: Unknown table '%s' in %s

  • Error number: 1110; Symbol: ER_FIELD_SPECIFIED_TWICE; SQLSTATE: 42000

    Message: Column '%s' specified twice

  • Error number: 1111; Symbol: ER_INVALID_GROUP_FUNC_USE; SQLSTATE: HY000

    Message: Invalid use of group function

  • Error number: 1112; Symbol: ER_UNSUPPORTED_EXTENSION; SQLSTATE: 42000

    Message: Table '%s' uses an extension that doesn't exist in this MySQL version

  • Error number: 1113; Symbol: ER_TABLE_MUST_HAVE_COLUMNS; SQLSTATE: 42000

    Message: A table must have at least 1 column

  • Error number: 1114; Symbol: ER_RECORD_FILE_FULL; SQLSTATE: HY000

    Message: The table '%s' is full

    InnoDB reports this error when the system tablespace runs out of free space. Reconfigure the system tablespace to add a new data file.

  • Error number: 1115; Symbol: ER_UNKNOWN_CHARACTER_SET; SQLSTATE: 42000

    Message: Unknown character set: '%s'

  • Error number: 1116; Symbol: ER_TOO_MANY_TABLES; SQLSTATE: HY000

    Message: Too many tables; MySQL can only use %d tables in a join

  • Error number: 1117; Symbol: ER_TOO_MANY_FIELDS; SQLSTATE: HY000

    Message: Too many columns

  • Error number: 1118; Symbol: ER_TOO_BIG_ROWSIZE; SQLSTATE: 42000

    Message: Row size too large. The maximum row size for the used table type, not counting BLOBs, is %ld. You have to change some columns to TEXT or BLOBs

  • Error number: 1119; Symbol: ER_STACK_OVERRUN; SQLSTATE: HY000

    Message: Thread stack overrun: Used: %ld of a %ld stack. Use 'mysqld --thread_stack=#' to specify a bigger stack if needed

  • Error number: 1120; Symbol: ER_WRONG_OUTER_JOIN; SQLSTATE: 42000

    Message: Cross dependency found in OUTER JOIN; examine your ON conditions

  • Error number: 1121; Symbol: ER_NULL_COLUMN_IN_INDEX; SQLSTATE: 42000

    Message: Table handler doesn't support NULL in given index. Please change column '%s' to be NOT NULL or use another handler

  • Error number: 1122; Symbol: ER_CANT_FIND_UDF; SQLSTATE: HY000

    Message: Can't load function '%s'

  • Error number: 1123; Symbol: ER_CANT_INITIALIZE_UDF; SQLSTATE: HY000

    Message: Can't initialize function '%s'; %s

  • Error number: 1124; Symbol: ER_UDF_NO_PATHS; SQLSTATE: HY000

    Message: No paths allowed for shared library

  • Error number: 1125; Symbol: ER_UDF_EXISTS; SQLSTATE: HY000

    Message: Function '%s' already exists

  • Error number: 1126; Symbol: ER_CANT_OPEN_LIBRARY; SQLSTATE: HY000

    Message: Can't open shared library '%s' (errno: %d %s)

  • Error number: 1127; Symbol: ER_CANT_FIND_DL_ENTRY; SQLSTATE: HY000

    Message: Can't find symbol '%s' in library

  • Error number: 1128; Symbol: ER_FUNCTION_NOT_DEFINED; SQLSTATE: HY000

    Message: Function '%s' is not defined

  • Error number: 1129; Symbol: ER_HOST_IS_BLOCKED; SQLSTATE: HY000

    Message: Host '%s' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

  • Error number: 1130; Symbol: ER_HOST_NOT_PRIVILEGED; SQLSTATE: HY000

    Message: Host '%s' is not allowed to connect to this MySQL server

  • Error number: 1131; Symbol: ER_PASSWORD_ANONYMOUS_USER; SQLSTATE: 42000

    Message: You are using MySQL as an anonymous user and anonymous users are not allowed to change passwords

  • Error number: 1132; Symbol: ER_PASSWORD_NOT_ALLOWED; SQLSTATE: 42000

    Message: You must have privileges to update tables in the mysql database to be able to change passwords for others

  • Error number: 1133; Symbol: ER_PASSWORD_NO_MATCH; SQLSTATE: 42000

    Message: Can't find any matching row in the user table

  • Error number: 1134; Symbol: ER_UPDATE_INFO; SQLSTATE: HY000

    Message: Rows matched: %ld Changed: %ld Warnings: %ld

  • Error number: 1135; Symbol: ER_CANT_CREATE_THREAD; SQLSTATE: HY000

    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 number: 1136; Symbol: ER_WRONG_VALUE_COUNT_ON_ROW; SQLSTATE: 21S01

    Message: Column count doesn't match value count at row %ld

  • Error number: 1137; Symbol: ER_CANT_REOPEN_TABLE; SQLSTATE: HY000

    Message: Can't reopen table: '%s'

  • Error number: 1138; Symbol: ER_INVALID_USE_OF_NULL; SQLSTATE: 22004

    Message: Invalid use of NULL value

  • Error number: 1139; Symbol: ER_REGEXP_ERROR; SQLSTATE: 42000

    Message: Got error '%s' from regexp

  • Error number: 1140; Symbol: ER_MIX_OF_GROUP_FUNC_AND_FIELDS; SQLSTATE: 42000

    Message: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

  • Error number: 1141; Symbol: ER_NONEXISTING_GRANT; SQLSTATE: 42000

    Message: There is no such grant defined for user '%s' on host '%s'

  • Error number: 1142; Symbol: ER_TABLEACCESS_DENIED_ERROR; SQLSTATE: 42000

    Message: %s command denied to user '%s'@'%s' for table '%s'

  • Error number: 1143; Symbol: ER_COLUMNACCESS_DENIED_ERROR; SQLSTATE: 42000

    Message: %s command denied to user '%s'@'%s' for column '%s' in table '%s'

  • Error number: 1144; Symbol: ER_ILLEGAL_GRANT_FOR_TABLE; SQLSTATE: 42000

    Message: Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used

  • Error number: 1145; Symbol: ER_GRANT_WRONG_HOST_OR_USER; SQLSTATE: 42000

    Message: The host or user argument to GRANT is too long

  • Error number: 1146; Symbol: ER_NO_SUCH_TABLE; SQLSTATE: 42S02

    Message: Table '%s.%s' doesn't exist

  • Error number: 1147; Symbol: ER_NONEXISTING_TABLE_GRANT; SQLSTATE: 42000

    Message: There is no such grant defined for user '%s' on host '%s' on table '%s'

  • Error number: 1148; Symbol: ER_NOT_ALLOWED_COMMAND; SQLSTATE: 42000

    Message: The used command is not allowed with this MySQL version

  • Error number: 1149; Symbol: ER_SYNTAX_ERROR; SQLSTATE: 42000

    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 number: 1150; Symbol: ER_DELAYED_CANT_CHANGE_LOCK; SQLSTATE: HY000

    Message: Delayed insert thread couldn't get requested lock for table %s

  • Error number: 1151; Symbol: ER_TOO_MANY_DELAYED_THREADS; SQLSTATE: HY000

    Message: Too many delayed threads in use

  • Error number: 1152; Symbol: ER_ABORTING_CONNECTION; SQLSTATE: 08S01

    Message: Aborted connection %ld to db: '%s' user: '%s' (%s)

  • Error number: 1153; Symbol: ER_NET_PACKET_TOO_LARGE; SQLSTATE: 08S01

    Message: Got a packet bigger than 'max_allowed_packet' bytes

  • Error number: 1154; Symbol: ER_NET_READ_ERROR_FROM_PIPE; SQLSTATE: 08S01

    Message: Got a read error from the connection pipe

  • Error number: 1155; Symbol: ER_NET_FCNTL_ERROR; SQLSTATE: 08S01

    Message: Got an error from fcntl()

  • Error number: 1156; Symbol: ER_NET_PACKETS_OUT_OF_ORDER; SQLSTATE: 08S01

    Message: Got packets out of order

  • Error number: 1157; Symbol: ER_NET_UNCOMPRESS_ERROR; SQLSTATE: 08S01

    Message: Couldn't uncompress communication packet

  • Error number: 1158; Symbol: ER_NET_READ_ERROR; SQLSTATE: 08S01

    Message: Got an error reading communication packets

  • Error number: 1159; Symbol: ER_NET_READ_INTERRUPTED; SQLSTATE: 08S01

    Message: Got timeout reading communication packets

  • Error number: 1160; Symbol: ER_NET_ERROR_ON_WRITE; SQLSTATE: 08S01

    Message: Got an error writing communication packets

  • Error number: 1161; Symbol: ER_NET_WRITE_INTERRUPTED; SQLSTATE: 08S01

    Message: Got timeout writing communication packets

  • Error number: 1162; Symbol: ER_TOO_LONG_STRING; SQLSTATE: 42000

    Message: Result string is longer than 'max_allowed_packet' bytes

  • Error number: 1163; Symbol: ER_TABLE_CANT_HANDLE_BLOB; SQLSTATE: 42000

    Message: The used table type doesn't support BLOB/TEXT columns

  • Error number: 1164; Symbol: ER_TABLE_CANT_HANDLE_AUTO_INCREMENT; SQLSTATE: 42000

    Message: The used table type doesn't support AUTO_INCREMENT columns

  • Error number: 1165; Symbol: ER_DELAYED_INSERT_TABLE_LOCKED; SQLSTATE: HY000

    Message: INSERT DELAYED can't be used with table '%s' because it is locked with LOCK TABLES

  • Error number: 1166; Symbol: ER_WRONG_COLUMN_NAME; SQLSTATE: 42000

    Message: Incorrect column name '%s'

  • Error number: 1167; Symbol: ER_WRONG_KEY_COLUMN; SQLSTATE: 42000

    Message: The used storage engine can't index column '%s'

  • Error number: 1168; Symbol: ER_WRONG_MRG_TABLE; SQLSTATE: HY000

    Message: Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist

  • Error number: 1169; Symbol: ER_DUP_UNIQUE; SQLSTATE: 23000

    Message: Can't write, because of unique constraint, to table '%s'

  • Error number: 1170; Symbol: ER_BLOB_KEY_WITHOUT_LENGTH; SQLSTATE: 42000

    Message: BLOB/TEXT column '%s' used in key specification without a key length

  • Error number: 1171; Symbol: ER_PRIMARY_CANT_HAVE_NULL; SQLSTATE: 42000

    Message: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

  • Error number: 1172; Symbol: ER_TOO_MANY_ROWS; SQLSTATE: 42000

    Message: Result consisted of more than one row

  • Error number: 1173; Symbol: ER_REQUIRES_PRIMARY_KEY; SQLSTATE: 42000

    Message: This table type requires a primary key

    InnoDB reports this error when you attempt to drop an implicit clustered index (the first UNIQUE NOT NULL index) if the table did not contain a PRIMARY KEY.

    InnoDB should no longer report this error as of MySQL 5.5. For tables without an explicit PRIMARY KEY, InnoDB creates an implicit clustered index using the first columns of the table that are declared UNIQUE and NOT NULL. When you drop such an index, InnoDB now automatically copies the table and rebuilds the index using a different UNIQUE NOT NULL group of columns or a system-generated key. Since this operation changes the primary key, it uses the slow method of copying the table and re-creating the index, rather than the Fast Index Creation technique from Section 14.16.3, “Implementation Details of Fast Index Creation”.

  • Error number: 1174; Symbol: ER_NO_RAID_COMPILED; SQLSTATE: HY000

    Message: This version of MySQL is not compiled with RAID support

  • Error number: 1175; Symbol: ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE; SQLSTATE: HY000

    Message: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column

  • Error number: 1176; Symbol: ER_KEY_DOES_NOT_EXITS; SQLSTATE: 42000

    Message: Key '%s' doesn't exist in table '%s'

  • Error number: 1177; Symbol: ER_CHECK_NO_SUCH_TABLE; SQLSTATE: 42000

    Message: Can't open table

  • Error number: 1178; Symbol: ER_CHECK_NOT_IMPLEMENTED; SQLSTATE: 42000

    Message: The storage engine for the table doesn't support %s

  • Error number: 1179; Symbol: ER_CANT_DO_THIS_DURING_AN_TRANSACTION; SQLSTATE: 25000

    Message: You are not allowed to execute this command in a transaction

  • Error number: 1180; Symbol: ER_ERROR_DURING_COMMIT; SQLSTATE: HY000

    Message: Got error %d during COMMIT

  • Error number: 1181; Symbol: ER_ERROR_DURING_ROLLBACK; SQLSTATE: HY000

    Message: Got error %d during ROLLBACK

  • Error number: 1182; Symbol: ER_ERROR_DURING_FLUSH_LOGS; SQLSTATE: HY000

    Message: Got error %d during FLUSH_LOGS

  • Error number: 1183; Symbol: ER_ERROR_DURING_CHECKPOINT; SQLSTATE: HY000

    Message: Got error %d during CHECKPOINT

  • Error number: 1184; Symbol: ER_NEW_ABORTING_CONNECTION; SQLSTATE: 08S01

    Message: Aborted connection %ld to db: '%s' user: '%s' host: '%s' (%s)

  • Error number: 1185; Symbol: ER_DUMP_NOT_IMPLEMENTED; SQLSTATE: HY000

    Message: The storage engine for the table does not support binary table dump

  • Error number: 1186; Symbol: ER_FLUSH_MASTER_BINLOG_CLOSED; SQLSTATE: HY000

    Message: Binlog closed, cannot RESET MASTER

  • Error number: 1187; Symbol: ER_INDEX_REBUILD; SQLSTATE: HY000

    Message: Failed rebuilding the index of dumped table '%s'

  • Error number: 1188; Symbol: ER_MASTER; SQLSTATE: HY000

    Message: Error from master: '%s'

  • Error number: 1189; Symbol: ER_MASTER_NET_READ; SQLSTATE: 08S01

    Message: Net error reading from master

  • Error number: 1190; Symbol: ER_MASTER_NET_WRITE; SQLSTATE: 08S01

    Message: Net error writing to master

  • Error number: 1191; Symbol: ER_FT_MATCHING_KEY_NOT_FOUND; SQLSTATE: HY000

    Message: Can't find FULLTEXT index matching the column list

  • Error number: 1192; Symbol: ER_LOCK_OR_ACTIVE_TRANSACTION; SQLSTATE: HY000

    Message: Can't execute the given command because you have active locked tables or an active transaction

  • Error number: 1193; Symbol: ER_UNKNOWN_SYSTEM_VARIABLE; SQLSTATE: HY000

    Message: Unknown system variable '%s'

  • Error number: 1194; Symbol: ER_CRASHED_ON_USAGE; SQLSTATE: HY000

    Message: Table '%s' is marked as crashed and should be repaired

  • Error number: 1195; Symbol: ER_CRASHED_ON_REPAIR; SQLSTATE: HY000

    Message: Table '%s' is marked as crashed and last (automatic?) repair failed

  • Error number: 1196; Symbol: ER_WARNING_NOT_COMPLETE_ROLLBACK; SQLSTATE: HY000

    Message: Some non-transactional changed tables couldn't be rolled back

  • Error number: 1197; Symbol: ER_TRANS_CACHE_FULL; SQLSTATE: HY000

    Message: Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again

  • Error number: 1198; Symbol: ER_SLAVE_MUST_STOP; SQLSTATE: HY000

    Message: This operation cannot be performed with a running slave; run STOP SLAVE first

  • Error number: 1199; Symbol: ER_SLAVE_NOT_RUNNING; SQLSTATE: HY000

    Message: This operation requires a running slave; configure slave and do START SLAVE

  • Error number: 1200; Symbol: ER_BAD_SLAVE; SQLSTATE: HY000

    Message: The server is not configured as slave; fix in config file or with CHANGE MASTER TO

  • Error number: 1201; Symbol: ER_MASTER_INFO; SQLSTATE: HY000

    Message: Could not initialize master info structure; more error messages can be found in the MySQL error log

  • Error number: 1202; Symbol: ER_SLAVE_THREAD; SQLSTATE: HY000

    Message: Could not create slave thread; check system resources

  • Error number: 1203; Symbol: ER_TOO_MANY_USER_CONNECTIONS; SQLSTATE: 42000

    Message: User %s already has more than 'max_user_connections' active connections

  • Error number: 1204; Symbol: ER_SET_CONSTANTS_ONLY; SQLSTATE: HY000

    Message: You may only use constant expressions with SET

  • Error number: 1205; Symbol: ER_LOCK_WAIT_TIMEOUT; SQLSTATE: HY000

    Message: Lock wait timeout exceeded; try restarting transaction

    InnoDB reports 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 the innodb_lock_wait_timeout configuration 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 number: 1206; Symbol: ER_LOCK_TABLE_FULL; SQLSTATE: HY000

    Message: The total number of locks exceeds the lock table size

    InnoDB reports this error when the total number of locks exceeds the amount of memory devoted to managing locks. To avoid this error, increase the value of innodb_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 large INSERT, perform several smaller INSERT operations.

  • Error number: 1207; Symbol: ER_READ_ONLY_TRANSACTION; SQLSTATE: 25000

    Message: Update locks cannot be acquired during a READ UNCOMMITTED transaction

  • Error number: 1208; Symbol: ER_DROP_DB_WITH_READ_LOCK; SQLSTATE: HY000

    Message: DROP DATABASE not allowed while thread is holding global read lock

  • Error number: 1209; Symbol: ER_CREATE_DB_WITH_READ_LOCK; SQLSTATE: HY000

    Message: CREATE DATABASE not allowed while thread is holding global read lock

  • Error number: 1210; Symbol: ER_WRONG_ARGUMENTS; SQLSTATE: HY000

    Message: Incorrect arguments to %s

  • Error number: 1211; Symbol: ER_NO_PERMISSION_TO_CREATE_USER; SQLSTATE: 42000

    Message: '%s'@'%s' is not allowed to create new users

  • Error number: 1212; Symbol: ER_UNION_TABLES_IN_DIFFERENT_DIR; SQLSTATE: HY000

    Message: Incorrect table definition; all MERGE tables must be in the same database

  • Error number: 1213; Symbol: ER_LOCK_DEADLOCK; SQLSTATE: 40001

    Message: Deadlock found when trying to get lock; try restarting transaction

    InnoDB reports 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.10.5, “Deadlocks in InnoDB” for details.

  • Error number: 1214; Symbol: ER_TABLE_CANT_HANDLE_FT; SQLSTATE: HY000

    Message: The used table type doesn't support FULLTEXT indexes

  • Error number: 1215; Symbol: ER_CANNOT_ADD_FOREIGN; SQLSTATE: HY000

    Message: Cannot add foreign key constraint

  • Error number: 1216; Symbol: ER_NO_REFERENCED_ROW; SQLSTATE: 23000

    Message: Cannot add or update a child row: a foreign key constraint fails

    InnoDB reports 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 number: 1217; Symbol: ER_ROW_IS_REFERENCED; SQLSTATE: 23000

    Message: Cannot delete or update a parent row: a foreign key constraint fails

    InnoDB reports this error when you try to delete a parent row that has children, and a foreign key constraint fails. Delete the children first.

  • Error number: 1218; Symbol: ER_CONNECT_TO_MASTER; SQLSTATE: 08S01

    Message: Error connecting to master: %s

  • Error number: 1219; Symbol: ER_QUERY_ON_MASTER; SQLSTATE: HY000

    Message: Error running query on master: %s

  • Error number: 1220; Symbol: ER_ERROR_WHEN_EXECUTING_COMMAND; SQLSTATE: HY000

    Message: Error when executing command %s: %s

  • Error number: 1221; Symbol: ER_WRONG_USAGE; SQLSTATE: HY000

    Message: Incorrect usage of %s and %s

  • Error number: 1222; Symbol: ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT; SQLSTATE: 21000

    Message: The used SELECT statements have a different number of columns

  • Error number: 1223; Symbol: ER_CANT_UPDATE_WITH_READLOCK; SQLSTATE: HY000

    Message: Can't execute the query because you have a conflicting read lock

  • Error number: 1224; Symbol: ER_MIXING_NOT_ALLOWED; SQLSTATE: HY000

    Message: Mixing of transactional and non-transactional tables is disabled

  • Error number: 1225; Symbol: ER_DUP_ARGUMENT; SQLSTATE: HY000

    Message: Option '%s' used twice in statement

  • Error number: 1226; Symbol: ER_USER_LIMIT_REACHED; SQLSTATE: 42000

    Message: User '%s' has exceeded the '%s' resource (current value: %ld)

  • Error number: 1227; Symbol: ER_SPECIFIC_ACCESS_DENIED_ERROR; SQLSTATE: 42000

    Message: Access denied; you need (at least one of) the %s privilege(s) for this operation

  • Error number: 1228; Symbol: ER_LOCAL_VARIABLE; SQLSTATE: HY000

    Message: Variable '%s' is a SESSION variable and can't be used with SET GLOBAL

  • Error number: 1229; Symbol: ER_GLOBAL_VARIABLE; SQLSTATE: HY000

    Message: Variable '%s' is a GLOBAL variable and should be set with SET GLOBAL

  • Error number: 1230; Symbol: ER_NO_DEFAULT; SQLSTATE: 42000

    Message: Variable '%s' doesn't have a default value

  • Error number: 1231; Symbol: ER_WRONG_VALUE_FOR_VAR; SQLSTATE: 42000

    Message: Variable '%s' can't be set to the value of '%s'

  • Error number: 1232; Symbol: ER_WRONG_TYPE_FOR_VAR; SQLSTATE: 42000

    Message: Incorrect argument type to variable '%s'

  • Error number: 1233; Symbol: ER_VAR_CANT_BE_READ; SQLSTATE: HY000

    Message: Variable '%s' can only be set, not read

  • Error number: 1234; Symbol: ER_CANT_USE_OPTION_HERE; SQLSTATE: 42000

    Message: Incorrect usage/placement of '%s'

  • Error number: 1235; Symbol: ER_NOT_SUPPORTED_YET; SQLSTATE: 42000

    Message: This version of MySQL doesn't yet support '%s'

  • Error number: 1236; Symbol: ER_MASTER_FATAL_ERROR_READING_BINLOG; SQLSTATE: HY000

    Message: Got fatal error %d from master when reading data from binary log: '%s'

  • Error number: 1237; Symbol: ER_SLAVE_IGNORED_TABLE; SQLSTATE: HY000

    Message: Slave SQL thread ignored the query because of replicate-*-table rules

  • Error number: 1238; Symbol: ER_INCORRECT_GLOBAL_LOCAL_VAR; SQLSTATE: HY000

    Message: Variable '%s' is a %s variable

  • Error number: 1239; Symbol: ER_WRONG_FK_DEF; SQLSTATE: 42000

    Message: Incorrect foreign key definition for '%s': %s

  • Error number: 1240; Symbol: ER_KEY_REF_DO_NOT_MATCH_TABLE_REF; SQLSTATE: HY000

    Message: Key reference and table reference don't match

  • Error number: 1241; Symbol: ER_OPERAND_COLUMNS; SQLSTATE: 21000

    Message: Operand should contain %d column(s)

  • Error number: 1242; Symbol: ER_SUBQUERY_NO_1_ROW; SQLSTATE: 21000

    Message: Subquery returns more than 1 row

  • Error number: 1243; Symbol: ER_UNKNOWN_STMT_HANDLER; SQLSTATE: HY000

    Message: Unknown prepared statement handler (%.*s) given to %s

  • Error number: 1244; Symbol: ER_CORRUPT_HELP_DB; SQLSTATE: HY000

    Message: Help database is corrupt or does not exist

  • Error number: 1245; Symbol: ER_CYCLIC_REFERENCE; SQLSTATE: HY000

    Message: Cyclic reference on subqueries

  • Error number: 1246; Symbol: ER_AUTO_CONVERT; SQLSTATE: HY000

    Message: Converting column '%s' from %s to %s

  • Error number: 1247; Symbol: ER_ILLEGAL_REFERENCE; SQLSTATE: 42S22

    Message: Reference '%s' not supported (%s)

  • Error number: 1248; Symbol: ER_DERIVED_MUST_HAVE_ALIAS; SQLSTATE: 42000

    Message: Every derived table must have its own alias

  • Error number: 1249; Symbol: ER_SELECT_REDUCED; SQLSTATE: 01000

    Message: Select %u was reduced during optimization

  • Error number: 1250; Symbol: ER_TABLENAME_NOT_ALLOWED_HERE; SQLSTATE: 42000

    Message: Table '%s' from one of the SELECTs cannot be used in %s

  • Error number: 1251; Symbol: ER_NOT_SUPPORTED_AUTH_MODE; SQLSTATE: 08004

    Message: Client does not support authentication protocol requested by server; consider upgrading MySQL client

  • Error number: 1252; Symbol: ER_SPATIAL_CANT_HAVE_NULL; SQLSTATE: 42000

    Message: All parts of a SPATIAL index must be NOT NULL

  • Error number: 1253; Symbol: ER_COLLATION_CHARSET_MISMATCH; SQLSTATE: 42000

    Message: COLLATION '%s' is not valid for CHARACTER SET '%s'

  • Error number: 1254; Symbol: ER_SLAVE_WAS_RUNNING; SQLSTATE: HY000

    Message: Slave is already running

  • Error number: 1255; Symbol: ER_SLAVE_WAS_NOT_RUNNING; SQLSTATE: HY000

    Message: Slave already has been stopped

  • Error number: 1256; Symbol: ER_TOO_BIG_FOR_UNCOMPRESS; SQLSTATE: HY000

    Message: Uncompressed data size too large; the maximum size is %d (probably, length of uncompressed data was corrupted)

  • Error number: 1257; Symbol: ER_ZLIB_Z_MEM_ERROR; SQLSTATE: HY000

    Message: ZLIB: Not enough memory

  • Error number: 1258; Symbol: ER_ZLIB_Z_BUF_ERROR; SQLSTATE: HY000

    Message: ZLIB: Not enough room in the output buffer (probably, length of uncompressed data was corrupted)

  • Error number: 1259; Symbol: ER_ZLIB_Z_DATA_ERROR; SQLSTATE: HY000

    Message: ZLIB: Input data corrupted

  • Error number: 1260; Symbol: ER_CUT_VALUE_GROUP_CONCAT; SQLSTATE: HY000

    Message: Row %u was cut by GROUP_CONCAT()

  • Error number: 1261; Symbol: ER_WARN_TOO_FEW_RECORDS; SQLSTATE: 01000

    Message: Row %ld doesn't contain data for all columns

  • Error number: 1262; Symbol: ER_WARN_TOO_MANY_RECORDS; SQLSTATE: 01000

    Message: Row %ld was truncated; it contained more data than there were input columns

  • Error number: 1263; Symbol: ER_WARN_NULL_TO_NOTNULL; SQLSTATE: 22004

    Message: Column set to default value; NULL supplied to NOT NULL column '%s' at row %ld

  • Error number: 1264; Symbol: ER_WARN_DATA_OUT_OF_RANGE; SQLSTATE: 22003

    Message: Out of range value for column '%s' at row %ld

  • Error number: 1265; Symbol: WARN_DATA_TRUNCATED; SQLSTATE: 01000

    Message: Data truncated for column '%s' at row %ld

  • Error number: 1266; Symbol: ER_WARN_USING_OTHER_HANDLER; SQLSTATE: HY000

    Message: Using storage engine %s for table '%s'

  • Error number: 1267; Symbol: ER_CANT_AGGREGATE_2COLLATIONS; SQLSTATE: HY000

    Message: Illegal mix of collations (%s,%s) and (%s,%s) for operation '%s'

  • Error number: 1268; Symbol: ER_DROP_USER; SQLSTATE: HY000

    Message: Cannot drop one or more of the requested users

  • Error number: 1269; Symbol: ER_REVOKE_GRANTS; SQLSTATE: HY000

    Message: Can't revoke all privileges for one or more of the requested users

  • Error number: 1270; Symbol: ER_CANT_AGGREGATE_3COLLATIONS; SQLSTATE: HY000

    Message: Illegal mix of collations (%s,%s), (%s,%s), (%s,%s) for operation '%s'

  • Error number: 1271; Symbol: ER_CANT_AGGREGATE_NCOLLATIONS; SQLSTATE: HY000

    Message: Illegal mix of collations for operation '%s'

  • Error number: 1272; Symbol: ER_VARIABLE_IS_NOT_STRUCT; SQLSTATE: HY000

    Message: Variable '%s' is not a variable component (can't be used as XXXX.variable_name)

  • Error number: 1273; Symbol: ER_UNKNOWN_COLLATION; SQLSTATE: HY000

    Message: Unknown collation: '%s'

  • Error number: 1274; Symbol: ER_SLAVE_IGNORED_SSL_PARAMS; SQLSTATE: HY000

    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 number: 1275; Symbol: ER_SERVER_IS_IN_SECURE_AUTH_MODE; SQLSTATE: HY000

    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 number: 1276; Symbol: ER_WARN_FIELD_RESOLVED; SQLSTATE: HY000

    Message: Field or reference '%s%s%s%s%s' of SELECT #%d was resolved in SELECT #%d

  • Error number: 1277; Symbol: ER_BAD_SLAVE_UNTIL_COND; SQLSTATE: HY000

    Message: Incorrect parameter or combination of parameters for START SLAVE UNTIL

  • Error number: 1278; Symbol: ER_MISSING_SKIP_SLAVE; SQLSTATE: HY000

    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 number: 1279; Symbol: ER_UNTIL_COND_IGNORED; SQLSTATE: HY000

    Message: SQL thread is not to be started so UNTIL options are ignored

  • Error number: 1280; Symbol: ER_WRONG_NAME_FOR_INDEX; SQLSTATE: 42000

    Message: Incorrect index name '%s'

  • Error number: 1281; Symbol: ER_WRONG_NAME_FOR_CATALOG; SQLSTATE: 42000

    Message: Incorrect catalog name '%s'

  • Error number: 1282; Symbol: ER_WARN_QC_RESIZE; SQLSTATE: HY000

    Message: Query cache failed to set size %lu; new query cache size is %lu

  • Error number: 1283; Symbol: ER_BAD_FT_COLUMN; SQLSTATE: HY000

    Message: Column '%s' cannot be part of FULLTEXT index

  • Error number: 1284; Symbol: ER_UNKNOWN_KEY_CACHE; SQLSTATE: HY000

    Message: Unknown key cache '%s'

  • Error number: 1285; Symbol: ER_WARN_HOSTNAME_WONT_WORK; SQLSTATE: HY000

    Message: MySQL is started in --skip-name-resolve mode; you must restart it without this switch for this grant to work

  • Error number: 1286; Symbol: ER_UNKNOWN_STORAGE_ENGINE; SQLSTATE: 42000

    Message: Unknown storage engine '%s'

  • Error number: 1287; Symbol: ER_WARN_DEPRECATED_SYNTAX; SQLSTATE: HY000

    Message: '%s' is deprecated and will be removed in a future release. Please use %s instead

  • Error number: 1288; Symbol: ER_NON_UPDATABLE_TABLE; SQLSTATE: HY000

    Message: The target table %s of the %s is not updatable

  • Error number: 1289; Symbol: ER_FEATURE_DISABLED; SQLSTATE: HY000

    Message: The '%s' feature is disabled; you need MySQL built with '%s' to have it working

  • Error number: 1290; Symbol: ER_OPTION_PREVENTS_STATEMENT; SQLSTATE: HY000

    Message: The MySQL server is running with the %s option so it cannot execute this statement

  • Error number: 1291; Symbol: ER_DUPLICATED_VALUE_IN_TYPE; SQLSTATE: HY000

    Message: Column '%s' has duplicated value '%s' in %s

  • Error number: 1292; Symbol: ER_TRUNCATED_WRONG_VALUE; SQLSTATE: 22007

    Message: Truncated incorrect %s value: '%s'

  • Error number: 1293; Symbol: ER_TOO_MUCH_AUTO_TIMESTAMP_COLS; SQLSTATE: HY000

    Message: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

  • Error number: 1294; Symbol: ER_INVALID_ON_UPDATE; SQLSTATE: HY000

    Message: Invalid ON UPDATE clause for '%s' column

  • Error number: 1295; Symbol: ER_UNSUPPORTED_PS; SQLSTATE: HY000

    Message: This command is not supported in the prepared statement protocol yet

  • Error number: 1296; Symbol: ER_GET_ERRMSG; SQLSTATE: HY000

    Message: Got error %d '%s' from %s

  • Error number: 1297; Symbol: ER_GET_TEMPORARY_ERRMSG; SQLSTATE: HY000

    Message: Got temporary error %d '%s' from %s

  • Error number: 1298; Symbol: ER_UNKNOWN_TIME_ZONE; SQLSTATE: HY000

    Message: Unknown or incorrect time zone: '%s'

  • Error number: 1299; Symbol: ER_WARN_INVALID_TIMESTAMP; SQLSTATE: HY000

    Message: Invalid TIMESTAMP value in column '%s' at row %ld

  • Error number: 1300; Symbol: ER_INVALID_CHARACTER_STRING; SQLSTATE: HY000

    Message: Invalid %s character string: '%s'

  • Error number: 1301; Symbol: ER_WARN_ALLOWED_PACKET_OVERFLOWED; SQLSTATE: HY000

    Message: Result of %s() was larger than max_allowed_packet (%ld) - truncated

  • Error number: 1302; Symbol: ER_CONFLICTING_DECLARATIONS; SQLSTATE: HY000

    Message: Conflicting declarations: '%s%s' and '%s%s'

  • Error number: 1303; Symbol: ER_SP_NO_RECURSIVE_CREATE; SQLSTATE: 2F003

    Message: Can't create a %s from within another stored routine

  • Error number: 1304; Symbol: ER_SP_ALREADY_EXISTS; SQLSTATE: 42000

    Message: %s %s already exists

  • Error number: 1305; Symbol: ER_SP_DOES_NOT_EXIST; SQLSTATE: 42000

    Message: %s %s does not exist

  • Error number: 1306; Symbol: ER_SP_DROP_FAILED; SQLSTATE: HY000

    Message: Failed to DROP %s %s

  • Error number: 1307; Symbol: ER_SP_STORE_FAILED; SQLSTATE: HY000

    Message: Failed to CREATE %s %s

  • Error number: 1308; Symbol: ER_SP_LILABEL_MISMATCH; SQLSTATE: 42000

    Message: %s with no matching label: %s

  • Error number: 1309; Symbol: ER_SP_LABEL_REDEFINE; SQLSTATE: 42000

    Message: Redefining label %s

  • Error number: 1310; Symbol: ER_SP_LABEL_MISMATCH; SQLSTATE: 42000

    Message: End-label %s without match

  • Error number: 1311; Symbol: ER_SP_UNINIT_VAR; SQLSTATE: 01000

    Message: Referring to uninitialized variable %s

  • Error number: 1312; Symbol: ER_SP_BADSELECT; SQLSTATE: 0A000

    Message: PROCEDURE %s can't return a result set in the given context

  • Error number: 1313; Symbol: ER_SP_BADRETURN; SQLSTATE: 42000

    Message: RETURN is only allowed in a FUNCTION

  • Error number: 1314; Symbol: ER_SP_BADSTATEMENT; SQLSTATE: 0A000

    Message: %s is not allowed in stored procedures

  • Error number: 1315; Symbol: ER_UPDATE_LOG_DEPRECATED_IGNORED; SQLSTATE: 42000

    Message: The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been ignored. This option will be removed in MySQL 5.6.

  • Error number: 1316; Symbol: ER_UPDATE_LOG_DEPRECATED_TRANSLATED; SQLSTATE: 42000

    Message: The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been translated to SET SQL_LOG_BIN. This option will be removed in MySQL 5.6.

  • Error number: 1317; Symbol: ER_QUERY_INTERRUPTED; SQLSTATE: 70100

    Message: Query execution was interrupted

  • Error number: 1318; Symbol: ER_SP_WRONG_NO_OF_ARGS; SQLSTATE: 42000

    Message: Incorrect number of arguments for %s %s; expected %u, got %u

  • Error number: 1319; Symbol: ER_SP_COND_MISMATCH; SQLSTATE: 42000

    Message: Undefined CONDITION: %s

  • Error number: 1320; Symbol: ER_SP_NORETURN; SQLSTATE: 42000

    Message: No RETURN found in FUNCTION %s

  • Error number: 1321; Symbol: ER_SP_NORETURNEND; SQLSTATE: 2F005

    Message: FUNCTION %s ended without RETURN

  • Error number: 1322; Symbol: ER_SP_BAD_CURSOR_QUERY; SQLSTATE: 42000

    Message: Cursor statement must be a SELECT

  • Error number: 1323; Symbol: ER_SP_BAD_CURSOR_SELECT; SQLSTATE: 42000

    Message: Cursor SELECT must not have INTO

  • Error number: 1324; Symbol: ER_SP_CURSOR_MISMATCH; SQLSTATE: 42000

    Message: Undefined CURSOR: %s

  • Error number: 1325; Symbol: ER_SP_CURSOR_ALREADY_OPEN; SQLSTATE: 24000

    Message: Cursor is already open

  • Error number: 1326; Symbol: ER_SP_CURSOR_NOT_OPEN; SQLSTATE: 24000

    Message: Cursor is not open

  • Error number: 1327; Symbol: ER_SP_UNDECLARED_VAR; SQLSTATE: 42000

    Message: Undeclared variable: %s

  • Error number: 1328; Symbol: ER_SP_WRONG_NO_OF_FETCH_ARGS; SQLSTATE: HY000

    Message: Incorrect number of FETCH variables

  • Error number: 1329; Symbol: ER_SP_FETCH_NO_DATA; SQLSTATE: 02000

    Message: No data - zero rows fetched, selected, or processed

  • Error number: 1330; Symbol: ER_SP_DUP_PARAM; SQLSTATE: 42000

    Message: Duplicate parameter: %s

  • Error number: 1331; Symbol: ER_SP_DUP_VAR; SQLSTATE: 42000

    Message: Duplicate variable: %s

  • Error number: 1332; Symbol: ER_SP_DUP_COND; SQLSTATE: 42000

    Message: Duplicate condition: %s

  • Error number: 1333; Symbol: ER_SP_DUP_CURS; SQLSTATE: 42000

    Message: Duplicate cursor: %s

  • Error number: 1334; Symbol: ER_SP_CANT_ALTER; SQLSTATE: HY000

    Message: Failed to ALTER %s %s

  • Error number: 1335; Symbol: ER_SP_SUBSELECT_NYI; SQLSTATE: 0A000

    Message: Subquery value not supported

  • Error number: 1336; Symbol: ER_STMT_NOT_ALLOWED_IN_SF_OR_TRG; SQLSTATE: 0A000

    Message: %s is not allowed in stored function or trigger

  • Error number: 1337; Symbol: ER_SP_VARCOND_AFTER_CURSHNDLR; SQLSTATE: 42000

    Message: Variable or condition declaration after cursor or handler declaration

  • Error number: 1338; Symbol: ER_SP_CURSOR_AFTER_HANDLER; SQLSTATE: 42000

    Message: Cursor declaration after handler declaration

  • Error number: 1339; Symbol: ER_SP_CASE_NOT_FOUND; SQLSTATE: 20000

    Message: Case not found for CASE statement

  • Error number: 1340; Symbol: ER_FPARSER_TOO_BIG_FILE; SQLSTATE: HY000

    Message: Configuration file '%s' is too big

  • Error number: 1341; Symbol: ER_FPARSER_BAD_HEADER; SQLSTATE: HY000

    Message: Malformed file type header in file '%s'

  • Error number: 1342; Symbol: ER_FPARSER_EOF_IN_COMMENT; SQLSTATE: HY000

    Message: Unexpected end of file while parsing comment '%s'

  • Error number: 1343; Symbol: ER_FPARSER_ERROR_IN_PARAMETER; SQLSTATE: HY000

    Message: Error while parsing parameter '%s' (line: '%s')

  • Error number: 1344; Symbol: ER_FPARSER_EOF_IN_UNKNOWN_PARAMETER; SQLSTATE: HY000

    Message: Unexpected end of file while skipping unknown parameter '%s'

  • Error number: 1345; Symbol: ER_VIEW_NO_EXPLAIN; SQLSTATE: HY000

    Message: EXPLAIN/SHOW can not be issued; lacking privileges for underlying table

  • Error number: 1346; Symbol: ER_FRM_UNKNOWN_TYPE; SQLSTATE: HY000

    Message: File '%s' has unknown type '%s' in its header

  • Error number: 1347; Symbol: ER_WRONG_OBJECT; SQLSTATE: HY000

    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 number: 1348; Symbol: ER_NONUPDATEABLE_COLUMN; SQLSTATE: HY000

    Message: Column '%s' is not updatable

  • Error number: 1349; Symbol: ER_VIEW_SELECT_DERIVED; SQLSTATE: HY000

    Message: View's SELECT contains a subquery in the FROM clause

  • Error number: 1350; Symbol: ER_VIEW_SELECT_CLAUSE; SQLSTATE: HY000

    Message: View's SELECT contains a '%s' clause

  • Error number: 1351; Symbol: ER_VIEW_SELECT_VARIABLE; SQLSTATE: HY000

    Message: View's SELECT contains a variable or parameter

  • Error number: 1352; Symbol: ER_VIEW_SELECT_TMPTABLE; SQLSTATE: HY000

    Message: View's SELECT refers to a temporary table '%s'

  • Error number: 1353; Symbol: ER_VIEW_WRONG_LIST; SQLSTATE: HY000

    Message: View's SELECT and view's field list have different column counts

  • Error number: 1354; Symbol: ER_WARN_VIEW_MERGE; SQLSTATE: HY000

    Message: View merge algorithm can't be used here for now (assumed undefined algorithm)

  • Error number: 1355; Symbol: ER_WARN_VIEW_WITHOUT_KEY; SQLSTATE: HY000

    Message: View being updated does not have complete key of underlying table in it

  • Error number: 1356; Symbol: ER_VIEW_INVALID; SQLSTATE: HY000

    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 number: 1357; Symbol: ER_SP_NO_DROP_SP; SQLSTATE: HY000

    Message: Can't drop or alter a %s from within another stored routine

  • Error number: 1358; Symbol: ER_SP_GOTO_IN_HNDLR; SQLSTATE: HY000

    Message: GOTO is not allowed in a stored procedure handler

  • Error number: 1359; Symbol: ER_TRG_ALREADY_EXISTS; SQLSTATE: HY000

    Message: Trigger already exists

  • Error number: 1360; Symbol: ER_TRG_DOES_NOT_EXIST; SQLSTATE: HY000

    Message: Trigger does not exist

  • Error number: 1361; Symbol: ER_TRG_ON_VIEW_OR_TEMP_TABLE; SQLSTATE: HY000

    Message: Trigger's '%s' is view or temporary table

  • Error number: 1362; Symbol: ER_TRG_CANT_CHANGE_ROW; SQLSTATE: HY000

    Message: Updating of %s row is not allowed in %strigger

  • Error number: 1363; Symbol: ER_TRG_NO_SUCH_ROW_IN_TRG; SQLSTATE: HY000

    Message: There is no %s row in %s trigger

  • Error number: 1364; Symbol: ER_NO_DEFAULT_FOR_FIELD; SQLSTATE: HY000

    Message: Field '%s' doesn't have a default value

  • Error number: 1365; Symbol: ER_DIVISION_BY_ZERO; SQLSTATE: 22012

    Message: Division by 0

  • Error number: 1366; Symbol: ER_TRUNCATED_WRONG_VALUE_FOR_FIELD; SQLSTATE: HY000

    Message: Incorrect %s value: '%s' for column '%s' at row %ld

  • Error number: 1367; Symbol: ER_ILLEGAL_VALUE_FOR_TYPE; SQLSTATE: 22007

    Message: Illegal %s '%s' value found during parsing

  • Error number: 1368; Symbol: ER_VIEW_NONUPD_CHECK; SQLSTATE: HY000

    Message: CHECK OPTION on non-updatable view '%s.%s'

  • Error number: 1369; Symbol: ER_VIEW_CHECK_FAILED; SQLSTATE: HY000

    Message: CHECK OPTION failed '%s.%s'

  • Error number: 1370; Symbol: ER_PROCACCESS_DENIED_ERROR; SQLSTATE: 42000

    Message: %s command denied to user '%s'@'%s' for routine '%s'

  • Error number: 1371; Symbol: ER_RELAY_LOG_FAIL; SQLSTATE: HY000

    Message: Failed purging old relay logs: %s

  • Error number: 1372; Symbol: ER_PASSWD_LENGTH; SQLSTATE: HY000

    Message: Password hash should be a %d-digit hexadecimal number

  • Error number: 1373; Symbol: ER_UNKNOWN_TARGET_BINLOG; SQLSTATE: HY000

    Message: Target log not found in binlog index

  • Error number: 1374; Symbol: ER_IO_ERR_LOG_INDEX_READ; SQLSTATE: HY000

    Message: I/O error reading log index file

  • Error number: 1375; Symbol: ER_BINLOG_PURGE_PROHIBITED; SQLSTATE: HY000

    Message: Server configuration does not permit binlog purge

  • Error number: 1376; Symbol: ER_FSEEK_FAIL; SQLSTATE: HY000

    Message: Failed on fseek()

  • Error number: 1377; Symbol: ER_BINLOG_PURGE_FATAL_ERR; SQLSTATE: HY000

    Message: Fatal error during log purge

  • Error number: 1378; Symbol: ER_LOG_IN_USE; SQLSTATE: HY000

    Message: A purgeable log is in use, will not purge

  • Error number: 1379; Symbol: ER_LOG_PURGE_UNKNOWN_ERR; SQLSTATE: HY000

    Message: Unknown error during log purge

  • Error number: 1380; Symbol: ER_RELAY_LOG_INIT; SQLSTATE: HY000

    Message: Failed initializing relay log position: %s

  • Error number: 1381; Symbol: ER_NO_BINARY_LOGGING; SQLSTATE: HY000

    Message: You are not using binary logging

  • Error number: 1382; Symbol: ER_RESERVED_SYNTAX; SQLSTATE: HY000

    Message: The '%s' syntax is reserved for purposes internal to the MySQL server

  • Error number: 1383; Symbol: ER_WSAS_FAILED; SQLSTATE: HY000

    Message: WSAStartup Failed

  • Error number: 1384; Symbol: ER_DIFF_GROUPS_PROC; SQLSTATE: HY000

    Message: Can't handle procedures with different groups yet

  • Error number: 1385; Symbol: ER_NO_GROUP_FOR_PROC; SQLSTATE: HY000

    Message: Select must have a group with this procedure

  • Error number: 1386; Symbol: ER_ORDER_WITH_PROC; SQLSTATE: HY000

    Message: Can't use ORDER clause with this procedure

  • Error number: 1387; Symbol: ER_LOGGING_PROHIBIT_CHANGING_OF; SQLSTATE: HY000

    Message: Binary logging and replication forbid changing the global server %s

  • Error number: 1388; Symbol: ER_NO_FILE_MAPPING; SQLSTATE: HY000

    Message: Can't map file: %s, errno: %d

  • Error number: 1389; Symbol: ER_WRONG_MAGIC; SQLSTATE: HY000

    Message: Wrong magic in %s

  • Error number: 1390; Symbol: ER_PS_MANY_PARAM; SQLSTATE: HY000

    Message: Prepared statement contains too many placeholders

  • Error number: 1391; Symbol: ER_KEY_PART_0; SQLSTATE: HY000

    Message: Key part '%s' length cannot be 0

  • Error number: 1392; Symbol: ER_VIEW_CHECKSUM; SQLSTATE: HY000

    Message: View text checksum failed

  • Error number: 1393; Symbol: ER_VIEW_MULTIUPDATE; SQLSTATE: HY000

    Message: Can not modify more than one base table through a join view '%s.%s'

  • Error number: 1394; Symbol: ER_VIEW_NO_INSERT_FIELD_LIST; SQLSTATE: HY000

    Message: Can not insert into join view '%s.%s' without fields list

  • Error number: 1395; Symbol: ER_VIEW_DELETE_MERGE_VIEW; SQLSTATE: HY000

    Message: Can not delete from join view '%s.%s'

  • Error number: 1396; Symbol: ER_CANNOT_USER; SQLSTATE: HY000

    Message: Operation %s failed for %s

  • Error number: 1397; Symbol: ER_XAER_NOTA; SQLSTATE: XAE04

    Message: XAER_NOTA: Unknown XID

  • Error number: 1398; Symbol: ER_XAER_INVAL; SQLSTATE: XAE05

    Message: XAER_INVAL: Invalid arguments (or unsupported command)

  • Error number: 1399; Symbol: ER_XAER_RMFAIL; SQLSTATE: XAE07

    Message: XAER_RMFAIL: The command cannot be executed when global transaction is in the %s state

  • Error number: 1400; Symbol: ER_XAER_OUTSIDE; SQLSTATE: XAE09

    Message: XAER_OUTSIDE: Some work is done outside global transaction

  • Error number: 1401; Symbol: ER_XAER_RMERR; SQLSTATE: XAE03

    Message: XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency

  • Error number: 1402; Symbol: ER_XA_RBROLLBACK; SQLSTATE: XA100

    Message: XA_RBROLLBACK: Transaction branch was rolled back

  • Error number: 1403; Symbol: ER_NONEXISTING_PROC_GRANT; SQLSTATE: 42000

    Message: There is no such grant defined for user '%s' on host '%s' on routine '%s'

  • Error number: 1404; Symbol: ER_PROC_AUTO_GRANT_FAIL; SQLSTATE: HY000

    Message: Failed to grant EXECUTE and ALTER ROUTINE privileges

  • Error number: 1405; Symbol: ER_PROC_AUTO_REVOKE_FAIL; SQLSTATE: HY000

    Message: Failed to revoke all privileges to dropped routine

  • Error number: 1406; Symbol: ER_DATA_TOO_LONG; SQLSTATE: 22001

    Message: Data too long for column '%s' at row %ld

  • Error number: 1407; Symbol: ER_SP_BAD_SQLSTATE; SQLSTATE: 42000

    Message: Bad SQLSTATE: '%s'

  • Error number: 1408; Symbol: ER_STARTUP; SQLSTATE: HY000

    Message: %s: ready for connections. Version: '%s' socket: '%s' port: %d %s

  • Error number: 1409; Symbol: ER_LOAD_FROM_FIXED_SIZE_ROWS_TO_VAR; SQLSTATE: HY000

    Message: Can't load value from file with fixed size rows to variable

  • Error number: 1410; Symbol: ER_CANT_CREATE_USER_WITH_GRANT; SQLSTATE: 42000

    Message: You are not allowed to create a user with GRANT

  • Error number: 1411; Symbol: ER_WRONG_VALUE_FOR_TYPE; SQLSTATE: HY000

    Message: Incorrect %s value: '%s' for function %s

  • Error number: 1412; Symbol: ER_TABLE_DEF_CHANGED; SQLSTATE: HY000

    Message: Table definition has changed, please retry transaction

  • Error number: 1413; Symbol: ER_SP_DUP_HANDLER; SQLSTATE: 42000

    Message: Duplicate handler declared in the same block

  • Error number: 1414; Symbol: ER_SP_NOT_VAR_ARG; SQLSTATE: 42000

    Message: OUT or INOUT argument %d for routine %s is not a variable or NEW pseudo-variable in BEFORE trigger

  • Error number: 1415; Symbol: ER_SP_NO_RETSET; SQLSTATE: 0A000

    Message: Not allowed to return a result set from a %s

  • Error number: 1416; Symbol: ER_CANT_CREATE_GEOMETRY_OBJECT; SQLSTATE: 22003

    Message: Cannot get geometry object from data you send to the GEOMETRY field

  • Error number: 1417; Symbol: ER_FAILED_ROUTINE_BREAK_BINLOG; SQLSTATE: HY000

    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 number: 1418; Symbol: ER_BINLOG_UNSAFE_ROUTINE; SQLSTATE: HY000

    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 number: 1419; Symbol: ER_BINLOG_CREATE_ROUTINE_NEED_SUPER; SQLSTATE: HY000

    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 number: 1420; Symbol: ER_EXEC_STMT_WITH_OPEN_CURSOR; SQLSTATE: HY000

    Message: You can't execute a prepared statement which has an open cursor associated with it. Reset the statement to re-execute it.

  • Error number: 1421; Symbol: ER_STMT_HAS_NO_OPEN_CURSOR; SQLSTATE: HY000

    Message: The statement (%lu) has no open cursor.

  • Error number: 1422; Symbol: ER_COMMIT_NOT_ALLOWED_IN_SF_OR_TRG; SQLSTATE: HY000

    Message: Explicit or implicit commit is not allowed in stored function or trigger.

  • Error number: 1423; Symbol: ER_NO_DEFAULT_FOR_VIEW_FIELD; SQLSTATE: HY000

    Message: Field of view '%s.%s' underlying table doesn't have a default value

  • Error number: 1424; Symbol: ER_SP_NO_RECURSION; SQLSTATE: HY000

    Message: Recursive stored functions and triggers are not allowed.

  • Error number: 1425; Symbol: ER_TOO_BIG_SCALE; SQLSTATE: 42000

    Message: Too big scale %d specified for column '%s'. Maximum is %lu.

  • Error number: 1426; Symbol: ER_TOO_BIG_PRECISION; SQLSTATE: 42000

    Message: Too big precision %d specified for column '%s'. Maximum is %lu.

  • Error number: 1427; Symbol: ER_M_BIGGER_THAN_D; SQLSTATE: 42000

    Message: For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column '%s').

  • Error number: 1428; Symbol: ER_WRONG_LOCK_OF_SYSTEM_TABLE; SQLSTATE: HY000

    Message: You can't combine write-locking of system tables with other tables or lock types

  • Error number: 1429; Symbol: ER_CONNECT_TO_FOREIGN_DATA_SOURCE; SQLSTATE: HY000

    Message: Unable to connect to foreign data source: %s

  • Error number: 1430; Symbol: ER_QUERY_ON_FOREIGN_DATA_SOURCE; SQLSTATE: HY000

    Message: There was a problem processing the query on the foreign data source. Data source error: %s

  • Error number: 1431; Symbol: ER_FOREIGN_DATA_SOURCE_DOESNT_EXIST; SQLSTATE: HY000

    Message: The foreign data source you are trying to reference does not exist. Data source error: %s

  • Error number: 1432; Symbol: ER_FOREIGN_DATA_STRING_INVALID_CANT_CREATE; SQLSTATE: HY000

    Message: Can't create federated table. The data source connection string '%s' is not in the correct format

  • Error number: 1433; Symbol: ER_FOREIGN_DATA_STRING_INVALID; SQLSTATE: HY000

    Message: The data source connection string '%s' is not in the correct format

  • Error number: 1434; Symbol: ER_CANT_CREATE_FEDERATED_TABLE; SQLSTATE: HY000

    Message: Can't create federated table. Foreign data src error: %s

  • Error number: 1435; Symbol: ER_TRG_IN_WRONG_SCHEMA; SQLSTATE: HY000

    Message: Trigger in wrong schema

  • Error number: 1436; Symbol: ER_STACK_OVERRUN_NEED_MORE; SQLSTATE: HY000

    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 number: 1437; Symbol: ER_TOO_LONG_BODY; SQLSTATE: 42000

    Message: Routine body for '%s' is too long

  • Error number: 1438; Symbol: ER_WARN_CANT_DROP_DEFAULT_KEYCACHE; SQLSTATE: HY000

    Message: Cannot drop default keycache

  • Error number: 1439; Symbol: ER_TOO_BIG_DISPLAYWIDTH; SQLSTATE: 42000

    Message: Display width out of range for column '%s' (max = %lu)

  • Error number: 1440; Symbol: ER_XAER_DUPID; SQLSTATE: XAE08

    Message: XAER_DUPID: The XID already exists

  • Error number: 1441; Symbol: ER_DATETIME_FUNCTION_OVERFLOW; SQLSTATE: 22008

    Message: Datetime function: %s field overflow

  • Error number: 1442; Symbol: ER_CANT_UPDATE_USED_TABLE_IN_SF_OR_TRG; SQLSTATE: HY000

    Message: Can't update table '%s' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.

  • Error number: 1443; Symbol: ER_VIEW_PREVENT_UPDATE; SQLSTATE: HY000

    Message: The definition of table '%s' prevents operation %s on table '%s'.

  • Error number: 1444; Symbol: ER_PS_NO_RECURSION; SQLSTATE: HY000

    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 number: 1445; Symbol: ER_SP_CANT_SET_AUTOCOMMIT; SQLSTATE: HY000

    Message: Not allowed to set autocommit from a stored function or trigger

  • Error number: 1446; Symbol: ER_MALFORMED_DEFINER; SQLSTATE: HY000

    Message: Definer is not fully qualified

  • Error number: 1447; Symbol: ER_VIEW_FRM_NO_USER; SQLSTATE: HY000

    Message: View '%s'.'%s' has no definer information (old table format). Current user is used as definer. Please recreate the view!

  • Error number: 1448; Symbol: ER_VIEW_OTHER_USER; SQLSTATE: HY000

    Message: You need the SUPER privilege for creation view with '%s'@'%s' definer

  • Error number: 1449; Symbol: ER_NO_SUCH_USER; SQLSTATE: HY000

    Message: The user specified as a definer ('%s'@'%s') does not exist

  • Error number: 1450; Symbol: ER_FORBID_SCHEMA_CHANGE; SQLSTATE: HY000

    Message: Changing schema from '%s' to '%s' is not allowed.

  • Error number: 1451; Symbol: ER_ROW_IS_REFERENCED_2; SQLSTATE: 23000

    Message: Cannot delete or update a parent row: a foreign key constraint fails (%s)

    InnoDB reports this error when you try to delete a parent row that has children, and a foreign key constraint fails. Delete the children first.

  • Error number: 1452; Symbol: ER_NO_REFERENCED_ROW_2; SQLSTATE: 23000

    Message: Cannot add or update a child row: a foreign key constraint fails (%s)

    InnoDB reports 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 number: 1453; Symbol: ER_SP_BAD_VAR_SHADOW; SQLSTATE: 42000

    Message: Variable '%s' must be quoted with `...`, or renamed

  • Error number: 1454; Symbol: ER_TRG_NO_DEFINER; SQLSTATE: HY000

    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 number: 1455; Symbol: ER_OLD_FILE_FORMAT; SQLSTATE: HY000

    Message: '%s' has an old format, you should re-create the '%s' object(s)

  • Error number: 1456; Symbol: ER_SP_RECURSION_LIMIT; SQLSTATE: HY000

    Message: Recursive limit %d (as set by the max_sp_recursion_depth variable) was exceeded for routine %s

  • Error number: 1457; Symbol: ER_SP_PROC_TABLE_CORRUPT; SQLSTATE: HY000

    Message: Failed to load routine %s. The table mysql.proc is missing, corrupt, or contains bad data (internal code %d)

  • Error number: 1458; Symbol: ER_SP_WRONG_NAME; SQLSTATE: 42000

    Message: Incorrect routine name '%s'

  • Error number: 1459; Symbol: ER_TABLE_NEEDS_UPGRADE; SQLSTATE: HY000

    Message: Table upgrade required. Please do "REPAIR TABLE `%s`" or dump/reload to fix it!

  • Error number: 1460; Symbol: ER_SP_NO_AGGREGATE; SQLSTATE: 42000

    Message: AGGREGATE is not supported for stored functions

  • Error number: 1461; Symbol: ER_MAX_PREPARED_STMT_COUNT_REACHED; SQLSTATE: 42000

    Message: Can't create more than max_prepared_stmt_count statements (current value: %lu)

  • Error number: 1462; Symbol: ER_VIEW_RECURSIVE; SQLSTATE: HY000

    Message: `%s`.`%s` contains view recursion

  • Error number: 1463; Symbol: ER_NON_GROUPING_FIELD_USED; SQLSTATE: 42000

    Message: Non-grouping field '%s' is used in %s clause

  • Error number: 1464; Symbol: ER_TABLE_CANT_HANDLE_SPKEYS; SQLSTATE: HY000

    Message: The used table type doesn't support SPATIAL indexes

  • Error number: 1465; Symbol: ER_NO_TRIGGERS_ON_SYSTEM_SCHEMA; SQLSTATE: HY000

    Message: Triggers can not be created on system tables

  • Error number: 1466; Symbol: ER_REMOVED_SPACES; SQLSTATE: HY000

    Message: Leading spaces are removed from name '%s'

  • Error number: 1467; Symbol: ER_AUTOINC_READ_FAILED; SQLSTATE: HY000

    Message: Failed to read auto-increment value from storage engine

  • Error number: 1468; Symbol: ER_USERNAME; SQLSTATE: HY000

    Message: user name

  • Error number: 1469; Symbol: ER_HOSTNAME; SQLSTATE: HY000

    Message: host name

  • Error number: 1470; Symbol: ER_WRONG_STRING_LENGTH; SQLSTATE: HY000

    Message: String '%s' is too long for %s (should be no longer than %d)

  • Error number: 1471; Symbol: ER_NON_INSERTABLE_TABLE; SQLSTATE: HY000

    Message: The target table %s of the %s is not insertable-into

  • Error number: 1472; Symbol: ER_ADMIN_WRONG_MRG_TABLE; SQLSTATE: HY000

    Message: Table '%s' is differently defined or of non-MyISAM type or doesn't exist

  • Error number: 1473; Symbol: ER_TOO_HIGH_LEVEL_OF_NESTING_FOR_SELECT; SQLSTATE: HY000

    Message: Too high level of nesting for select

  • Error number: 1474; Symbol: ER_NAME_BECOMES_EMPTY; SQLSTATE: HY000

    Message: Name '%s' has become ''

  • Error number: 1475; Symbol: ER_AMBIGUOUS_FIELD_TERM; SQLSTATE: HY000

    Message: First character of the FIELDS TERMINATED string is ambiguous; please use non-optional and non-empty FIELDS ENCLOSED BY

  • Error number: 1476; Symbol: ER_FOREIGN_SERVER_EXISTS; SQLSTATE: HY000

    Message: The foreign server, %s, you are trying to create already exists.

  • Error number: 1477; Symbol: ER_FOREIGN_SERVER_DOESNT_EXIST; SQLSTATE: HY000

    Message: The foreign server name you are trying to reference does not exist. Data source error: %s

  • Error number: 1478; Symbol: ER_ILLEGAL_HA_CREATE_OPTION; SQLSTATE: HY000

    Message: Table storage engine '%s' does not support the create option '%s'

  • Error number: 1479; Symbol: ER_PARTITION_REQUIRES_VALUES_ERROR; SQLSTATE: HY000

    Message: Syntax error: %s PARTITIONING requires definition of VALUES %s for each partition

  • Error number: 1480; Symbol: ER_PARTITION_WRONG_VALUES_ERROR; SQLSTATE: HY000

    Message: Only %s PARTITIONING can use VALUES %s in partition definition

  • Error number: 1481; Symbol: ER_PARTITION_MAXVALUE_ERROR; SQLSTATE: HY000

    Message: MAXVALUE can only be used in last partition definition

  • Error number: 1482; Symbol: ER_PARTITION_SUBPARTITION_ERROR; SQLSTATE: HY000

    Message: Subpartitions can only be hash partitions and by key

  • Error number: 1483; Symbol: ER_PARTITION_SUBPART_MIX_ERROR; SQLSTATE: HY000

    Message: Must define subpartitions on all partitions if on one partition

  • Error number: 1484; Symbol: ER_PARTITION_WRONG_NO_PART_ERROR; SQLSTATE: HY000

    Message: Wrong number of partitions defined, mismatch with previous setting

  • Error number: 1485; Symbol: ER_PARTITION_WRONG_NO_SUBPART_ERROR; SQLSTATE: HY000

    Message: Wrong number of subpartitions defined, mismatch with previous setting

  • Error number: 1486; Symbol: ER_CONST_EXPR_IN_PARTITION_FUNC_ERROR; SQLSTATE: HY000

    Message: Constant/Random expression in (sub)partitioning function is not allowed

    In 5.5.1: ER_CONST_EXPR_IN_PARTITION_FUNC_ERROR was renamed to ER_WRONG_EXPR_IN_PARTITION_FUNC_ERROR.

    ER_CONST_EXPR_IN_PARTITION_FUNC_ERROR was removed after 5.5.0.

  • Error number: 1486; Symbol: ER_WRONG_EXPR_IN_PARTITION_FUNC_ERROR; SQLSTATE: HY000

    Message: Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed

    In 5.5.1: ER_CONST_EXPR_IN_PARTITION_FUNC_ERROR was renamed to ER_WRONG_EXPR_IN_PARTITION_FUNC_ERROR.

    ER_WRONG_EXPR_IN_PARTITION_FUNC_ERROR was added in 5.5.1.

  • Error number: 1487; Symbol: ER_NO_CONST_EXPR_IN_RANGE_OR_LIST_ERROR; SQLSTATE: HY000

    Message: Expression in RANGE/LIST VALUES must be constant

  • Error number: 1488; Symbol: ER_FIELD_NOT_FOUND_PART_ERROR; SQLSTATE: HY000

    Message: Field in list of fields for partition function not found in table

  • Error number: 1489; Symbol: ER_LIST_OF_FIELDS_ONLY_IN_HASH_ERROR; SQLSTATE: HY000

    Message: List of fields is only allowed in KEY partitions

  • Error number: 1490; Symbol: ER_INCONSISTENT_PARTITION_INFO_ERROR; SQLSTATE: HY000

    Message: The partition info in the frm file is not consistent with what can be written into the frm file

  • Error number: 1491; Symbol: ER_PARTITION_FUNC_NOT_ALLOWED_ERROR; SQLSTATE: HY000

    Message: The %s function returns the wrong type

  • Error number: 1492; Symbol: ER_PARTITIONS_MUST_BE_DEFINED_ERROR; SQLSTATE: HY000

    Message: For %s partitions each partition must be defined

  • Error number: 1493; Symbol: ER_RANGE_NOT_INCREASING_ERROR; SQLSTATE: HY000

    Message: VALUES LESS THAN value must be strictly increasing for each partition

  • Error number: 1494; Symbol: ER_INCONSISTENT_TYPE_OF_FUNCTIONS_ERROR; SQLSTATE: HY000

    Message: VALUES value must be of same type as partition function

  • Error number: 1495; Symbol: ER_MULTIPLE_DEF_CONST_IN_LIST_PART_ERROR; SQLSTATE: HY000

    Message: Multiple definition of same constant in list partitioning

  • Error number: 1496; Symbol: ER_PARTITION_ENTRY_ERROR; SQLSTATE: HY000

    Message: Partitioning can not be used stand-alone in query

  • Error number: 1497; Symbol: ER_MIX_HANDLER_ERROR; SQLSTATE: HY000

    Message: The mix of handlers in the partitions is not allowed in this version of MySQL

  • Error number: 1498; Symbol: ER_PARTITION_NOT_DEFINED_ERROR; SQLSTATE: HY000

    Message: For the partitioned engine it is necessary to define all %s

  • Error number: 1499; Symbol: ER_TOO_MANY_PARTITIONS_ERROR; SQLSTATE: HY000

    Message: Too many partitions (including subpartitions) were defined

  • Error number: 1500; Symbol: ER_SUBPARTITION_ERROR; SQLSTATE: HY000

    Message: It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning

  • Error number: 1501; Symbol: ER_CANT_CREATE_HANDLER_FILE; SQLSTATE: HY000

    Message: Failed to create specific handler file

  • Error number: 1502; Symbol: ER_BLOB_FIELD_IN_PART_FUNC_ERROR; SQLSTATE: HY000

    Message: A BLOB field is not allowed in partition function

  • Error number: 1503; Symbol: ER_UNIQUE_KEY_NEED_ALL_FIELDS_IN_PF; SQLSTATE: HY000

    Message: A %s must include all columns in the table's partitioning function

  • Error number: 1504; Symbol: ER_NO_PARTS_ERROR; SQLSTATE: HY000

    Message: Number of %s = 0 is not an allowed value

  • Error number: 1505; Symbol: ER_PARTITION_MGMT_ON_NONPARTITIONED; SQLSTATE: HY000

    Message: Partition management on a not partitioned table is not possible

  • Error number: 1506; Symbol: ER_FOREIGN_KEY_ON_PARTITIONED; SQLSTATE: HY000

    Message: Foreign key clause is not yet supported in conjunction with partitioning

  • Error number: 1507; Symbol: ER_DROP_PARTITION_NON_EXISTENT; SQLSTATE: HY000

    Message: Error in list of partitions to %s

  • Error number: 1508; Symbol: ER_DROP_LAST_PARTITION; SQLSTATE: HY000

    Message: Cannot remove all partitions, use DROP TABLE instead

  • Error number: 1509; Symbol: ER_COALESCE_ONLY_ON_HASH_PARTITION; SQLSTATE: HY000

    Message: COALESCE PARTITION can only be used on HASH/KEY partitions

  • Error number: 1510; Symbol: ER_REORG_HASH_ONLY_ON_SAME_NO; SQLSTATE: HY000

    Message: REORGANIZE PARTITION can only be used to reorganize partitions not to change their numbers

  • Error number: 1511; Symbol: ER_REORG_NO_PARAM_ERROR; SQLSTATE: HY000

    Message: REORGANIZE PARTITION without parameters can only be used on auto-partitioned tables using HASH PARTITIONs

  • Error number: 1512; Symbol: ER_ONLY_ON_RANGE_LIST_PARTITION; SQLSTATE: HY000

    Message: %s PARTITION can only be used on RANGE/LIST partitions

  • Error number: 1513; Symbol: ER_ADD_PARTITION_SUBPART_ERROR; SQLSTATE: HY000

    Message: Trying to Add partition(s) with wrong number of subpartitions

  • Error number: 1514; Symbol: ER_ADD_PARTITION_NO_NEW_PARTITION; SQLSTATE: HY000

    Message: At least one partition must be added

  • Error number: 1515; Symbol: ER_COALESCE_PARTITION_NO_PARTITION; SQLSTATE: HY000

    Message: At least one partition must be coalesced

  • Error number: 1516; Symbol: ER_REORG_PARTITION_NOT_EXIST; SQLSTATE: HY000

    Message: More partitions to reorganize than there are partitions

  • Error number: 1517; Symbol: ER_SAME_NAME_PARTITION; SQLSTATE: HY000

    Message: Duplicate partition name %s

  • Error number: 1518; Symbol: ER_NO_BINLOG_ERROR; SQLSTATE: HY000

    Message: It is not allowed to shut off binlog on this command

  • Error number: 1519; Symbol: ER_CONSECUTIVE_REORG_PARTITIONS; SQLSTATE: HY000

    Message: When reorganizing a set of partitions they must be in consecutive order

  • Error number: 1520; Symbol: ER_REORG_OUTSIDE_RANGE; SQLSTATE: HY000

    Message: Reorganize of range partitions cannot change total ranges except for last partition where it can extend the range

  • Error number: 1521; Symbol: ER_PARTITION_FUNCTION_FAILURE; SQLSTATE: HY000

    Message: Partition function not supported in this version for this handler

  • Error number: 1522; Symbol: ER_PART_STATE_ERROR; SQLSTATE: HY000

    Message: Partition state cannot be defined from CREATE/ALTER TABLE

  • Error number: 1523; Symbol: ER_LIMITED_PART_RANGE; SQLSTATE: HY000

    Message: The %s handler only supports 32 bit integers in VALUES

  • Error number: 1524; Symbol: ER_PLUGIN_IS_NOT_LOADED; SQLSTATE: HY000

    Message: Plugin '%s' is not loaded

  • Error number: 1525; Symbol: ER_WRONG_VALUE; SQLSTATE: HY000

    Message: Incorrect %s value: '%s'

  • Error number: 1526; Symbol: ER_NO_PARTITION_FOR_GIVEN_VALUE; SQLSTATE: HY000

    Message: Table has no partition for value %s

  • Error number: 1527; Symbol: ER_FILEGROUP_OPTION_ONLY_ONCE; SQLSTATE: HY000

    Message: It is not allowed to specify %s more than once

  • Error number: 1528; Symbol: ER_CREATE_FILEGROUP_FAILED; SQLSTATE: HY000

    Message: Failed to create %s

  • Error number: 1529; Symbol: ER_DROP_FILEGROUP_FAILED; SQLSTATE: HY000

    Message: Failed to drop %s

  • Error number: 1530; Symbol: ER_TABLESPACE_AUTO_EXTEND_ERROR; SQLSTATE: HY000

    Message: The handler doesn't support autoextend of tablespaces

  • Error number: 1531; Symbol: ER_WRONG_SIZE_NUMBER; SQLSTATE: HY000

    Message: A size parameter was incorrectly specified, either number or on the form 10M

  • Error number: 1532; Symbol: ER_SIZE_OVERFLOW_ERROR; SQLSTATE: HY000

    Message: The size number was correct but we don't allow the digit part to be more than 2 billion

  • Error number: 1533; Symbol: ER_ALTER_FILEGROUP_FAILED; SQLSTATE: HY000

    Message: Failed to alter: %s

  • Error number: 1534; Symbol: ER_BINLOG_ROW_LOGGING_FAILED; SQLSTATE: HY000

    Message: Writing one row to the row-based binary log failed

  • Error number: 1535; Symbol: ER_BINLOG_ROW_WRONG_TABLE_DEF; SQLSTATE: HY000

    Message: Table definition on master and slave does not match: %s

  • Error number: 1536; Symbol: ER_BINLOG_ROW_RBR_TO_SBR; SQLSTATE: HY000

    Message: Slave running with --log-slave-updates must use row-based binary logging to be able to replicate row-based binary log events

  • Error number: 1537; Symbol: ER_EVENT_ALREADY_EXISTS; SQLSTATE: HY000

    Message: Event '%s' already exists

  • Error number: 1538; Symbol: ER_EVENT_STORE_FAILED; SQLSTATE: HY000

    Message: Failed to store event %s. Error code %d from storage engine.

  • Error number: 1539; Symbol: ER_EVENT_DOES_NOT_EXIST; SQLSTATE: HY000

    Message: Unknown event '%s'

  • Error number: 1540; Symbol: ER_EVENT_CANT_ALTER; SQLSTATE: HY000

    Message: Failed to alter event '%s'

  • Error number: 1541; Symbol: ER_EVENT_DROP_FAILED; SQLSTATE: HY000

    Message: Failed to drop %s

  • Error number: 1542; Symbol: ER_EVENT_INTERVAL_NOT_POSITIVE_OR_TOO_BIG; SQLSTATE: HY000

    Message: INTERVAL is either not positive or too big

  • Error number: 1543; Symbol: ER_EVENT_ENDS_BEFORE_STARTS; SQLSTATE: HY000

    Message: ENDS is either invalid or before STARTS

  • Error number: 1544; Symbol: ER_EVENT_EXEC_TIME_IN_THE_PAST; SQLSTATE: HY000

    Message: Event execution time is in the past. Event has been disabled

  • Error number: 1545; Symbol: ER_EVENT_OPEN_TABLE_FAILED; SQLSTATE: HY000

    Message: Failed to open mysql.event

  • Error number: 1546; Symbol: ER_EVENT_NEITHER_M_EXPR_NOR_M_AT; SQLSTATE: HY000

    Message: No datetime expression provided

  • Error number: 1547; Symbol: ER_COL_COUNT_DOESNT_MATCH_CORRUPTED; SQLSTATE: HY000

    Message: Column count of mysql.%s is wrong. Expected %d, found %d. The table is probably corrupted

  • Error number: 1548; Symbol: ER_CANNOT_LOAD_FROM_TABLE; SQLSTATE: HY000

    Message: Cannot load from mysql.%s. The table is probably corrupted

  • Error number: 1549; Symbol: ER_EVENT_CANNOT_DELETE; SQLSTATE: HY000

    Message: Failed to delete the event from mysql.event

  • Error number: 1550; Symbol: ER_EVENT_COMPILE_ERROR; SQLSTATE: HY000

    Message: Error during compilation of event's body

  • Error number: 1551; Symbol: ER_EVENT_SAME_NAME; SQLSTATE: HY000

    Message: Same old and new event name

  • Error number: 1552; Symbol: ER_EVENT_DATA_TOO_LONG; SQLSTATE: HY000

    Message: Data for column '%s' too long

  • Error number: 1553; Symbol: ER_DROP_INDEX_FK; SQLSTATE: HY000

    Message: Cannot drop index '%s': needed in a foreign key constraint

    InnoDB reports this error when you attempt to drop the last index that can enforce a particular referential constraint.

    For optimal performance with DML statements, InnoDB requires an index to exist on foreign key columns, so that UPDATE and DELETE operations 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 of CREATE TABLE, CREATE INDEX, and ALTER TABLE statements.

    When you drop an index, InnoDB checks 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. InnoDB prevents you from dropping the last index that can enforce a particular referential constraint.

  • Error number: 1554; Symbol: ER_WARN_DEPRECATED_SYNTAX_WITH_VER; SQLSTATE: HY000

    Message: The syntax '%s' is deprecated and will be removed in MySQL %s. Please use %s instead

  • Error number: 1555; Symbol: ER_CANT_WRITE_LOCK_LOG_TABLE; SQLSTATE: HY000

    Message: You can't write-lock a log table. Only read access is possible

  • Error number: 1556; Symbol: ER_CANT_LOCK_LOG_TABLE; SQLSTATE: HY000

    Message: You can't use locks with log tables.

  • Error number: 1557; Symbol: ER_FOREIGN_DUPLICATE_KEY; SQLSTATE: 23000

    Message: Upholding foreign key constraints for table '%s', entry '%s', key %d would lead to a duplicate entry

  • Error number: 1558; Symbol: ER_COL_COUNT_DOESNT_MATCH_PLEASE_UPDATE; SQLSTATE: HY000

    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 number: 1559; Symbol: ER_TEMP_TABLE_PREVENTS_SWITCH_OUT_OF_RBR; SQLSTATE: HY000

    Message: Cannot switch out of the row-based binary log format when the session has open temporary tables

  • Error number: 1560; Symbol: ER_STORED_FUNCTION_PREVENTS_SWITCH_BINLOG_FORMAT; SQLSTATE: HY000

    Message: Cannot change the binary logging format inside a stored function or trigger

  • Error number: 1561; Symbol: ER_NDB_CANT_SWITCH_BINLOG_FORMAT; SQLSTATE: HY000

    Message: The NDB cluster engine does not support changing the binlog format on the fly yet

  • Error number: 1562; Symbol: ER_PARTITION_NO_TEMPORARY; SQLSTATE: HY000

    Message: Cannot create temporary table with partitions

  • Error number: 1563; Symbol: ER_PARTITION_CONST_DOMAIN_ERROR; SQLSTATE: HY000

    Message: Partition constant is out of partition function domain

  • Error number: 1564; Symbol: ER_PARTITION_FUNCTION_IS_NOT_ALLOWED; SQLSTATE: HY000

    Message: This partition function is not allowed

  • Error number: 1565; Symbol: ER_DDL_LOG_ERROR; SQLSTATE: HY000

    Message: Error in DDL log

  • Error number: 1566; Symbol: ER_NULL_IN_VALUES_LESS_THAN; SQLSTATE: HY000

    Message: Not allowed to use NULL value in VALUES LESS THAN

  • Error number: 1567; Symbol: ER_WRONG_PARTITION_NAME; SQLSTATE: HY000

    Message: Incorrect partition name

  • Error number: 1568; Symbol: ER_CANT_CHANGE_TX_ISOLATION; SQLSTATE: 25001

    Message: Transaction isolation level can't be changed while a transaction is in progress

  • Error number: 1569; Symbol: ER_DUP_ENTRY_AUTOINCREMENT_CASE; SQLSTATE: HY000

    Message: ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '%s' for key '%s'

  • Error number: 1570; Symbol: ER_EVENT_MODIFY_QUEUE_ERROR; SQLSTATE: HY000

    Message: Internal scheduler error %d

  • Error number: 1571; Symbol: ER_EVENT_SET_VAR_ERROR; SQLSTATE: HY000

    Message: Error during starting/stopping of the scheduler. Error code %u

  • Error number: 1572; Symbol: ER_PARTITION_MERGE_ERROR; SQLSTATE: HY000

    Message: Engine cannot be used in partitioned tables

  • Error number: 1573; Symbol: ER_CANT_ACTIVATE_LOG; SQLSTATE: HY000

    Message: Cannot activate '%s' log

  • Error number: 1574; Symbol: ER_RBR_NOT_AVAILABLE; SQLSTATE: HY000

    Message: The server was not built with row-based replication

  • Error number: 1575; Symbol: ER_BASE64_DECODE_ERROR; SQLSTATE: HY000

    Message: Decoding of base64 string failed

  • Error number: 1576; Symbol: ER_EVENT_RECURSION_FORBIDDEN; SQLSTATE: HY000

    Message: Recursion of EVENT DDL statements is forbidden when body is present

  • Error number: 1577; Symbol: ER_EVENTS_DB_ERROR; SQLSTATE: HY000

    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 number: 1578; Symbol: ER_ONLY_INTEGERS_ALLOWED; SQLSTATE: HY000

    Message: Only integers allowed as number here

  • Error number: 1579; Symbol: ER_UNSUPORTED_LOG_ENGINE; SQLSTATE: HY000

    Message: This storage engine cannot be used for log tables"

  • Error number: 1580; Symbol: ER_BAD_LOG_STATEMENT; SQLSTATE: HY000

    Message: You cannot '%s' a log table if logging is enabled

  • Error number: 1581; Symbol: ER_CANT_RENAME_LOG_TABLE; SQLSTATE: HY000

    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 number: 1582; Symbol: ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT; SQLSTATE: 42000

    Message: Incorrect parameter count in the call to native function '%s'

  • Error number: 1583; Symbol: ER_WRONG_PARAMETERS_TO_NATIVE_FCT; SQLSTATE: 42000

    Message: Incorrect parameters in the call to native function '%s'

  • Error number: 1584; Symbol: ER_WRONG_PARAMETERS_TO_STORED_FCT; SQLSTATE: 42000

    Message: Incorrect parameters in the call to stored function '%s'

  • Error number: 1585; Symbol: ER_NATIVE_FCT_NAME_COLLISION; SQLSTATE: HY000

    Message: This function '%s' has the same name as a native function

  • Error number: 1586; Symbol: ER_DUP_ENTRY_WITH_KEY_NAME; SQLSTATE: 23000

    Message: Duplicate entry '%s' for key '%s'

    The format string for this error is also used with ER_DUP_ENTRY.

  • Error number: 1587; Symbol: ER_BINLOG_PURGE_EMFILE; SQLSTATE: HY000

    Message: Too many files opened, please execute the command again

  • Error number: 1588; Symbol: ER_EVENT_CANNOT_CREATE_IN_THE_PAST; SQLSTATE: HY000

    Message: Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was dropped immediately after creation.

  • Error number: 1589; Symbol: ER_EVENT_CANNOT_ALTER_IN_THE_PAST; SQLSTATE: HY000

    Message: Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was dropped immediately after creation.

  • Error number: 1590; Symbol: ER_SLAVE_INCIDENT; SQLSTATE: HY000

    Message: The incident %s occured on the master. Message: %s

  • Error number: 1591; Symbol: ER_NO_PARTITION_FOR_GIVEN_VALUE_SILENT; SQLSTATE: HY000

    Message: Table has no partition for some existing values

  • Error number: 1592; Symbol: ER_BINLOG_UNSAFE_STATEMENT; SQLSTATE: HY000

    Message: Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. %s

  • Error number: 1593; Symbol: ER_SLAVE_FATAL_ERROR; SQLSTATE: HY000

    Message: Fatal error: %s

  • Error number: 1594; Symbol: ER_SLAVE_RELAY_LOG_READ_FAILURE; SQLSTATE: HY000

    Message: Relay log read failure: %s

  • Error number: 1595; Symbol: ER_SLAVE_RELAY_LOG_WRITE_FAILURE; SQLSTATE: HY000

    Message: Relay log write failure: %s

  • Error number: 1596; Symbol: ER_SLAVE_CREATE_EVENT_FAILURE; SQLSTATE: HY000

    Message: Failed to create %s

  • Error number: 1597; Symbol: ER_SLAVE_MASTER_COM_FAILURE; SQLSTATE: HY000

    Message: Master command %s failed: %s

  • Error number: 1598; Symbol: ER_BINLOG_LOGGING_IMPOSSIBLE; SQLSTATE: HY000

    Message: Binary logging not possible. Message: %s

  • Error number: 1599; Symbol: ER_VIEW_NO_CREATION_CTX; SQLSTATE: HY000

    Message: View `%s`.`%s` has no creation context

  • Error number: 1600; Symbol: ER_VIEW_INVALID_CREATION_CTX; SQLSTATE: HY000

    Message: Creation context of view `%s`.`%s' is invalid

  • Error number: 1601; Symbol: ER_SR_INVALID_CREATION_CTX; SQLSTATE: HY000

    Message: Creation context of stored routine `%s`.`%s` is invalid

  • Error number: 1602; Symbol: ER_TRG_CORRUPTED_FILE; SQLSTATE: HY000

    Message: Corrupted TRG file for table `%s`.`%s`

  • Error number: 1603; Symbol: ER_TRG_NO_CREATION_CTX; SQLSTATE: HY000

    Message: Triggers for table `%s`.`%s` have no creation context

  • Error number: 1604; Symbol: ER_TRG_INVALID_CREATION_CTX; SQLSTATE: HY000

    Message: Trigger creation context of table `%s`.`%s` is invalid

  • Error number: 1605; Symbol: ER_EVENT_INVALID_CREATION_CTX; SQLSTATE: HY000

    Message: Creation context of event `%s`.`%s` is invalid

  • Error number: 1606; Symbol: ER_TRG_CANT_OPEN_TABLE; SQLSTATE: HY000

    Message: Cannot open table for trigger `%s`.`%s`

  • Error number: 1607; Symbol: ER_CANT_CREATE_SROUTINE; SQLSTATE: HY000

    Message: Cannot create stored routine `%s`. Check warnings

  • Error number: 1608; Symbol: ER_SLAVE_AMBIGOUS_EXEC_MODE; SQLSTATE: HY000

    Message: Ambiguous slave modes combination. %s

    In 5.5.3: ER_SLAVE_AMBIGOUS_EXEC_MODE was renamed to ER_NEVER_USED.

    ER_SLAVE_AMBIGOUS_EXEC_MODE was removed after 5.5.2.

  • Error number: 1608; Symbol: ER_NEVER_USED; SQLSTATE: HY000

    Message: Ambiguous slave modes combination. %s

    In 5.5.3: ER_SLAVE_AMBIGOUS_EXEC_MODE was renamed to ER_NEVER_USED.

    ER_NEVER_USED was added in 5.5.3.

  • Error number: 1609; Symbol: ER_NO_FORMAT_DESCRIPTION_EVENT_BEFORE_BINLOG_STATEMENT; SQLSTATE: HY000

    Message: The BINLOG statement of type `%s` was not preceded by a format description BINLOG statement.

  • Error number: 1610; Symbol: ER_SLAVE_CORRUPT_EVENT; SQLSTATE: HY000

    Message: Corrupted replication event was detected

  • Error number: 1611; Symbol: ER_LOAD_DATA_INVALID_COLUMN; SQLSTATE: HY000

    Message: Invalid column reference (%s) in LOAD DATA

  • Error number: 1612; Symbol: ER_LOG_PURGE_NO_FILE; SQLSTATE: HY000

    Message: Being purged log %s was not found

  • Error number: 1613; Symbol: ER_XA_RBTIMEOUT; SQLSTATE: XA106

    Message: XA_RBTIMEOUT: Transaction branch was rolled back: took too long

  • Error number: 1614; Symbol: ER_XA_RBDEADLOCK; SQLSTATE: XA102

    Message: XA_RBDEADLOCK: Transaction branch was rolled back: deadlock was detected

  • Error number: 1615; Symbol: ER_NEED_REPREPARE; SQLSTATE: HY000

    Message: Prepared statement needs to be re-prepared

  • Error number: 1616; Symbol: ER_DELAYED_NOT_SUPPORTED; SQLSTATE: HY000

    Message: DELAYED option not supported for table '%s'

  • Error number: 1617; Symbol: WARN_NO_MASTER_INFO; SQLSTATE: HY000

    Message: The master info structure does not exist

  • Error number: 1618; Symbol: WARN_OPTION_IGNORED; SQLSTATE: HY000

    Message: <%s> option ignored

  • Error number: 1619; Symbol: WARN_PLUGIN_DELETE_BUILTIN; SQLSTATE: HY000

    Message: Built-in plugins cannot be deleted

  • Error number: 1620; Symbol: WARN_PLUGIN_BUSY; SQLSTATE: HY000

    Message: Plugin is busy and will be uninstalled on shutdown

  • Error number: 1621; Symbol: ER_VARIABLE_IS_READONLY; SQLSTATE: HY000

    Message: %s variable '%s' is read-only. Use SET %s to assign the value

  • Error number: 1622; Symbol: ER_WARN_ENGINE_TRANSACTION_ROLLBACK; SQLSTATE: HY000

    Message: Storage engine %s does not support rollback for this statement. Transaction rolled back and must be restarted

  • Error number: 1623; Symbol: ER_SLAVE_HEARTBEAT_FAILURE; SQLSTATE: HY000

    Message: Unexpected master's heartbeat data: %s

  • Error number: 1624; Symbol: ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE; SQLSTATE: HY000

    Message: The requested value for the heartbeat period is either negative or exceeds the maximum allowed (%s seconds).

  • Error number: 1625; Symbol: ER_NDB_REPLICATION_SCHEMA_ERROR; SQLSTATE: HY000

    Message: Bad schema for mysql.ndb_replication table. Message: %s

  • Error number: 1626; Symbol: ER_CONFLICT_FN_PARSE_ERROR; SQLSTATE: HY000

    Message: Error in parsing conflict function. Message: %s

  • Error number: 1627; Symbol: ER_EXCEPTIONS_WRITE_ERROR; SQLSTATE: HY000

    Message: Write to exceptions table failed. Message: %s"

  • Error number: 1628; Symbol: ER_TOO_LONG_TABLE_COMMENT; SQLSTATE: HY000

    Message: Comment for table '%s' is too long (max = %lu)

  • Error number: 1629; Symbol: ER_TOO_LONG_FIELD_COMMENT; SQLSTATE: HY000

    Message: Comment for field '%s' is too long (max = %lu)

  • Error number: 1630; Symbol: ER_FUNC_INEXISTENT_NAME_COLLISION; SQLSTATE: 42000

    Message: FUNCTION %s does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual

  • Error number: 1631; Symbol: ER_DATABASE_NAME; SQLSTATE: HY000

    Message: Database

  • Error number: 1632; Symbol: ER_TABLE_NAME; SQLSTATE: HY000

    Message: Table

  • Error number: 1633; Symbol: ER_PARTITION_NAME; SQLSTATE: HY000

    Message: Partition

  • Error number: 1634; Symbol: ER_SUBPARTITION_NAME; SQLSTATE: HY000

    Message: Subpartition

  • Error number: 1635; Symbol: ER_TEMPORARY_NAME; SQLSTATE: HY000

    Message: Temporary

  • Error number: 1636; Symbol: ER_RENAMED_NAME; SQLSTATE: HY000

    Message: Renamed

  • Error number: 1637; Symbol: ER_TOO_MANY_CONCURRENT_TRXS; SQLSTATE: HY000

    Message: Too many active concurrent transactions

  • Error number: 1638; Symbol: WARN_NON_ASCII_SEPARATOR_NOT_IMPLEMENTED; SQLSTATE: HY000

    Message: Non-ASCII separator arguments are not fully supported

  • Error number: 1639; Symbol: ER_DEBUG_SYNC_TIMEOUT; SQLSTATE: HY000

    Message: debug sync point wait timed out

  • Error number: 1640; Symbol: ER_DEBUG_SYNC_HIT_LIMIT; SQLSTATE: HY000

    Message: debug sync point hit limit reached

  • Error number: 1641; Symbol: ER_DUP_SIGNAL_SET; SQLSTATE: 42000

    Message: Duplicate condition information item '%s'

  • Error number: 1642; Symbol: ER_SIGNAL_WARN; SQLSTATE: 01000

    Message: Unhandled user-defined warning condition

  • Error number: 1643; Symbol: ER_SIGNAL_NOT_FOUND; SQLSTATE: 02000

    Message: Unhandled user-defined not found condition

  • Error number: 1644; Symbol: ER_SIGNAL_EXCEPTION; SQLSTATE: HY000

    Message: Unhandled user-defined exception condition

  • Error number: 1645; Symbol: ER_RESIGNAL_WITHOUT_ACTIVE_HANDLER; SQLSTATE: 0K000

    Message: RESIGNAL when handler not active

  • Error number: 1646; Symbol: ER_SIGNAL_BAD_CONDITION_TYPE; SQLSTATE: HY000

    Message: SIGNAL/RESIGNAL can only use a CONDITION defined with SQLSTATE

  • Error number: 1647; Symbol: WARN_COND_ITEM_TRUNCATED; SQLSTATE: HY000

    Message: Data truncated for condition item '%s'

  • Error number: 1648; Symbol: ER_COND_ITEM_TOO_LONG; SQLSTATE: HY000

    Message: Data too long for condition item '%s'

  • Error number: 1649; Symbol: ER_UNKNOWN_LOCALE; SQLSTATE: HY000

    Message: Unknown locale: '%s'

  • Error number: 1650; Symbol: ER_SLAVE_IGNORE_SERVER_IDS; SQLSTATE: HY000

    Message: The requested server id %d clashes with the slave startup option --replicate-same-server-id

  • Error number: 1651; Symbol: ER_QUERY_CACHE_DISABLED; SQLSTATE: HY000

    Message: Query cache is disabled; restart the server with query_cache_type=1 to enable it

  • Error number: 1652; Symbol: ER_SAME_NAME_PARTITION_FIELD; SQLSTATE: HY000

    Message: Duplicate partition field name '%s'

  • Error number: 1653; Symbol: ER_PARTITION_COLUMN_LIST_ERROR; SQLSTATE: HY000

    Message: Inconsistency in usage of column lists for partitioning

  • Error number: 1654; Symbol: ER_WRONG_TYPE_COLUMN_VALUE_ERROR; SQLSTATE: HY000

    Message: Partition column values of incorrect type

  • Error number: 1655; Symbol: ER_TOO_MANY_PARTITION_FUNC_FIELDS_ERROR; SQLSTATE: HY000

    Message: Too many fields in '%s'

  • Error number: 1656; Symbol: ER_MAXVALUE_IN_VALUES_IN; SQLSTATE: HY000

    Message: Cannot use MAXVALUE as value in VALUES IN

  • Error number: 1657; Symbol: ER_TOO_MANY_VALUES_ERROR; SQLSTATE: HY000

    Message: Cannot have more than one value for this type of %s partitioning

  • Error number: 1658; Symbol: ER_ROW_SINGLE_PARTITION_FIELD_ERROR; SQLSTATE: HY000

    Message: Row expressions in VALUES IN only allowed for multi-field column partitioning

  • Error number: 1659; Symbol: ER_FIELD_TYPE_NOT_ALLOWED_AS_PARTITION_FIELD; SQLSTATE: HY000

    Message: Field '%s' is of a not allowed type for this type of partitioning

  • Error number: 1660; Symbol: ER_PARTITION_FIELDS_TOO_LONG; SQLSTATE: HY000

    Message: The total length of the partitioning fields is too large

  • Error number: 1661; Symbol: ER_BINLOG_ROW_ENGINE_AND_STMT_ENGINE; SQLSTATE: HY000

    Message: Cannot execute statement: impossible to write to binary log since both row-incapable engines and statement-incapable engines are involved.

    ER_BINLOG_ROW_ENGINE_AND_STMT_ENGINE was added in 5.5.3.

  • Error number: 1662; Symbol: ER_BINLOG_ROW_MODE_AND_STMT_ENGINE; SQLSTATE: HY000

    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.

    ER_BINLOG_ROW_MODE_AND_STMT_ENGINE was added in 5.5.3.

  • Error number: 1663; Symbol: ER_BINLOG_UNSAFE_AND_STMT_ENGINE; SQLSTATE: HY000

    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

    ER_BINLOG_UNSAFE_AND_STMT_ENGINE was added in 5.5.3.

  • Error number: 1664; Symbol: ER_BINLOG_ROW_INJECTION_AND_STMT_ENGINE; SQLSTATE: HY000

    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.

    ER_BINLOG_ROW_INJECTION_AND_STMT_ENGINE was added in 5.5.3.

  • Error number: 1665; Symbol: ER_BINLOG_STMT_MODE_AND_ROW_ENGINE; SQLSTATE: HY000

    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

    ER_BINLOG_STMT_MODE_AND_ROW_ENGINE was added in 5.5.3.

  • Error number: 1666; Symbol: ER_BINLOG_ROW_INJECTION_AND_STMT_MODE; SQLSTATE: HY000

    Message: Cannot execute statement: impossible to write to binary log since statement is in row format and BINLOG_FORMAT = STATEMENT.

    ER_BINLOG_ROW_INJECTION_AND_STMT_MODE was added in 5.5.3.

  • Error number: 1667; Symbol: ER_BINLOG_MULTIPLE_ENGINES_AND_SELF_LOGGING_ENGINE; SQLSTATE: HY000

    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.

    ER_BINLOG_MULTIPLE_ENGINES_AND_SELF_LOGGING_ENGINE was added in 5.5.3.

  • Error number: 1668; Symbol: ER_BINLOG_UNSAFE_LIMIT; SQLSTATE: HY000

    Message: The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.

    ER_BINLOG_UNSAFE_LIMIT was added in 5.5.3.

  • Error number: 1669; Symbol: ER_BINLOG_UNSAFE_INSERT_DELAYED; SQLSTATE: HY000

    Message: The statement is unsafe because it uses INSERT DELAYED. This is unsafe because the times when rows are inserted cannot be predicted.

    ER_BINLOG_UNSAFE_INSERT_DELAYED was added in 5.5.3.

  • Error number: 1670; Symbol: ER_BINLOG_UNSAFE_SYSTEM_TABLE; SQLSTATE: HY000

    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.

    ER_BINLOG_UNSAFE_SYSTEM_TABLE was added in 5.5.3.

  • Error number: 1671; Symbol: ER_BINLOG_UNSAFE_AUTOINC_COLUMNS; SQLSTATE: HY000

    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.

    ER_BINLOG_UNSAFE_AUTOINC_COLUMNS was added in 5.5.3.

  • Error number: 1672; Symbol: ER_BINLOG_UNSAFE_UDF; SQLSTATE: HY000

    Message: Statement is unsafe because it uses a UDF which may not return the same value on the slave.

    ER_BINLOG_UNSAFE_UDF was added in 5.5.3.

  • Error number: 1673; Symbol: ER_BINLOG_UNSAFE_SYSTEM_VARIABLE; SQLSTATE: HY000

    Message: Statement is unsafe because it uses a system variable that may have a different value on the slave.

    ER_BINLOG_UNSAFE_SYSTEM_VARIABLE was added in 5.5.3.

  • Error number: 1674; Symbol: ER_BINLOG_UNSAFE_SYSTEM_FUNCTION; SQLSTATE: HY000

    Message: Statement is unsafe because it uses a system function that may return a different value on the slave.

    ER_BINLOG_UNSAFE_SYSTEM_FUNCTION was added in 5.5.3.

  • Error number: 1675; Symbol: ER_BINLOG_UNSAFE_NONTRANS_AFTER_TRANS; SQLSTATE: HY000

    Message: Statement is unsafe because it accesses a non-transactional table after accessing a transactional table within the same transaction.

    ER_BINLOG_UNSAFE_NONTRANS_AFTER_TRANS was added in 5.5.3.

  • Error number: 1676; Symbol: ER_MESSAGE_AND_STATEMENT; SQLSTATE: HY000

    Message: %s Statement: %s

    ER_MESSAGE_AND_STATEMENT was added in 5.5.3.

  • Error number: 1677; Symbol: ER_SLAVE_CONVERSION_FAILED; SQLSTATE: HY000

    Message: Column %d of table '%s.%s' cannot be converted from type '%s' to type '%s'

    ER_SLAVE_CONVERSION_FAILED was added in 5.5.3.

  • Error number: 1678; Symbol: ER_SLAVE_CANT_CREATE_CONVERSION; SQLSTATE: HY000

    Message: Can't create conversion table for table '%s.%s'

    ER_SLAVE_CANT_CREATE_CONVERSION was added in 5.5.3.

  • Error number: 1679; Symbol: ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_BINLOG_FORMAT; SQLSTATE: HY000

    Message: Cannot modify @@session.binlog_format inside a transaction

    ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_BINLOG_FORMAT was added in 5.5.3.

  • Error number: 1680; Symbol: ER_PATH_LENGTH; SQLSTATE: HY000

    Message: The path specified for %s is too long.

    ER_PATH_LENGTH was added in 5.5.3.

  • Error number: 1681; Symbol: ER_WARN_DEPRECATED_SYNTAX_NO_REPLACEMENT; SQLSTATE: HY000

    Message: '%s' is deprecated and will be removed in a future release.

    ER_WARN_DEPRECATED_SYNTAX_NO_REPLACEMENT was added in 5.5.3.

  • Error number: 1682; Symbol: ER_WRONG_NATIVE_TABLE_STRUCTURE; SQLSTATE: HY000

    Message: Native table '%s'.'%s' has the wrong structure

    ER_WRONG_NATIVE_TABLE_STRUCTURE was added in 5.5.3.

  • Error number: 1683; Symbol: ER_WRONG_PERFSCHEMA_USAGE; SQLSTATE: HY000

    Message: Invalid performance_schema usage.

    ER_WRONG_PERFSCHEMA_USAGE was added in 5.5.3.

  • Error number: 1684; Symbol: ER_WARN_I_S_SKIPPED_TABLE; SQLSTATE: HY000

    Message: Table '%s'.'%s' was skipped since its definition is being modified by concurrent DDL statement

    ER_WARN_I_S_SKIPPED_TABLE was added in 5.5.3.

  • Error number: 1685; Symbol: ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_BINLOG_DIRECT; SQLSTATE: HY000

    Message: Cannot modify @@session.binlog_direct_non_transactional_updates inside a transaction

    ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_BINLOG_DIRECT was added in 5.5.3.

  • Error number: 1686; Symbol: ER_STORED_FUNCTION_PREVENTS_SWITCH_BINLOG_DIRECT; SQLSTATE: HY000

    Message: Cannot change the binlog direct flag inside a stored function or trigger

    ER_STORED_FUNCTION_PREVENTS_SWITCH_BINLOG_DIRECT was added in 5.5.3.

  • Error number: 1687; Symbol: ER_SPATIAL_MUST_HAVE_GEOM_COL; SQLSTATE: 42000

    Message: A SPATIAL index may only contain a geometrical type column

    ER_SPATIAL_MUST_HAVE_GEOM_COL was added in 5.5.2.

  • Error number: 1688; Symbol: ER_TOO_LONG_INDEX_COMMENT; SQLSTATE: HY000

    Message: Comment for index '%s' is too long (max = %lu)

    ER_TOO_LONG_INDEX_COMMENT was added in 5.5.3.

  • Error number: 1689; Symbol: ER_LOCK_ABORTED; SQLSTATE: HY000

    Message: Wait on a lock was aborted due to a pending exclusive lock

    ER_LOCK_ABORTED was added in 5.5.4.

  • Error number: 1690; Symbol: ER_DATA_OUT_OF_RANGE; SQLSTATE: 22003

    Message: %s value is out of range in '%s'

    ER_DATA_OUT_OF_RANGE was added in 5.5.5.

  • Error number: 1691; Symbol: ER_WRONG_SPVAR_TYPE_IN_LIMIT; SQLSTATE: HY000

    Message: A variable of a non-integer based type in LIMIT clause

    ER_WRONG_SPVAR_TYPE_IN_LIMIT was added in 5.5.5.

  • Error number: 1692; Symbol: ER_BINLOG_UNSAFE_MULTIPLE_ENGINES_AND_SELF_LOGGING_ENGINE; SQLSTATE: HY000

    Message: Mixing self-logging and non-self-logging engines in a statement is unsafe.

    ER_BINLOG_UNSAFE_MULTIPLE_ENGINES_AND_SELF_LOGGING_ENGINE was added in 5.5.5.

  • Error number: 1693; Symbol: ER_BINLOG_UNSAFE_MIXED_STATEMENT; SQLSTATE: HY000

    Message: Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them.

    ER_BINLOG_UNSAFE_MIXED_STATEMENT was added in 5.5.5.

  • Error number: 1694; Symbol: ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_SQL_LOG_BIN; SQLSTATE: HY000

    Message: Cannot modify @@session.sql_log_bin inside a transaction

    ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_SQL_LOG_BIN was added in 5.5.5.

  • Error number: 1695; Symbol: ER_STORED_FUNCTION_PREVENTS_SWITCH_SQL_LOG_BIN; SQLSTATE: HY000

    Message: Cannot change the sql_log_bin inside a stored function or trigger

    ER_STORED_FUNCTION_PREVENTS_SWITCH_SQL_LOG_BIN was added in 5.5.5.

  • Error number: 1696; Symbol: ER_FAILED_READ_FROM_PAR_FILE; SQLSTATE: HY000

    Message: Failed to read from the .par file

    ER_FAILED_READ_FROM_PAR_FILE was added in 5.5.5.

  • Error number: 1697; Symbol: ER_VALUES_IS_NOT_INT_TYPE_ERROR; SQLSTATE: HY000

    Message: VALUES value for partition '%s' must have type INT

    ER_VALUES_IS_NOT_INT_TYPE_ERROR was added in 5.5.7.

  • Error number: 1698; Symbol: ER_ACCESS_DENIED_NO_PASSWORD_ERROR; SQLSTATE: 28000

    Message: Access denied for user '%s'@'%s'

    ER_ACCESS_DENIED_NO_PASSWORD_ERROR was added in 5.5.7.

  • Error number: 1699; Symbol: ER_SET_PASSWORD_AUTH_PLUGIN; SQLSTATE: HY000

    Message: SET PASSWORD has no significance for users authenticating via plugins

    ER_SET_PASSWORD_AUTH_PLUGIN was added in 5.5.7.

  • Error number: 1700; Symbol: ER_GRANT_PLUGIN_USER_EXISTS; SQLSTATE: HY000

    Message: GRANT with IDENTIFIED WITH is illegal because the user %-.*s already exists

    ER_GRANT_PLUGIN_USER_EXISTS was added in 5.5.7.

  • Error number: 1701; Symbol: ER_TRUNCATE_ILLEGAL_FK; SQLSTATE: 42000

    Message: Cannot truncate a table referenced in a foreign key constraint (%s)

    ER_TRUNCATE_ILLEGAL_FK was added in 5.5.7.

  • Error number: 1702; Symbol: ER_PLUGIN_IS_PERMANENT; SQLSTATE: HY000

    Message: Plugin '%s' is force_plus_permanent and can not be unloaded

    ER_PLUGIN_IS_PERMANENT was added in 5.5.7.

  • Error number: 1703; Symbol: ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE_MIN; SQLSTATE: HY000

    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_MIN was added in 5.5.7.

  • Error number: 1704; Symbol: ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE_MAX; SQLSTATE: HY000

    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_MAX was added in 5.5.7.

  • Error number: 1705; Symbol: ER_STMT_CACHE_FULL; SQLSTATE: HY000

    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_FULL was added in 5.5.9.

  • Error number: 1706; Symbol: ER_MULTI_UPDATE_KEY_CONFLICT; SQLSTATE: HY000

    Message: Primary key/partition key update is not allowed since the table is updated both as '%s' and '%s'.

    ER_MULTI_UPDATE_KEY_CONFLICT was added in 5.5.11.

  • Error number: 1707; Symbol: ER_TABLE_NEEDS_REBUILD; SQLSTATE: HY000

    Message: Table rebuild required. Please do "ALTER TABLE `%s` FORCE" or dump/reload to fix it!

    ER_TABLE_NEEDS_REBUILD was added in 5.5.11.

  • Error number: 1708; Symbol: WARN_OPTION_BELOW_LIMIT; SQLSTATE: HY000

    Message: The value of '%s' should be no less than the value of '%s'

    WARN_OPTION_BELOW_LIMIT was added in 5.5.12.

  • Error number: 1709; Symbol: ER_INDEX_COLUMN_TOO_LONG; SQLSTATE: HY000

    Message: Index column size too large. The maximum column size is %lu bytes.

    ER_INDEX_COLUMN_TOO_LONG was added in 5.5.14.

  • Error number: 1710; Symbol: ER_ERROR_IN_TRIGGER_BODY; SQLSTATE: HY000

    Message: Trigger '%s' has an error in its body: '%s'

    ER_ERROR_IN_TRIGGER_BODY was added in 5.5.15.

  • Error number: 1711; Symbol: ER_ERROR_IN_UNKNOWN_TRIGGER_BODY; SQLSTATE: HY000

    Message: Unknown trigger has an error in its body: '%s'

    ER_ERROR_IN_UNKNOWN_TRIGGER_BODY was added in 5.5.15.

  • Error number: 1712; Symbol: ER_INDEX_CORRUPT; SQLSTATE: HY000

    Message: Index %s is corrupted

    ER_INDEX_CORRUPT was added in 5.5.17.

  • Error number: 1713; Symbol: ER_UNDO_RECORD_TOO_BIG; SQLSTATE: HY000

    Message: Undo log record is too big.

    ER_UNDO_RECORD_TOO_BIG was added in 5.5.17.

  • Error number: 1714; Symbol: ER_BINLOG_UNSAFE_INSERT_IGNORE_SELECT; SQLSTATE: HY000

    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_SELECT was added in 5.5.18.

  • Error number: 1715; Symbol: ER_BINLOG_UNSAFE_INSERT_SELECT_UPDATE; SQLSTATE: HY000

    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_UPDATE was added in 5.5.18.

  • Error number: 1716; Symbol: ER_BINLOG_UNSAFE_REPLACE_SELECT; SQLSTATE: HY000

    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_SELECT was added in 5.5.18.

  • Error number: 1717; Symbol: ER_BINLOG_UNSAFE_CREATE_IGNORE_SELECT; SQLSTATE: HY000

    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_SELECT was added in 5.5.18.

  • Error number: 1718; Symbol: ER_BINLOG_UNSAFE_CREATE_REPLACE_SELECT; SQLSTATE: HY000

    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_SELECT was added in 5.5.18.

  • Error number: 1719; Symbol: ER_BINLOG_UNSAFE_UPDATE_IGNORE; SQLSTATE: HY000

    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_IGNORE was added in 5.5.18.

  • Error number: 1720; Symbol: ER_PLUGIN_NO_UNINSTALL; SQLSTATE: HY000

    Message: Plugin '%s' is marked as not dynamically uninstallable. You have to stop the server to uninstall it.

    ER_PLUGIN_NO_UNINSTALL was added in 5.5.16.

  • Error number: 1721; Symbol: ER_PLUGIN_NO_INSTALL; SQLSTATE: HY000

    Message: Plugin '%s' is marked as not dynamically installable. You have to stop the server to install it.

    ER_PLUGIN_NO_INSTALL was added in 5.5.16.

  • Error number: 1722; Symbol: ER_BINLOG_UNSAFE_WRITE_AUTOINC_SELECT; SQLSTATE: HY000

    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_SELECT was added in 5.5.22.

  • Error number: 1723; Symbol: ER_BINLOG_UNSAFE_CREATE_SELECT_AUTOINC; SQLSTATE: HY000

    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_AUTOINC was added in 5.5.22.

  • Error number: 1724; Symbol: ER_BINLOG_UNSAFE_INSERT_TWO_KEYS; SQLSTATE: HY000

    Message: INSERT... ON DUPLICATE KEY UPDATE on a table with more than one UNIQUE KEY is unsafe

    ER_BINLOG_UNSAFE_INSERT_TWO_KEYS was added in 5.5.24.

  • Error number: 1725; Symbol: ER_TABLE_IN_FK_CHECK; SQLSTATE: HY000

    Message: Table is being used in foreign key check.

    ER_TABLE_IN_FK_CHECK was added in 5.5.24.

  • Error number: 1726; Symbol: ER_UNSUPPORTED_ENGINE; SQLSTATE: HY000

    Message: Storage engine '%s' does not support system tables. [%s.%s]

    ER_UNSUPPORTED_ENGINE was added in 5.5.24.

  • Error number: 1727; Symbol: ER_BINLOG_UNSAFE_AUTOINC_NOT_FIRST; SQLSTATE: HY000

    Message: INSERT into autoincrement field which is not the first part in the composed primary key is unsafe.

    ER_BINLOG_UNSAFE_AUTOINC_NOT_FIRST was added in 5.5.25.


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.