mysqlのオペレーティングシステムレベルのエラーコードとその意味
5992 ワード
よく見られるネットユーザーはmysqlの操作ミスの解決方法について、今整理しています.mysqlperformanceblogでは、mysqlに表示されるerrno(オペレーティングシステムレベルのエラー)は変更されず、エラーコードを1つ封印してユーザーに提示するだけだと明らかにしています.次のマニュアルでは、これらのOSレベルのエラーと対応するエラーコードについて説明します.
Linuxプラットフォーム:
Number
Macro
Description
1
Operation not permitted
2
No such file or directory
3
No such process
4
Interrupted system call
5
I/O error
6
No such device or address
7
Arg list too long
8
Exec format error
9
Bad file number
10
No child processes
11
Try again
12
Out of memory
13
Permission denied
14
Bad address
15
Block device required
16
Device or resource busy
17
File exists
18
Cross-device link
19
No such device
20
Not a directory
21
Is a directory
22
Invalid argument
23
File table overflow
24
Too many open files
25
Inappropriate ioctl for device
26
Text file busy
27
File too large
28
No space left on device
29
Illegal seek
30
Read-only file system
31
Too many links
Windowsプラットフォーム:
Number
Macro
Description
1
Incorrect function.
2
The system cannot find the file specified.
3
The system cannot find the path specified.
4
The system cannot open the file.
5
Access is denied.
6
The handle is invalid.
7
The storage control blocks were destroyed.
8
Not enough storage is available to process this command.
9
The storage control block address is invalid.
10
The environment is incorrect.
11
An attempt was made to load a program with an incorrect format.
12
The access code is invalid.
13
The data is invalid.
14
Not enough storage is available to complete this operation.
15
The system cannot find the drive specified.
16
The directory cannot be removed.
17
The system cannot move the file to a different disk drive.
18
There are no more files.
19
The media is write protected.
20
The system cannot find the device specified.
21
The device is not ready.
22
The device does not recognize the command.
23
Data error (cyclic redundancy check).
24
The program issued a command but the command length is incorrect.
25
The drive cannot locate a specific area or track on the disk.
26
The specified disk or diskette cannot be accessed.
27
The drive cannot find the sector requested.
28
The printer is out of paper.
29
The system cannot write to the specified device.
30
The system cannot read from the specified device.
31
A device attached to the system is not functioning.
32
The process cannot access the file because it is being used by another process.
33
The process cannot access the file because another process has locked a portion of the file.
34
The wrong diskette is in the drive. Insert %2 (Volume Serial Number: %3) into drive %1.
36
Too many files opened for sharing.
38
Reached the end of the file.
39
The disk is full.
87
The parameter is incorrect.
112
The disk is full.
123
The file name, directory name, or volume label syntax is incorrect.
1450
Insufficient system resources exist to complete the requested service.
これらのエラーコードがあれば、多くの問題を解決するのは簡単だと思います.また、osレベルのエラーはerrnoではなくerrnoを指していることに注意してください.
ERROR xxx(HY 000)というエラーコードで、後者はmysql自身のものです.
参考記事:
1. http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html
2. http://www.mysqlperformanceblog.com/2012/03/26/how-to-diagnose-errors-in-the-mysql-error-log/
Linuxプラットフォーム:
Number
Macro
Description
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
Windowsプラットフォーム:
Number
Macro
Description
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.
112
ERROR_DISK_FULL The disk is full.
123
ERROR_INVALID_NAME The file name, directory name, or volume label syntax is incorrect.
1450
ERROR_NO_SYSTEM_RESOURCES Insufficient system resources exist to complete the requested service.
これらのエラーコードがあれば、多くの問題を解決するのは簡単だと思います.また、osレベルのエラーはerrnoではなくerrnoを指していることに注意してください.
ERROR xxx(HY 000)というエラーコードで、後者はmysql自身のものです.
参考記事:
1. http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html
2. http://www.mysqlperformanceblog.com/2012/03/26/how-to-diagnose-errors-in-the-mysql-error-log/