[MySQL] ErrorCode / ErrorNo

(2009/03/28 05:38 작성)

[ Mysql - ErrCode/ErrNo  { 출처 -  06/09/04 18:01 }

Mysql - ErrCode  Error code 1 : 명령이 허용되지 않음 Error code 2 : 그런 파일이나 디렉토리가 없음 Error code 3 : 그런 프로세스가 없음 Error code 4 : 중단된 시스템 호출 Error code 5 : 입력/출력 오류 Error code 6 : 장치가 설정되지 않았음 Error code 7 : 인수 명단이 너무 깁니다 Error code 8 : Exec 형식 오류 Error code 9 : 잘못된 파일 기술자 Error code 10 : 자식 프로세스가 없음 Error code 11 : 자원이 일시적으로 사용 불가능함 Error code 12 : 메모리를 할당할 수 없습니다 Error code 13 : 허가 거부됨 Error code 14 : 잘못된 주소 Error code 15 : 블럭 장치가 필요함 Error code 16 : 장치나 자원이 동작 중 Error code 17 : 파일이 존재합니다 Error code 18 : 부적절한 장치간 연결 Error code 19 : 그런 장치가 없음 Error code 20 : 디렉토리가 아닙니다 Error code 21 : 디렉토리입니다 Error code 22 : 부적절한 인수 Error code 23 : 시스템에 열린 파일이 너무 많음 Error code 24 : 열린 파일이 너무 많음 Error code 25 : 장치에 대해 부적절한 ioctl Error code 26 : 실행 파일 사용 중 Error code 27 : 파일이 너무 큽니다 Error code 28 : 장치에 남은 공간이 없음 Error code 29 : 잘못된 탐색 Error code 30 : 읽기전용 파일 시스템 Error code 31 : 연결이 너무 많음 Error code 32 : 파이프가 깨어짐 Error code 33 : 영역을 벗어난 수치 인수 Error code 34 : 범위를 벗어난 수치 결과 Error code 35 : 자원 교착상태를 피했습니다 Error code 36 : 파일 이름이 너무 깁니다 Error code 37 : 사용가능한 잠금장치가 없음 Error code 38 : 함수가 구현되지 않았음 Error code 39 : 디렉토리가 비어있지 않음 Error code 40 : 기호 연결의 단계가 너무 많음 Error code 41 : 알 수 없는 오류41 Error code 42 : 적당한 형을 가진 메시지가 없음 Error code 43 : 식별자 제거됨 Error code 44 : 범위를 벗어난 채널 번호 Error code 45 : 등급 2가 동기화되지 않음 Error code 46 : 등급 3 멎었음 Error code 47 : 등급 3 리셋 Error code 48 : 범위를 벗어난 링크 번호 Error code 49 : 규약 구동기에 연결되지 않음 Error code 50 : 사용 가능한 CSI 구조가 없음 Error code 51 : 등급 2 멎었음 Error code 52 : 부적절한 교환 Error code 53 : 잘못된 요청 기술자 Error code 54 : 교환이 가득참 Error code 55 : anode가 없음 Error code 56 : 부적절한 요청 코드 Error code 57 : 부적절한 슬롯 Error code 58 : 알 수 없는 오류58 Error code 59 : 잘못된 폰트 파일 형식 Error code 60 : 장치가 스트림이 아님 Error code 61 : 사용 가능한 자료가 없음 Error code 62 : 타이머 시간 초과됨 Error code 63 : 스트림 자원 부족 Error code 64 : 기계가 네트워크 상에 있지 않습니다 Error code 65 : 패키지가 설치되지 않음 Error code 66 : 원격 개체입니다 Error code 67 : 링크가 손상되었습니다 Error code 68 : 광고 오류 Error code 69 : Srmount 오류 Error code 70 : 전송 중 통신 오류 Error code 71 : 규약 오류 Error code 72 : 여러개의 hop이 시도됨 Error code 73 : RFS에 국한된 오류 Error code 74 : 잘못된 메시지 Error code 75 : 정의된 자료형으로 쓰기엔 너무 큰 값 Error code 76 : 이름이 네트워크 상에서 단일하지 않음 Error code 77 : 파일 기술자가 잘못된 상태에 있음 Error code 78 : 원격 주소가 바뀌었음 Error code 79 : 필요한 공유 라이브러리에 접근할 수 없습니다 Error code 80 : 손상된 공유 라이브러리에 접근함 Error code 81 : a.out의 .lib 절이 손상되었음 Error code 82 : 너무 많은 동적 라이브러리와 링크하려고 시도하였음 Error code 83 : 공유 라이브러리를 직접 실행할 수 없습니다 Error code 84 : 부적절하거나 불완전한 다중바이트 또는 광역 문자 Error code 85 : 중단된 시스템 호출은 재시작되어야 합니다 Error code 86 : 스트림 파이프 오류 Error code 87 : 사용자가 너무 많음 Error code 88 : 비소켓상의 소켓 동작 Error code 89 : 목적지 주소가 필요함 Error code 90 : 메시지가 너무 깁니다 Error code 91 : 소켓에 대한 규약이 잘못됨 Error code 92 : 규약 사용 불가능 Error code 93 : 규약이 지원되지 않음 Error code 94 : 소켓 타입이 지원되지 않습니다 Error code 95 : 명령이 지원되지 않음 Error code 96 : 규약군이 지원되지 않음 Error code 97 : 주소군이 규약에서 지원되지 않음 Error code 98 : 주소가 이미 사용 중입니다 Error code 99 : 요청된 주소를 배정할 수 없습니다 Error code 100 : 네트워크가 죽었습니다 Error code 101 : 네트워크가 접근 불가능합니다 Error code 102 : 네트웍이 reset때문에 연결을 끊었습니다 Error code 103 : 소프트웨어가 연결 중단을 초래했습니다 Error code 104 : 연결이 상대편에 의해 끊어짐 Error code 105 : 사용 가능한 버퍼 공간이 없음 Error code 106 : 전송 종료지점이 이미 연결되어 있습니다 Error code 107 : 전송 종료지점이 연결되어 있지 않습니다 Error code 108 : 전송 종료지점이 지난 후에 보낼 수 없습니다 Error code 109 : 참조가 너무 많음: 연결할 수 없습니다 Error code 110 : 연결 시간 초과 Error code 111 : 연결이 거부됨 Error code 112 : 호스트가 죽었습니다 Error code 113 : 호스트로 갈 루트가 없음 Error code 114 : 이미 진행 중인 명령 Error code 115 : 지금 진행 중인 명령 Error code 116 : 끊어진 NFS 파일 핸들 Error code 117 : 구조에 청소가 필요합니다 Error code 118 : XENIX named 타입 파일이 아님 Error code 119 : 사용 가능한 XENIX 세마포어가 없음 Error code 120 : Didnt find key on read or update Error code 121 : Duplicate key on write or update Error code 122 : Disk quota exceeded Error code 123 : Someone has changed the row since it was read; Update with is recoverable Error code 124 : Wrong index given to function Error code 125 : 알 수 없는 오류125 Error code 126 : Index file is crashed / Wrong file format Error code 127 : Record-file is crashed Error code 131 : Command not supported by database Error code 132 : Old database file Error code 133 : No record read before update Error code 134 : Record was already deleted (or record file crashed) Error code 135 : No more room in record file Error code 136 : No more room in index file Error code 137 : No more records (read after end of file) Error code 138 : Unsupported extension used for table Error code 139 : Too big row (>= 16 M) Error code 140 : Wrong create options Error code 141 : Duplicate unique key or constraint on write or update Error code 142 : Unknown character set used Error code 143 : Conflicting table definition between MERGE and mapped table Error code 144 : Table is crashed and last repair failed Error code 145 : Table was marked as crashed and should be repaired Error code 146 : Lock timed out; Retry transaction Error code 147 : Lock table is full; Restart program with a larger locktable Error code 148 : Updates are not allowed under a read only transactions Error code 149 : Lock deadlock; Retry transaction Mysql - ErrNo 1000hashchk, 1001isamchk, 1002NO, 1003YES, 1004Cant create file %-.64s (errno: %d), 1005Cant create table %-.64s (errno: %d), 1006Cant create database %-.64s. (errno: %d), 1007Cant create database %-.64s. Database exists, 1008Cant drop database %-.64s. Database doesnt exist, 1009Error dropping database (cant delete %-.64s, errno: %d), 1010Error dropping database (cant rmdir %-.64s, errno: %d), 1011Error on delete of %-.64s (errno: %d), 1012Cant read record in system table, 1013Cant get status of %-.64s (errno: %d), 1014Cant get working directory (errno: %d), 1015Cant lock file (errno: %d), 1016Cant open file: %-.64s. (errno: %d), 1017Cant find file: %-.64s (errno: %d), 1018Cant read dir of %-.64s (errno: %d), 1019Cant change dir to %-.64s (errno: %d), 1020Record has changed since last read in table %-.64s, 1021Disk full (%s). Waiting for someone to free some space...., 1022Cant write, duplicate key in table %-.64s, 1023Error on close of %-.64s (errno: %d), 1024Error reading file %-.64s (errno: %d), 1025Error on rename of %-.64s to %-.64s (errno: %d), 1026Error writing file %-.64s (errno: %d), 1027%-.64s is locked against change, 1028Sort aborted, 1029View %-.64s doesnt exist for %-.64s, 1030Got error %d from table handler, 1031Table handler for %-.64s doesnt have this option, 1032Cant find record in %-.64s, 1033Incorrect information in file: %-.64s, 1034Incorrect key file for table: %-.64s. Try to repair it, 1035Old key file for table %-.64s; Repair it!, 1036Table %-.64s is read only, 1037Out of memory. Restart daemon and try again (needed %d bytes), 1038Out of sort memory. Increase daemon sort buffer size, 1039Unexpected eof found when reading file %-.64s (errno: %d), 1040Too many connections, 1041Out 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, 1042Cant get hostname for your address, 1043Bad handshake, 1044Access denied for user: %-.32s@%-.64s to database %-.64s, 1045Access denied for user: %-.32s@%-.64s (Using password: %s), 1046No Database Selected, 1047Unknown command, 1048Column %-.64s cannot be null, 1049Unknown database %-.64s, 1050Table %-.64s already exists, 1051Unknown table %-.64s, 1052Column: %-.64s in %-.64s is ambiguous, 1053Server shutdown in progress, 1054Unknown column %-.64s in %-.64s, 1055%-.64s isnt in GROUP BY, 1056Cant group on %-.64s, 1057Statement has sum functions and columns in same statement, 1058Column count doesnt match value count, 1059Identifier name %-.100s is too long, 1060Duplicate column name %-.64s, 1061Duplicate key name %-.64s, 1062Duplicate entry %-.64s for key %d, 1063Incorrect column specifier for column %-.64s, 1064%s near %-.80s at line %d, 1065Query was empty, 1066Not unique table/alias: %-.64s, 1067Invalid default value for %-.64s, 1068Multiple primary key defined, 1069Too many keys specified. Max %d keys allowed, 1070Too many key parts specified. Max %d parts allowed, 1071Specified key was too long. Max key length is %d, 1072Key column %-.64s doesnt exist in table, 1073BLOB column %-.64s cant be used in key specification with the used table type, 1074Too big column length for column %-.64s (max = %d). Use BLOB instead, 1075Incorrect table definition; There can only be one auto column and it must be defined as a key, 1076%s: ready for connectionsn, 1077%s: Normal shutdownn, 1078%s: Got signal %d. Aborting!n, 1079%s: Shutdown Completen, 1080%s: Forcing close of thread %ld user: %-.32sn, 1081Cant create IP socket, 1082Table %-.64s has no index like the one used in CREATE INDEX. Recreate the table, 1083Field separator argument is not what is expected. Check the manual, 1084You cant use fixed rowlength with BLOBs. Please use fields terminated by., 1085The file %-.64s must be in the database directory or be readable by all, 1086File %-.80s already exists, 1087Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld, 1088Records: %ld Duplicates: %ld, 1089Incorrect sub part key. The used key part isnt a string, the used length is longer than the key part or the table handler doesnt support unique sub keys, 1090You cant delete all columns with ALTER TABLE. Use DROP TABLE instead, 1091Cant DROP %-.64s. Check that column/key exists, 1092Records: %ld Duplicates: %ld Warnings: %ld, 1093INSERT TABLE %-.64s isnt allowed in FROM table list, 1094Unknown thread id: %lu, 1095You are not owner of thread %lu, 1096No tables used, 1097Too many strings for column %-.64s and SET, 1098Cant generate a unique log-filename %-.64s.(1-999)n, 1099Table %-.64s was locked with a READ lock and cant be updated, 1100Table %-.64s was not locked with LOCK TABLES, 1101BLOB column %-.64s cant have a default value, 1102Incorrect database name %-.100s, 1103Incorrect table name %-.100s, 1104The 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, 1105Unknown error, 1106Unknown procedure %-.64s, 1107Incorrect parameter count to procedure %-.64s, 1108Incorrect parameters to procedure %-.64s, 1109Unknown table %-.64s in %-.32s, 1110Column %-.64s specified twice, 1111Invalid use of group function, 1112Table %-.64s uses an extension that doesnt exist in this MySQL version, 1113A table must have at least 1 column, 1114The table %-.64s is full, 1115Unknown character set: %-.64s, 1116Too many tables. MySQL can only use %d tables in a join, 1117Too many columns, 1118Too big row size. The maximum row size, not counting BLOBs, is %d. You have to change some fields to BLOBs, 1119Thread stack overrun: Used: %ld of a %ld stack. Use mysqld -O thread_stack=# to specify a bigger stack if needed, 1120Cross dependency found in OUTER JOIN. Examine your ON conditions, 1121Column %-.64s is used with UNIQUE or INDEX but is not defined as NOT NULL, 1122Cant load function %-.64s, 1123Cant initialize function %-.64s; %-.80s, 1124No paths allowed for shared library, 1125Function %-.64s already exist, 1126Cant open shared library %-.64s (errno: %d %-.64s), 1127Cant find function %-.64s in library, 1128Function %-.64s is not defined, 1129Host %-.64s is blocked because of many connection errors. Unblock with mysqladmin flush-hosts, 1130Host %-.64s is not allowed to connect to this MySQL server, 1131You are using MySQL as an anonymous users and anonymous users are not allowed to change passwords, 1132You must have privileges to update tables in the mysql database to be able to change passwords for others, 1133Cant find any matching row in the user table, 1134Rows matched: %ld Changed: %ld Warnings: %ld, 1135Cant 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, 1136Column count doesnt match value count at row %ld, 1137Cant reopen table: %-.64s, 1138Invalid use of NULL value, 1139Got error %-.64s from regexp, 1140Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if there is no GROUP BY clause, 1141There is no such grant defined for user %-.32s on host %-.64s, 1142%-.16s command denied to user: %-.32s@%-.64s for table %-.64s, 1143%-.16s command denied to user: %-.32s@%-.64s for column %-.64s in table %-.64s, 1144Illegal GRANT/REVOKE command. Please consult the manual which privileges can be used., 1145The host or user argument to GRANT is too long, 1146Table %-.64s.%-.64s doesnt exist, 1147There is no such grant defined for user %-.32s on host %-.64s on table %-.64s, 1148The used command is not allowed with this MySQL version, 1149You have an error in your SQL syntax, 1150Delayed insert thread couldnt get requested lock for table %-.64s, 1151Too many delayed threads in use, 1152Aborted connection %ld to db: %-.64s user: %-.32s (%-.64s), 1153Got a packet bigger than max_allowed_packet, 1154Got a read error from the connection pipe, 1155Got an error from fcntl(), 1156Got packets out of order, 1157Couldnt uncompress communication packet, 1158Got an error reading communication packets, 1159Got timeout reading communication packets, 1160Got an error writing communication packets, 1161Got timeout writing communication packets, 1162Result string is longer than max_allowed_packet, 1163The used table type doesnt support BLOB/TEXT columns, 1164The used table type doesnt support AUTO_INCREMENT columns, 1165INSERT DELAYED cant be used with table %-.64s, because it is locked with LOCK TABLES, 1166Incorrect column name %-.100s, 1167The used table handler cant index column %-.64s, 1168All tables in the MERGE table are not identically defined, 1169Cant write, because of unique constraint, to table %-.64s, 1170BLOB column %-.64s used in key specification without a key length, 1171All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead, 1172Result consisted of more than one row, 1173This table type requires a primary key, 1174This version of MySQL is not compiled with RAID support, 1175You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column, 1176Key %-.64s doesnt exist in table %-.64s, 1177Cant open table, 1178The handler for the table doesnt support check/repair, 1179You are not allowed to execute this command in a transaction, 1180Got error %d during COMMIT, 1181Got error %d during ROLLBACK, 1182Got error %d during FLUSH_LOGS, 1183Got error %d during CHECKPOINT, 1184Aborted connection %ld to db: %-.64s user: %-.32s host: `%-.64s (%-.64s), 1185The handler for the table does not support binary table dump, 1186Binlog closed, cannot RESET MASTER, 1187Failed rebuilding the index of dumped table %-.64s, 1188Error from master: %-.64s, 1189Net error reading from master, 1190Net error writing to master, 1191Cant find FULLTEXT index matching the column list, 1192Cant execute the given command because you have active locked tables or an active transaction, 1193Unknown system variable %-.64, 1194Table %-.64s is marked as crashed and should be repaired, 1195Table %-.64s is marked as crashed and last (automatic?) repair failed, 1196Warning: Some non-transactional changed tables couldnt be rolled back, 1197Multi-statement transaction required more than max_binlog_cache_size bytes of storage. Increase this mysqld variable and try again, 1198This operation cannot be performed with a running slave, run SLAVE STOP first, 1199This operation requires a running slave, configure slave and do SLAVE START, 1200The server is not configured as slave, fix in config file or with CHANGE MASTER TO, 1201Could not initialize master info structure, check permisions on master.info, 1202Could not create slave thread, check system resources, 1203User %-.64s has already more than max_user_connections active connections, 1204You may only use constant expressions with SET, 1205Lock wait timeout exceeded; Try restarting transaction, 1206The total number of locks exceeds the lock table size, 1207Update locks cannot be acquired during a READ UNCOMMITTED transaction, 1208DROP DATABASE not allowed while thread is holding global read lock, 1209CREATE DATABASE not allowed while thread is holding global read lock, 1210Wrong arguments to %s, 1211%-.32s@%-.64s is not allowed to create new users, 1212Incorrect table definition; All MERGE tables must be in the same database, 1213Deadlock found when trying to get lock; Try restarting transaction, 1214The used table type doesnt support FULLTEXT indexes, 1215Cannot add foreign key constraint, 1216Cannot add a child row: a foreign key constraint fails, 1217Cannot delete a parent row: a foreign key constraint fails,