13.2.15.2. Operating System Error Codes
To print the meaning of an operating system error number, use the perror program that comes with the MySQL distribution.
The following table provides a list of some common Linux system error codes. For a more complete list, see Linux source code.
1 (EPERM)Operation not permitted
2 (ENOENT)No such file or directory
3 (ESRCH)No such process
4 (EINTR)Interrupted system call
5 (EIO)I/O error
6 (ENXIO)No such device or address
7 (E2BIG)Arg list too long
8 (ENOEXEC)Exec format error
9 (EBADF)Bad file number
10 (ECHILD)No child processes
11 (EAGAIN)Try again
12 (ENOMEM)Out of memory
13 (EACCES)Permission denied
14 (EFAULT)Bad address
15 (ENOTBLK)Block device required
16 (EBUSY)Device or resource busy
17 (EEXIST)File exists
18 (EXDEV)Cross-device link
19 (ENODEV)No such device
20 (ENOTDIR)Not a directory
21 (EISDIR)Is a directory
22 (EINVAL)Invalid argument
23 (ENFILE)File table overflow
24 (EMFILE)Too many open files
25 (ENOTTY)Inappropriate ioctl for device
26 (ETXTBSY)Text file busy
27 (EFBIG)File too large
28 (ENOSPC)No space left on device
29 (ESPIPE)Illegal seek
30 (EROFS)Read-only file system
31 (EMLINK)Too many links
The following table provides a list of some common Windows system error codes. For a complete list see the Microsoft Web site.
1 (ERROR_INVALID_FUNCTION)Incorrect function.
2 (ERROR_FILE_NOT_FOUND)The system cannot find the file specified.
3 (ERROR_PATH_NOT_FOUND)The system cannot find the path specified.
4 (ERROR_TOO_MANY_OPEN_FILES)The system cannot open the file.
5 (ERROR_ACCESS_DENIED)Access is denied.
6 (ERROR_INVALID_HANDLE)The handle is invalid.
7 (ERROR_ARENA_TRASHED)The storage control blocks were destroyed.
8 (ERROR_NOT_ENOUGH_MEMORY)Not enough storage is available to process this command.
9 (ERROR_INVALID_BLOCK)The storage control block address is invalid.
10 (ERROR_BAD_ENVIRONMENT)The environment is incorrect.
11 (ERROR_BAD_FORMAT)An attempt was made to load a program with an incorrect format.
12 (ERROR_INVALID_ACCESS)The access code is invalid.
13 (ERROR_INVALID_DATA)The data is invalid.
14 (ERROR_OUTOFMEMORY)Not enough storage is available to complete this operation.
15 (ERROR_INVALID_DRIVE)The system cannot find the drive specified.
16 (ERROR_CURRENT_DIRECTORY)The directory cannot be removed.
17 (ERROR_NOT_SAME_DEVICE)The system cannot move the file to a different disk drive.
18 (ERROR_NO_MORE_FILES)There are no more files.
19 (ERROR_WRITE_PROTECT)The media is write protected.
20 (ERROR_BAD_UNIT)The system cannot find the device specified.
21 (ERROR_NOT_READY)The device is not ready.
22 (ERROR_BAD_COMMAND)The device does not recognize the command.
23 (ERROR_CRC)Data error (cyclic redundancy check).
24 (ERROR_BAD_LENGTH)The program issued a command but the command length is incorrect.
25 (ERROR_SEEK)The drive cannot locate a specific area or track on the disk.
26 (ERROR_NOT_DOS_DISK)The specified disk or diskette cannot be accessed.
27 (ERROR_SECTOR_NOT_FOUND)The drive cannot find the sector requested.
28 (ERROR_OUT_OF_PAPER)The printer is out of paper.
29 (ERROR_WRITE_FAULT)The system cannot write to the specified device.
30 (ERROR_READ_FAULT)The system cannot read from the specified device.
31 (ERROR_GEN_FAILURE)A device attached to the system is not functioning.
32 (ERROR_SHARING_VIOLATION)The process cannot access the file because it is being used by another process.
33 (ERROR_LOCK_VIOLATION)To print the meaning of an operating system error number, use the perror program that comes with the MySQL distribution.
The following table provides a list of some common Linux system error codes. For a more complete list, see Linux source code.
1 (EPERM)Operation not permitted
2 (ENOENT)No such file or directory
3 (ESRCH)No such process
4 (EINTR)Interrupted system call
5 (EIO)I/O error
6 (ENXIO)No such device or address
7 (E2BIG)Arg list too long
8 (ENOEXEC)Exec format error
9 (EBADF)Bad file number
10 (ECHILD)No child processes
11 (EAGAIN)Try again
12 (ENOMEM)Out of memory
13 (EACCES)Permission denied
14 (EFAULT)Bad address
15 (ENOTBLK)Block device required
16 (EBUSY)Device or resource busy
17 (EEXIST)File exists
18 (EXDEV)Cross-device link
19 (ENODEV)No such device
20 (ENOTDIR)Not a directory
21 (EISDIR)Is a directory
22 (EINVAL)Invalid argument
23 (ENFILE)File table overflow
24 (EMFILE)Too many open files
25 (ENOTTY)Inappropriate ioctl for device
26 (ETXTBSY)Text file busy
27 (EFBIG)File too large
28 (ENOSPC)No space left on device
29 (ESPIPE)Illegal seek
30 (EROFS)Read-only file system
31 (EMLINK)Too many links
The following table provides a list of some common Windows system error codes. For a complete list see the Microsoft Web site.
1 (ERROR_INVALID_FUNCTION)Incorrect function.
2 (ERROR_FILE_NOT_FOUND)The system cannot find the file specified.
3 (ERROR_PATH_NOT_FOUND)The system cannot find the path specified.
4 (ERROR_TOO_MANY_OPEN_FILES)The system cannot open the file.
5 (ERROR_ACCESS_DENIED)Access is denied.
6 (ERROR_INVALID_HANDLE)The handle is invalid.
7 (ERROR_ARENA_TRASHED)The storage control blocks were destroyed.
8 (ERROR_NOT_ENOUGH_MEMORY)Not enough storage is available to process this command.
9 (ERROR_INVALID_BLOCK)The storage control block address is invalid.
10 (ERROR_BAD_ENVIRONMENT)The environment is incorrect.
11 (ERROR_BAD_FORMAT)An attempt was made to load a program with an incorrect format.
12 (ERROR_INVALID_ACCESS)The access code is invalid.
13 (ERROR_INVALID_DATA)The data is invalid.
14 (ERROR_OUTOFMEMORY)Not enough storage is available to complete this operation.
15 (ERROR_INVALID_DRIVE)The system cannot find the drive specified.
16 (ERROR_CURRENT_DIRECTORY)The directory cannot be removed.
17 (ERROR_NOT_SAME_DEVICE)The system cannot move the file to a different disk drive.
18 (ERROR_NO_MORE_FILES)There are no more files.
19 (ERROR_WRITE_PROTECT)The media is write protected.
20 (ERROR_BAD_UNIT)The system cannot find the device specified.
21 (ERROR_NOT_READY)The device is not ready.
22 (ERROR_BAD_COMMAND)The device does not recognize the command.
23 (ERROR_CRC)Data error (cyclic redundancy check).
24 (ERROR_BAD_LENGTH)The program issued a command but the command length is incorrect.
25 (ERROR_SEEK)The drive cannot locate a specific area or track on the disk.
26 (ERROR_NOT_DOS_DISK)The specified disk or diskette cannot be accessed.
27 (ERROR_SECTOR_NOT_FOUND)The drive cannot find the sector requested.
28 (ERROR_OUT_OF_PAPER)The printer is out of paper.
29 (ERROR_WRITE_FAULT)The system cannot write to the specified device.
30 (ERROR_READ_FAULT)The system cannot read from the specified device.
31 (ERROR_GEN_FAILURE)A device attached to the system is not functioning.
32 (ERROR_SHARING_VIOLATION)The process cannot access the file because it is being used by another process.
33 (ERROR_LOCK_VIOLATION)The process cannot access the file because another process has locked a portion of the file.
34 (ERROR_WRONG_DISK)The wrong diskette is in the drive. Insert %2 (Volume Serial Number: %3) into drive %1.
36 (ERROR_SHARING_BUFFER_EXCEEDED)Too many files opened for sharing.
38 (ERROR_HANDLE_EOF)Reached the end of the file.
39 (ERROR_HANDLE_DISK_FULL)The disk is full.
87 (ERROR_INVALID_PARAMETER)The parameter is incorrect. (If this error occurs on Windows and you have enabled
innodb_file_per_tablein a server option file, add the lineinnodb_flush_method=unbufferedto the file as well.)112 (ERROR_DISK_FULL)The disk is full.
123 (ERROR_INVALID_NAME)The filename, directory name, or volume label syntax is incorrect.
1450 (ERROR_NO_SYSTEM_RESOURCES)Insufficient system resources exist to complete the requested service.
The process cannot access the file because another process has locked a portion of the file.
34 (ERROR_WRONG_DISK)The wrong diskette is in the drive. Insert %2 (Volume Serial Number: %3) into drive %1.
36 (ERROR_SHARING_BUFFER_EXCEEDED)Too many files opened for sharing.
38 (ERROR_HANDLE_EOF)Reached the end of the file.
39 (ERROR_HANDLE_DISK_FULL)The disk is full.
87 (ERROR_INVALID_PARAMETER)The parameter is incorrect. (If this error occurs on Windows and you have enabled
innodb_file_per_tablein a server option file, add the lineinnodb_flush_method=unbufferedto the file as well.)112 (ERROR_DISK_FULL)The disk is full.
123 (ERROR_INVALID_NAME)The filename, directory name, or volume label syntax is incorrect.
1450 (ERROR_NO_SYSTEM_RESOURCES)Insufficient system resources exist to complete the requested service
'DB' 카테고리의 다른 글
| [DB] mysql 최적화 설계 (펌) (0) | 2010.04.28 |
|---|---|
| [DB] mysql 최적화 #2 (0) | 2010.04.28 |
| [DB] mysql 최적화 #1 (0) | 2010.04.28 |
| [DB] mysql index 정리 (0) | 2010.04.28 |
| [DB] mysql error 메세지 모음 (0) | 2010.04.26 |
