Failed reading log event, reconnecting to retry
資料庫版本:5.6.16
系統:CentOS 6.5
搭建資料庫從庫報錯:
160411 14:30:39 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000004' at position 4279701
協助搭建資料庫從庫,之前同事搭建好了資料庫,只需要將主庫全部dump下來,記錄binlog在從庫還原即可。
change master配置的時候,搭建成功,但是透過 show slave status\G檢視從庫狀態,一會YES,一會NO....
檢視從庫警告日誌:
160411 14:30:39 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000004' at position 4279701
從庫沒有連線成功!
檢查配置檔案的server-id,是另一個從庫的配置檔案,修改即可!
系統:CentOS 6.5
搭建資料庫從庫報錯:
160411 14:30:39 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000004' at position 4279701
change master配置的時候,搭建成功,但是透過 show slave status\G檢視從庫狀態,一會YES,一會NO....
檢視從庫警告日誌:
160411 14:30:39 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000004' at position 4279701
從庫沒有連線成功!
檢查配置檔案的server-id,是另一個從庫的配置檔案,修改即可!
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28939273/viewspace-2079004/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-28056 Writing audit records to Windows Event Log failedWindowsAI
- ORA-28056: Writing audit records to Windows Event Log failedWindowsAI
- [ERROR] Failed to open logErrorAI
- FAILED_LOGIN_ATTEMPTSAI
- weblogic - <BEA-141281> <unable to get file lock, will retry ...>Web
- 【MySQL】log event entry exceededMySql
- MySQL [ERROR] Slave I/O: Found a Gtid_log_event or Previous_gtids_log_eventMySqlError
- 解析MYSQL BINLOG二進位制格式(8)--GTID_LOG_EVENT/ANONYMOUS_GTID_LOG_EVENT及其他MySql
- 解析MYSQL BINLOG 二進位制格式(7)--Xid_log_event/XID_EVENTMySql
- Javascript記憶體溢位,FATAL ERROR: CALL_AND_RETRY_LAST Allocation failed - JavaScript heap out of memoryJavaScript記憶體溢位ErrorASTAI
- Spring RetrySpring
- How to audit failed logon attemptsAIGo
- Oracle FAILED_LOGIN_ATTEMPTS 理解OracleAI
- zt_Failed Logon AttemptsAIGo
- Database Triggers and event attributes--Event Attributes【Blog 搬家】Database
- log buffer space wait event等待事件AI事件
- Weblogic BEA-141281 unable to get file lock, will retry 故障處理Web
- java retry(重試) spring retry, guava retrying 詳解JavaSpringGuava
- SEC_MAX_FAILED_LOGIN_ATTEMPTS 用途AI
- oracle Database Event trace 設定【Blog 搬家】OracleDatabase
- Failed: error reading separator after document # 1: bad JSON array format - found no opening brackAIErrorJSONORM
- 執行mysqlbinlog出現Found invalid event in binary log錯MySql
- weblogic報錯: OPatch failed with error code 73WebAIError
- logstash retrying failed action with response code: 429AI
- win10下github for desktop log in failedWin10GithubAI
- listDatabases failed:{ "errmsg" : "need to login", "ok" : 0 }DatabaseAI
- About login/failed_user_auto_unlock work or notAI
- LOGIN:ERROR-Failed to initialize policy manager(轉)ErrorAI
- PMON failed to acquire latch, see PMON dump in alert logAIUI
- unable to get file lock, will retry ...
- Oracle event 10231 【Blog 搬家】Oracle
- 解析MYSQL BINLOG 二進位制格式(6)--UPDATE_ROW_EVENT/DELETE_ROW_EVENTMySqldelete
- Slave failed to initialize relay log info structure from the repositoryAIStruct
- [ORACLE 11G]Failed Logon Delays特性OracleAIGo
- 重試工具 — retry-goGo
- Got fatal error 1236 from master when reading data from binary logGoErrorAST
- reading input to shell
- DBLOGIN ERROR: Failed to open data source for user OGG.ErrorAI