欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

MySQL中操作系统级别错误代码与其含义

程序员文章站 2022-04-25 19:37:41
...

经常见到网友在发一些关于mysql操作出错的解决方法,现在整理一下。mysqlperformanceblog上明确说了,mysql里面出现的errno(操作

  • 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,而不是ERROR xxx(HY000)这个错误代码,后者是mysql自身的。