Configurering relay_log_info_file For a Multi-Threaded Slave Does Not Work; [ERROR] Failed to Create a New Info File; Errno 2; slave_parallel_workers
Last updated on MARCH 08, 2017
Applies to:MySQL Server - Version 5.6 and later
Information in this document applies to any platform.
When attempting to start the multi-threaded slave (slave_parallel_workers > 0) with relay_log_info_file configured,
the following error occurs.
[ERROR] Failed to create a new info file (file '/var/lib/mysql/worker-/mysql/logs/myhost-relay-log.info.1', errno 2)
The issue happens with a configuration file that specifies both relay_log_info_file and set the number of parallel slave workers greater than 0:
The issue can happen after updating the configuration to have both of
- slave_parallel_workers with a value greater than 0
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms