OS Errors





OS Errors OS Error Explanation









1 1 Operation not permitted

2 No such file or directory

3 No such process

4 Interrupted system call

5 Input/output error

6 No such device or address

7 Argument list too long

8 Exec format error

9 Bad file descriptor
10 10 No child processes

11 Resource temporarily unavailable

12 Cannot allocate memory

13 Permission denied

14 Bad address

15 Block device required

16 Device or resource busy

17 File exists

18 Invalid cross-device link

19 No such device
20 20 Not a directory

21 Is a directory

22 Invalid argument

23 Too many open files in system

24 Too many open files

25 Inappropriate ioctl for device

26 Text file busy

27 File too large

28 No space left on device

29 Illegal seek
30 30 Read-only file system

31 Too many links

32 Broken pipe

33 Numerical argument out of domain

34 Numerical result out of range

35 Resource deadlock avoided

36 File name too long

37 No locks available

38 Function not implemented

39 Directory not empty
40 40 Too many levels of symbolic links

41 Unknown error 41

42 No message of desired type

43 Identifier removed

44 Channel number out of range

45 Level 2 not synchronized

46 Level 3 halted

47 Level 3 reset

48 Link number out of range

49 Protocol driver not attached
50 50 No CSI structure available

51 Level 2 halted

52 Invalid exchange

53 Invalid request descriptor

54 Exchange full

55 No anode

56 Invalid request code

57 Invalid slot

58 Unknown error 58

59 Bad font file format
60 60 Device not a stream

61 No data available

62 Timer expired

63 Out of streams resources

64 Machine is not on the network

65 Package not installed

66 Object is remote

67 Link has been severed

68 Advertise error

69 Srmount error
70 70 Communication error on send

71 Protocol error

72 Multihop attempted

73 RFS specific error

74 Bad message

75 Value too large for defined data type

76 Name not unique on network

77 File descriptor in bad state

78 Remote address changed

79 Can not access a needed shared library
80 80 Accessing a corrupted shared library

81 .lib section in a.out corrupted

82 Attempting to link in too many shared

83 Cannot exec a shared library directly

84 Invalid or incomplete multibyte or wide character

85 Interrupted system call should be restarted

86 Streams pipe error

87 Too many users

88 Socket operation on non-socket

89 Destination address required
90 90 Message too long

91 Protocol wrong type for socket

92 Protocol not available

93 Protocol not supported

94 Socket type not supported

95 Operation not supported

96 Protocol family not supported

97 Address family not supported by protocol

98 Address already in use

99 Cannot assign requested address
100 100 Network is down

101 Network is unreachable

102 Network dropped connection on reset

103 Software caused connection abort

104 Connection reset by peer

105 No buffer space available

106 Transport endpoint is already connected

107 Transport endpoint is not connected

108 Cannot send after transport endpoint shutdown

109 Too many references: cannot splice
110 110 Connection timed out

111 Connection refused

112 Host is down

113 No route to host

114 Operation already in progress

115 Operation now in progress

116 Stale NFS file handle

117 Structure needs cleaning

118 Not a XENIX named type file

119 No XENIX semaphores available
120
















MyISAM Tables





MyISAM Table Errors MyISAM Table Error Explanation









120 120 Didnt find key on read or update / Is a named type file

121 Duplicate key on wriote or update/ Remote I/O error

122 Disk quota exceeded

123 No medium found / Someone has changed the row since it was read, Update with is recoverable

124 Wrong medium type / Wrong index given to function

125

126 Index file is crashed / Wrong file format

127 Record-file is crashed

128 Out of memory

129
130 130 Incorrect file format

131 Command not supported by database

132 Old database file

133 No record read before update

134 Record was already deleted

135 No more room in record file

136 No more room in Index file

137 No more records (read after end of file)

138 Unsupported extension used for table

139 Too big row >16 M
140 140 Wrong create options

141 Duplicate unique key or constraint on write or update

142 Unknokn character set used

143 Conflicting table definition between MERGE and mapped table

