Retours d'erreurs
<<<
Messages d'erreurs Manuel de Référence MySQL 4.1 : Version Française
>>>

22 Gestion des erreurs avec MySQL
 Manuel de Référence MySQL 4.1 : Version Française

Retours d'erreurs
->Messages d'erreurs

22.2 Messages d'erreurs

Voici la liste des messages d'erreurs qui peuvent apparaître si vous appelez MySQL, quelque soit la langue utilisée par l'hôte.
Code d'erreur Message d'erreur
1000 hashchk
1001 isamchk
1002 NO
1003 YES
1004 Can't create file '%s' (errno: %d)
1005 Can't create table '%s' (errno: %d)
1006 Can't create database '%s' (errno: %d)
1007 Can't create database '%s'; database exists
1008 Can't drop database '%s'; database doesn't exist
1009 Error dropping database (can't delete '%s', errno: %d)
1010 Error dropping database (can't rmdir '%s', errno: %d)
1011 Error on delete of '%s' (errno: %d)
1012 Can't read record in system table
1013 Can't get status of '%s' (errno: %d)
1014 Can't get working directory (errno: %d)
1015 Can't lock file (errno: %d)
1016 Can't open file: '%s' (errno: %d)
1017 Can't find file: '%s' (errno: %d)
1018 Can't read dir of '%s' (errno: %d)
1019 Can't change dir to '%s' (errno: %d)
1020 Record has changed since last read in table '%s'
1021 Disk full (%s). Waiting for someone to free some space...
1022 Can't write, duplicate key in table '%s'
1023 Error on close of '%s' (errno: %d)
1024 Error reading file '%s' (errno: %d)
1025 Error on rename of '%s' to '%s' (errno: %d)
1026 Error writing file '%s' (errno: %d)
1027 '%s' is locked against change
1028 Sort aborted
1029 View '%s' doesn't exist for '%s'
1030 Got error %d from storage engine
1031 Table storage engine for '%s' doesn't have this option
1032 Can't find record in '%s'
1033 Incorrect information in file: '%s'
1034 Incorrect key file for table: '%s'; try to repair it
1035 Old key file for table '%s'; repair it!
1036 Table '%s' is read only
1037 Out of memory. Restart daemon and try again (needed %d bytes)
1038 Out of sort memory. Increase daemon sort buffer size
1039 Unexpected eof found when reading file '%s' (errno: %d)
1040 Too many connections
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
1042 Can't get hostname for your address
1043 Bad handshake
1044 Access denied for user: '%s'@'%s' to database '%s'
1045 Access denied for user: '%s'@'%s' (Using password: %s)
1046 No Database Selected
1047 Unknown command
1048 Column '%s' cannot be null
1049 Unknown database '%s'
1050 Table '%s' already exists
1051 Unknown table '%s'
1052 Column: '%s' in %s is ambiguous
1053 Server shutdown in progress
1054 Unknown column '%s' in '%s'
1055 '%s' isn't in GROUP BY
1056 Can't group on '%s'
1057 Statement has sum functions and columns in same statement
1058 Column count doesn't match value count
1059 Identifier name '%s' is too long
1060 Duplicate column name '%s'
1061 Duplicate key name '%s'
1062 Duplicate entry '%s' for key %d
1063 Incorrect column specifier for column '%s'
1064 %s near '%s' at line %d
1065 Query was empty
1066 Not unique table/alias: '%s'
1067 Invalid default value for '%s'
1068 Multiple primary key defined
1069 Too many keys specified. Max %d keys allowed
1070 Too many key parts specified. Max %d parts allowed
1071 Specified key was too long. Max key length is %d
1072 Key column '%s' doesn't exist in table
1073 BLOB column '%s' can't be used in key specification with the used table type
1074 Too big column length for column '%s' (max = %d). Use BLOB instead
1075 Incorrect table definition; There can only be one auto column and it must be defined as a key
1076 %s: ready for connections. Version: '%s' socket: '%s' port: %d
1077 %s: Normal shutdown
1078 %s: Got signal %d. Aborting!
1079 %s: Shutdown Complete
1080 %s: Forcing close of thread %ld user: '%s'
1081 Can't create IP socket
1082 Table '%s' has no index like the one used in CREATE INDEX. Recreate the table
1083 Field separator argument is not what is expected. Check the manual
1084 You can't use fixed rowlength with BLOBs. Please use 'fields terminated by'
1085 The file '%s' must be in the database directory or be readable by all
1086 File '%s' already exists
1087 Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld
1088 Records: %ld Duplicates: %ld
1089 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 You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
1091 Can't DROP '%s'. Check that column/key exists
1092 Records: %ld Duplicates: %ld Warnings: %ld
1093 You can't specify target table '%s' for update in FROM clause
1094 Unknown thread id: %lu
1095 You are not owner of thread %lu
1096 No tables used
1097 Too many strings for column %s and SET
1098 Can't generate a unique log-filename %s.(1-999)
1099 Table '%s' was locked with a READ lock and can't be updated
1100 Table '%s' was not locked with LOCK TABLES
1101 BLOB/TEXT column '%s' can't have a default value
1102 Incorrect database name '%s'
1103 Incorrect table name '%s'
1104 The SELECT would examine more rows than MAX_JOIN_SIZE. Check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is ok
1105 Unknown error
1106 Unknown procedure '%s'
1107 Incorrect parameter count to procedure '%s'
1108 Incorrect parameters to procedure '%s'
1109 Unknown table '%s' in %s
1110 Column '%s' specified twice
1111 Invalid use of group function
1112 Table '%s' uses an extension that doesn't exist in this MySQL version
1113 A table must have at least 1 column
1114 The table '%s' is full
1115 Unknown character set: '%s'
1116 Too many tables. MySQL can only use %d tables in a join
1117 Too many columns
1118 Too big row size. The maximum row size for the used table type, not counting BLOBs, is %ld. You have to change some fields to TEXT or BLOBs
1119 Thread stack overrun: Used: %ld of a %ld stack. Use 'mysqld -O thread_stack=#' to specify a bigger stack if needed
1120 Cross dependency found in OUTER JOIN. Examine your ON conditions
1121 Column '%s' is used with UNIQUE or INDEX but is not defined as NOT NULL
1122 Can't load function '%s'
1123 Can't initialize function '%s'; %s
1124 No paths allowed for shared library
1125 Function '%s' already exist
1126 Can't open shared library '%s' (errno: %d %s)
1127 Can't find function '%s' in library'
1128 Function '%s' is not defined
1129 Host '%s' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'
1130 Host '%s' is not allowed to connect to this MySQL server
1131 You are using MySQL as an anonymous users and anonymous users are not allowed to change passwords
1132 You must have privileges to update tables in the mysql database to be able to change passwords for others
1133 Can't find any matching row in the user table
1134 Rows matched: %ld Changed: %ld Warnings: %ld
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
1136 Column count doesn't match value count at row %ld
1137 Can't reopen table: '%s'
1138 Invalid use of NULL value
1139 Got error '%s' from regexp
1140 Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if there is no GROUP BY clause
1141 There is no such grant defined for user '%s' on host '%s'
1142 %s command denied to user: '%s'@'%s' for table '%s'
1143 %s command denied to user: '%s'@'%s' for column '%s' in table '%s'
1144 Illegal GRANT/REVOKE command. Please consult the manual which privileges can be used
1145 The host or user argument to GRANT is too long
1146 Table '%s.%s' doesn't exist
1147 There is no such grant defined for user '%s' on host '%s' on table '%s'
1148 The used command is not allowed with this MySQL version
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 Delayed insert thread couldn't get requested lock for table %s
1151 Too many delayed threads in use
1152 Aborted connection %ld to db: '%s' user: '%s' (%s)
1153 Got a packet bigger than 'max_allowed_packet'
1154 Got a read error from the connection pipe
1155 Got an error from fcntl()
1156 Got packets out of order
1157 Couldn't uncompress communication packet
1158 Got an error reading communication packets
1159 Got timeout reading communication packets
1160 Got an error writing communication packets
1161 Got timeout writing communication packets
1162 Result string is longer than max_allowed_packet
1163 The used table type doesn't support BLOB/TEXT columns
1164 The used table type doesn't support AUTO_INCREMENT columns
1165 INSERT DELAYED can't be used with table '%s' because it is locked with LOCK TABLES
1166 Incorrect column name '%s'
1167 The used storage engine can't index column '%s'
1168 All tables in the MERGE table are not identically defined
1169 Can't write, because of unique constraint, to table '%s'
1170 BLOB/TEXT column '%s' used in key specification without a key length
1171 All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead
1172 Result consisted of more than one row
1173 This table type requires a primary key
1174 This version of MySQL is not compiled with RAID support
1175 You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
1176 Key '%s' doesn't exist in table '%s'
1177 Can't open table
1178 The storage engine for the table doesn't support %s
1179 You are not allowed to execute this command in a transaction
1180 Got error %d during COMMIT
1181 Got error %d during ROLLBACK
1182 Got error %d during FLUSH_LOGS
1183 Got error %d during CHECKPOINT
1184 Aborted connection %ld to db: '%s' user: '%s' host: `%s' (%s)
1185 The storage engine for the table does not support binary table dump
1186 Binlog closed, cannot RESET MASTER
1187 Failed rebuilding the index of dumped table '%s'
1188 Error from master: '%s'
1189 Net error reading from master
1190 Net error writing to master
1191 Can't find FULLTEXT index matching the column list
1192 Can't execute the given command because you have active locked tables or an active transaction
1193 Unknown system variable '%s'
1194 Table '%s' is marked as crashed and should be repaired
1195 Table '%s' is marked as crashed and last (automatic?) repair failed
1196 Some non-transactional changed tables couldn't be rolled back
1197 Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage. Increase this mysqld variable and try again
1198 This operation cannot be performed with a running slave, run STOP SLAVE first
1199 This operation requires a running slave, configure slave and do START SLAVE
1200 The server is not configured as slave, fix in config file or with CHANGE MASTER TO
1201 Could not initialize master info structure, more error messages can be found in the MySQL error log
1202 Could not create slave thread, check system resources
1203 User %s has already more than 'max_user_connections' active connections
1204 You may only use constant expressions with SET
1205 Lock wait timeout exceeded; Try restarting transaction
1206 The total number of locks exceeds the lock table size
1207 Update locks cannot be acquired during a READ UNCOMMITTED transaction
1208 DROP DATABASE not allowed while thread is holding global read lock
1209 CREATE DATABASE not allowed while thread is holding global read lock
1210 Wrong arguments to %s
1211 '%s'@'%s' is not allowed to create new users
1212 Incorrect table definition; all MERGE tables must be in the same database
1213 Deadlock found when trying to get lock; Try restarting transaction
1214 The used table type doesn't support FULLTEXT indexes
1215 Cannot add foreign key constraint
1216 Cannot add or update a child row: a foreign key constraint fails
1217 Cannot delete or update a parent row: a foreign key constraint fails
1218 Error connecting to master: %s
1219 Error running query on master: %s
1220 Error when executing command %s: %s
1221 Wrong usage of %s and %s
1222 The used SELECT statements have a different number of columns
1223 Can't execute the query because you have a conflicting read lock
1224 Mixing of transactional and non-transactional tables is disabled
1225 Option '%s' used twice in statement
1226 User '%s' has exceeded the '%s' resource (current value: %ld)
1227 Access denied. You need the %s privilege for this operation
1228 Variable '%s' is a LOCAL variable and can't be used with SET GLOBAL
1229 Variable '%s' is a GLOBAL variable and should be set with SET GLOBAL
1230 Variable '%s' doesn't have a default value
1231 Variable '%s' can't be set to the value of '%s'
1232 Wrong argument type to variable '%s'
1233 Variable '%s' can only be set, not read
1234 Wrong usage/placement of '%s'
1235 This version of MySQL doesn't yet support '%s'
1236 Got fatal error %d: '%s' from master when reading data from binary log
1237 Slave SQL thread ignored the query because of replicate-*-table rules
1238 Wrong foreign key definition for '%s': %s
1239 Key reference and table reference doesn't match
1240 Operand should contain %d column(s)
1241 Subquery returns more than 1 row
1242 Unknown prepared statement handler (%ld) given to %s
1243 Help database is corrupt or does not exist
1244 Cyclic reference on subqueries
1245 Converting column '%s' from %s to %s
1246 Reference '%s' not supported (%s)
1247 Every derived table must have it's own alias
1248 Select %u was reduced during optimisation
1249 Table '%s' from one of SELECT's can not be used in %s
1250 Client does not support authentication protocol requested by server; consider upgrading MySQL client
1251 All parts of a SPATIAL KEY must be NOT NULL
1252 COLLATION '%s' is not valid for CHARACTER SET '%s'
1253 Slave is already running
1254 Slave has already been stopped
1255 Too big size of uncompressed data. The maximum size is %d. (probably, length of uncompressed data was corrupted)
1256 ZLIB: Not enough memory available for zlib
1257 ZLIB: Not enough room in the output buffer for zlib (probably, length of uncompressed data was corrupted)
1258 ZLIB: Input data was corrupted for zlib
1259 %d line(s) was(were) cut by group_concat()
1260 Row %ld doesn't contain data for all columns
1261 Row %ld was truncated; It contained more data than there where input columns
1262 Data truncated, NULL supplied to NOT NULL column '%s' at row %ld
1263 Data truncated, out of range for column '%s' at row %ld
1264 Data truncated for column '%s' at row %ld
1265 Using storage engine %s for table '%s'
1266 Illegal mix of collations (%s,%s) and (%s,%s) for operation '%s'
1267 Can't drop one or more of the requested users
1268 Can't revoke all privileges, grant for one or more of the requested users
1269 Illegal mix of collations (%s,%s), (%s,%s), (%s,%s) for operation '%s'
1270 Illegal mix of collations for operation '%s'
1271 Variable '%s' is not a variable component (Can't be used as XXXX.variable_name)
1272 Unknown collation: '%s'
1273 SSL parameters in CHANGE MASTER are ignored because this MySQL slave was compiled without SSL support. They can be used later when MySQL slave with SSL will be started.
1274 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
1275 Field or reference '%s%s%s%s%s' of SELECT #%d was resolved in SELECT #%d
1276 Wrong parameter or combination of parameters for START SLAVE UNTIL
1277 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
1278 SQL thread is not to be started so UNTIL options are ignored
1279 Incorrect index name '%s'
1280 Incorrect catalog name '%s'
1281 Query cache failed to set size %lu, new query cache size is %lu
1282 Column '%s' cannot be part of FULLTEXT index
1283 Unknown key cache '%s'
1284 MySQL is started in --skip-name-resolve mode. You need to restart it without this switch for this grant to work
1285 Unknown table engine '%s'
1286 '%s' is deprecated. Use '%s' instead.
1287 The target table %s of the %s is not updatable.
1288 The '%s' feature was disabled. You need MySQL built with '%s' define to have it working
1289 MySQL is started in --skip-grant-tables mode. You can't use this command
1290 Can't create a %s from within another stored routine
1291 %s %s already exists
1292 %s %s does not exist
1293 Failed to DROP %s %s
1294 Failed to CREATE %s %s
1295 %s with no matching label: %s
1296 Redefining label %s
1297 End-label %s without match
1298 Referring to uninitialized variable %s
1299 SELECT in a stored procedure must have INTO
1300 RETURN is only allowed in a FUNCTION
1301 Statements like SELECT, INSERT, UPDATE (and others) are not allowed in a FUNCTION
1302 The update log is deprecated and replaced by the binary log. SET SQL_LOG_UPDATE has been ignored.
1303 The update log is deprecated and replaced by the binary log. SET SQL_LOG_UPDATE has been translated to SET SQL_LOG_BIN.
1304 Query execution was interrupted
1305 Wrong number of arguments for %s %s, expected %u, got %u
1306 Undefined CONDITION: %s
1307 No RETURN found in FUNCTION %s
1308 FUNCTION %s ended without RETURN
1309 Cursor statement must be a SELECT
1310 Cursor SELECT must not have INTO
1311 Undefined CURSOR: %s
1312 Cursor is already open
1313 Cursor is not open
1314 Undeclared variable: %s
1315 Wrong number of FETCH variables
1316 No data to FETCH
1317 Duplicate parameter: %s
1318 Duplicate variable: %s
1319 Duplicate condition: %s
1320 Duplicate cursor: %s
1321 Failed to ALTER %s %s
1322 Subselect value not supported

<< Messages d'erreurs >>
Retours d'erreurs Gestion des erreurs avec MySQL Manuel de Référence MySQL 4.1 : Version Française