Skip navigation links
13.6.13 InnoDB Performance Tuning and Troubleshooting »
Section Navigation      [Toggle]

13.6.12.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.

  • Linux System Error Codes

    The following table provides a list of some common Linux system error codes. For a more complete list, see Linux source code.

    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 System Error Codes

    The following table provides a list of some common Windows system error codes. For a complete list, see the Microsoft Web site.

    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.

User Comments

Posted by Peter Beckman on August 23 2005 1:41pm[Delete] [Edit]

On FreeBSD 5.x, there is a hard limit default compiled into the kernel which limits the amount of memory a process can use to 512MB. You can see this by running the command "limits."

You can, without recompiling the kernel, increase this per process memory limit to something higher, but absolutely below your physical memory. I.e. if you have 1GB of memory, do not set your per process memory limit equal to or higher than that! FreeBSD 5.x will crash and not be able to be recovered without a local change being made if you set that limit higher than the amount of physical memory . (FreeBSD Bug: http://www.freebsd.org/cgi/query-pr.cgi?pr=84656)

In /boot/loader.conf, add these lines (on a 1.5GB box or greater):
kern.maxdsiz="1073741824" # 1GB
kern.dfldsiz="1073741824" # 1GB
kern.maxssiz="134217728" # 128MB

Then reboot, and increase your my.cnf memory configuration values in order to increase mysql memory usage.

The error you might see (related here since the Operating system error number is 12 (ENOMEM) Out of memory:

InnoDB: Error: cannot allocate 797284 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 6299504 bytes. Operating system errno: 12
InnoDB: Check if you should increase the swap file or
InnoDB: ulimits of your operating system.
InnoDB: On FreeBSD check you have compiled the OS with
InnoDB: a big enough maximum process size.
InnoDB: We keep retrying the allocation for 60 seconds...
InnoDB: Fatal error: cannot allocate the memory for the buffer pool

Add your own comment.