144 Table is rashed and last repair failed

145 Table was marked as crashed and should be repaired


















TST Tables





TST Table Errors TST Error Explanation







146 Lock timed out; Retry transaction

147 Lock table is full; Restart program with a larger locktable

148 Updates are not allowed under a read only transactions

149 Lock deadlock; Retry transaction
150 150 Foreign key constraint is incorrectly formed

151 Cannot add a child row

152 Cannot delete a parent row















MySQL Server





MySQL Server Errors Server Error Explanation









1000 ER_HASHCHK 1000 hashchk

ER_NISAMCHK 1001 isamchk

ER_NO 1002 NO

ER_YES 1003 YES

ER_CANT_CREATE_FILE 1004 Can't create file '%-.64s' (errno: %d)

ER_CANT_CREATE_TABLE 1005 Can't create table '%-.64s' (errno: %d)

ER_CANT_CREATE_DB 1006 Can't create database '%-.64s'. (errno: %d)

ER_DB_CREATE_EXISTS 1007 Can't create database '%-.64s'. Database exists

ER_DB_DROP_EXISTS 1008 Can't drop database '%-.64s'. Database doesn't exist

ER_DB_DROP_DELETE 1009 Error dropping database (can't delete '%-.64s', errno: %d)
1010 ER_DB_DROP_RMDIR 1010 Error dropping database (can't rmdir '%-.64s', errno: %d)

ER_CANT_DELETE_FILE 1011 Error on delete of '%-.64s' (errno: %d)

ER_CANT_FIND_SYSTEM_REC 1012 Can't read record in system table

ER_CANT_GET_STAT 1013 Can't get status of '%-.64s' (errno: %d)

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

ER_CANT_LOCK 1015 Can't lock file (errno: %d)

ER_CANT_OPEN_FILE 1016 Can't open file: '%-.64s'. (errno: %d)

ER_FILE_NOT_FOUND 1017 Can't find file: '%-.64s' (errno: %d)

ER_CANT_READ_DIR 1018 Can't read dir of '%-.64s' (errno: %d)

ER_CANT_SET_WD 1019 Can't change dir to '%-.64s' (errno: %d)
1020 ER_CHECKREAD 1020 Record has changed since last read in table '%-.64s'

ER_DISK_FULL 1021 Disk full (%s). Waiting for someone to free some space....

ER_DUP_KEY 1022 Can't write, duplicate key in table '%-.64s'

ER_ERROR_ON_CLOSE 1023 Error on close of '%-.64s' (errno: %d)

ER_ERROR_ON_READ 1024 Error reading file '%-.64s' (errno: %d)

ER_ERROR_ON_RENAME 1025 Error on rename of '%-.64s' to '%-.64s' (errno: %d)

ER_ERROR_ON_WRITE 1026 Error writing file '%-.64s' (errno: %d)

ER_FILE_USED 1027 %-.64s' is locked against change

ER_FILSORT_ABORT 1028 Sort aborted

ER_FORM_NOT_FOUND 1029 View '%-.64s' doesn't exist for '%-.64s'
1030 ER_GET_ERRNO 1030 Got error %d from table handler

ER_ILLEGAL_HA 1031 Table handler for '%-.64s' doesn't have this option

ER_KEY_NOT_FOUND 1032 Can't find record in '%-.64s'

ER_NOT_FORM_FILE 1033 Incorrect information in file: '%-.64s'

ER_NOT_KEYFILE 1034 Incorrect key file for table: '%-.64s'. Try to repair it

ER_OLD_KEYFILE 1035 Old key file for table '%-.64s'; Repair it!

ER_OPEN_AS_READONLY 1036 Table '%-.64s' is read only

ER_OUTOFMEMORY 1037 Out of memory. Restart daemon and try again (needed %d bytes)

ER_OUT_OF_SORTMEMORY 1038 Out of sort memory. Increase daemon sort buffer size

ER_UNEXPECTED_EOF 1039 Unexpected eof found when reading file '%-.64s' (errno: %d)
1040 ER_CON_COUNT_ERROR 1040 Too many connections

ER_OUT_OF_RESOURCES 1041 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

ER_BAD_HOST_ERROR 1042 Can't get hostname for your address

ER_HANDSHAKE_ERROR 1043 Bad handshake

ER_DBACCESS_DENIED_ERROR 1044 Access denied for user: '%-.32s@%-.64s' to database '%-.64s'

ER_ACCESS_DENIED_ERROR 1045 Access denied for user: '%-.32s@%-.64s' (Using password: %s)

ER_NO_DB_ERROR 1046 No Database Selected

ER_UNKNOWN_COM_ERROR 1047 Unknown command

ER_BAD_NULL_ERROR 1048 Column '%-.64s' cannot be null

ER_BAD_DB_ERROR 1049 Unknown database '%-.64s'
1050 ER_TABLE_EXISTS_ERROR 1050 Table '%-.64s' already exists

ER_BAD_TABLE_ERROR 1051 Unknown table '%-.64s'

ER_NON_UNIQ_ERROR 1052 Column: '%-.64s' in %-.64s is ambiguous

ER_SERVER_SHUTDOWN 1053 Server shutdown in progress

ER_BAD_FIELD_ERROR 1054 Unknown column '%-.64s' in '%-.64s'

ER_WRONG_FIELD_WITH_GROUP 1055 %-.64s' isn't in GROUP BY

ER_WRONG_GROUP_FIELD 1056 Can't group on '%-.64s'

ER_WRONG_SUM_SELECT 1057 Statement has sum functions and columns in same statement

ER_WRONG_VALUE_COUNT 1058 Column count doesn't match value count

ER_TOO_LONG_IDENT 1059 Identifier name '%-.100s' is too long
1060 ER_DUP_FIELDNAME 1060 Duplicate column name '%-.64s'

ER_DUP_KEYNAME 1061 Duplicate key name '%-.64s'

ER_DUP_ENTRY 1062 Duplicate entry '%-.64s' for key %d

ER_WRONG_FIELD_SPEC 1063 Incorrect column specifier for column '%-.64s'

ER_PARSE_ERROR 1064 %s near '%-.80s' at line %d

ER_EMPTY_QUERY 1065 Query was empty

ER_NONUNIQ_TABLE 1066 Not unique table/alias: '%-.64s'

ER_INVALID_DEFAULT 1067 Invalid default value for '%-.64s'

ER_MULTIPLE_PRI_KEY 1068 Multiple primary key defined

ER_TOO_MANY_KEYS 1069 Too many keys specified. Max %d keys allowed
1070 ER_TOO_MANY_KEY_PARTS 1070 Too many key parts specified. Max %d parts allowed

ER_TOO_LONG_KEY 1071 Specified key was too long. Max key length is %d

ER_KEY_COLUMN_DOES_NOT_EXITS 1072 Key column '%-.64s' doesn't exist in table

ER_BLOB_USED_AS_KEY 1073 BLOB column '%-.64s' can't be used in key specification with the used table type

ER_TOO_BIG_FIELDLENGTH 1074 Too big column length for column '%-.64s' (max = %d). Use BLOB instead

ER_WRONG_AUTO_KEY 1075 Incorrect table definition; There can only be one auto column and it must be defined as a key

ER_READY 1076 %s: ready for connections.\nVersion: '%s' socket: '%s' port: %d\n

ER_NORMAL_SHUTDOWN 1077 %s: Normal shutdown\n

ER_GOT_SIGNAL 1078 %s: Got signal %d. Aborting!\n

ER_SHUTDOWN_COMPLETE 1079 %s: Shutdown Complete\n
1080 ER_FORCING_CLOSE 1080 %s: Forcing close of thread %ld user: '%-.32s'\n

ER_IPSOCK_ERROR 1081 Can't create IP socket

ER_NO_SUCH_INDEX 1082 Table '%-.64s' has no index like the one used in CREATE INDEX. Recreate the table

ER_WRONG_FIELD_TERMINATORS 1083 Field separator argument is not what is expected. Check the manual

ER_BLOBS_AND_NO_TERMINATED 1084 You can't use fixed rowlength with BLOBs. Please use 'fields terminated by'.

ER_TEXTFILE_NOT_READABLE 1085 The file '%-.64s' must be in the database directory or be readable by all

ER_FILE_EXISTS_ERROR 1086 File '%-.80s' already exists

ER_LOAD_INFO 1087 Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld

ER_ALTER_INFO 1088 Records: %ld Duplicates: %ld

ER_WRONG_SUB_KEY 1089 Incorrect sub part key. The used key part isn't a string, the used length is longer than the key part or the table handler doesn't support unique sub keys
1090 ER_CANT_REMOVE_ALL_FIELDS 1090 You can't delete all columns with ALTER TABLE. Use DROP TABLE instead

ER_CANT_DROP_FIELD_OR_KEY 1091 Can't DROP '%-.64s'. Check that column/key exists

ER_INSERT_INFO 1092 Records: %ld Duplicates: %ld Warnings: %ld

ER_UPDATE_TABLE_USED 1093 You can't specify target table '%-.64s' for update in FROM clause

ER_NO_SUCH_THREAD 1094 Unknown thread id: %lu

ER_KILL_DENIED_ERROR 1095 You are not owner of thread %lu

ER_NO_TABLES_USED 1096 No tables used

ER_TOO_BIG_SET 1097 Too many strings for column %-.64s and SET

ER_NO_UNIQUE_LOGFILE 1098 Can't generate a unique log-filename %-.64s.(1-999)\n

ER_TABLE_NOT_LOCKED_FOR_WRITE 1099 Table '%-.64s' was locked with a READ lock and can't be updated
1100 ER_TABLE_NOT_LOCKED 1100 Table '%-.64s' was not locked with LOCK TABLES

ER_BLOB_CANT_HAVE_DEFAULT 1101 BLOB column '%-.64s' can't have a default value

ER_WRONG_DB_NAME 1102 Incorrect database name '%-.100s'

ER_WRONG_TABLE_NAME 1103 Incorrect table name '%-.100s'

ER_TOO_BIG_SELECT 1104 The SELECT would examine too many records and probably take a very long time. Check your WHERE and use SET OPTION SQL_BIG_SELECTS=1 if the SELECT is ok

ER_UNKNOWN_ERROR 1105 Unknown error

ER_UNKNOWN_PROCEDURE 1106 Unknown procedure '%-.64s'

ER_WRONG_PARAMCOUNT_TO_PROCEDURE 1107 Incorrect parameter count to procedure '%-.64s'

ER_WRONG_PARAMETERS_TO_PROCEDURE 1108 Incorrect parameters to procedure '%-.64s'

ER_UNKNOWN_TABLE 1109 Unknown table '%-.64s' in %-.32s
1110 ER_FIELD_SPECIFIED_TWICE 1110 Column '%-.64s' specified twice

ER_INVALID_GROUP_FUNC_USE 1111 Invalid use of group function

ER_UNSUPPORTED_EXTENSION 1112 Table '%-.64s' uses an extension that doesn't exist in this MySQL version

ER_TABLE_MUST_HAVE_COLUMNS 1113 A table must have at least 1 column

ER_RECORD_FILE_FULL 1114 The table '%-.64s' is full

ER_UNKNOWN_CHARACTER_SET 1115 Unknown character set: '%-.64s'

ER_TOO_MANY_TABLES 1116 Too many tables. MySQL can only use %d tables in a join

ER_TOO_MANY_FIELDS 1117 Too many columns

ER_TOO_BIG_ROWSIZE 1118 Too big row size. The maximum row size, not counting BLOBs, is %d. You have to change some fields to BLOBs

ER_STACK_OVERRUN 1119 Thread stack overrun: Used: %ld of a %ld stack. Use 'mysqld -O thread_stack=#' to specify a bigger stack if needed
1120 ER_WRONG_OUTER_JOIN 1120 Cross dependency found in OUTER JOIN. Examine your ON conditions

ER_NULL_COLUMN_IN_INDEX 1121 Column '%-.64s' is used with UNIQUE or INDEX but is not defined as NOT NULL

ER_CANT_FIND_UDF 1122 Can't load function '%-.64s'

ER_CANT_INITIALIZE_UDF 1123 Can't initialize function '%-.64s'; %-.80s

ER_UDF_NO_PATHS 1124 No paths allowed for shared library

ER_UDF_EXISTS 1125 Function '%-.64s' already exist

ER_CANT_OPEN_LIBRARY 1126 Can't open shared library '%-.64s' (errno: %d %-.64s)

ER_CANT_FIND_DL_ENTRY 1127 Can't find function '%-.64s' in library'

ER_FUNCTION_NOT_DEFINED 1128 Function '%-.64s' is not defined

ER_HOST_IS_BLOCKED 1129 Host '%-.64s' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'
1130 ER_HOST_NOT_PRIVILEGED 1130 Host '%-.64s' is not allowed to connect to this MySQL server

ER_PASSWORD_ANONYMOUS_USER 1131 You are using MySQL as an anonymous users and anonymous users are not allowed to change passwords

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

ER_PASSWORD_NO_MATCH 1133 Can't find any matching row in the user table

ER_UPDATE_INFO 1134 Rows matched: %ld Changed: %ld Warnings: %ld

ER_CANT_CREATE_THREAD 1135 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

ER_WRONG_VALUE_COUNT_ON_ROW 1136 Column count doesn't match value count at row %ld

ER_CANT_REOPEN_TABLE 1137 Can't reopen table: '%-.64s'

ER_INVALID_USE_OF_NULL 1138 Invalid use of NULL value

ER_REGEXP_ERROR 1139 Got error '%-.64s' from regexp
1140 ER_MIX_OF_GROUP_FUNC_AND_FIELDS 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if there is no GROUP BY clause

ER_NONEXISTING_GRANT 1141 There is no such grant defined for user '%-.32s' on host '%-.64s'

ER_TABLEACCESS_DENIED_ERROR 1142 %-.16s command denied to user: '%-.32s@%-.64s' for table '%-.64s'

ER_COLUMNACCESS_DENIED_ERROR 1143 %-.16s command denied to user: '%-.32s@%-.64s' for column '%-.64s' in table '%-.64s'

ER_ILLEGAL_GRANT_FOR_TABLE 1144 Illegal GRANT/REVOKE command. Please consult the manual which privileges can be used.

ER_GRANT_WRONG_HOST_OR_USER 1145 The host or user argument to GRANT is too long

ER_NO_SUCH_TABLE 1146 Table '%-.64s.%-.64s' doesn't exist

ER_NONEXISTING_TABLE_GRANT 1147 There is no such grant defined for user '%-.32s' on host '%-.64s' on table '%-.64s'

ER_NOT_ALLOWED_COMMAND 1148 The used command is not allowed with this MySQL version

ER_SYNTAX_ERROR 1149 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 ER_DELAYED_CANT_CHANGE_LOCK 1150 Delayed insert thread couldn't get requested lock for table %-.64s

ER_TOO_MANY_DELAYED_THREADS 1151 Too many delayed threads in use

ER_ABORTING_CONNECTION 1152 Aborted connection %ld to db: '%-.64s' user: '%-.32s' (%-.64s)

ER_NET_PACKET_TOO_LARGE 1153 Got a packet bigger than 'max_allowed_packet'

ER_NET_READ_ERROR_FROM_PIPE 1154 Got a read error from the connection pipe

ER_NET_FCNTL_ERROR 1155 Got an error from fcntl()

ER_NET_PACKETS_OUT_OF_ORDER 1156 Got packets out of order

ER_NET_UNCOMPRESS_ERROR 1157 Couldn't uncompress communication packet

ER_NET_READ_ERROR 1158 Got an error reading communication packets

ER_NET_READ_INTERRUPTED 1159 Got timeout reading communication packets
1160 ER_NET_ERROR_ON_WRITE 1160 Got an error writing communication packets

ER_NET_WRITE_INTERRUPTED 1161 Got timeout writing communication packets

ER_TOO_LONG_STRING 1162 Result string is longer than max_allowed_packet

ER_TABLE_CANT_HANDLE_BLOB 1163 The used table type doesn't support BLOB/TEXT columns

ER_TABLE_CANT_HANDLE_AUTO_INCREMENT 1164 The used table type doesn't support AUTO_INCREMENT columns

ER_DELAYED_INSERT_TABLE_LOCKED 1165 INSERT DELAYED can't be used with table '%-.64s' because it is locked with LOCK TABLES

ER_WRONG_COLUMN_NAME 1166 Incorrect column name '%-.100s'

ER_WRONG_KEY_COLUMN 1167 The used table handler can't index column '%-.64s'

ER_WRONG_MRG_TABLE 1168 All tables in the MERGE table are not identically defined

ER_DUP_UNIQUE 1169 Can't write, because of unique constraint, to table '%-.64s'
1170 ER_BLOB_KEY_WITHOUT_LENGTH 1170 BLOB column '%-.64s' used in key specification without a key length

ER_PRIMARY_CANT_HAVE_NULL 1171 All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead

ER_TOO_MANY_ROWS 1172 Result consisted of more than one row

ER_REQUIRES_PRIMARY_KEY 1173 This table type requires a primary key

ER_NO_RAID_COMPILED 1174 This version of MySQL is not compiled with RAID support

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

ER_KEY_DOES_NOT_EXITS 1176 Key '%-.64s' doesn't exist in table '%-.64s'

ER_CHECK_NO_SUCH_TABLE 1177 Can't open table

ER_CHECK_NOT_IMPLEMENTED 1178 The handler for the table doesn't support %s

ER_CANT_DO_THIS_DURING_AN_TRANSACTION 1179 You are not allowed to execute this command in a transaction
1180 ER_ERROR_DURING_COMMIT 1180 Got error %d during COMMIT

ER_ERROR_DURING_ROLLBACK 1181 Got error %d during ROLLBACK

ER_ERROR_DURING_FLUSH_LOGS 1182 Got error %d during FLUSH_LOGS

ER_ERROR_DURING_CHECKPOINT 1183 Got error %d during CHECKPOINT

ER_NEW_ABORTING_CONNECTION 1184 Aborted connection %ld to db: '%-.64s' user: '%-.32s' host: `%-.64s' (%-.64s)

ER_DUMP_NOT_IMPLEMENTED 1185 The handler for the table does not support binary table dump

ER_FLUSH_MASTER_BINLOG_CLOSED 1186 Binlog closed, cannot RESET MASTER

ER_INDEX_REBUILD 1187 Failed rebuilding the index of dumped table '%-.64s'

ER_MASTER 1188 Error from master: '%-.64s'

ER_MASTER_NET_READ 1189 Net error reading from master
1190 ER_MASTER_NET_WRITE 1190 Net error writing to master

ER_FT_MATCHING_KEY_NOT_FOUND 1191 Can't find FULLTEXT index matching the column list

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

ER_UNKNOWN_SYSTEM_VARIABLE 1193 Unknown system variable '%-.64s'

ER_CRASHED_ON_USAGE 1194 Table '%-.64s' is marked as crashed and should be repaired

ER_CRASHED_ON_REPAIR 1195 Table '%-.64s' is marked as crashed and last (automatic?) repair failed

ER_WARNING_NOT_COMPLETE_ROLLBACK 1196 Some non-transactional changed tables couldn't be rolled back

ER_TRANS_CACHE_FULL 1197 Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage. Increase this mysqld variable and try again

ER_SLAVE_MUST_STOP 1198 This operation cannot be performed with a running slave, run STOP SLAVE first

ER_SLAVE_NOT_RUNNING 1199 This operation requires a running slave, configure slave and do START SLAVE
1200 ER_BAD_SLAVE 1200 The server is not configured as slave, fix in config file or with CHANGE MASTER TO

ER_MASTER_INFO 1201 Could not initialize master info structure, check permisions on master.info

ER_SLAVE_THREAD 1202 Could not create slave thread, check system resources

ER_TOO_MANY_USER_CONNECTIONS 1203 User %-.64s has already more than 'max_user_connections' active connections

ER_SET_CONSTANTS_ONLY 1204 You may only use constant expressions with SET

ER_LOCK_WAIT_TIMEOUT 1205 Lock wait timeout exceeded; Try restarting transaction

ER_LOCK_TABLE_FULL 1206 The total number of locks exceeds the lock table size

ER_READ_ONLY_TRANSACTION 1207 Update locks cannot be acquired during a READ UNCOMMITTED transaction

ER_DROP_DB_WITH_READ_LOCK 1208 DROP DATABASE not allowed while thread is holding global read lock

ER_CREATE_DB_WITH_READ_LOCK 1209 CREATE DATABASE not allowed while thread is holding global read lock
1210 ER_WRONG_ARGUMENTS 1210 Wrong arguments to %s

ER_NO_PERMISSION_TO_CREATE_USER 1211 %-.32s@%-.64s is not allowed to create new users

ER_UNION_TABLES_IN_DIFFERENT_DIR 1212 Incorrect table definition; All MERGE tables must be in the same database

ER_LOCK_DEADLOCK 1213 Deadlock found when trying to get lock; Try restarting transaction

ER_TABLE_CANT_HANDLE_FULLTEXT 1214 The used table type doesn't support FULLTEXT indexes

ER_CANNOT_ADD_FOREIGN 1215 Cannot add foreign key constraint

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

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

ER_CONNECT_TO_MASTER 1218 Error connecting to master: %-.128s

ER_QUERY_ON_MASTER 1219 Error running query on master: %-.128s
1220 ER_ERROR_WHEN_EXECUTING_COMMAND 1220 Error when executing command %s: %-.128s

ER_WRONG_USAGE 1221 Wrong usage of %s and %s

ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT 1222 The used SELECT statements have a different number of columns

ER_CANT_UPDATE_WITH_READLOCK 1223 Can't execute the query because you have a conflicting read lock

ER_MIXING_NOT_ALLOWED 1224 Mixing of transactional and non-transactional tables is disabled

ER_DUP_ARGUMENT 1225 Option '%s' used twice in statement

ER_USER_LIMIT_REACHED 1226 User '%-.64s' has exceeded the '%s' resource (current value: %ld)

ER_SPECIFIC_ACCESS_DENIED_ERROR 1227 Access denied. You need the %-.128s privilege for this operation

ER_LOCAL_VARIABLE 1228 Variable '%-.64s' is a LOCAL variable and can't be used with SET GLOBAL

ER_GLOBAL_VARIABLE 1229 Variable '%-.64s' is a GLOBAL variable and should be set with SET GLOBAL
1230 ER_NO_DEFAULT 1230 Variable '%-.64s' doesn't have a default value

ER_WRONG_VALUE_FOR_VAR 1231 Variable '%-.64s' can't be set to the value of '%-.64s'

ER_WRONG_TYPE_FOR_VAR 1232 Wrong argument type to variable '%-.64s'

ER_VAR_CANT_BE_READ 1233 Variable '%-.64s' can only be set, not read

ER_CANT_USE_OPTION_HERE 1234 Wrong usage/placement of '%s'

ER_NOT_SUPPORTED_YET 1235 This version of MySQL doesn't yet support '%s'

ER_MASTER_FATAL_ERROR_READING_BINLOG 1236 Got fatal error %d: '%-.128s' from master when reading data from binary log

ER_WRONG_FK_DEF 1237 Wrong foreign key definition for '%-.64s': %s

ER_KEY_REF_DO_NOT_MATCH_TABLE_REF 1238 Key reference and table reference doesn't match

ER_CARDINALITY_COL 1239 Cardinality error (more/less than %d columns)
1240 ER_SUBSELECT_NO_1_ROW 1240 Subselect returns more than 1 record

ER_UNKNOWN_STMT_HANDLER 1241 Unknown prepared statement handler (%ld) given to %s

ER_CORRUPT_HELP_DB 1242 Help database is corrupt or does not exist

ER_CYCLIC_REFERENCE 1243 Cyclic reference on subqueries

ER_AUTO_CONVERT 1244 Converting column '%s' from %s to %s

ER_ILLEGAL_REFERENCE 1245 Reference '%-.64s' not supported (%s)

ER_DERIVED_MUST_HAVE_ALIAS 1246 Every derived table must have it's own alias

ER_SELECT_REDUCED 1247 Select %u was reduced during optimisation

ER_TABLENAME_NOT_ALLOWED_HERE 1248 Table '%-.64s' from one of SELECT's can not be used in %-.32s

ER_NOT_SUPPORTED_AUTH_MODE 1249 Client does not support authentication protocol requested by server. Consider upgrading MySQL client
1250 ER_SPATIAL_CANT_HAVE_NULL 1250 All parts of a SPATIAL KEY must be NOT NULL

ER_COLLATION_CHARSET_MISMATCH 1251 COLLATION '%s' is not valid for CHARACTER SET '%s'

ER_SLAVE_WAS_RUNNING 1252 The slave was already running

ER_SLAVE_WAS_NOT_RUNNING 1253 The slave was already stopped

ER_CUT_VALUE_GROUP_CONCAT 1254 %d line(s) was(were) cut by group_concat()









MySQL Client





MySQL Client Error Client Error Explanation



2000 CR_UNKNOWN_ERROR 2000 Unknown MySQL error

CR_SOCKET_CREATE_ERROR 2001 Cant create Unix socket

CR_CONNECTION_ERROR 2002 Cant connect to local MySQL server through socket *(*)

CR_CONN_HOST_ERROR 2003 Cant connect to local MySQL server on *(*)

CR_IPSOCK_ERROR 2004 Cant create TCP/IP socket

CR_UNKNOWN_HOST 2005 Unknown MySQL Server Host *(*)

CR_SERVER_GONE_ERROR 2006 MySQL server has gone away

CR_VERSION_ERROR 2007 Protocol mismatch. Server Version=* Client Version=*

CR_OUT_OF_MEMORY 2008 MSQL Client run out of Memory

CR_WRONG_HOST_INFO 2009 Wrong Host info
2010 CR_LOCALHOST_CONNECTION 2010 Localhost via Unix socket

CR_TCP_CONNECTION 2011 * via TCP/IP

CR_SERVER_HANDSHAKE_ERR 2012 Error in server handshake

CR_SERVER_LOST 2013 Lost Connection to MyQL server during query

CR_COMMANDS_OUT_OF_SYNC 2014 Commands out of sync, You can't run this command now

CR_NAMEDPIPE_CONNECTION 2015 * via named pipe

CR_NAMEDPIPEWAIT_ERROR 2016 Cant wait for named pipe to host pipe*(*)

CR_NAMEDPIPEOPEN_ERROR 2017 Cant open named pipe to host: pipe:(*)

CR_NAMEDPIPESETSTATE_ERROR 2018 Cant set state of named pipe to host: pipe(*)

CR_CANT_READ_CHARSET 2019 Cant initialie character set (path:*)
2020 CR_NET_PACKET_TOO_LARGE 2020 Got packet bigger than 'max_allowed_packet'

CR_EMBEDDED_CONNECTION 2021

CR_PROBE_SLAVE_STATUS 2022

CR_PROBE_SLAVE_HOSTS 2023

CR_PROBE_SLAVE_CONNECT 2024
2025 CR_PROBE_MASTER_CONNECT 2025

CR_SSL_CONNECTION_ERROR 2026

CR_MALFORMED_PACKET 2027