mysql 에러코드

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 : Didn\t 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

1000\hashchk\,
1001\isamchk\,
1002\NO\,
1003\YES\,
1004\Can\t create file \%-.64s\ (errno: %d)\,
1005\Can\t create table \%-.64s\ (errno: %d)\,
1006\Can\t create database \%-.64s\. (errno: %d)\,
1007\Can\t create database \%-.64s\. Database exists\,
1008\Can\t drop database \%-.64s\. Database doesn\t exist\,
1009\Error dropping database (can\t delete \%-.64s\, errno: %d)\,
1010\Error dropping database (can\t rmdir \%-.64s\, errno: %d)\,
1011\Error on delete of \%-.64s\ (errno: %d)\,
1012\Can\t read record in system table\,
1013\Can\t get status of \%-.64s\ (errno: %d)\,
1014\Can\t get working directory (errno: %d)\,
1015\Can\t lock file (errno: %d)\,
1016\Can\t open file: \%-.64s\. (errno: %d)\,
1017\Can\t find file: \%-.64s\ (errno: %d)\,
1018\Can\t read dir of \%-.64s\ (errno: %d)\,
1019\Can\t change dir to \%-.64s\ (errno: %d)\,
1020\Record has changed since last read in table \%-.64s\,
1021\Disk full (%s). Waiting for someone to free some space....\,
1022\Can\t write, duplicate key in table \%-.64s\,
1023\Error on close of \%-.64s\ (errno: %d)\,
1024\Error reading file \%-.64s\ (errno: %d)\,
1025\Error on rename of \%-.64s\ to \%-.64s\ (errno: %d)\,
1026\Error writing file \%-.64s\ (errno: %d)\,
1027\%-.64s\ is locked against change\,
1028\Sort aborted\,
1029\View \%-.64s\ doesn\t exist for \%-.64s\,
1030\Got error %d from table handler\,
1031\Table handler for \%-.64s\ doesn\t have this option\,
1032\Can\t find record in \%-.64s\,
1033\Incorrect information in file: \%-.64s\,
1034\Incorrect key file for table: \%-.64s\. Try to repair it\,
1035\Old key file for table \%-.64s\; Repair it!\,
1036\Table \%-.64s\ 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 \%-.64s\ (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: \%-.32s@%-.64s\ to database \%-.64s\,
1045\Access denied for user: \%-.32s@%-.64s\ (Using password: %s)\,
1046\No Database Selected\,
1047\Unknown command\,
1048\Column \%-.64s\ cannot be null\,
1049\Unknown database \%-.64s\,
1050\Table \%-.64s\ already exists\,
1051\Unknown table \%-.64s\,
1052\Column: \%-.64s\ in %-.64s is ambiguous\,
1053\Server shutdown in progress\,
1054\Unknown column \%-.64s\ in \%-.64s\,
1055\%-.64s\ isn\t in GROUP BY\,
1056\Can\t group on \%-.64s\,
1057\Statement has sum functions and columns in same statement\,
1058\Column count doesn\t match value count\,
1059\Identifier name \%-.100s\ is too long\,
1060\Duplicate column name \%-.64s\,
1061\Duplicate key name \%-.64s\,
1062\Duplicate entry \%-.64s\ for key %d\,
1063\Incorrect column specifier for column \%-.64s\,
1064\%s near \%-.80s\ at line %d\,
1065\Query was empty\,
1066\Not unique table/alias: \%-.64s\,
1067\Invalid default value for \%-.64s\,
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 \%-.64s\ doesn\t exist in table\,
1073\BLOB column \%-.64s\ can\t be used in key specification with the used table type\,
1074\Too big column length for column \%-.64s\ (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\n\,
1077\%s: Normal shutdown\n\,
1078\%s: Got signal %d. Aborting!\n\,
1079\%s: Shutdown Complete\n\,
1080\%s: Forcing close of thread %ld user: \%-.32s\n\,
1081\Can\t create IP socket\,
1082\Table \%-.64s\ 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 \%-.64s\ must be in the database directory or be readable by all\,
1086\File \%-.80s\ 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 table handler doesn\t support unique sub keys\,
1090\You can\t delete all columns with ALTER TABLE. Use DROP TABLE instead\,
1091\Can\t DROP \%-.64s\. Check that column/key exists\,
1092\Records: %ld Duplicates: %ld Warnings: %ld\,
1093\INSERT TABLE \%-.64s\ isn\t allowed in FROM table list\,
1094\Unknown thread id: %lu\,
1095\You are not owner of thread %lu\,
1096\No tables used\,
1097\Too many strings for column %-.64s and SET\,
1098\Can\t generate a unique log-filename %-.64s.(1-999)\n\,
1099\Table \%-.64s\ was locked with a READ lock and can\t be updated\,
1100\Table \%-.64s\ was not locked with LOCK TABLES\,
1101\BLOB column \%-.64s\ can\t have a default value\,
1102\Incorrect database name \%-.100s\,
1103\Incorrect table name \%-.100s\,
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\,
1105\Unknown error\,
1106\Unknown procedure \%-.64s\,
1107\Incorrect parameter count to procedure \%-.64s\,
1108\Incorrect parameters to procedure \%-.64s\,
1109\Unknown table \%-.64s\ in %-.32s\,
1110\Column \%-.64s\ specified twice\,
1111\Invalid use of group function\,
1112\Table \%-.64s\ uses an extension that doesn\t exist in this MySQL version\,
1113\A table must have at least 1 column\,
1114\The table \%-.64s\ is full\,
1115\Unknown character set: \%-.64s\,
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, not counting BLOBs, is %d. You have to change some fields to 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 \%-.64s\ is used with UNIQUE or INDEX but is not defined as NOT NULL\,
1122\Can\t load function \%-.64s\,
1123\Can\t initialize function \%-.64s\; %-.80s\,
1124\No paths allowed for shared library\,
1125\Function \%-.64s\ already exist\,
1126\Can\t open shared library \%-.64s\ (errno: %d %-.64s)\,
1127\Can\t find function \%-.64s\ in library\,
1128\Function \%-.64s\ is not defined\,
1129\Host \%-.64s\ is blocked because of many connection errors. Unblock with \mysqladmin flush-hosts\,
1130\Host \%-.64s\ 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: \%-.64s\,
1138\Invalid use of NULL value\,
1139\Got error \%-.64s\ 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 \%-.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\,
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 \%-.64s.%-.64s\ doesn\t exist\,
1147\There is no such grant defined for user \%-.32s\ on host \%-.64s\ on table \%-.64s\,
1148\The used command is not allowed with this MySQL version\,
1149\You have an error in your SQL syntax\,
1150\Delayed insert thread couldn\t get requested lock for table %-.64s\,
1151\Too many delayed threads in use\,
1152\Aborted connection %ld to db: \%-.64s\ user: \%-.32s\ (%-.64s)\,
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 \%-.64s\, because it is locked with LOCK TABLES\,
1166\Incorrect column name \%-.100s\,
1167\The used table handler can\t index column \%-.64s\,
1168\All tables in the MERGE table are not identically defined\,
1169\Can\t write, because of unique constraint, to table \%-.64s\,
1170\BLOB column \%-.64s\ 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 \%-.64s\ doesn\t exist in table \%-.64s\,
1177\Can\t open table\,
1178\The handler for the table doesn\t support check/repair\,
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: \%-.64s\ user: \%-.32s\ host: `%-.64s\ (%-.64s)\,
1185\The handler for the table does not support binary table dump\,
1186\Binlog closed, cannot RESET MASTER\,
1187\Failed rebuilding the index of dumped table \%-.64s\,
1188\Error from master: \%-.64s\,
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 \%-.64\,
1194\Table \%-.64s\ is marked as crashed and should be repaired\,
1195\Table \%-.64s\ is marked as crashed and last (automatic?) repair failed\,
1196\Warning: 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 SLAVE STOP first\,
1199\This operation requires a running slave, configure slave and do SLAVE START\,
1200\The server is not configured as slave, fix in config file or with CHANGE MASTER TO\,
1201\Could not initialize master info structure, check permisions on master.info\,
1202\Could not create slave thread, check system resources\,
1203\User %-.64s 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\%-.32s@%-.64s 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 a child row: a foreign key constraint fails\,
1217\Cannot delete a parent row: a foreign key constraint fails\,