Slave failed to initialize relay log info structure from the repository
啟動從時報錯:
mysql> start slave;
ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository
reset slave之後可以:
mysql> reset slave;
Query OK, 0 rows affected (0.00 sec)
mysql> change master to master_host='192.168.118.161', master_user='song', master_password='song', master_log_file='1.000016', master_log_pos=430;
Query OK, 0 rows affected, 2 warnings (0.04 sec)
mysql> start slave;
Query OK, 0 rows affected (0.02 sec)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28258625/viewspace-1595219/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- mysql 8 報錯 ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repositoryMySqlErrorAIStruct
- 【Mysql】ERROR 1872 (HY000): Slave failed to initialize relay log infoMySqlErrorAI
- 【MySQL】Could not initialize master info structureMySqlASTStruct
- LOGIN:ERROR-Failed to initialize policy manager(轉)ErrorAI
- 【MySQL】錯誤資訊寫入slave_relay_log.index 案例一則MySqlIndex
- pycharm出現Git Pull Failed: Could not read from remote repository.PyCharmGitAIREM
- MySQL 5.6修復從庫複製時報錯'ERROR 1872 (HY000): Slave failed to initialize'MySqlErrorAI
- 【Mysql】master_info 與 relay_info對資料庫的影響MySqlAST資料庫
- mysql 5.5 中對SLAVE relay-log相關日誌檔案同步的強化MySql
- MySQL錯誤之mysql.slave_master_infoMySqlAST
- PROT-1 Failed to initialize ocrconfigAI
- Failed to initialize NVML: Driver/library version mismatchAI
- mysql relay log和binlog 小結MySql
- buffer cache logical structure!Struct
- mysql relay log引數彙總MySql
- 1.1 Logical Structure of Database ClusterStructDatabase
- Get All IE Info from win32 apiWin32API
- android: failed to find provider info for downloadsAndroidAIIDE
- solrcloud 報 HTTP Status 503 - Server is shutting down or failed to initializeSolrCloudHTTPServerAI
- httpd: apr_sockaddr_info_get() failed for bogonhttpdAIGo
- MySQL relay log 詳細引數解釋MySql
- mysql relay log相關引數說明MySql
- jpa報錯 Failed to initialize JPA EntityManagerFactory: Unable to instantiate default tuplizerAI
- 10G rac crsd.log :th_select_handler: Failed to retrieve procctx from htAI
- Python(logging.getLogger().info())Python
- [ERROR] Failed to open logErrorAI
- Slave: received 0 length packet from server, apparent master shutdownServerAPPAST
- From CORBA technology To Thrift technologyORB
- innobackupex中--slave-info引數的含義和適用場景
- 解決SBT下載慢,dump project structure from sbt問題ProjectStruct
- 關於IDEA新建工程後dump project structure from sbtIdeaProjectStruct
- Catalog archivelog from file system to Asmdg;HiveASM
- 刪除mysql relay-log 的解決辦法MySql
- FAILED_LOGIN_ATTEMPTSAI
- Starting httpd: httpd: apr_sockaddr_info_get() failed for subversionhttpdAI
- [已解決] [HiveCatalog]Kerberos GSS initiate failed, No valid credentials provided, Cannot read from System.inHiveROSAIIDE
- Flutter:VM snapshot must be valid. Check failed: vm. Must be able to initializeFlutterAI
- MySQL報錯Slave: received end packet from server, apparent master shutdownMySqlServerAPPAST