This section 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
Section B.1, “Error Message Sources and Components”. These components are
available as described in Section B.2, “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.
EE_DISK_FULL_WITH_RETRY_MSG
was added in 8.0.13.Error number:
36
; Symbol:EE_FAILED_TO_CREATE_TIMER
;Message: Failed to create timer (OS errno %d).
EE_FAILED_TO_CREATE_TIMER
was added in 8.0.13.Error number:
37
; Symbol:EE_FAILED_TO_DELETE_TIMER
;Message: Failed to delete timer (OS errno %d).
EE_FAILED_TO_DELETE_TIMER
was added in 8.0.13.Error number:
38
; Symbol:EE_FAILED_TO_CREATE_TIMER_QUEUE
;Message: Failed to create timer queue (OS errno %d).
EE_FAILED_TO_CREATE_TIMER_QUEUE
was added in 8.0.13.Error number:
39
; Symbol:EE_FAILED_TO_START_TIMER_NOTIFY_THREAD
;Message: Failed to start timer notify thread.
EE_FAILED_TO_START_TIMER_NOTIFY_THREAD
was added in 8.0.13.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).
EE_FAILED_TO_CREATE_TIMER_NOTIFY_THREAD_INTERRUPT_EVENT
was added in 8.0.13.Error number:
41
; Symbol:EE_EXITING_TIMER_NOTIFY_THREAD
;Message: Failed to register timer event with queue (OS errno %d), exiting timer notifier thread.
EE_EXITING_TIMER_NOTIFY_THREAD
was added in 8.0.13.Error number:
42
; Symbol:EE_WIN_LIBRARY_LOAD_FAILED
;Message: LoadLibrary("kernel32.dll") failed: GetLastError returns %lu.
EE_WIN_LIBRARY_LOAD_FAILED
was added in 8.0.13.Error number:
43
; Symbol:EE_WIN_RUN_TIME_ERROR_CHECK
;Message: %s.
EE_WIN_RUN_TIME_ERROR_CHECK
was added in 8.0.13.Error number:
44
; Symbol:EE_FAILED_TO_DETERMINE_LARGE_PAGE_SIZE
;Message: Failed to determine large page size.
EE_FAILED_TO_DETERMINE_LARGE_PAGE_SIZE
was added in 8.0.13.Error number:
45
; Symbol:EE_FAILED_TO_KILL_ALL_THREADS
;Message: Error in my_thread_global_end(): %d thread(s) did not exit.
EE_FAILED_TO_KILL_ALL_THREADS
was added in 8.0.13.Error number:
46
; Symbol:EE_FAILED_TO_CREATE_IO_COMPLETION_PORT
;Message: Failed to create IO completion port (OS errno %d).
EE_FAILED_TO_CREATE_IO_COMPLETION_PORT
was added in 8.0.13.Error number:
47
; Symbol:EE_FAILED_TO_OPEN_DEFAULTS_FILE
;Message: Failed to open required defaults file: %s
EE_FAILED_TO_OPEN_DEFAULTS_FILE
was added in 8.0.13.Error number:
48
; Symbol:EE_FAILED_TO_HANDLE_DEFAULTS_FILE
;Message: Fatal error in defaults handling. Program aborted!
EE_FAILED_TO_HANDLE_DEFAULTS_FILE
was added in 8.0.13.Error number:
49
; Symbol:EE_WRONG_DIRECTIVE_IN_CONFIG_FILE
;Message: Wrong '!%s' directive in config file %s at line %d.
EE_WRONG_DIRECTIVE_IN_CONFIG_FILE
was added in 8.0.13.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.
EE_SKIPPING_DIRECTIVE_DUE_TO_MAX_INCLUDE_RECURSION
was added in 8.0.13.Error number:
51
; Symbol:EE_INCORRECT_GRP_DEFINITION_IN_CONFIG_FILE
;Message: Wrong group definition in config file %s at line %d.
EE_INCORRECT_GRP_DEFINITION_IN_CONFIG_FILE
was added in 8.0.13.Error number:
52
; Symbol:EE_OPTION_WITHOUT_GRP_IN_CONFIG_FILE
;Message: Found option without preceding group in config file %s at line %d.
EE_OPTION_WITHOUT_GRP_IN_CONFIG_FILE
was added in 8.0.13.Error number:
53
; Symbol:EE_CONFIG_FILE_PERMISSION_ERROR
;Message: %s should be readable/writable only by current user.
EE_CONFIG_FILE_PERMISSION_ERROR
was added in 8.0.13.Error number:
54
; Symbol:EE_IGNORE_WORLD_WRITABLE_CONFIG_FILE
;Message: World-writable config file '%s' is ignored.
EE_IGNORE_WORLD_WRITABLE_CONFIG_FILE
was added in 8.0.13.Error number:
55
; Symbol:EE_USING_DISABLED_OPTION
;Message: %s: Option '%s' was used, but is disabled.
EE_USING_DISABLED_OPTION
was added in 8.0.13.Error number:
56
; Symbol:EE_USING_DISABLED_SHORT_OPTION
;Message: %s: Option '-%c' was used, but is disabled.
EE_USING_DISABLED_SHORT_OPTION
was added in 8.0.13.Error number:
57
; Symbol:EE_USING_PASSWORD_ON_CLI_IS_INSECURE
;Message: Using a password on the command line interface can be insecure.
EE_USING_PASSWORD_ON_CLI_IS_INSECURE
was added in 8.0.13.Error number:
58
; Symbol:EE_UNKNOWN_SUFFIX_FOR_VARIABLE
;Message: Unknown suffix '%c' used for variable '%s' (value '%s').
EE_UNKNOWN_SUFFIX_FOR_VARIABLE
was added in 8.0.13.Error number:
59
; Symbol:EE_SSL_ERROR_FROM_FILE
;Message: SSL error: %s from '%s'.
EE_SSL_ERROR_FROM_FILE
was added in 8.0.13.Error number:
60
; Symbol:EE_SSL_ERROR
;Message: SSL error: %s.
EE_SSL_ERROR
was added in 8.0.13.Error number:
61
; Symbol:EE_NET_SEND_ERROR_IN_BOOTSTRAP
;Message: %d %s.
EE_NET_SEND_ERROR_IN_BOOTSTRAP
was added in 8.0.13.Error number:
62
; Symbol:EE_PACKETS_OUT_OF_ORDER
;Message: Packets out of order (found %u, expected %u).
EE_PACKETS_OUT_OF_ORDER
was added in 8.0.13.Error number:
63
; Symbol:EE_UNKNOWN_PROTOCOL_OPTION
;Message: Unknown option to protocol: %s.
EE_UNKNOWN_PROTOCOL_OPTION
was added in 8.0.13.Error number:
64
; Symbol:EE_FAILED_TO_LOCATE_SERVER_PUBLIC_KEY
;Message: Failed to locate server public key '%s'.
EE_FAILED_TO_LOCATE_SERVER_PUBLIC_KEY
was added in 8.0.13.Error number:
65
; Symbol:EE_PUBLIC_KEY_NOT_IN_PEM_FORMAT
;Message: Public key is not in Privacy Enhanced Mail format: '%s'.
EE_PUBLIC_KEY_NOT_IN_PEM_FORMAT
was added in 8.0.13.Error number:
66
; Symbol:EE_DEBUG_INFO
;Message: %s.
EE_DEBUG_INFO
was added in 8.0.13.Error number:
67
; Symbol:EE_UNKNOWN_VARIABLE
;Message: unknown variable '%s'.
EE_UNKNOWN_VARIABLE
was added in 8.0.13.Error number:
68
; Symbol:EE_UNKNOWN_OPTION
;Message: unknown option '--%s'.
EE_UNKNOWN_OPTION
was added in 8.0.13.Error number:
69
; Symbol:EE_UNKNOWN_SHORT_OPTION
;Message: %s: unknown option '-%c'.
EE_UNKNOWN_SHORT_OPTION
was added in 8.0.13.Error number:
70
; Symbol:EE_OPTION_WITHOUT_ARGUMENT
;Message: %s: option '--%s' cannot take an argument.
EE_OPTION_WITHOUT_ARGUMENT
was added in 8.0.13.Error number:
71
; Symbol:EE_OPTION_REQUIRES_ARGUMENT
;Message: %s: option '--%s' requires an argument.
EE_OPTION_REQUIRES_ARGUMENT
was added in 8.0.13.Error number:
72
; Symbol:EE_SHORT_OPTION_REQUIRES_ARGUMENT
;Message: %s: option '-%c' requires an argument.
EE_SHORT_OPTION_REQUIRES_ARGUMENT
was added in 8.0.13.Error number:
73
; Symbol:EE_OPTION_IGNORED_DUE_TO_INVALID_VALUE
;Message: %s: ignoring option '--%s' due to invalid value '%s'.
EE_OPTION_IGNORED_DUE_TO_INVALID_VALUE
was added in 8.0.13.Error number:
74
; Symbol:EE_OPTION_WITH_EMPTY_VALUE
;Message: %s: Empty value for '%s' specified.
EE_OPTION_WITH_EMPTY_VALUE
was added in 8.0.13.Error number:
75
; Symbol:EE_FAILED_TO_ASSIGN_MAX_VALUE_TO_OPTION
;Message: %s: Maximum value of '%s' cannot be set.
EE_FAILED_TO_ASSIGN_MAX_VALUE_TO_OPTION
was added in 8.0.13.Error number:
76
; Symbol:EE_INCORRECT_BOOLEAN_VALUE_FOR_OPTION
;Message: option '%s': boolean value '%s' was not recognized. Set to OFF.
EE_INCORRECT_BOOLEAN_VALUE_FOR_OPTION
was added in 8.0.13.Error number:
77
; Symbol:EE_FAILED_TO_SET_OPTION_VALUE
;Message: %s: Error while setting value '%s' to '%s'.
EE_FAILED_TO_SET_OPTION_VALUE
was added in 8.0.13.Error number:
78
; Symbol:EE_INCORRECT_INT_VALUE_FOR_OPTION
;Message: Incorrect integer value: '%s'.
EE_INCORRECT_INT_VALUE_FOR_OPTION
was added in 8.0.13.Error number:
79
; Symbol:EE_INCORRECT_UINT_VALUE_FOR_OPTION
;Message: Incorrect unsigned integer value: '%s'.
EE_INCORRECT_UINT_VALUE_FOR_OPTION
was added in 8.0.13.Error number:
80
; Symbol:EE_ADJUSTED_SIGNED_VALUE_FOR_OPTION
;Message: option '%s': signed value %s adjusted to %s.
EE_ADJUSTED_SIGNED_VALUE_FOR_OPTION
was added in 8.0.13.Error number:
81
; Symbol:EE_ADJUSTED_UNSIGNED_VALUE_FOR_OPTION
;Message: option '%s': unsigned value %s adjusted to %s.
EE_ADJUSTED_UNSIGNED_VALUE_FOR_OPTION
was added in 8.0.13.Error number:
82
; Symbol:EE_ADJUSTED_ULONGLONG_VALUE_FOR_OPTION
;Message: option '%s': value %s adjusted to %s.
EE_ADJUSTED_ULONGLONG_VALUE_FOR_OPTION
was added in 8.0.13.Error number:
83
; Symbol:EE_ADJUSTED_DOUBLE_VALUE_FOR_OPTION
;Message: option '%s': value %g adjusted to %g.
EE_ADJUSTED_DOUBLE_VALUE_FOR_OPTION
was added in 8.0.13.Error number:
84
; Symbol:EE_INVALID_DECIMAL_VALUE_FOR_OPTION
;Message: Invalid decimal value for option '%s'.
EE_INVALID_DECIMAL_VALUE_FOR_OPTION
was added in 8.0.13.Error number:
85
; Symbol:EE_COLLATION_PARSER_ERROR
;Message: %s.
EE_COLLATION_PARSER_ERROR
was added in 8.0.13.Error number:
86
; Symbol:EE_FAILED_TO_RESET_BEFORE_PRIMARY_IGNORABLE_CHAR
;Message: Failed to reset before a primary ignorable character %s.
EE_FAILED_TO_RESET_BEFORE_PRIMARY_IGNORABLE_CHAR
was added in 8.0.13.Error number:
87
; Symbol:EE_FAILED_TO_RESET_BEFORE_TERTIARY_IGNORABLE_CHAR
;Message: Failed to reset before a tertiary ignorable character %s.
EE_FAILED_TO_RESET_BEFORE_TERTIARY_IGNORABLE_CHAR
was added in 8.0.13.Error number:
88
; Symbol:EE_SHIFT_CHAR_OUT_OF_RANGE
;Message: Shift character out of range: %s.
EE_SHIFT_CHAR_OUT_OF_RANGE
was added in 8.0.13.Error number:
89
; Symbol:EE_RESET_CHAR_OUT_OF_RANGE
;Message: Reset character out of range: %s.
EE_RESET_CHAR_OUT_OF_RANGE
was added in 8.0.13.Error number:
90
; Symbol:EE_UNKNOWN_LDML_TAG
;Message: Unknown LDML tag: '%.*s'.
EE_UNKNOWN_LDML_TAG
was added in 8.0.13.Error number:
91
; Symbol:EE_FAILED_TO_RESET_BEFORE_SECONDARY_IGNORABLE_CHAR
;Message: Failed to reset before a secondary ignorable character %s.
EE_FAILED_TO_RESET_BEFORE_SECONDARY_IGNORABLE_CHAR
was added in 8.0.16.