MySQL 8.4 Error Message Reference
This document lists “global” error messages that are shared in the sense that they can be produced by the MySQL server or by MySQL client programs. These errors have error codes in the range from 1 to 999.
Each global error message includes an error code, SQLSTATE value,
and message string, as described in
Error Message Sources and Elements. These elements are
available as described in Error Information Interfaces. For
global errors, the SQLSTATE value is always
'HY000'
(general error), so it is not
meaningful for distinguishing one client error from another.
If the server writes a message to the error log that has a global
error code, it pads the error code with leading zeros to six
digits and adds a prefix of MY-
(example:
MY-000022
).
The following list displays error codes in that format.
If a client returns a message with a global error code, it adds no zero-padding or prefix to the error code.
Error number: 1
; Symbol:
EE_CANTCREATEFILE
;
Message: Can't create/write to file '%s' (OS errno %d - %s)
Error number: 2
; Symbol:
EE_READ
;
Message: Error reading file '%s' (OS errno %d - %s)
Error number: 3
; Symbol:
EE_WRITE
;
Message: Error writing file '%s' (OS errno %d - %s)
Error number: 4
; Symbol:
EE_BADCLOSE
;
Message: Error on close of '%s' (OS errno %d - %s)
Error number: 5
; Symbol:
EE_OUTOFMEMORY
;
Message: Out of memory (Needed %u bytes)
Error number: 6
; Symbol:
EE_DELETE
;
Message: Error on delete of '%s' (OS errno %d - %s)
Error number: 7
; Symbol:
EE_LINK
;
Message: Error on rename of '%s' to '%s' (OS errno %d - %s)
Error number: 9
; Symbol:
EE_EOFERR
;
Message: Unexpected EOF found when reading file '%s' (OS errno %d - %s)
Error number: 10
; Symbol:
EE_CANTLOCK
;
Message: Can't lock file (OS errno %d - %s)
Error number: 11
; Symbol:
EE_CANTUNLOCK
;
Message: Can't unlock file (OS errno %d - %s)
Error number: 12
; Symbol:
EE_DIR
;
Message: Can't read dir of '%s' (OS errno %d - %s)
Error number: 13
; Symbol:
EE_STAT
;
Message: Can't get stat of '%s' (OS errno %d - %s)
Error number: 14
; Symbol:
EE_CANT_CHSIZE
;
Message: Can't change size of file (OS errno %d - %s)
Error number: 15
; Symbol:
EE_CANT_OPEN_STREAM
;
Message: Can't open stream from handle (OS errno %d - %s)
Error number: 16
; Symbol:
EE_GETWD
;
Message: Can't get working directory (OS errno %d - %s)
Error number: 17
; Symbol:
EE_SETWD
;
Message: Can't change dir to '%s' (OS errno %d - %s)
Error number: 18
; Symbol:
EE_LINK_WARNING
;
Message: Warning: '%s' had %d links
Error number: 19
; Symbol:
EE_OPEN_WARNING
;
Message: Warning: %d files and %d streams are left open
Error number: 20
; Symbol:
EE_DISK_FULL
;
Message: Disk is full writing '%s' (OS errno %d - %s). Waiting for someone to free space...
Error number: 21
; Symbol:
EE_CANT_MKDIR
;
Message: Can't create directory '%s' (OS errno %d - %s)
Error number: 22
; Symbol:
EE_UNKNOWN_CHARSET
;
Message: Character set '%s' is not a compiled character set and is not specified in the '%s' file
Error number: 23
; Symbol:
EE_OUT_OF_FILERESOURCES
;
Message: Out of resources when opening file '%s' (OS errno %d - %s)
Error number: 24
; Symbol:
EE_CANT_READLINK
;
Message: Can't read value for symlink '%s' (Error %d - %s)
Error number: 25
; Symbol:
EE_CANT_SYMLINK
;
Message: Can't create symlink '%s' pointing at '%s' (Error %d - %s)
Error number: 26
; Symbol:
EE_REALPATH
;
Message: Error on realpath() on '%s' (Error %d - %s)
Error number: 27
; Symbol:
EE_SYNC
;
Message: Can't sync file '%s' to disk (OS errno %d - %s)
Error number: 28
; Symbol:
EE_UNKNOWN_COLLATION
;
Message: Collation '%s' is not a compiled collation and is not specified in the '%s' file
Error number: 29
; Symbol:
EE_FILENOTFOUND
;
Message: File '%s' not found (OS errno %d - %s)
Error number: 30
; Symbol:
EE_FILE_NOT_CLOSED
;
Message: File '%s' (fileno: %d) was not closed
Error number: 31
; Symbol:
EE_CHANGE_OWNERSHIP
;
Message: Cannot change ownership of the file '%s' (OS errno %d - %s)
Error number: 32
; Symbol:
EE_CHANGE_PERMISSIONS
;
Message: Cannot change permissions of the file '%s' (OS errno %d - %s)
Error number: 33
; Symbol:
EE_CANT_SEEK
;
Message: Cannot seek in file '%s' (OS errno %d - %s)
Error number: 34
; Symbol:
EE_CAPACITY_EXCEEDED
;
Message: Memory capacity exceeded (capacity %llu bytes)
Error number: 35
; Symbol:
EE_DISK_FULL_WITH_RETRY_MSG
;
Message: Disk is full writing '%s' (OS errno %d - %s). Waiting for someone to free space... Retry in %d secs. Message reprinted in %d secs.
Error number: 36
; Symbol:
EE_FAILED_TO_CREATE_TIMER
;
Message: Failed to create timer (OS errno %d).
Error number: 37
; Symbol:
EE_FAILED_TO_DELETE_TIMER
;
Message: Failed to delete timer (OS errno %d).
Error number: 38
; Symbol:
EE_FAILED_TO_CREATE_TIMER_QUEUE
;
Message: Failed to create timer queue (OS errno %d).
Error number: 39
; Symbol:
EE_FAILED_TO_START_TIMER_NOTIFY_THREAD
;
Message: Failed to start timer notify thread.
Error number: 40
; Symbol:
EE_FAILED_TO_CREATE_TIMER_NOTIFY_THREAD_INTERRUPT_EVENT
;
Message: Failed to create event to interrupt timer notifier thread (OS errno %d).
Error number: 41
; Symbol:
EE_EXITING_TIMER_NOTIFY_THREAD
;
Message: Failed to register timer event with queue (OS errno %d), exiting timer notifier thread.
Error number: 42
; Symbol:
EE_WIN_LIBRARY_LOAD_FAILED
;
Message: LoadLibrary("kernel32.dll") failed: GetLastError returns %lu.
Error number: 43
; Symbol:
EE_WIN_RUN_TIME_ERROR_CHECK
;
Message: %s.
Error number: 44
; Symbol:
EE_FAILED_TO_DETERMINE_LARGE_PAGE_SIZE
;
Message: Failed to determine large page size.
Error number: 45
; Symbol:
EE_FAILED_TO_KILL_ALL_THREADS
;
Message: Error in my_thread_global_end(): %d thread(s) did not exit.
Error number: 46
; Symbol:
EE_FAILED_TO_CREATE_IO_COMPLETION_PORT
;
Message: Failed to create IO completion port (OS errno %d).
Error number: 47
; Symbol:
EE_FAILED_TO_OPEN_DEFAULTS_FILE
;
Message: Failed to open required defaults file: %s
Error number: 48
; Symbol:
EE_FAILED_TO_HANDLE_DEFAULTS_FILE
;
Message: Fatal error in defaults handling. Program aborted!
Error number: 49
; Symbol:
EE_WRONG_DIRECTIVE_IN_CONFIG_FILE
;
Message: Wrong '!%s' directive in config file %s at line %d.
Error number: 50
; Symbol:
EE_SKIPPING_DIRECTIVE_DUE_TO_MAX_INCLUDE_RECURSION
;
Message: Skipping '%s' directive as maximum include recursion level was reached in file %s at line %d.
Error number: 51
; Symbol:
EE_INCORRECT_GRP_DEFINITION_IN_CONFIG_FILE
;
Message: Wrong group definition in config file %s at line %d.
Error number: 52
; Symbol:
EE_OPTION_WITHOUT_GRP_IN_CONFIG_FILE
;
Message: Found option without preceding group in config file %s at line %d.
Error number: 53
; Symbol:
EE_CONFIG_FILE_PERMISSION_ERROR
;
Message: %s should be readable/writable only by current user.
Error number: 54
; Symbol:
EE_IGNORE_WORLD_WRITABLE_CONFIG_FILE
;
Message: World-writable config file '%s' is ignored.
Error number: 55
; Symbol:
EE_USING_DISABLED_OPTION
;
Message: %s: Option '%s' was used, but is disabled.
Error number: 56
; Symbol:
EE_USING_DISABLED_SHORT_OPTION
;
Message: %s: Option '-%c' was used, but is disabled.
Error number: 57
; Symbol:
EE_USING_PASSWORD_ON_CLI_IS_INSECURE
;
Message: Using a password on the command line interface can be insecure.
Error number: 58
; Symbol:
EE_UNKNOWN_SUFFIX_FOR_VARIABLE
;
Message: Unknown suffix '%c' used for variable '%s' (value '%s').
Error number: 59
; Symbol:
EE_SSL_ERROR_FROM_FILE
;
Message: SSL error: %s from '%s'.
Error number: 60
; Symbol:
EE_SSL_ERROR
;
Message: SSL error: %s.
Error number: 61
; Symbol:
EE_NET_SEND_ERROR_IN_BOOTSTRAP
;
Message: %d %s.
Error number: 62
; Symbol:
EE_PACKETS_OUT_OF_ORDER
;
Message: Packets out of order (found %u, expected %u).
Error number: 63
; Symbol:
EE_UNKNOWN_PROTOCOL_OPTION
;
Message: Unknown option to protocol: %s.
Error number: 64
; Symbol:
EE_FAILED_TO_LOCATE_SERVER_PUBLIC_KEY
;
Message: Failed to locate server public key '%s'.
Error number: 65
; Symbol:
EE_PUBLIC_KEY_NOT_IN_PEM_FORMAT
;
Message: Public key is not in Privacy Enhanced Mail format: '%s'.
Error number: 66
; Symbol:
EE_DEBUG_INFO
;
Message: %s.
Error number: 67
; Symbol:
EE_UNKNOWN_VARIABLE
;
Message: unknown variable '%s'.
Error number: 68
; Symbol:
EE_UNKNOWN_OPTION
;
Message: unknown option '--%s'.
Error number: 69
; Symbol:
EE_UNKNOWN_SHORT_OPTION
;
Message: %s: unknown option '-%c'.
Error number: 70
; Symbol:
EE_OPTION_WITHOUT_ARGUMENT
;
Message: %s: option '--%s' cannot take an argument.
Error number: 71
; Symbol:
EE_OPTION_REQUIRES_ARGUMENT
;
Message: %s: option '--%s' requires an argument.
Error number: 72
; Symbol:
EE_SHORT_OPTION_REQUIRES_ARGUMENT
;
Message: %s: option '-%c' requires an argument.
Error number: 73
; Symbol:
EE_OPTION_IGNORED_DUE_TO_INVALID_VALUE
;
Message: %s: ignoring option '--%s' due to invalid value '%s'.
Error number: 74
; Symbol:
EE_OPTION_WITH_EMPTY_VALUE
;
Message: %s: Empty value for '%s' specified.
Error number: 75
; Symbol:
EE_FAILED_TO_ASSIGN_MAX_VALUE_TO_OPTION
;
Message: %s: Maximum value of '%s' cannot be set.
Error number: 76
; Symbol:
EE_INCORRECT_BOOLEAN_VALUE_FOR_OPTION
;
Message: option '%s': boolean value '%s' was not recognized. Set to OFF.
Error number: 77
; Symbol:
EE_FAILED_TO_SET_OPTION_VALUE
;
Message: %s: Error while setting value '%s' to '%s'.
Error number: 78
; Symbol:
EE_INCORRECT_INT_VALUE_FOR_OPTION
;
Message: Incorrect integer value: '%s'.
Error number: 79
; Symbol:
EE_INCORRECT_UINT_VALUE_FOR_OPTION
;
Message: Incorrect unsigned integer value: '%s'.
Error number: 80
; Symbol:
EE_ADJUSTED_SIGNED_VALUE_FOR_OPTION
;
Message: option '%s': signed value %s adjusted to %s.
Error number: 81
; Symbol:
EE_ADJUSTED_UNSIGNED_VALUE_FOR_OPTION
;
Message: option '%s': unsigned value %s adjusted to %s.
Error number: 82
; Symbol:
EE_ADJUSTED_ULONGLONG_VALUE_FOR_OPTION
;
Message: option '%s': value %s adjusted to %s.
Error number: 83
; Symbol:
EE_ADJUSTED_DOUBLE_VALUE_FOR_OPTION
;
Message: option '%s': value %g adjusted to %g.
Error number: 84
; Symbol:
EE_INVALID_DECIMAL_VALUE_FOR_OPTION
;
Message: Invalid decimal value for option '%s'.
Error number: 85
; Symbol:
EE_COLLATION_PARSER_ERROR
;
Message: %s.
Error number: 86
; Symbol:
EE_FAILED_TO_RESET_BEFORE_PRIMARY_IGNORABLE_CHAR
;
Message: Failed to reset before a primary ignorable character %s.
Error number: 87
; Symbol:
EE_FAILED_TO_RESET_BEFORE_TERTIARY_IGNORABLE_CHAR
;
Message: Failed to reset before a tertiary ignorable character %s.
Error number: 88
; Symbol:
EE_SHIFT_CHAR_OUT_OF_RANGE
;
Message: Shift character out of range: %s.
Error number: 89
; Symbol:
EE_RESET_CHAR_OUT_OF_RANGE
;
Message: Reset character out of range: %s.
Error number: 90
; Symbol:
EE_UNKNOWN_LDML_TAG
;
Message: Unknown LDML tag: '%.*s'.
Error number: 91
; Symbol:
EE_FAILED_TO_RESET_BEFORE_SECONDARY_IGNORABLE_CHAR
;
Message: Failed to reset before a secondary ignorable character %s.
Error number: 92
; Symbol:
EE_FAILED_PROCESSING_DIRECTIVE
;
Message: Stopped processing the '%s' directive in file %s at line %d.
Error number: 93
; Symbol:
EE_PTHREAD_KILL_FAILED
;
Message: pthread_kill(thread_id:%lu, signal:%s) returned '%s'.