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

eagleshi

　　经常见到网友在发一些关于mysql操作出错的解决方法，现在整理一下。mysqlperformanceblog上明确说了，mysql里面出现的errno(操作系统级别的错误)没有经过任何改变，仅仅是封了一个错误代码，然后呈现给用户。下面是手册上对这些操作系统级别错误和其对应错误代码解释：
　　Linux平台：
　　

• NumberMacroDescription1EPERMOperation not permitted2ENOENTNo such file or directory3ESRCHNo such process4EINTRInterrupted system call5EIOI/O error6ENXIONo such device or address7E2BIGArg list too long8ENOEXECExec format error9EBADFBad file number10ECHILDNo child processes11EAGAINTry again12ENOMEMOut of memory13EACCESPermission denied14EFAULTBad address15ENOTBLKBlock device required16EBUSYDevice or resource busy17EEXISTFile exists18EXDEVCross-device link19ENODEVNo such device20ENOTDIRNot a directory21EISDIRIs a directory22EINVALInvalid argument23ENFILEFile table overflow24EMFILEToo many open files25ENOTTYInappropriate ioctl for device26ETXTBSYText file busy27EFBIGFile too large28ENOSPCNo space left on device29ESPIPEIllegal seek30EROFSRead-only file system31EMLINKToo many links
  
  windows平台：
  
  
  
  • NumberMacroDescription1ERROR_INVALID_FUNCTIONIncorrect function.2ERROR_FILE_NOT_FOUNDThe system cannot find the file specified.3ERROR_PATH_NOT_FOUNDThe system cannot find the path specified.4ERROR_TOO_MANY_OPEN_FILESThe system cannot open the file.5ERROR_ACCESS_DENIEDAccess is denied.6ERROR_INVALID_HANDLEThe handle is invalid.7ERROR_ARENA_TRASHEDThe storage control blocks were destroyed.8ERROR_NOT_ENOUGH_MEMORYNot enough storage is available to process this command.9ERROR_INVALID_BLOCKThe storage control block address is invalid.10ERROR_BAD_ENVIRONMENTThe environment is incorrect.11ERROR_BAD_FORMATAn attempt was made to load a program with an incorrect format.12ERROR_INVALID_ACCESSThe access code is invalid.13ERROR_INVALID_DATAThe data is invalid.14ERROR_OUTOFMEMORYNot enough storage is available to complete this operation.15ERROR_INVALID_DRIVEThe system cannot find the drive specified.16ERROR_CURRENT_DIRECTORYThe directory cannot be removed.17ERROR_NOT_SAME_DEVICEThe system cannot move the file to a different disk drive.18ERROR_NO_MORE_FILESThere are no more files.19ERROR_WRITE_PROTECTThe media is write protected.20ERROR_BAD_UNITThe system cannot find the device specified.21ERROR_NOT_READYThe device is not ready.22ERROR_BAD_COMMANDThe device does not recognize the command.23ERROR_CRCData error (cyclic redundancy check).24ERROR_BAD_LENGTHThe program issued a command but the command length is incorrect.25ERROR_SEEKThe drive cannot locate a specific area or track on the disk.26ERROR_NOT_DOS_DISKThe specified disk or diskette cannot be accessed.27ERROR_SECTOR_NOT_FOUNDThe drive cannot find the sector requested.28ERROR_OUT_OF_PAPERThe printer is out of paper.29ERROR_WRITE_FAULTThe system cannot write to the specified device.30ERROR_READ_FAULTThe system cannot read from the specified device.31ERROR_GEN_FAILUREA device attached to the system is not functioning.32ERROR_SHARING_VIOLATIONThe process cannot access the file because it is being used by another process.33ERROR_LOCK_VIOLATIONThe process cannot access the file because another process has locked a portion of the file.34ERROR_WRONG_DISKThe wrong diskette is in the drive. Insert %2 (Volume Serial Number: %3) into drive %1.36ERROR_SHARING_BUFFER_EXCEEDEDToo many files opened for sharing.38ERROR_HANDLE_EOFReached the end of the file.39ERROR_HANDLE_DISK_FULLThe disk is full.87ERROR_INVALID_PARAMETERThe parameter is incorrect.112ERROR_DISK_FULLThe disk is full.123ERROR_INVALID_NAMEThe file name, directory name, or volume label syntax is incorrect.1450ERROR_NO_SYSTEM_RESOURCESInsufficient system resources exist to complete the requested service.
    
    有了这些错误代码，我想解决很多问题就简单多了,，另外需要注意，os级别的错误指的是errno，而不是ERROR xxx(HY000)这个错误代码，后者是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/