MySQL Error Code文档手册.doc

Chapter26.Error Handling in MySQLThis chapter lists the errors that may appear when you call MySQL from any host language. The first list displays server error messages. The second list displays client program messages. Server error information comes from the following files: o The Error values and the symbols in parentheses correspond to definitions in the include/mysqld_error.h MySQL source file. o The SQLSTATE values correspond to definitions in the include/sql_state.h MySQL source file. SQLSTATE error codes are displayed only if you use MySQL version 4.1 and up. SQLSTATE codes were added for compatibility with X/Open, ANSI, and ODBC behavior. o The Message values correspond to the error messages that are listed in the sql/share/english/errmsg.txt file. %d or %s represent numbers or strings that are substituted into the messages %when they are displayed. Because updates are frequent, it is possible that these files contain additional error information not listed here. o Error: 1000 SQLSTATE: HY000 (ER_HASHCHK) Message: hashchk o Error: 1001 SQLSTATE: HY000 (ER_NISAMCHK) Message: isamchk o Error: 1002 SQLSTATE: HY000 (ER_NO) Message: NO o Error: 1003 SQLSTATE: HY000 (ER_YES) Message: YES o Error: 1004 SQLSTATE: HY000 (ER_CANT_CREATE_FILE) Message: Cant create file %s (errno: %d) o Error: 1005 SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Message: Cant create table %s (errno: %d) o Error: 1006 SQLSTATE: HY000 (ER_CANT_CREATE_DB) Message: Cant create database %s (errno: %d) o Error: 1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Message: Cant create database %s; database exists o Error: 1008 SQLSTATE: HY000 (ER_DB_DROP_EXISTS) Message: Cant drop database %s; database doesnt exist o Error: 1009 SQLSTATE: HY000 (ER_DB_DROP_DELETE) Message: Error dropping database (cant delete %s, errno: %d) o Error: 1010 SQLSTATE: HY000 (ER_DB_DROP_RMDIR) Message: Error dropping database (cant rmdir %s, errno: %d) o Error: 1011 SQLSTATE: HY000 (ER_CANT_DELETE_FILE) Message: Error on delete of %s (errno: %d) o Error: 1012 SQLSTATE: HY000 (ER_CANT_FIND_SYSTEM_REC) Message: Cant read record in system table o Error: 1013 SQLSTATE: HY000 (ER_CANT_GET_STAT) Message: Cant get status of %s (errno: %d) o Error: 1014 SQLSTATE: HY000 (ER_CANT_GET_WD) Message: Cant get working directory (errno: %d) o Error: 1015 SQLSTATE: HY000 (ER_CANT_LOCK) Message: Cant lock file (errno: %d) o Error: 1016 SQLSTATE: HY000 (ER_CANT_OPEN_FILE) Message: Cant open file: %s (errno: %d) o Error: 1017 SQLSTATE: HY000 (ER_FILE_NOT_FOUND) Message: Cant find file: %s (errno: %d) o Error: 1018 SQLSTATE: HY000 (ER_CANT_READ_DIR) Message: Cant read dir of %s (errno: %d) o Error: 1019 SQLSTATE: HY000 (ER_CANT_SET_WD) Message: Cant change dir to %s (errno: %d) o Error: 1020 SQLSTATE: HY000 (ER_CHECKREAD) Message: Record has changed since last read in table %s o Error: 1021 SQLSTATE: HY000 (ER_DISK_FULL) Message: Disk full (%s); waiting for someone to free some space. o Error: 1022 SQLSTATE: 23000 (ER_DUP_KEY) Message: Cant write; duplicate key in table %s o Error: 1023 SQLSTATE: HY000 (ER_ERROR_ON_CLOSE) Message: Error on close of %s (errno: %d) o Error: 1024 SQLSTATE: HY000 (ER_ERROR_ON_READ) Message: Error reading file %s (errno: %d) o Error: 1025 SQLSTATE: HY000 (ER_ERROR_ON_RENAME) Message: Error on rename of %s to %s (errno: %d) o Error: 1026 SQLSTATE: HY000 (ER_ERROR_ON_WRITE) Message: Error writing file %s (errno: %d) o Error: 1027 SQLSTATE: HY000 (ER_FILE_USED) Message: %s is locked against change o Error: 1028 SQLSTATE: HY000 (ER_FILSORT_ABORT) Message: Sort aborted o Error: 1029 SQLSTATE: HY000 (ER_FORM_NOT_FOUND) Message: View %s doesnt exist for %s o Error: 1030 SQLSTATE: HY000 (ER_GET_ERRNO) Message: Got error %d from storage engine o Error: 1031 SQLSTATE: HY000 (ER_ILLEGAL_HA) Message: Table storage engine for %s doesnt have this option o Error: 1032 SQLSTATE: HY000 (ER_KEY_NOT_FOUND) Message: Cant find record in %s o Error: 1033 SQLSTATE: HY000 (ER_NOT_FORM_FILE) Message: Incorrect information in file: %s o Error: 1034 SQLSTATE: HY000 (ER_NOT_KEYFILE) Message: Incorrect key file for table %s; try to repair it o Error: 1035 SQLSTATE: HY000 (ER_OLD_KEYFILE) Message: Old key file for table %s; repair it! o Error: 1036 SQLSTATE: HY000 (ER_OPEN_AS_READONLY) Message: Table %s is read only o Error: 1037 SQLSTATE: HY001 (ER_OUTOFMEMORY) Message: Out of memory; restart server and try again (needed %d bytes) o Error: 1038 SQLSTATE: HY001 (ER_OUT_OF_SORTMEMORY) Message: Out of sort memory; increase server sort buffer size o Error: 1039 SQLSTATE: HY000 (ER_UNEXPECTED_EOF) Message: Unexpected EOF found when reading file %s (errno: %d) o Error: 1040 SQLSTATE: 08004 (ER_CON_COUNT_ERROR) Message: Too many connections o Error: 1041 SQLSTATE: HY000 (ER_OUT_OF_RESOURCES) Message: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use ulimit to allow mysqld to use more memory or you can add more swap space o Error: 1042 SQLSTATE: 08S01 (ER_BAD_HOST_ERROR) Message: Cant get hostname for your address o Error: 1043 SQLSTATE: 08S01 (ER_HANDSHAKE_ERROR) Message: Bad handshake o Error: 1044 SQLSTATE: 42000 (ER_DBACCESS_DENIED_ERROR) Message: Access denied for user %s%s to database %s o Error: 1045 SQLSTATE: 28000 (ER_ACCESS_DENIED_ERROR) Message: Access denied for user %s%s (using password: %s) o Error: 1046 SQLSTATE: 3D000 (ER_NO_DB_ERROR) Message: No database selected o Error: 1047 SQLSTATE: 08S01 (ER_UNKNOWN_COM_ERROR) Message: Unknown command o Error: 1048 SQLSTATE: 23000 (ER_BAD_NULL_ERROR) Message: Column %s cannot be null o Error: 1049 SQLSTATE: 42000 (ER_BAD_DB_ERROR) Message: Unknown database %s o Error: 1050 SQLSTATE: 42S01 (ER_TABLE_EXISTS_ERROR) Message: Table %s already exists o Error: 1051 SQLSTATE: 42S02 (ER_BAD_TABLE_ERROR) Message: Unknown table %s o Error: 1052 SQLSTATE: 23000 (ER_NON_UNIQ_ERROR) Message: Column %s in %s is ambiguous o Error: 1053 SQLSTATE: 08S01 (ER_SERVER_SHUTDOWN) Message: Server shutdown in progress o Error: 1054 SQLSTATE: 42S22 (ER_BAD_FIELD_ERROR) Message: Unknown column %s in %s o Error: 1055 SQLSTATE: 42000 (ER_WRONG_FIELD_WITH_GROUP) Message: %s isnt in GROUP BY o Error: 1056 SQLSTATE: 42000 (ER_WRONG_GROUP_FIELD) Message: Cant group on %s o Error: 1057 SQLSTATE: 42000 (ER_WRONG_SUM_SELECT) Message: Statement has sum functions and columns in same statement o Error: 1058 SQLSTATE: 21S01 (ER_WRONG_VALUE_COUNT) Message: Column count doesnt match value count o Error: 1059 SQLSTATE: 42000 (ER_TOO_LONG_IDENT) Message: Identifier name %s is too long o Error: 1060 SQLSTATE: 42S21 (ER_DUP_FIELDNAME) Message: Duplicate column name %s o Error: 1061 SQLSTATE: 42000 (ER_DUP_KEYNAME) Message: Duplicate key name %s o Error: 1062 SQLSTATE: 23000 (ER_DUP_ENTRY) Message: Duplicate entry %s for key %d o Error: 1063 SQLSTATE: 42000 (ER_WRONG_FIELD_SPEC) Message: Incorrect column specifier for column %s o Error: 1064 SQLSTATE: 42000 (ER_PARSE_ERROR) Message: %s near %s at line %d o Error: 1065 SQLSTATE: 42000 (ER_EMPTY_QUERY) Message: Query was empty o Error: 1066 SQLSTATE: 42000 (ER_NONUNIQ_TABLE) Message: Not unique table/alias: %s o Error: 1067 SQLSTATE: 42000 (ER_INVALID_DEFAULT) Message: Invalid default value for %s o Error: 1068 SQLSTATE: 42000 (ER_MULTIPLE_PRI_KEY) Message: Multiple primary key defined o Error: 1069 SQLSTATE: 42000 (ER_TOO_MANY_KEYS) Message: Too many keys specified; max %d keys allowed o Error: 1070 SQLSTATE: 42000 (ER_TOO_MANY_KEY_PARTS) Message: Too many key parts specified; max %d parts allowed o Error: 1071 SQLSTATE: 42000 (ER_TOO_LONG_KEY) Message: Specified key was too long; max key length is %d bytes o Error: 1072 SQLSTATE: 42000 (ER_KEY_COLUMN_DOES_NOT_EXITS) Message: Key column %s doesnt exist in table o Error: 1073 SQLSTATE: 42000 (ER_BLOB_USED_AS_KEY) Message: BLOB column %s cant be used in key specification with the used table type o Error: 1074 SQLSTATE: 42000 (ER_TOO_BIG_FIELDLENGTH) Message: Column length too big for column %s (max = %d); use BLOB instead o Error: 1075 SQLSTATE: 42000 (ER_WRONG_AUTO_KEY) Message: Incorrect table definition; there can be only one auto column and it must be defined as a key o Error: 1076 SQLSTATE: HY000 (ER_READY) Message: %s: ready for connections. Version: %s socket: %s port: %d o Error: 1077 SQLSTATE: HY000 (ER_NORMAL_SHUTDOWN) Message: %s: Normal shutdown o Error: 1078 SQLSTATE: HY000 (ER_GOT_SIGNAL) Message: %s: Got signal %d. Aborting! o Error: 1079 SQLSTATE: HY000 (ER_SHUTDOWN_COMPLETE) Message: %s: Shutdown complete o Error: 1080 SQLSTATE: 08S01 (ER_FORCING_CLOSE) Message: %s: Forcing close of thread %ld user: %s o Error: 1081 SQLSTATE: 08S01 (ER_IPSOCK_ERROR) Message: Cant create IP socket o Error: 1082 SQLSTATE: 42S12 (ER_NO_SUCH_INDEX) Message: Table %s has no index like the one used in CREATE INDEX; recreate the table o Error: 1083 SQLSTATE: 42000 (ER_WRONG_FIELD_TERMINATORS) Message: Field separator argument is not what is expected; check the manual o Error: 1084 SQLSTATE: 42000 (ER_BLOBS_AND_NO_TERMINATED) Message: You cant use fixed rowlength with BLOBs; please use fields terminated by o Error: 1085 SQLSTATE: HY000 (ER_TEXTFILE_NOT_READABLE) Message: The file %s must be in the database directory or be readable by all o Error: 1086 SQLSTATE: HY000 (ER_FILE_EXISTS_ERROR) Message: File %s already exists o Error: 1087 SQLSTATE: HY000 (ER_LOAD_INFO) Message: Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld o Error: 1088 SQLSTATE: HY000 (ER_ALTER_INFO) Message: Records: %ld Duplicates: %ld o Error: 1089 SQLSTATE: HY000 (ER_WRONG_SUB_KEY) Message: Incorrect sub part key; the used key part isnt a string, the used length is longer than the key part, or the storage engine doesnt support unique sub keys o Error: 1090 SQLSTATE: 42000 (ER_CANT_REMOVE_ALL_FIELDS) Message: You cant delete all columns with ALTER TABLE; use DROP TABLE instead o Error: 1091 SQLSTATE: 42000 (ER_CANT_DROP_FIELD_OR_KEY) Message: Cant DROP %s; check that column/key exists o Error: 1092 SQLSTATE: HY000 (ER_INSERT_INFO) Message: Records: %ld Duplicates: %ld Warnings: %ld o Error: 1093 SQLSTATE: HY000 (ER_UPDATE_TABLE_USED) Message: You cant specify target table %s for update in FROM clause o Error: 1094 SQLSTATE: HY000 (ER_NO_SUCH_THREAD) Message: Unknown thread id: %lu o Error: 1095 SQLSTATE: HY000 (ER_KILL_DENIED_ERROR) Message: You are not owner of thread %lu o Error: 1096 SQLSTATE: HY000 (ER_NO_TABLES_USED) Message: No tables used o Error: 1097 SQLSTATE: HY000 (ER_TOO_BIG_SET) Message: Too many strings for column %s and SET o Error: 1098 SQLSTATE: HY000 (ER_NO_UNIQUE_LOGFILE) Message: Cant generate a unique log-filename %s.(1-999) o Error: 1099 SQLSTATE: HY000 (ER_TABLE_NOT_LOCKED_FOR_WRITE) Message: Table %s was locked with a READ lock and cant be updated o Error: 1100 SQLSTATE: HY000 (ER_TABLE_NOT_LOCKED) Message: Table %s was not locked with LOCK TABLES o Error: 1101 SQLSTATE: 42000 (ER_BLOB_CANT_HAVE_DEFAULT) Message: BLOB/TEXT column %s cant have a default value o Error: 1102 SQLSTATE: 42000 (ER_WRONG_DB_NAME) Message: Incorrect database name %s o Error: 1103 SQLSTATE: 42000 (ER_WRONG_TABLE_NAME) Message: Incorrect table name %s o Error: 1104 SQLSTATE: 42000 (ER_TOO_BIG_SELECT) Message: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay o Error: 1105 SQLSTATE: HY000 (ER_UNKNOWN_ERROR) Message: Unknown error o Error: 1106 SQLSTATE: 42000 (ER_UNKNOWN_PROCEDURE) Message: Unknown procedure %s o Error: 1107 SQLSTATE: 42000 (ER_WRONG_PARAMCOUNT_TO_PROCEDURE) Message: Incorrect parameter count to procedure %s o Error: 1108 SQLSTATE: HY000 (ER_WRONG_PARAMETERS_TO_PROCEDURE) Message: Incorrect parameters to procedure %s o Error: 1109 SQLSTATE: 42S02 (ER_UNKNOWN_TABLE) Message: Unknown table %s in %s o Error: 1110 SQLSTATE: 42000 (ER_FIELD_SPECIFIED_TWICE) Message: Column %s specified twice o Error: 1111 SQLSTATE: HY000 (ER_INVALID_GROUP_FUNC_USE) Message: Invalid use of group function o Error: 1112 SQLSTATE: 42000 (ER_UNSUPPORTED_EXTENSION) Message: Table %s uses an extension that doesnt exist in this MySQL version o Error: 1113 SQLSTATE: 42000 (ER_TABLE_MUST_HAVE_COLUMNS) Message: A table must have at least 1 column o Error: 1114 SQLSTATE: HY000 (ER_RECORD_FILE_FULL) Message: The table %s is full o Error: 1115 SQLSTATE: 42000 (ER_UNKNOWN_CHARACTER_SET) Message: Unknown character set: %s o Error: 1116 SQLSTATE: HY000 (ER_TOO_MANY_TABLES) Message: Too many tables; MySQL can only use %d tables in a join o Error: 1117 SQLSTATE: HY000 (ER_TOO_MANY_FIELDS) Message: Too many columns o Error: 1118 SQLSTATE: 42000 (ER_TOO_BIG_ROWSIZE) 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 o Error: 1119 SQLSTATE: HY000 (ER_STACK_OVERRUN) Message: Thread stack overrun: Used: %ld of a %ld stack. Use mysqld -O thread_stack=# to specify a bigger stack if needed o Error: 1120 SQLSTATE: 42000 (ER_WRONG_OUTER_JOIN) Message: Cross dependency found in OUTER JOIN; examine your ON conditions o Error: 1121 SQLSTATE: 42000 (ER_NULL_COLUMN_IN_INDEX) Message: Column %s is used with UNIQUE or INDEX but is not defined as NOT NULL o Error: 1122 SQLSTATE: HY000 (ER_CANT_FIND_UDF) Message: Cant load function %s o Error: 1123 SQLSTATE: HY000 (ER_CANT_INITIALIZE_UDF) Message: Cant initialize function %s; %s o Error: 1124 SQLSTATE: HY000 (ER_UDF_NO_PATHS) Message: No paths allowed for shared library o Error: 1125 SQLSTATE: HY000 (ER_UDF_EXISTS) Message: Function %s already exists o Error: 1126 SQLSTATE: HY000 (ER_CANT_OPEN_LIBRARY) Message: Cant open shared library %s (errno: %d %s) o Error: 1127 SQLSTATE: HY000 (ER_CANT_FIND_DL_ENTRY) Message: Cant find function %s in library o Error: 1128 SQLSTATE: HY000 (ER_FUNCTION_NOT_DEFINED) Message: Function %s is not defined o Error: 1129 SQLSTATE: HY000 (ER_HOST_IS_BLOCKED) Message: Host %s is blocked because of many connection errors; unblock with mysqladmin flush-hosts o Error: 1130 SQLSTATE: HY000 (ER_HOST_NOT_PRIVILEGED) Message: Host %s is not allowed to connect to this MySQL server o Error: 1131 SQLSTATE: 42000 (ER_PASSWORD_ANONYMOUS_USER) Message: You are using MySQL as an anonymous user and anonymous users are not allowed to change passwords o Error: 1132 SQLSTATE: 42000 (ER_PASSWORD_NOT_ALLOWED) Message: You must have privileges to update tables in the mysql database to be able to change passwords for others o Error: 1133 SQLSTATE: 42000 (ER_PASSWORD_NO_MATCH) Message: Cant find any matching row in the user table o Error: 1134 SQLSTATE: HY000 (ER_UPDATE_INFO) Message: Rows matched: %ld Changed: %ld Warnings: %ld o Error: 1135 SQLSTATE: HY000 (ER_CANT_CREATE_THREAD) Message: Cant 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 o Error: 1136 SQLSTATE: 21S01 (ER_WRONG_VALUE_COUNT_ON_ROW) Message: Column count doesnt match value count at row %ld o Error: 1137 SQLSTATE: HY000 (ER_CANT_REOPEN_TABLE) Message: Cant reopen table: %s o Error: 1138 SQLSTATE: 22004 (ER_INVALID_USE_OF_NULL) Message: Invalid use of NULL value o Error: 1139 SQLSTATE: 42000 (ER_REGEXP_ERROR) Message: Got error %s from regexp o Error: 1140 SQLSTATE: 42000 (ER_MIX_OF_GROUP_FUNC_AND_FIELDS) Message: Mixing of GROUP columns (MIN(),MAX(),COUNT(),.) with no GROUP columns is illegal if there is no GROUP BY clause o Error: 1141 SQLSTATE: 42000 (ER_NONEXISTING_GRANT) Message: There is no such grant defined for user %s on host %s o Error: 1142 SQLSTATE: 42000 (ER_TABLEACCESS_DENIED_ERROR) Message: %s command denied to user %s%s for table %s o Error: 1143 SQLSTATE: 42000 (ER_COLUMNACCESS_DENIED_ERROR) Message: %s command denied to user %s%s for column %s in table %s o Error: 1144 SQLSTATE: 42000 (ER_ILLEGAL_GRANT_FOR_TABLE) Message: Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used o Error: 1145 SQLSTATE: 42000 (ER_GRANT_WRONG_HOST_OR_USER) Message: The host or user argument to GRANT is too long o Error: 1146 SQLSTATE: 42S02 (ER_NO_SUCH_TABLE) Message: Table %s.%s doesnt exist o Error: 1147 SQLSTATE: 42000 (ER_NONEXISTING_TABLE_GRANT) Message: There is no such grant defined for user %s on host %s on table %s o Error: 1148 SQLSTATE: 42000 (ER_NOT_ALLOWED_COMMAND) Message: The used command is not allowed with this MySQL version o Error: 1149 SQLSTATE: 42000 (ER_SYNTAX_ERROR) Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use o Error: 1150 SQLSTATE: HY000 (ER_DELAYED_CANT_CHANGE_LOCK) Message: Delayed insert thread couldnt get requested lock for table %s o Error: 1151 SQLSTATE: HY000 (ER_TOO_MANY_DELAYED_THREADS) Message: Too many delayed threads in use o Error: 1152 SQLSTATE: 08S01 (ER_ABORTING_CONNECTION) Message: Aborted connection %ld to db: %s user: %s (%s) o Error: 1153 SQLSTATE: 08S01 (ER_NET_PACKET_TOO_LARGE) Message: Got a packet bigger than max_allowed