Comments - Strange error coming on MariaDB Master server in /var/log/mariadb/mariadb.log

6 years, 6 months ago kanika satija
This comment has the status of 'removed' and can only be seen by you.

Hi,

To resolve this issue "Failed to initialize the master info structure" please reset slave once and the change master info to slave. Please find complete steps below after connecting to mariadb

1) RESET SLAVE;

2) CHANGE MASTER TO MASTER_HOST='<Master_IP>', MASTER_USER='<created_slave_user>', MASTER_PASSWORD='<slave_password>', MASTER_LOG_FILE='<Bin_log_file>', MASTER_LOG_POS=<Bin_log_pos>;

3) START SLAVE;

I have also faced the same issue earlier in my setup and resolved this issue using above steps.

In case this problem is not resolved with above steps please provide below information: 1) Provide mariadb configuration files "my.cnf" of Master as well as slave

2) Master and slave status a) show master status b) show slave status

3) Also provide complete command "CHANGE MASTER TO" which you ran on slave

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.