'2019/01/31'에 해당되는 글 2건

MariaDB [mysql]> stop slave; 

한 뒤,

MariaDB [mysql]> SET GLOBAL sql_slave_skip_counter = 1;

하고

MariaDB [mysql]> start slave;

한다.

에러가 계속 발생하면,

위 단계를 반복한다.

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