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
(Doc ID 1569202.1)
Last updated on FEBRUARY 22, 2019
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|1. Store Relay Info Data In a Table|
|2. Use the Default Value for relay_log_info_file|
|3. Do Not Use the Multi-Threaded Slave|