My Oracle Support Banner

Cannot Configure Replication and RESET SLAVE ALL Does Not Work: "ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository" (Doc ID 2203190.1)

Last updated on OCTOBER 02, 2018

Applies to:

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

Symptoms

Trying to setup a replication slave gives the following error:

ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository

Using RESET SLAVE ALL (see also <Note 1638949.1>) to reset the relay log info structure does not resolve the issue.

Looking into the relay log index file, it looks like there are two sets of files or they are not in order, for example:

/mysql/log/relay.000009
/mysql/log/relay.000010
/mysql/log/relay.000011
/mysql/log/relay.000001
/mysql/log/relay.000002

 

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


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