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 MARCH 08, 2017

Applies to:

MySQL Server - Version 5.6 and later
Information in this document applies to any platform.

Symptoms

When attempting to start the multi-threaded slave (slave_parallel_workers > 0) with relay_log_info_file configured,
the following error occurs.

ERROR
-----------------------
[ERROR] Failed to create a new info file (file '/var/lib/mysql/worker-/mysql/logs/myhost-relay-log.info.1', 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:

 

Changes

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

configurered.

Cause

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