My Oracle Support Banner

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/', errno 2)

Note: The actual errno will depend on the operating system. The above example is from Linux.

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

  1. relay_log_info_file
  2. 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.