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.
EE_DISK_FULL_WITH_RETRY_MSGwas 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_TIMERwas 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_TIMERwas 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_QUEUEwas 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_THREADwas 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_EVENTwas 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_THREADwas 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_FAILEDwas added in 8.0.13. -
Error number:
43; Symbol:EE_WIN_RUN_TIME_ERROR_CHECK;Message: %s.
EE_WIN_RUN_TIME_ERROR_CHECKwas 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_SIZEwas 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_THREADSwas 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_PORTwas 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_FILEwas 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_FILEwas 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_FILEwas 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_RECURSIONwas 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_FILEwas 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_FILEwas 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_ERRORwas 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_FILEwas 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_OPTIONwas 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_OPTIONwas 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_INSECUREwas 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_VARIABLEwas added in 8.0.13. -
Error number:
59; Symbol:EE_SSL_ERROR_FROM_FILE;Message: SSL error: %s from '%s'.
EE_SSL_ERROR_FROM_FILEwas added in 8.0.13. -
Error number:
60; Symbol:EE_SSL_ERROR;Message: SSL error: %s.
EE_SSL_ERRORwas added in 8.0.13. -
Error number:
61; Symbol:EE_NET_SEND_ERROR_IN_BOOTSTRAP;Message: %d %s.
EE_NET_SEND_ERROR_IN_BOOTSTRAPwas 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_ORDERwas added in 8.0.13. -
Error number:
63; Symbol:EE_UNKNOWN_PROTOCOL_OPTION;Message: Unknown option to protocol: %s.
EE_UNKNOWN_PROTOCOL_OPTIONwas 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_KEYwas 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_FORMATwas added in 8.0.13. -
Error number:
66; Symbol:EE_DEBUG_INFO;Message: %s.
EE_DEBUG_INFOwas added in 8.0.13. -
Error number:
67; Symbol:EE_UNKNOWN_VARIABLE;Message: unknown variable '%s'.
EE_UNKNOWN_VARIABLEwas added in 8.0.13. -
Error number:
68; Symbol:EE_UNKNOWN_OPTION;Message: unknown option '--%s'.
EE_UNKNOWN_OPTIONwas added in 8.0.13. -
Error number:
69; Symbol:EE_UNKNOWN_SHORT_OPTION;Message: %s: unknown option '-%c'.
EE_UNKNOWN_SHORT_OPTIONwas added in 8.0.13. -
Error number:
70; Symbol:EE_OPTION_WITHOUT_ARGUMENT;Message: %s: option '--%s' cannot take an argument.
EE_OPTION_WITHOUT_ARGUMENTwas added in 8.0.13. -
Error number:
71; Symbol:EE_OPTION_REQUIRES_ARGUMENT;Message: %s: option '--%s' requires an argument.
EE_OPTION_REQUIRES_ARGUMENTwas 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_ARGUMENTwas 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_VALUEwas 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_VALUEwas 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_OPTIONwas 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_OPTIONwas 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_VALUEwas 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_OPTIONwas 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_OPTIONwas 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_OPTIONwas 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_OPTIONwas 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_OPTIONwas 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_OPTIONwas 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_OPTIONwas added in 8.0.13. -
Error number:
85; Symbol:EE_COLLATION_PARSER_ERROR;Message: %s.
EE_COLLATION_PARSER_ERRORwas 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_CHARwas 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_CHARwas 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_RANGEwas 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_RANGEwas added in 8.0.13. -
Error number:
90; Symbol:EE_UNKNOWN_LDML_TAG;Message: Unknown LDML tag: '%.*s'.
EE_UNKNOWN_LDML_TAGwas 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_CHARwas added in 8.0.16. -
Error number:
92; Symbol:EE_FAILED_PROCESSING_DIRECTIVE;Message: Stopped processing the '%s' directive in file %s at line %d.
EE_FAILED_PROCESSING_DIRECTIVEwas added in 8.0.27. -
Error number:
93; Symbol:EE_PTHREAD_KILL_FAILED;Message: pthread_kill(thread_id:%lu, signal:%s) returned '%s'.
EE_PTHREAD_KILL_FAILEDwas added in 8.0.31.