【Mysql】ERROR 1872 (HY000): Slave failed to initialize relay log info
背景“:線上將資料庫目錄遷移到k另一個目錄後啟動slave程式報錯:
start slave;
ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository
解決辦法:
start slave;
ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository
解決辦法:
- 修改index檔案和info檔案
- index裡面的記錄是原來的目錄的
-
[root@Yun-MySQL02 3306]# more mysqlrelay.index
/data/mydata/3306/mysqlrelay.000006 ---修改為新的中繼日誌目錄即可
/databak/3306/mysqlrelay.000007
/databak/3306/mysqlrelay.000008
/databak/3306/mysqlrelay.000009
/databak/3306/mysqlrelay.000010
-
[root@Yun-MySQL02 3306]# more relay-log.info
7
/databak/3306/mysqlrelay.000007 ----修改為新的中繼日誌目錄
29378841
mysql-bin.000051
706927394
0
0
1
注意:有可能有的環境找不到relay-log.info,那是因為引數設定的原因
-
在MySQL 5.6.2之前,slave記錄的master資訊以及slave應用binlog的資訊存放在檔案中,即master.info與relay-log.info。在5.6.2版本之後,允許記錄到table中,引數設定如下:
-
master-info-repository = TABLE ---FILE表示以檔案方式
-
relay-log-info-repository = TABLE ---FILE表示以檔案方式
-
對應的表分別為mysql.slave_master_info與mysql.slave_relay_log_info,且這兩個表均為innodb引擎表。
-
-
-
mysql> select * from mysql.slave_master_info\G:
-
*************************** 1. row ***************************
-
Number_of_lines: 23
-
Master_log_name: mysql-bin.000129
-
Master_log_pos: 760146983
-
Host: 192.168.10.1
-
User_name: repl
-
User_password: aaafdffdgbh_$3KFUH
-
Port: 3307
-
Connect_retry: 60
-
Enabled_ssl: 0
-
Ssl_ca:
-
Ssl_capath:
-
Ssl_cert:
-
Ssl_cipher:
-
Ssl_key:
-
Ssl_verify_server_cert: 0
-
Heartbeat: 1800
-
Bind:
-
Ignored_server_ids: 0
-
Uuid: 6c8a10ed-ed0b-11e4-91eb-00163ec546aa
-
Retry_count: 86400
-
Ssl_crl:
-
Ssl_crlpath:
-
Enabled_auto_position: 1
- 1 row in set (0.07 sec)
mysql> show variables like 'relay%';
+---------------------------+--------------------------------+
| Variable_name | Value |
+---------------------------+--------------------------------+
| relay_log | /databak/3306/mysqlrelay |
| relay_log_basename | /databak/3306/mysqlrelay |
| relay_log_index | /databak/3306/mysqlrelay.index |
| relay_log_info_file | relay-log.info |
| relay_log_info_repository | FILE |
| relay_log_purge | ON |
| relay_log_recovery | OFF |
| relay_log_space_limit | 0 |
+---------------------------+--------------------------------+
-
在MySQL 5.6.2之前,slave記錄的master資訊以及slave應用binlog的資訊存放在檔案中,即master.info與relay-log.info。在5.6.2版本之後,允許記錄到table中,引數設定如下:
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29096438/viewspace-2122680/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- mysql 8 報錯 ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repositoryMySqlErrorAIStruct
- Slave failed to initialize relay log info structure from the repositoryAIStruct
- MySQL 5.6修復從庫複製時報錯'ERROR 1872 (HY000): Slave failed to initialize'MySqlErrorAI
- LOGIN:ERROR-Failed to initialize policy manager(轉)ErrorAI
- 【MySQL】Could not initialize master info structureMySqlASTStruct
- 【MySQL】錯誤資訊寫入slave_relay_log.index 案例一則MySqlIndex
- MySQL錯誤之mysql.slave_master_infoMySqlAST
- [ERROR] Failed to open logErrorAI
- 【Mysql】master_info 與 relay_info對資料庫的影響MySqlAST資料庫
- mysql relay log和binlog 小結MySql
- mysql 5.5 中對SLAVE relay-log相關日誌檔案同步的強化MySql
- mysql relay log引數彙總MySql
- MySQL建立使用者報錯 ERROR 1396 (HY000): Operation CREATE USER failed for 'afei'@'%'MySqlErrorAI
- MySQL [ERROR] Slave I/O: Found a Gtid_log_event or Previous_gtids_log_eventMySqlError
- MySQL relay log 詳細引數解釋MySql
- mysql relay log相關引數說明MySql
- MYSQL ERROR 2003 (HY000) CanMySqlError
- MySQL "ERROR 1010(HY000):Error dropping database(canMySqlErrorDatabase
- MySQL error log和bin logMySqlError
- weblogic報錯: OPatch failed with error code 73WebAIError
- ERROR 1290 (HY000): The MySQL server is running withErrorMySqlServer
- ERROR 1010 (HY000) mysql 5.5.19ErrorMySql
- error:slave communication error with ASMErrorASM
- ERROR: slave communication error with ASMErrorASM
- mysql_slave :Error_code: 1593解決MySqlError
- 刪除mysql relay-log 的解決辦法MySql
- mysql 配置log_errorMySqlError
- 【MySQL】ERROR 1878 (HY000): Temporary file write failure.MySqlErrorAI
- PROT-1 Failed to initialize ocrconfigAI
- MySQL:產生大量小relay log的故障一例MySql
- 【Mysql】Slave_SQL_Running: No:Last_Error: Error :1032/1062MySqlASTError
- DBLOGIN ERROR: Failed to open data source for user OGG.ErrorAI
- sqlserver 2008 login failed: error 18456SQLServerAIError
- Mysql連線錯誤ERROR 2003 (HY000)MySqlError
- MySQL ERROR 1031 (HY000) at line 33: Table storage engine forMySqlError
- 【ERROR】OPatch failed with error code 73ErrorAI
- MYSQL sync_relay_log對I/O thread的影響分析MySqlthread
- android: failed to find provider info for downloadsAndroidAIIDE