MySQL error codes

From Just Solve the File Format Problem
(Difference between revisions)
Jump to: navigation, search
(Created page with "{{FormatInfo | name = MySQL error codes | formattype = electronic | subcat = Error codes | subcat2 = | subcat3 ...")
 
(Changed category)
 
(3 intermediate revisions by 2 users not shown)
Line 2: Line 2:
 
| name                  = MySQL error codes
 
| name                  = MySQL error codes
 
| formattype            = electronic
 
| formattype            = electronic
| subcat                = Error codes
+
| subcat                = Error codes and messages
 
| subcat2                =  
 
| subcat2                =  
 
| subcat3                =  
 
| subcat3                =  
Line 20: Line 20:
 
| caption                =
 
| caption                =
 
}}
 
}}
 +
 +
[[MySQL]] error code list:
  
 
{| class='wikitable'
 
{| class='wikitable'
Line 1,252: Line 1,254:
 
| (CR_NO_DATA) Attempt to read column without prior row fetch
 
| (CR_NO_DATA) Attempt to read column without prior row fetch
 
|}
 
|}
 +
 +
[[Category:Databases]]

Latest revision as of 19:27, 7 November 2015

File Format
Name MySQL error codes
Ontology
MySQL error code list:
1000 SQLSTATE: HY000 (ER_HASHCHK) hashchk
1001 SQLSTATE: HY000 (ER_NISAMCHK) isamchk
1002 SQLSTATE: HY000 (ER_NO) NO
1003 SQLSTATE: HY000 (ER_YES) YES
1004 SQLSTATE: HY000 (ER_CANT_CREATE_FILE) Can’t create file ‘%s’ (errno: %d)
1005 SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Can’t create table ‘%s’ (errno: %d)
1006 SQLSTATE: HY000 (ER_CANT_CREATE_DB) Can’t create database ‘%s’ (errno: %d)
1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Can’t create database ‘%s'; database exists
1008 SQLSTATE: HY000 (ER_DB_DROP_EXISTS) Can’t drop database ‘%s'; database doesn’t exist
1009 SQLSTATE: HY000 (ER_DB_DROP_DELETE) Error dropping database (can’t delete ‘%s’, errno: %d)
1010 SQLSTATE: HY000 (ER_DB_DROP_RMDIR) Error dropping database (can’t rmdir ‘%s’, errno: %d)
1011 SQLSTATE: HY000 (ER_CANT_DELETE_FILE) Error on delete of ‘%s’ (errno: %d)
1012 SQLSTATE: HY000 (ER_CANT_FIND_SYSTEM_REC) Can’t read record in system table
1013 SQLSTATE: HY000 (ER_CANT_GET_STAT) Can’t get status of ‘%s’ (errno: %d)
1014 SQLSTATE: HY000 (ER_CANT_GET_WD) Can’t get working directory (errno: %d)
1015 SQLSTATE: HY000 (ER_CANT_LOCK) Can’t lock file (errno: %d)
1016 SQLSTATE: HY000 (ER_CANT_OPEN_FILE) Can’t open file: ‘%s’ (errno: %d)
1017 SQLSTATE: HY000 (ER_FILE_NOT_FOUND) Can’t find file: ‘%s’ (errno: %d)
1018 SQLSTATE: HY000 (ER_CANT_READ_DIR) Can’t read dir of ‘%s’ (errno: %d)
1019 SQLSTATE: HY000 (ER_CANT_SET_WD) Can’t change dir to ‘%s’ (errno: %d)
1020 SQLSTATE: HY000 (ER_CHECKREAD) Record has changed since last read in table ‘%s’
1021 SQLSTATE: HY000 (ER_DISK_FULL) Disk full (%s); waiting for someone to free some space…
1022 SQLSTATE: 23000 (ER_DUP_KEY) Can’t write; duplicate key in table ‘%s’
1023 SQLSTATE: HY000 (ER_ERROR_ON_CLOSE) Error on close of ‘%s’ (errno: %d)
1024 SQLSTATE: HY000 (ER_ERROR_ON_READ) Error reading file ‘%s’ (errno: %d)
1025 SQLSTATE: HY000 (ER_ERROR_ON_RENAME) Error on rename of ‘%s’ to ‘%s’ (errno: %d)
1026 SQLSTATE: HY000 (ER_ERROR_ON_WRITE) Error writing file ‘%s’ (errno: %d)
1027 SQLSTATE: HY000 (ER_FILE_USED) ‘%s’ is locked against change
1028 SQLSTATE: HY000 (ER_FILSORT_ABORT) Sort aborted
1029 SQLSTATE: HY000 (ER_FORM_NOT_FOUND) View ‘%s’ doesn’t exist for ‘%s’
1030 SQLSTATE: HY000 (ER_GET_ERRNO) Got error %d from storage engine
1031 SQLSTATE: HY000 (ER_ILLEGAL_HA) Table storage engine for ‘%s’ doesn’t have this option
1032 SQLSTATE: HY000 (ER_KEY_NOT_FOUND) Can’t find record in ‘%s’
1033 SQLSTATE: HY000 (ER_NOT_FORM_FILE) Incorrect information in file: ‘%s’
1034 SQLSTATE: HY000 (ER_NOT_KEYFILE) Incorrect key file for table ‘%s'; try to repair it
1035 SQLSTATE: HY000 (ER_OLD_KEYFILE) Old key file for table ‘%s'; repair it!
1036 SQLSTATE: HY000 (ER_OPEN_AS_READONLY) Table ‘%s’ is read only
1037 SQLSTATE: HY001 (ER_OUTOFMEMORY) Out of memory; restart server and try again (needed %d bytes)
1038 SQLSTATE: HY001 (ER_OUT_OF_SORTMEMORY) Out of sort memory; increase server sort buffer size
1039 SQLSTATE: HY000 (ER_UNEXPECTED_EOF) Unexpected EOF found when reading file ‘%s’ (errno: %d)
1040 SQLSTATE: 08004 (ER_CON_COUNT_ERROR) Too many connections
1041 SQLSTATE: HY000 (ER_OUT_OF_RESOURCES) Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use ‘ulimit’ to allow mysqld to use more memory or you can add more swap space
1042 SQLSTATE: 08S01 (ER_BAD_HOST_ERROR) Can’t get hostname for your address
1043 SQLSTATE: 08S01 (ER_HANDSHAKE_ERROR) Bad handshake
1044 SQLSTATE: 42000 (ER_DBACCESS_DENIED_ERROR) Access denied for user ‘%s’@’%s’ to database ‘%s’
1045 SQLSTATE: 28000 (ER_ACCESS_DENIED_ERROR) Access denied for user ‘%s’@’%s’ (using password: %s)
1046 SQLSTATE: 3D000 (ER_NO_DB_ERROR) No database selected
1047 SQLSTATE: 08S01 (ER_UNKNOWN_COM_ERROR) Unknown command
1048 SQLSTATE: 23000 (ER_BAD_NULL_ERROR) Column ‘%s’ cannot be null
1049 SQLSTATE: 42000 (ER_BAD_DB_ERROR) Unknown database ‘%s’
1050 SQLSTATE: 42S01 (ER_TABLE_EXISTS_ERROR) Table ‘%s’ already exists
1051 SQLSTATE: 42S02 (ER_BAD_TABLE_ERROR) Unknown table ‘%s’
1052 SQLSTATE: 23000 (ER_NON_UNIQ_ERROR) Column ‘%s’ in %s is ambiguous
1053 SQLSTATE: 08S01 (ER_SERVER_SHUTDOWN) Server shutdown in progress
1054 SQLSTATE: 42S22 (ER_BAD_FIELD_ERROR) Unknown column ‘%s’ in ‘%s’
1055 SQLSTATE: 42000 (ER_WRONG_FIELD_WITH_GROUP) ‘%s’ isn’t in GROUP BY
1056 SQLSTATE: 42000 (ER_WRONG_GROUP_FIELD) Can’t group on ‘%s’
1057 SQLSTATE: 42000 (ER_WRONG_SUM_SELECT) Statement has sum functions and columns in same statement
1058 SQLSTATE: 21S01 (ER_WRONG_VALUE_COUNT) Column count doesn’t match value count
1059 SQLSTATE: 42000 (ER_TOO_LONG_IDENT) Identifier name ‘%s’ is too long
1060 SQLSTATE: 42S21 (ER_DUP_FIELDNAME) Duplicate column name ‘%s’
1061 SQLSTATE: 42000 (ER_DUP_KEYNAME) Duplicate key name ‘%s’
1062 SQLSTATE: 23000 (ER_DUP_ENTRY) Duplicate entry ‘%s’ for key %d
1063 SQLSTATE: 42000 (ER_WRONG_FIELD_SPEC) Incorrect column specifier for column ‘%s’
1064 SQLSTATE: 42000 (ER_PARSE_ERROR) %s near ‘%s’ at line %d
1065 SQLSTATE: HY000 (ER_EMPTY_QUERY) Query was empty
1066 SQLSTATE: 42000 (ER_NONUNIQ_TABLE) Not unique table/alias: ‘%s’
1067 SQLSTATE: 42000 (ER_INVALID_DEFAULT) Invalid default value for ‘%s’
1068 SQLSTATE: 42000 (ER_MULTIPLE_PRI_KEY) Multiple primary key defined
1069 SQLSTATE: 42000 (ER_TOO_MANY_KEYS) Too many keys specified; max %d keys allowed
1070 SQLSTATE: 42000 (ER_TOO_MANY_KEY_PARTS) Too many key parts specified; max %d parts allowed
1071 SQLSTATE: 42000 (ER_TOO_LONG_KEY) Specified key was too long; max key length is %d bytes
1072 SQLSTATE: 42000 (ER_KEY_COLUMN_DOES_NOT_EXITS) Key column ‘%s’ doesn’t exist in table
1073 SQLSTATE: 42000 (ER_BLOB_USED_AS_KEY) BLOB column ‘%s’ can’t be used in key specification with the used table type
1074 SQLSTATE: 42000 (ER_TOO_BIG_FIELDLENGTH) Column length too big for column ‘%s’ (max = %d); use BLOB instead
1075 SQLSTATE: 42000 (ER_WRONG_AUTO_KEY) Incorrect table definition; there can be only one auto column and it must be defined as a key
1076 SQLSTATE: HY000 (ER_READY) %s: ready for connections. Version: ‘%s’ socket: ‘%s’ port: %d
1077 SQLSTATE: HY000 (ER_NORMAL_SHUTDOWN) %s: Normal shutdown
1078 SQLSTATE: HY000 (ER_GOT_SIGNAL) %s: Got signal %d. Aborting!
1079 SQLSTATE: HY000 (ER_SHUTDOWN_COMPLETE) %s: Shutdown complete
1080 SQLSTATE: 08S01 (ER_FORCING_CLOSE) %s: Forcing close of thread %ld user: ‘%s’
1081 SQLSTATE: 08S01 (ER_IPSOCK_ERROR) Can’t create IP socket
1082 SQLSTATE: 42S12 (ER_NO_SUCH_INDEX) Table ‘%s’ has no index like the one used in CREATE INDEX; recreate the table
1083 SQLSTATE: 42000 (ER_WRONG_FIELD_TERMINATORS) Field separator argument is not what is expected; check the manual
1084 SQLSTATE: 42000 (ER_BLOBS_AND_NO_TERMINATED) You can’t use fixed rowlength with BLOBs; please use ‘fields terminated by’
1085 SQLSTATE: HY000 (ER_TEXTFILE_NOT_READABLE) The file ‘%s’ must be in the database directory or be readable by all
1086 SQLSTATE: HY000 (ER_FILE_EXISTS_ERROR) File ‘%s’ already exists
1087 SQLSTATE: HY000 (ER_LOAD_INFO) Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld
1088 SQLSTATE: HY000 (ER_ALTER_INFO) Records: %ld Duplicates: %ld
1089 SQLSTATE: HY000 (ER_WRONG_SUB_KEY) Incorrect sub part 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 sub keys
1090 SQLSTATE: 42000 (ER_CANT_REMOVE_ALL_FIELDS) You can’t delete all columns with ALTER TABLE; use DROP TABLE instead
1091 SQLSTATE: 42000 (ER_CANT_DROP_FIELD_OR_KEY) Can’t DROP ‘%s'; check that column/key exists
1092 SQLSTATE: HY000 (ER_INSERT_INFO) Records: %ld Duplicates: %ld Warnings: %ld
1093 SQLSTATE: HY000 (ER_UPDATE_TABLE_USED) You can’t specify target table ‘%s’ for update in FROM clause
1094 SQLSTATE: HY000 (ER_NO_SUCH_THREAD) Unknown thread id: %lu
1095 SQLSTATE: HY000 (ER_KILL_DENIED_ERROR) You are not owner of thread %lu
1096 SQLSTATE: HY000 (ER_NO_TABLES_USED) No tables used
1097 SQLSTATE: HY000 (ER_TOO_BIG_SET) Too many strings for column %s and SET
1098 SQLSTATE: HY000 (ER_NO_UNIQUE_LOGFILE) Can’t generate a unique log-filename %s.(1-999)
1099 SQLSTATE: HY000 (ER_TABLE_NOT_LOCKED_FOR_WRITE) Table ‘%s’ was locked with a READ lock and can’t be updated
1100 SQLSTATE: HY000 (ER_TABLE_NOT_LOCKED) Table ‘%s’ was not locked with LOCK TABLES
1101 SQLSTATE: 42000 (ER_BLOB_CANT_HAVE_DEFAULT) BLOB/TEXT column ‘%s’ can’t have a default value
1102 SQLSTATE: 42000 (ER_WRONG_DB_NAME) Incorrect database name ‘%s’
1103 SQLSTATE: 42000 (ER_WRONG_TABLE_NAME) Incorrect table name ‘%s’
1104 SQLSTATE: 42000 (ER_TOO_BIG_SELECT) The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
1105 SQLSTATE: HY000 (ER_UNKNOWN_ERROR) Unknown error
1106 SQLSTATE: 42000 (ER_UNKNOWN_PROCEDURE) Unknown procedure ‘%s’
1107 SQLSTATE: 42000 (ER_WRONG_PARAMCOUNT_TO_PROCEDURE) Incorrect parameter count to procedure ‘%s’
1108 SQLSTATE: HY000 (ER_WRONG_PARAMETERS_TO_PROCEDURE) Incorrect parameters to procedure ‘%s’
1109 SQLSTATE: 42S02 (ER_UNKNOWN_TABLE) Unknown table ‘%s’ in %s
1110 SQLSTATE: 42000 (ER_FIELD_SPECIFIED_TWICE) Column ‘%s’ specified twice
1111 SQLSTATE: HY000 (ER_INVALID_GROUP_FUNC_USE) Invalid use of group function
1112 SQLSTATE: 42000 (ER_UNSUPPORTED_EXTENSION) Table ‘%s’ uses an extension that doesn’t exist in this MySQL version
1113 SQLSTATE: 42000 (ER_TABLE_MUST_HAVE_COLUMNS) A table must have at least 1 column
1114 SQLSTATE: HY000 (ER_RECORD_FILE_FULL) The table ‘%s’ is full
1115 SQLSTATE: 42000 (ER_UNKNOWN_CHARACTER_SET) Unknown character set: ‘%s’
1116 SQLSTATE: HY000 (ER_TOO_MANY_TABLES) Too many tables; MySQL can only use %d tables in a join
1117 SQLSTATE: HY000 (ER_TOO_MANY_FIELDS) Too many columns
1118 SQLSTATE: 42000 (ER_TOO_BIG_ROWSIZE) Row size too large. The maximum row size for the used table type, not counting BLOBs, is %ld. You have to change some columns to TEXT or BLOBs
1119 SQLSTATE: HY000 (ER_STACK_OVERRUN) Thread stack overrun: Used: %ld of a %ld stack. Use ‘mysqld -O thread_stack=#’ to specify a bigger stack if needed
1120 SQLSTATE: 42000 (ER_WRONG_OUTER_JOIN) Cross dependency found in OUTER JOIN; examine your ON conditions
1121 SQLSTATE: 42000 (ER_NULL_COLUMN_IN_INDEX) Column ‘%s’ is used with UNIQUE or INDEX but is not defined as NOT NULL
1122 SQLSTATE: HY000 (ER_CANT_FIND_UDF) Can’t load function ‘%s’
1123 SQLSTATE: HY000 (ER_CANT_INITIALIZE_UDF) Can’t initialize function ‘%s'; %s
1124 SQLSTATE: HY000 (ER_UDF_NO_PATHS) No paths allowed for shared library
1125 SQLSTATE: HY000 (ER_UDF_EXISTS) Function ‘%s’ already exists
1126 SQLSTATE: HY000 (ER_CANT_OPEN_LIBRARY) Can’t open shared library ‘%s’ (errno: %d %s)
1127 SQLSTATE: HY000 (ER_CANT_FIND_DL_ENTRY) Can’t find function ‘%s’ in library’
1128 SQLSTATE: HY000 (ER_FUNCTION_NOT_DEFINED) Function ‘%s’ is not defined
1129 SQLSTATE: HY000 (ER_HOST_IS_BLOCKED) Host ‘%s’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’
1130 SQLSTATE: HY000 (ER_HOST_NOT_PRIVILEGED) Host ‘%s’ is not allowed to connect to this MySQL server
1131 SQLSTATE: 42000 (ER_PASSWORD_ANONYMOUS_USER) You are using MySQL as an anonymous user and anonymous users are not allowed to change passwords
1132 SQLSTATE: 42000 (ER_PASSWORD_NOT_ALLOWED) You must have privileges to update tables in the mysql database to be able to change passwords for others
1133 SQLSTATE: 42000 (ER_PASSWORD_NO_MATCH) Can’t find any matching row in the user table
1134 SQLSTATE: HY000 (ER_UPDATE_INFO) Rows matched: %ld Changed: %ld Warnings: %ld
1135 SQLSTATE: HY000 (ER_CANT_CREATE_THREAD) Can’t create a new thread (errno %d); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug
1136 SQLSTATE: 21S01 (ER_WRONG_VALUE_COUNT_ON_ROW) Column count doesn’t match value count at row %ld
1137 SQLSTATE: HY000 (ER_CANT_REOPEN_TABLE) Can’t reopen table: ‘%s’
1138 SQLSTATE: 42000 (ER_INVALID_USE_OF_NULL) Invalid use of NULL value
1139 SQLSTATE: 42000 (ER_REGEXP_ERROR) Got error ‘%s’ from regexp
1140 SQLSTATE: 42000 (ER_MIX_OF_GROUP_FUNC_AND_FIELDS) Mixing of GROUP columns (MIN(),MAX(),COUNT(),…) with no GROUP columns is illegal if there is no GROUP BY clause
1141 SQLSTATE: 42000 (ER_NONEXISTING_GRANT) There is no such grant defined for user ‘%s’ on host ‘%s’
1142 SQLSTATE: 42000 (ER_TABLEACCESS_DENIED_ERROR) %s command denied to user ‘%s’@’%s’ for table ‘%s’
1143 SQLSTATE: 42000 (ER_COLUMNACCESS_DENIED_ERROR) %s command denied to user ‘%s’@’%s’ for column ‘%s’ in table ‘%s’
1144 SQLSTATE: 42000 (ER_ILLEGAL_GRANT_FOR_TABLE) Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used
1145 SQLSTATE: 42000 (ER_GRANT_WRONG_HOST_OR_USER) The host or user argument to GRANT is too long
1146 SQLSTATE: 42S02 (ER_NO_SUCH_TABLE) Table ‘%s.%s’ doesn’t exist
1147 SQLSTATE: 42000 (ER_NONEXISTING_TABLE_GRANT) There is no such grant defined for user ‘%s’ on host ‘%s’ on table ‘%s’
1148 SQLSTATE: 42000 (ER_NOT_ALLOWED_COMMAND) The used command is not allowed with this MySQL version
1149 SQLSTATE: 42000 (ER_SYNTAX_ERROR) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use
1150 SQLSTATE: HY000 (ER_DELAYED_CANT_CHANGE_LOCK) Delayed insert thread couldn’t get requested lock for table %s
1151 SQLSTATE: HY000 (ER_TOO_MANY_DELAYED_THREADS) Too many delayed threads in use
1152 SQLSTATE: 08S01 (ER_ABORTING_CONNECTION) Aborted connection %ld to db: ‘%s’ user: ‘%s’ (%s)
1153 SQLSTATE: 08S01 (ER_NET_PACKET_TOO_LARGE) Got a packet bigger than ‘max_allowed_packet’ bytes
1154 SQLSTATE: 08S01 (ER_NET_READ_ERROR_FROM_PIPE) Got a read error from the connection pipe
1155 SQLSTATE: 08S01 (ER_NET_FCNTL_ERROR) Got an error from fcntl()
1156 SQLSTATE: 08S01 (ER_NET_PACKETS_OUT_OF_ORDER) Got packets out of order
1157 SQLSTATE: 08S01 (ER_NET_UNCOMPRESS_ERROR) Couldn’t uncompress communication packet
1158 SQLSTATE: 08S01 (ER_NET_READ_ERROR) Got an error reading communication packets
1159 SQLSTATE: 08S01 (ER_NET_READ_INTERRUPTED) Got timeout reading communication packets
1160 SQLSTATE: 08S01 (ER_NET_ERROR_ON_WRITE) Got an error writing communication packets
1161 SQLSTATE: 08S01 (ER_NET_WRITE_INTERRUPTED) Got timeout writing communication packets
1162 SQLSTATE: 42000 (ER_TOO_LONG_STRING) Result string is longer than ‘max_allowed_packet’ bytes
1163 SQLSTATE: 42000 (ER_TABLE_CANT_HANDLE_BLOB) The used table type doesn’t support BLOB/TEXT columns
1164 SQLSTATE: 42000 (ER_TABLE_CANT_HANDLE_AUTO_INCREMENT) The used table type doesn’t support AUTO_INCREMENT columns
1165 SQLSTATE: HY000 (ER_DELAYED_INSERT_TABLE_LOCKED) INSERT DELAYED can’t be used with table ‘%s’ because it is locked with LOCK TABLES
1166 SQLSTATE: 42000 (ER_WRONG_COLUMN_NAME) Incorrect column name ‘%s’
1167 SQLSTATE: 42000 (ER_WRONG_KEY_COLUMN) The used storage engine can’t index column ‘%s’
1168 SQLSTATE: HY000 (ER_WRONG_MRG_TABLE) All tables in the MERGE table are not identically defined
1169 SQLSTATE: 23000 (ER_DUP_UNIQUE) Can’t write, because of unique constraint, to table ‘%s’
1170 SQLSTATE: 42000 (ER_BLOB_KEY_WITHOUT_LENGTH) BLOB/TEXT column ‘%s’ used in key specification without a key length
1171 SQLSTATE: 42000 (ER_PRIMARY_CANT_HAVE_NULL) All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
1172 SQLSTATE: 42000 (ER_TOO_MANY_ROWS) Result consisted of more than one row
1173 SQLSTATE: 42000 (ER_REQUIRES_PRIMARY_KEY) This table type requires a primary key
1174 SQLSTATE: HY000 (ER_NO_RAID_COMPILED) This version of MySQL is not compiled with RAID support
1175 SQLSTATE: HY000 (ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE) You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
1176 SQLSTATE: HY000 (ER_KEY_DOES_NOT_EXITS) Key ‘%s’ doesn’t exist in table ‘%s’
1177 SQLSTATE: 42000 (ER_CHECK_NO_SUCH_TABLE) Can’t open table
1178 SQLSTATE: 42000 (ER_CHECK_NOT_IMPLEMENTED) The storage engine for the table doesn’t support %s
1179 SQLSTATE: 25000 (ER_CANT_DO_THIS_DURING_AN_TRANSACTION) You are not allowed to execute this command in a transaction
1180 SQLSTATE: HY000 (ER_ERROR_DURING_COMMIT) Got error %d during COMMIT
1181 SQLSTATE: HY000 (ER_ERROR_DURING_ROLLBACK) Got error %d during ROLLBACK
1182 SQLSTATE: HY000 (ER_ERROR_DURING_FLUSH_LOGS) Got error %d during FLUSH_LOGS
1183 SQLSTATE: HY000 (ER_ERROR_DURING_CHECKPOINT) Got error %d during CHECKPOINT
1184 SQLSTATE: 08S01 (ER_NEW_ABORTING_CONNECTION) Aborted connection %ld to db: ‘%s’ user: ‘%s’ host: `%s’ (%s)
1185 SQLSTATE: HY000 (ER_DUMP_NOT_IMPLEMENTED) The storage engine for the table does not support binary table dump
1186 SQLSTATE: HY000 (ER_FLUSH_MASTER_BINLOG_CLOSED) Binlog closed, cannot RESET MASTER
1187 SQLSTATE: HY000 (ER_INDEX_REBUILD) Failed rebuilding the index of dumped table ‘%s’
1188 SQLSTATE: HY000 (ER_MASTER) Error from master: ‘%s’
1189 SQLSTATE: 08S01 (ER_MASTER_NET_READ) Net error reading from master
1190 SQLSTATE: 08S01 (ER_MASTER_NET_WRITE) Net error writing to master
1191 SQLSTATE: HY000 (ER_FT_MATCHING_KEY_NOT_FOUND) Can’t find FULLTEXT index matching the column list
1192 SQLSTATE: HY000 (ER_LOCK_OR_ACTIVE_TRANSACTION) Can’t execute the given command because you have active locked tables or an active transaction
1193 SQLSTATE: HY000 (ER_UNKNOWN_SYSTEM_VARIABLE) Unknown system variable ‘%s’
1194 SQLSTATE: HY000 (ER_CRASHED_ON_USAGE) Table ‘%s’ is marked as crashed and should be repaired
1195 SQLSTATE: HY000 (ER_CRASHED_ON_REPAIR) Table ‘%s’ is marked as crashed and last (automatic?) repair failed
1196 SQLSTATE: HY000 (ER_WARNING_NOT_COMPLETE_ROLLBACK) Some non-transactional changed tables couldn’t be rolled back
1197 SQLSTATE: HY000 (ER_TRANS_CACHE_FULL) Multi-statement transaction required more than ‘max_binlog_cache_size’ bytes of storage; increase this mysqld variable and try again
1198 SQLSTATE: HY000 (ER_SLAVE_MUST_STOP) This operation cannot be performed with a running slave; run STOP SLAVE first
1199 SQLSTATE: HY000 (ER_SLAVE_NOT_RUNNING) This operation requires a running slave; configure slave and do START SLAVE
1200 SQLSTATE: HY000 (ER_BAD_SLAVE) The server is not configured as slave; fix in config file or with CHANGE MASTER TO
1201 SQLSTATE: HY000 (ER_MASTER_INFO) Could not initialize master info structure; more error messages can be found in the MySQL error log
1202 SQLSTATE: HY000 (ER_SLAVE_THREAD) Could not create slave thread; check system resources
1203 SQLSTATE: 42000 (ER_TOO_MANY_USER_CONNECTIONS) User %s has already more than ‘max_user_connections’ active connections
1204 SQLSTATE: HY000 (ER_SET_CONSTANTS_ONLY) You may only use constant expressions with SET
1205 SQLSTATE: HY000 (ER_LOCK_WAIT_TIMEOUT) Lock wait timeout exceeded; try restarting transaction
1206 SQLSTATE: HY000 (ER_LOCK_TABLE_FULL) The total number of locks exceeds the lock table size
1207 SQLSTATE: 25000 (ER_READ_ONLY_TRANSACTION) Update locks cannot be acquired during a READ UNCOMMITTED transaction
1208 SQLSTATE: HY000 (ER_DROP_DB_WITH_READ_LOCK) DROP DATABASE not allowed while thread is holding global read lock
1209 SQLSTATE: HY000 (ER_CREATE_DB_WITH_READ_LOCK) CREATE DATABASE not allowed while thread is holding global read lock
1210 SQLSTATE: HY000 (ER_WRONG_ARGUMENTS) Incorrect arguments to %s
1211 SQLSTATE: 42000 (ER_NO_PERMISSION_TO_CREATE_USER) ‘%s’@’%s’ is not allowed to create new users
1212 SQLSTATE: HY000 (ER_UNION_TABLES_IN_DIFFERENT_DIR) Incorrect table definition; all MERGE tables must be in the same database
1213 SQLSTATE: 40001 (ER_LOCK_DEADLOCK) Deadlock found when trying to get lock; try restarting transaction
1214 SQLSTATE: HY000 (ER_TABLE_CANT_HANDLE_FT) The used table type doesn’t support FULLTEXT indexes
1215 SQLSTATE: HY000 (ER_CANNOT_ADD_FOREIGN) Cannot add foreign key constraint
1216 SQLSTATE: 23000 (ER_NO_REFERENCED_ROW) Cannot add or update a child row: a foreign key constraint fails
1217 SQLSTATE: 23000 (ER_ROW_IS_REFERENCED) Cannot delete or update a parent row: a foreign key constraint fails
1218 SQLSTATE: 08S01 (ER_CONNECT_TO_MASTER) Error connecting to master: %s
1219 SQLSTATE: HY000 (ER_QUERY_ON_MASTER) Error running query on master: %s
1220 SQLSTATE: HY000 (ER_ERROR_WHEN_EXECUTING_COMMAND) Error when executing command %s: %s
1221 SQLSTATE: HY000 (ER_WRONG_USAGE) Incorrect usage of %s and %s
1222 SQLSTATE: 21000 (ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT) The used SELECT statements have a different number of columns
1223 SQLSTATE: HY000 (ER_CANT_UPDATE_WITH_READLOCK) Can’t execute the query because you have a conflicting read lock
1224 SQLSTATE: HY000 (ER_MIXING_NOT_ALLOWED) Mixing of transactional and non-transactional tables is disabled
1225 SQLSTATE: HY000 (ER_DUP_ARGUMENT) Option ‘%s’ used twice in statement
1226 SQLSTATE: 42000 (ER_USER_LIMIT_REACHED) User ‘%s’ has exceeded the ‘%s’ resource (current value: %ld)
1227 SQLSTATE: HY000 (ER_SPECIFIC_ACCESS_DENIED_ERROR) Access denied; you need the %s privilege for this operation
1228 SQLSTATE: HY000 (ER_LOCAL_VARIABLE) Variable ‘%s’ is a SESSION variable and can’t be used with SET GLOBAL
1229 SQLSTATE: HY000 (ER_GLOBAL_VARIABLE) Variable ‘%s’ is a GLOBAL variable and should be set with SET GLOBAL
1230 SQLSTATE: 42000 (ER_NO_DEFAULT) Variable ‘%s’ doesn’t have a default value
1231 SQLSTATE: 42000 (ER_WRONG_VALUE_FOR_VAR) Variable ‘%s’ can’t be set to the value of ‘%s’
1232 SQLSTATE: 42000 (ER_WRONG_TYPE_FOR_VAR) Incorrect argument type to variable ‘%s’
1233 SQLSTATE: HY000 (ER_VAR_CANT_BE_READ) Variable ‘%s’ can only be set, not read
1234 SQLSTATE: 42000 (ER_CANT_USE_OPTION_HERE) Incorrect usage/placement of ‘%s’
1235 SQLSTATE: 42000 (ER_NOT_SUPPORTED_YET) This version of MySQL doesn’t yet support ‘%s’
1236 SQLSTATE: HY000 (ER_MASTER_FATAL_ERROR_READING_BINLOG) Got fatal error %d: ‘%s’ from master when reading data from binary log
1237 SQLSTATE: HY000 (ER_SLAVE_IGNORED_TABLE) Slave SQL thread ignored the query because of replicate-*-table rules
1238 SQLSTATE: HY000 (ER_INCORRECT_GLOBAL_LOCAL_VAR) Variable ‘%s’ is a %s variable
1239 SQLSTATE: 42000 (ER_WRONG_FK_DEF) Incorrect foreign key definition for ‘%s': %s
1240 SQLSTATE: HY000 (ER_KEY_REF_DO_NOT_MATCH_TABLE_REF) Key reference and table reference don’t match
1241 SQLSTATE: 21000 (ER_OPERAND_COLUMNS) Operand should contain %d column(s)
1242 SQLSTATE: 21000 (ER_SUBQUERY_NO_1_ROW) Subquery returns more than 1 row
1243 SQLSTATE: HY000 (ER_UNKNOWN_STMT_HANDLER) Unknown prepared statement handler (%.*s) given to %s
1244 SQLSTATE: HY000 (ER_CORRUPT_HELP_DB) Help database is corrupt or does not exist
1245 SQLSTATE: HY000 (ER_CYCLIC_REFERENCE) Cyclic reference on subqueries
1246 SQLSTATE: HY000 (ER_AUTO_CONVERT) Converting column ‘%s’ from %s to %s
1247 SQLSTATE: 42S22 (ER_ILLEGAL_REFERENCE) Reference ‘%s’ not supported (%s)
1248 SQLSTATE: 42000 (ER_DERIVED_MUST_HAVE_ALIAS) Every derived table must have its own alias
1249 SQLSTATE: 01000 (ER_SELECT_REDUCED) Select %u was reduced during optimization
1250 SQLSTATE: 42000 (ER_TABLENAME_NOT_ALLOWED_HERE) Table ‘%s’ from one of the SELECTs cannot be used in %s
1251 SQLSTATE: 08004 (ER_NOT_SUPPORTED_AUTH_MODE) Client does not support authentication protocol requested by server; consider upgrading MySQL client
1252 SQLSTATE: 42000 (ER_SPATIAL_CANT_HAVE_NULL) All parts of a SPATIAL index must be NOT NULL
1253 SQLSTATE: 42000 (ER_COLLATION_CHARSET_MISMATCH) COLLATION ‘%s’ is not valid for CHARACTER SET ‘%s’
1254 SQLSTATE: HY000 (ER_SLAVE_WAS_RUNNING) Slave is already running
1255 SQLSTATE: HY000 (ER_SLAVE_WAS_NOT_RUNNING) Slave has already been stopped
1256 SQLSTATE: HY000 (ER_TOO_BIG_FOR_UNCOMPRESS) Uncompressed data size too large; the maximum size is %d (probably, length of uncompressed data was corrupted)
1257 SQLSTATE: HY000 (ER_ZLIB_Z_MEM_ERROR) ZLIB: Not enough memory
1258 SQLSTATE: HY000 (ER_ZLIB_Z_BUF_ERROR) ZLIB: Not enough room in the output buffer (probably, length of uncompressed data was corrupted)
1259 SQLSTATE: HY000 (ER_ZLIB_Z_DATA_ERROR) ZLIB: Input data corrupted
1260 SQLSTATE: HY000 (ER_CUT_VALUE_GROUP_CONCAT) %d line(s) were cut by GROUP_CONCAT()
1261 SQLSTATE: 01000 (ER_WARN_TOO_FEW_RECORDS) Row %ld doesn’t contain data for all columns
1262 SQLSTATE: 01000 (ER_WARN_TOO_MANY_RECORDS) Row %ld was truncated; it contained more data than there were input columns
1263 SQLSTATE: 01000 (ER_WARN_NULL_TO_NOTNULL) Data truncated; NULL supplied to NOT NULL column ‘%s’ at row %ld
1264 SQLSTATE: 01000 (ER_WARN_DATA_OUT_OF_RANGE) Data truncated; out of range for column ‘%s’ at row %ld
1265 SQLSTATE: 01000 (ER_WARN_DATA_TRUNCATED) Data truncated for column ‘%s’ at row %ld
1266 SQLSTATE: HY000 (ER_WARN_USING_OTHER_HANDLER) Using storage engine %s for table ‘%s’
1267 SQLSTATE: HY000 (ER_CANT_AGGREGATE_2COLLATIONS) Illegal mix of collations (%s,%s) and (%s,%s) for operation ‘%s’
1268 SQLSTATE: HY000 (ER_DROP_USER) Can’t drop one or more of the requested users
1269 SQLSTATE: HY000 (ER_REVOKE_GRANTS) Can’t revoke all privileges, grant for one or more of the requested users
1270 SQLSTATE: HY000 (ER_CANT_AGGREGATE_3COLLATIONS) Illegal mix of collations (%s,%s), (%s,%s), (%s,%s) for operation ‘%s’
1271 SQLSTATE: HY000 (ER_CANT_AGGREGATE_NCOLLATIONS) Illegal mix of collations for operation ‘%s’
1272 SQLSTATE: HY000 (ER_VARIABLE_IS_NOT_STRUCT) Variable ‘%s’ is not a variable component (can’t be used as XXXX.variable_name)
1273 SQLSTATE: HY000 (ER_UNKNOWN_COLLATION) Unknown collation: ‘%s’
1274 SQLSTATE: HY000 (ER_SLAVE_IGNORED_SSL_PARAMS) 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
1275 SQLSTATE: HY000 (ER_SERVER_IS_IN_SECURE_AUTH_MODE) Server is running in –secure-auth mode, but ‘%s’@’%s’ has a password in the old format; please change the password to the new format
1276 SQLSTATE: HY000 (ER_WARN_FIELD_RESOLVED) Field or reference ‘%s%s%s%s%s’ of SELECT #%d was resolved in SELECT #%d
1277 SQLSTATE: HY000 (ER_BAD_SLAVE_UNTIL_COND) Incorrect parameter or combination of parameters for START SLAVE UNTIL
1278 SQLSTATE: HY000 (ER_MISSING_SKIP_SLAVE) It is recommended to use –skip-slave-start when doing step-by-step replication with START SLAVE UNTIL; otherwise, you will get problems if you get an unexpected slave’s mysqld restart
1279 SQLSTATE: HY000 (ER_UNTIL_COND_IGNORED) SQL thread is not to be started so UNTIL options are ignored
1280 SQLSTATE: 42000 (ER_WRONG_NAME_FOR_INDEX) Incorrect index name ‘%s’
1281 SQLSTATE: 42000 (ER_WRONG_NAME_FOR_CATALOG) Incorrect catalog name ‘%s’
1282 SQLSTATE: HY000 (ER_WARN_QC_RESIZE) Query cache failed to set size %lu; new query cache size is %lu
1283 SQLSTATE: HY000 (ER_BAD_FT_COLUMN) Column ‘%s’ cannot be part of FULLTEXT index
1284 SQLSTATE: HY000 (ER_UNKNOWN_KEY_CACHE) Unknown key cache ‘%s’
1285 SQLSTATE: HY000 (ER_WARN_HOSTNAME_WONT_WORK) MySQL is started in –skip-name-resolve mode; you must restart it without this switch for this grant to work
1286 SQLSTATE: 42000 (ER_UNKNOWN_STORAGE_ENGINE) Unknown table engine ‘%s’
1287 SQLSTATE: HY000 (ER_WARN_DEPRECATED_SYNTAX) ‘%s’ is deprecated; use ‘%s’ instead
1288 SQLSTATE: HY000 (ER_NON_UPDATABLE_TABLE) The target table %s of the %s is not updatable
1289 SQLSTATE: HY000 (ER_FEATURE_DISABLED) The ‘%s’ feature is disabled; you need MySQL built with ‘%s’ to have it working
1290 SQLSTATE: HY000 (ER_OPTION_PREVENTS_STATEMENT) The MySQL server is running with the %s option so it cannot execute this statement
1291 SQLSTATE: HY000 (ER_DUPLICATED_VALUE_IN_TYPE) Column ‘%s’ has duplicated value ‘%s’ in %s
1292 SQLSTATE: HY000 (ER_TRUNCATED_WRONG_VALUE) Truncated incorrect %s value: ‘%s’
1293 SQLSTATE: HY000 (ER_TOO_MUCH_AUTO_TIMESTAMP_COLS) Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
1294 SQLSTATE: HY000 (ER_INVALID_ON_UPDATE) Invalid ON UPDATE clause for ‘%s’ column
1295 SQLSTATE: HY000 (ER_UNSUPPORTED_PS) This command is not supported in the prepared statement protocol yet
1296 SQLSTATE: HY000 (ER_GET_ERRMSG) Got error %d ‘%s’ from %s
1297 SQLSTATE: HY000 (ER_GET_TEMPORARY_ERRMSG) Got temporary error %d ‘%s’ from %s
1298 SQLSTATE: HY000 (ER_UNKNOWN_TIME_ZONE) Unknown or incorrect time zone: ‘%s’
1299 SQLSTATE: HY000 (ER_WARN_INVALID_TIMESTAMP) Invalid TIMESTAMP value in column ‘%s’ at row %ld
1300 SQLSTATE: HY000 (ER_INVALID_CHARACTER_STRING) Invalid %s character string: ‘%s’
1301 SQLSTATE: HY000 (ER_WARN_ALLOWED_PACKET_OVERFLOWED) Result of %s() was larger than max_allowed_packet (%d) – truncated
1302 SQLSTATE: 2F003 (ER_SP_NO_RECURSIVE_CREATE) Can’t create a %s from within another stored routine
1303 SQLSTATE: 42000 (ER_SP_ALREADY_EXISTS) %s %s already exists
1304 SQLSTATE: 42000 (ER_SP_DOES_NOT_EXIST) %s %s does not exist
1305 SQLSTATE: HY000 (ER_SP_DROP_FAILED) Failed to DROP %s %s
1306 SQLSTATE: HY000 (ER_SP_STORE_FAILED) Failed to CREATE %s %s
1307 SQLSTATE: 42000 (ER_SP_LILABEL_MISMATCH) %s with no matching label: %s
1308 SQLSTATE: 42000 (ER_SP_LABEL_REDEFINE) Redefining label %s
1309 SQLSTATE: 42000 (ER_SP_LABEL_MISMATCH) End-label %s without match
1310 SQLSTATE: 01000 (ER_SP_UNINIT_VAR) Referring to uninitialized variable %s
1311 SQLSTATE: 0A000 (ER_SP_BADSELECT) SELECT in a stored procedure must have INTO
1312 SQLSTATE: 42000 (ER_SP_BADRETURN) RETURN is only allowed in a FUNCTION
1313 SQLSTATE: 0A000 (ER_SP_BADSTATEMENT) Statements like SELECT, INSERT, UPDATE (and others) are not allowed in a FUNCTION
1314 SQLSTATE: 42000 (ER_UPDATE_LOG_DEPRECATED_IGNORED) The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been ignored
1315 SQLSTATE: 42000 (ER_UPDATE_LOG_DEPRECATED_TRANSLATED) The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been translated to SET SQL_LOG_BIN
1316 SQLSTATE: 70100 (ER_QUERY_INTERRUPTED) Query execution was interrupted
1317 SQLSTATE: 42000 (ER_SP_WRONG_NO_OF_ARGS) Incorrect number of arguments for %s %s; expected %u, got %u
1318 SQLSTATE: 42000 (ER_SP_COND_MISMATCH) Undefined CONDITION: %s
1319 SQLSTATE: 42000 (ER_SP_NORETURN) No RETURN found in FUNCTION %s
1320 SQLSTATE: 2F005 (ER_SP_NORETURNEND) FUNCTION %s ended without RETURN
1321 SQLSTATE: 42000 (ER_SP_BAD_CURSOR_QUERY) Cursor statement must be a SELECT
1322 SQLSTATE: 42000 (ER_SP_BAD_CURSOR_SELECT) Cursor SELECT must not have INTO
1323 SQLSTATE: 42000 (ER_SP_CURSOR_MISMATCH) Undefined CURSOR: %s
1324 SQLSTATE: 24000 (ER_SP_CURSOR_ALREADY_OPEN) Cursor is already open
1325 SQLSTATE: 24000 (ER_SP_CURSOR_NOT_OPEN) Cursor is not open
1326 SQLSTATE: 42000 (ER_SP_UNDECLARED_VAR) Undeclared variable: %s
1327 SQLSTATE: HY000 (ER_SP_WRONG_NO_OF_FETCH_ARGS) Incorrect number of FETCH variables
1328 SQLSTATE: 02000 (ER_SP_FETCH_NO_DATA) No data to FETCH
1329 SQLSTATE: 42000 (ER_SP_DUP_PARAM) Duplicate parameter: %s
1330 SQLSTATE: 42000 (ER_SP_DUP_VAR) Duplicate variable: %s
1331 SQLSTATE: 42000 (ER_SP_DUP_COND) Duplicate condition: %s
1332 SQLSTATE: 42000 (ER_SP_DUP_CURS) Duplicate cursor: %s
1333 SQLSTATE: HY000 (ER_SP_CANT_ALTER) Failed to ALTER %s %s
1334 SQLSTATE: 0A000 (ER_SP_SUBSELECT_NYI) Subselect value not supported
1335 SQLSTATE: 42000 (ER_SP_NO_USE) USE is not allowed in a stored procedure
1336 SQLSTATE: 42000 (ER_SP_VARCOND_AFTER_CURSHNDLR) Variable or condition declaration after cursor or handler declaration
1337 SQLSTATE: 42000 (ER_SP_CURSOR_AFTER_HANDLER) Cursor declaration after handler declaration
1338 SQLSTATE: 20000 (ER_SP_CASE_NOT_FOUND) Case not found for CASE statement
1339 SQLSTATE: HY000 (ER_FPARSER_TOO_BIG_FILE) Configuration file ‘%s’ is too big
1340 SQLSTATE: HY000 (ER_FPARSER_BAD_HEADER) Malformed file type header in file ‘%s’
1341 SQLSTATE: HY000 (ER_FPARSER_EOF_IN_COMMENT) Unexpected end of file while parsing comment ‘%s’
1342 SQLSTATE: HY000 (ER_FPARSER_ERROR_IN_PARAMETER) Error while parsing parameter ‘%s’ (line: ‘%s’)
1343 SQLSTATE: HY000 (ER_FPARSER_EOF_IN_UNKNOWN_PARAMETER) Unexpected end of file while skipping unknown parameter ‘%s’
1344 SQLSTATE: HY000 (ER_VIEW_NO_EXPLAIN) EXPLAIN/SHOW can not be issued; lacking privileges for underlying table
1345 SQLSTATE: HY000 (ER_FRM_UNKNOWN_TYPE) File ‘%s’ has unknown type ‘%s’ in its header
1346 SQLSTATE: HY000 (ER_WRONG_OBJECT) ‘%s.%s’ is not %s
1347 SQLSTATE: HY000 (ER_NONUPDATEABLE_COLUMN) Column ‘%s’ is not updatable
1348 SQLSTATE: HY000 (ER_VIEW_SELECT_DERIVED) View’s SELECT contains a subquery in the FROM clause
1349 SQLSTATE: HY000 (ER_VIEW_SELECT_PROCEDURE) View’s SELECT contains a PROCEDURE clause
1350 SQLSTATE: HY000 (ER_VIEW_SELECT_VARIABLE) View’s SELECT contains a variable or parameter
1351 SQLSTATE: HY000 (ER_VIEW_SELECT_TMPTABLE) View’s SELECT contains a temporary table ‘%s’
1352 SQLSTATE: HY000 (ER_VIEW_WRONG_LIST) View’s SELECT and view’s field list have different column counts
1353 SQLSTATE: HY000 (ER_WARN_VIEW_MERGE) View merge algorithm can’t be used here for now (assumed undefined algorithm)
1354 SQLSTATE: HY000 (ER_WARN_VIEW_WITHOUT_KEY) View being updated does not have complete key of underlying table in it
1355 SQLSTATE: HY000 (ER_VIEW_INVALID) View ‘%s.%s’ references invalid table(s) or column(s)
1356 SQLSTATE: HY000 (ER_SP_NO_DROP_SP) Can’t drop a %s from within another stored routine
1357 SQLSTATE: HY000 (ER_SP_GOTO_IN_HNDLR) GOTO is not allowed in a stored procedure handler
2000 (CR_UNKNOWN_ERROR) Unknown MySQL error
2001 (CR_SOCKET_CREATE_ERROR) Can’t create UNIX socket (%d)
2002 (CR_CONNECTION_ERROR) Can’t connect to local MySQL server through socket ‘%s’ (%d)
2003 (CR_CONN_HOST_ERROR) Can’t connect to MySQL server on ‘%s’ (%d)
2004 (CR_IPSOCK_ERROR) Can’t create TCP/IP socket (%d)
2005 (CR_UNKNOWN_HOST) Unknown MySQL server host ‘%s’ (%d)
2006 (CR_SERVER_GONE_ERROR) MySQL server has gone away
2007 (CR_VERSION_ERROR) Protocol mismatch; server version = %d, client version = %d
2008 (CR_OUT_OF_MEMORY) MySQL client ran out of memory
2009 (CR_WRONG_HOST_INFO) Wrong host info
2010 (CR_LOCALHOST_CONNECTION) Localhost via UNIX socket
2011 (CR_TCP_CONNECTION) %s via TCP/IP
2012 (CR_SERVER_HANDSHAKE_ERR) Error in server handshake
2013 (CR_SERVER_LOST) Lost connection to MySQL server during query
2014 (CR_COMMANDS_OUT_OF_SYNC) Commands out of sync; you can’t run this command now
2015 (CR_NAMEDPIPE_CONNECTION) %s via named pipe
2016 (CR_NAMEDPIPEWAIT_ERROR) Can’t wait for named pipe to host: %s pipe: %s (%lu)
2017 (CR_NAMEDPIPEOPEN_ERROR) Can’t open named pipe to host: %s pipe: %s (%lu)
2018 (CR_NAMEDPIPESETSTATE_ERROR) Can’t set state of named pipe to host: %s pipe: %s (%lu)
2019 (CR_CANT_READ_CHARSET) Can’t initialize character set %s (path: %s)
2020 (CR_NET_PACKET_TOO_LARGE) Got packet bigger than ‘max_allowed_packet’ bytes
2021 (CR_EMBEDDED_CONNECTION) Embedded server
2022 (CR_PROBE_SLAVE_STATUS) Error on SHOW SLAVE STATUS:
2023 (CR_PROBE_SLAVE_HOSTS) Error on SHOW SLAVE HOSTS:
2024 (CR_PROBE_SLAVE_CONNECT) Error connecting to slave:
2025 (CR_PROBE_MASTER_CONNECT) Error connecting to master:
2026 (CR_SSL_CONNECTION_ERROR) SSL connection error
2027 (CR_MALFORMED_PACKET) Malformed packet
2028 (CR_WRONG_LICENSE) This client library is licensed only for use with MySQL servers having ‘%s’ license
2029 (CR_NULL_POINTER) Invalid use of null pointer
2030 (CR_NO_PREPARE_STMT) Statement not prepared
2031 (CR_PARAMS_NOT_BOUND) No data supplied for parameters in prepared statement
2032 (CR_DATA_TRUNCATED) Data truncated
2033 (CR_NO_PARAMETERS_EXISTS) No parameters exist in the statement
2034 (CR_INVALID_PARAMETER_NO) Invalid parameter number
2035 (CR_INVALID_BUFFER_USE) Can’t send long data for non-string/non-binary data types (parameter: %d)
2036 (CR_UNSUPPORTED_PARAM_TYPE) Using unsupported buffer type: %d (parameter: %d)
2037 (CR_SHARED_MEMORY_CONNECTION) Shared memory (%lu)
2038 (CR_SHARED_MEMORY_CONNECT_REQUEST_ERROR) Can’t open shared memory; client could not create request event (%lu)
2039 (CR_SHARED_MEMORY_CONNECT_ANSWER_ERROR) Can’t open shared memory; no answer event received from server (%lu)
2040 (CR_SHARED_MEMORY_CONNECT_FILE_MAP_ERROR) Can’t open shared memory; server could not allocate file mapping (%lu)
2041 (CR_SHARED_MEMORY_CONNECT_MAP_ERROR) Can’t open shared memory; server could not get pointer to file mapping (%lu)
2042 (CR_SHARED_MEMORY_FILE_MAP_ERROR) Can’t open shared memory; client could not allocate file mapping (%lu)
2043 (CR_SHARED_MEMORY_MAP_ERROR) Can’t open shared memory; client could not get pointer to file mapping (%lu)
2044 (CR_SHARED_MEMORY_EVENT_ERROR) Can’t open shared memory; client could not create %s event (%lu)
2045 (CR_SHARED_MEMORY_CONNECT_ABANDONED_ERROR) Can’t open shared memory; no answer from server (%lu)
2046 (CR_SHARED_MEMORY_CONNECT_SET_ERROR) Can’t open shared memory; cannot send request event to server (%lu)
2047 (CR_CONN_UNKNOW_PROTOCOL) Wrong or unknown protocol
2048 (CR_INVALID_CONN_HANDLE) Invalid connection handle
2049 (CR_SECURE_AUTH) Connection using old (pre-4.1.1) authentication protocol refused (client option ‘secure_auth’ enabled)
2050 (CR_FETCH_CANCELED) Row retrieval was canceled by mysql_stmt_close() call
2051 (CR_NO_DATA) Attempt to read column without prior row fetch
Personal tools
Namespaces

Variants
Actions
Navigation
Toolbox