Thursday, February 4, 2010

List Of Few MySQL Error

1000 -SQLSTATE: HY000 (ER_HASHCHK) hashchk
1001 -SQLSTATE: HY000 (ER_NISAMCHK) isamchk
1002 -SQLSTATE: HY000 (ER_NO) NO
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

1 comment:

Related Posts Plugin for WordPress, Blogger...