mysql 에러 메시지 Global Error Message Reference 조치 방안

mysql 에러 메시지 Global Error Message Reference 조치 방안

 

안녕하세요.

 

mysql의 Global Error Message Reference 조치 방안에 대해서 확인해보겠습니다.

 

mysql을 사용하다 보면 수많은 에러 메시지들을 만나게 되는데 이에 대한 내용을 정리하였습니다.

 

이번 포스팅에 기술되는 에러 메시지는 Global 에러 메시지입니다.

 

일반 에러 메시지는 따로 포스팅을 하도록 하겠습니다.

 

에러 메시지에 대한 조치방안은 해당 에러 메시지의 Message 부분을 읽어보시면 해결하실 수 있습니다.

 

예를 들어서 error: 1이라고 한다면 메시지는 Can't create/write to file...인데.. 이런 경우 경로가 잘못 지정되어 있거나, 파일을 생성하거나 쓰는 데 있어서 권한이 없는 경우가 될 것입니다.

 

이런 식으로 유추해서 해당 에러 메시지에 대한 대응을 하시면 됩니다.

 

 

Error Number	Symbol	Message
error: 1	EE_CANTCREATEFILE	Can't create/write to file '%s' (OS errno %d - %s)
error: 2	EE_READ	Error reading file '%s' (OS errno %d - %s)
error: 3	EE_WRITE	Error writing file '%s' (OS errno %d - %s)
error: 4	EE_BADCLOSE	Error on close of '%s' (OS errno %d - %s)
error: 5	EE_OUTOFMEMORY	Out of memory (Needed %u bytes)
error: 6	EE_DELETE	Error on delete of '%s' (OS errno %d - %s)
error: 7	EE_LINK	Error on rename of '%s' to '%s' (OS errno %d - %s)
error: 9	EE_EOFERR	Unexpected EOF found when reading file '%s' (OS errno %d - %s)
error: 10	EE_CANTLOCK	Can't lock file (OS errno %d - %s)
error: 11	EE_CANTUNLOCK	Can't unlock file (OS errno %d - %s)
error: 12	EE_DIR	Can't read dir of '%s' (OS errno %d - %s)
error: 13	EE_STAT	Can't get stat of '%s' (OS errno %d - %s)
error: 14	EE_CANT_CHSIZE	Can't change size of file (OS errno %d - %s)
error: 15	EE_CANT_OPEN_STREAM	Can't open stream from handle (OS errno %d - %s)
error: 16	EE_GETWD	Can't get working directory (OS errno %d - %s)
error: 17	EE_SETWD	Can't change dir to '%s' (OS errno %d - %s)
error: 18	EE_LINK_WARNING	Warning
error: 19	EE_OPEN_WARNING	Warning
error: 20	EE_DISK_FULL	Disk is full writing '%s' (OS errno %d - %s). Waiting for someone to free space...
error: 21	EE_CANT_MKDIR	Can't create directory '%s' (OS errno %d - %s)
error: 22	EE_UNKNOWN_CHARSET	Character set '%s' is not a compiled character set and is not specified in the '%s' file
error: 23	EE_OUT_OF_FILERESOURCES	Out of resources when opening file '%s' (OS errno %d - %s)
error: 24	EE_CANT_READLINK	Can't read value for symlink '%s' (Error %d - %s)
error: 25	EE_CANT_SYMLINK	Can't create symlink '%s' pointing at '%s' (Error %d - %s)
error: 26	EE_REALPATH	Error on realpath() on '%s' (Error %d - %s)
error: 27	EE_SYNC	Can't sync file '%s' to disk (OS errno %d - %s)
error: 28	EE_UNKNOWN_COLLATION	Collation '%s' is not a compiled collation and is not specified in the '%s' file
error: 29	EE_FILENOTFOUND	File '%s' not found (OS errno %d - %s)
error: 30	EE_FILE_NOT_CLOSED	File '%s' (fileno
error: 31	EE_CHANGE_OWNERSHIP	Cannot change ownership of the file '%s' (OS errno %d - %s)
error: 32	EE_CHANGE_PERMISSIONS	Cannot change permissions of the file '%s' (OS errno %d - %s)
error: 33	EE_CANT_SEEK	Cannot seek in file '%s' (OS errno %d - %s)
error: 34	EE_CAPACITY_EXCEEDED	Memory capacity exceeded (capacity %llu bytes)
error: 35	EE_DISK_FULL_WITH_RETRY_MSG	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: 36	EE_FAILED_TO_CREATE_TIMER	Failed to create timer (OS errno %d).
error: 37	EE_FAILED_TO_DELETE_TIMER	Failed to delete timer (OS errno %d).
error: 38	EE_FAILED_TO_CREATE_TIMER_QUEUE	Failed to create timer queue (OS errno %d).
error: 39	EE_FAILED_TO_START_TIMER_NOTIFY_THREAD	Failed to start timer notify thread.
error: 40	EE_FAILED_TO_CREATE_TIMER_NOTIFY_THREAD_INTERRUPT_EVENT	Failed to create event to interrupt timer notifier thread (OS errno %d).
error: 41	EE_EXITING_TIMER_NOTIFY_THREAD	Failed to register timer event with queue (OS errno %d), exiting timer notifier thread.
error: 42	EE_WIN_LIBRARY_LOAD_FAILED	LoadLibrary("kernel32.dll") failed
error: 43	EE_WIN_RUN_TIME_ERROR_CHECK	%s.
error: 44	EE_FAILED_TO_DETERMINE_LARGE_PAGE_SIZE	Failed to determine large page size.
error: 45	EE_FAILED_TO_KILL_ALL_THREADS	Error in my_thread_global_end()
error: 46	EE_FAILED_TO_CREATE_IO_COMPLETION_PORT	Failed to create IO completion port (OS errno %d).
error: 47	EE_FAILED_TO_OPEN_DEFAULTS_FILE	Failed to open required defaults file
error: 48	EE_FAILED_TO_HANDLE_DEFAULTS_FILE	Fatal error in defaults handling. Program aborted!
error: 49	EE_WRONG_DIRECTIVE_IN_CONFIG_FILE	Wrong '!%s' directive in config file %s at line %d.
error: 50	EE_SKIPPING_DIRECTIVE_DUE_TO_MAX_INCLUDE_RECURSION	Skipping '%s' directive as maximum include recursion level was reached in file %s at line %d.
error: 51	EE_INCORRECT_GRP_DEFINITION_IN_CONFIG_FILE	Wrong group definition in config file %s at line %d.
error: 52	EE_OPTION_WITHOUT_GRP_IN_CONFIG_FILE	Found option without preceding group in config file %s at line %d.
error: 53	EE_CONFIG_FILE_PERMISSION_ERROR	%s should be readable/writable only by current user.
error: 54	EE_IGNORE_WORLD_WRITABLE_CONFIG_FILE	World-writable config file '%s' is ignored.
error: 55	EE_USING_DISABLED_OPTION	%s
error: 56	EE_USING_DISABLED_SHORT_OPTION	%s
error: 57	EE_USING_PASSWORD_ON_CLI_IS_INSECURE	Using a password on the command line interface can be insecure.
error: 58	EE_UNKNOWN_SUFFIX_FOR_VARIABLE	Unknown suffix '%c' used for variable '%s' (value '%s').
error: 59	EE_SSL_ERROR_FROM_FILE	SSL error
error: 60	EE_SSL_ERROR	SSL error
error: 61	EE_NET_SEND_ERROR_IN_BOOTSTRAP	%d %s.
error: 62	EE_PACKETS_OUT_OF_ORDER	Packets out of order (found %u, expected %u).
error: 63	EE_UNKNOWN_PROTOCOL_OPTION	Unknown option to protocol
error: 64	EE_FAILED_TO_LOCATE_SERVER_PUBLIC_KEY	Failed to locate server public key '%s'.
error: 65	EE_PUBLIC_KEY_NOT_IN_PEM_FORMAT	Public key is not in Privacy Enhanced Mail format
error: 66	EE_DEBUG_INFO	%s.
error: 67	EE_UNKNOWN_VARIABLE	unknown variable '%s'.
error: 68	EE_UNKNOWN_OPTION	unknown option '--%s'.
error: 69	EE_UNKNOWN_SHORT_OPTION	%s
error: 70	EE_OPTION_WITHOUT_ARGUMENT	%s
error: 71	EE_OPTION_REQUIRES_ARGUMENT	%s
error: 72	EE_SHORT_OPTION_REQUIRES_ARGUMENT	%s
error: 73	EE_OPTION_IGNORED_DUE_TO_INVALID_VALUE	%s
error: 74	EE_OPTION_WITH_EMPTY_VALUE	%s
error: 75	EE_FAILED_TO_ASSIGN_MAX_VALUE_TO_OPTION	%s
error: 76	EE_INCORRECT_BOOLEAN_VALUE_FOR_OPTION	option '%s'
error: 77	EE_FAILED_TO_SET_OPTION_VALUE	%s
error: 78	EE_INCORRECT_INT_VALUE_FOR_OPTION	Incorrect integer value
error: 79	EE_INCORRECT_UINT_VALUE_FOR_OPTION	Incorrect unsigned integer value
error: 80	EE_ADJUSTED_SIGNED_VALUE_FOR_OPTION	option '%s'
error: 81	EE_ADJUSTED_UNSIGNED_VALUE_FOR_OPTION	option '%s'
error: 82	EE_ADJUSTED_ULONGLONG_VALUE_FOR_OPTION	option '%s'
error: 83	EE_ADJUSTED_DOUBLE_VALUE_FOR_OPTION	option '%s'
error: 84	EE_INVALID_DECIMAL_VALUE_FOR_OPTION	Invalid decimal value for option '%s'.
error: 85	EE_COLLATION_PARSER_ERROR	%s.
error: 86	EE_FAILED_TO_RESET_BEFORE_PRIMARY_IGNORABLE_CHAR	Failed to reset before a primary ignorable character %s.
error: 87	EE_FAILED_TO_RESET_BEFORE_TERTIARY_IGNORABLE_CHAR	Failed to reset before a tertiary ignorable character %s.
error: 88	EE_SHIFT_CHAR_OUT_OF_RANGE	Shift character out of range
error: 89	EE_RESET_CHAR_OUT_OF_RANGE	Reset character out of range
error: 90	EE_UNKNOWN_LDML_TAG	Unknown LDML tag
error: 91	EE_FAILED_TO_RESET_BEFORE_SECONDARY_IGNORABLE_CHAR	Failed to reset before a secondary ignorable character %s.

 

에러코드가 나타나도 당황하지마시고, 잘 해결 하시기 바랍니다.

 

by.sTricky