ERROR 1201 (HY000): Could not initialize master info structure for '';
MySQL, MariaDB 2019. 1. 31. 20:30start slave 시 아래와 같은 메시지가 나온다.
MariaDB [mysql]> start slave;
ERROR 1201 (HY000): Could not initialize master info structure for ''; more error messages can be found in the MariaDB error log
MariaDB [mysql]> MariaDB [mysql]> start slave;
ERROR 1201 (HY000): Could not initialize master info structure for ''; more error messages can be found in the MariaDB error log MariaDB [mysql]>
MariaDB [mysql]> start slave; ERROR 1201 (HY000): Could not initialize master info structure for ''; more error messages can be found in the MariaDB error log MariaDB [mysql]>
MariaDB [mysql]> start slave; ERROR 1201 (HY000): Could not initialize master info structure for ''; more error messages can be found in the MariaDB error log MariaDB [mysql]>
MariaDB [mysql]> start slave;
ERROR 1201 (HY000): Could not initialize master info structure for ''; more error messages can be found in the MariaDB error log
MariaDB [mysql]>
해결방법 : slave를 reset한 후 start 한다.
MariaDB [mysql]> reset slave;
Query OK, 0 rows affected (0.014 sec)
MariaDB [mysql]> start slave;
Query OK, 0 rows affected (0.015 sec)
'MySQL, MariaDB' 카테고리의 다른 글
Centos7 MariaDB 10.7 설치 (0) | 2022.04.17 |
---|---|
Last_SQL_Errno: 1032 Last_SQL_Error: Could not execute Delete_rows_v1 event on table (0) | 2019.01.31 |
MySQL/MariaDB replication 유지하며 마스터 mysql-bin.xxxxxx 로그 삭제 (0) | 2019.01.18 |
replication (0) | 2018.06.26 |
CentOS7 nginx, mariadb10, php-fpm 설치 (0) | 2017.01.05 |