symptoms:
MySQL master slave copy, when starting slave, the following error occurs:
mysql> start slave;
ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository
solution: check the log,
can see the error, it was not found originally./server246-relay-bin.index file, find the reason, because I used an instance of cold backup file recovery, in mysql library slave_relay_log_info table still retain the previous relay_log information, so it caused to start slave error.
mysql provides tools for deleting records: slave reset;
slave reset does a few things when executed:
1, delete slave_master_info, slave_relay_log_info in both tables; 2. Delete all relay log files and recreate new relay log files; 3, will not change the value of gtid_executed or gtid_purged
mysql> reset slave;
Query OK, 0 rows affected (0.01 sec)
mysql> change master to ......
mysql> start slave;
Query OK, 0 rows affected (0.00 sec)
So it’s
so that slave can start.
Read More:
- After the two hosts set up the master-slave replication of MySQL, the show slave status displays: last_ IO_ Error: error connecting to master ……
- Mysql start slave error 1201 (HY000)
- The problem of master-slave database synchronization stop caused by MySQL deleting data
- MySQL operation and maintenance slave_ skip_ errors
- Hadoop hdfs dfs -ls/ error: Call From master/192.168.88.108 to slave1:9820 failed on connection except
- When configuring ROS distributed / Error report solution and command requirements encountered in the process of master-slave computer
- An error is reported when Clickhouse is started. The error log information is: structure needs cleaning
- [error handling] when logging into MySQL with CentOS command, an error 1045 (28000) is reported
- MySQL — initialize failed to generate temporary password in error log after initialization
- An error commandnotfounderror (to initialize your shell) is reported when activating the virtual environment
- SSH suddenly fails to log in, and an error is reported: failed to start openssh daemon
- The list command in HBase shell reported an error org.apache.hadoop . hbase.PleaseHoldException : Master is initializing
- Explain MySQL replication error 1032 & 1205
- An error is reported when starting the Android emulator: Emulator: audio: Failed to create voice `goldfish_audio_in’
- Pikachu vulnerability is installed in the shooting range, and an error is reported when connecting to the MySQL database
- An error is reported when using SecureCRT to log in to a non root account
- An error is reported when starting the Remote Access Connection Manager service
- An error was reported during MySQL 6.0 installation: start service failed
- An error is reported when the jeecg boot project connects to the MySQL database running on docker
- Vue failed to log in. F12 reported an error: request failed with status code 404