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\,
