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 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

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
Symptoms
Changes
Cause
Solution
 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
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.