【MySQL】Could not initialize master info structure

楊奇龍發表於2012-10-28
MySqlASTStruct
對一個M-M 架構的mysql 重新搭建雙master ,出現了兩個報錯：
ERROR 29 (HY000): File '/home/mysql/data3306/slave-relay.066538' not found (Errcode: 2)
ERROR 1201 (HY000): Could not initialize master info structure;

(none)@3306 14:34:29>CHANGE MASTER TO
    -> MASTER_HOST='10.1.147.164',
    -> MASTER_USER='replicator',
    -> MASTER_PASSWORD='yangql',
    -> MASTER_LOG_FILE='mysql-bin.000002',
    -> MASTER_LOG_POS=106;
ERROR 29 (HY000): File '/home/mysql/data3306/slave-relay.066538' not found (Errcode: 2)
檢視 slave-relay-log.index 檔案
[root@linux11-02 data3306]#cat slave-relay-log.index 
/home/mysql/data3306/slave-relay.066537
/home/mysql/data3306/slave-relay.066538
/home/mysql/data3306/slave-relay.066539
/home/mysql/data3306/slave-relay.066540
/home/mysql/data3306/slave-relay.066541
/home/mysql/data3306/slave-relay.066542
/home/mysql/data3306/slave-relay.066543
/home/mysql/data3306/slave-relay.066544
/home/mysql/data3306/slave-relay.066545

data_dir 目錄並不存在這些relay.log file 因為要重新建立，所以清除slave-relay-log.index 之後 重新指定 master

(none)@3306 14:37:36>CHANGE MASTER TO
    -> MASTER_HOST='10.1.147.164',
    -> MASTER_USER='replicator',
    -> MASTER_PASSWORD='yangql',
    -> MASTER_LOG_FILE='mysql-bin.000002',
    -> MASTER_LOG_POS=106;
ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log
(none)@3306 14:37:42>

出現上述報錯的原因是因為已經存在一個86KB的檔案master.info(之前已經存在的檔案)，該檔案導致mysqld提示覆制無法初始化主資料庫伺服器的資訊，直接刪除該檔案：
[root@linux11-02 data3306]# rm master.info
rm: remove regular file `master.info'? y
[root@linux11-02 data3306]# rm slave-relay-log.info 
rm: remove regular empty file `slave-relay-log.info'? y
[root@linux11-02 data3306]# 
再執行CHANAGE MASTER TO 命令，複製搭建成功，
(none)@3306 14:50:50>CHANGE MASTER TO
    -> MASTER_HOST='10.1.147.164',
    -> MASTER_USER='replicator',
    -> MASTER_PASSWORD='yangql',
    -> MASTER_LOG_FILE='mysql-bin.000002',
    -> MASTER_LOG_POS=106;
Query OK, 0 rows affected (0.26 sec)
且生成了記錄主資料庫伺服器資訊的master.info和 slave-relay-log.info檔案。

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/22664653/viewspace-747780/，如需轉載，請註明出處，否則將追究法律責任。

相關文章