The incident LOST_EVENTS occured on the master
Last_SQL_Error: The incident LOST_EVENTS occured on the master. Message: error writing to the binary log
主從同步的狀態中顯示
Last_SQL_Error: The incident LOST_EVENTS occured on the master. Message: error writing to the binary log
這個錯誤 ，並且
Slave_IO_Running: Yes
Slave_SQL_Running: No
指定的執行到的檔案位置分析出
# at 1073746107
#150724 9:15:48 server id 168042596 end_log_pos 1073746164
# Incident: LOST_EVENTS
ERROR: RELOAD DATABASE; # Shall generate syntax error
Error in Log_event::read_log_event(): 'Sanity check failed', data_len: 122, event_type: 30
表示不會，查資料
看起來是一個bug
我就跳了幾下日誌，誰知道 資料不一致了。 。 擦，只好重搞 了。
轉載請註明源出處
QQ 273002188 歡迎一起學習
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/25099483/viewspace-1749812/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- oracle的adr清理incidentOracleIDE
- MySQL Master/Slave Master/MasterMySqlAST
- Incident management at Google — adventures in SRE-landIDEGo
- The connection to adb is down, and a severe error has occured.Error
- ! [rejected] master -> master (fetch first)AST
- Mysql5.6 Master+MasterMySqlAST
- incident如何使用Golang構建工作流程引擎？IDEGolang
- Mongodb的master-slave模式與master-master模式實驗MongoDBAST模式
- DevOps 自動化實踐 —— Incident 工作流devIDE
- Android-The connection to adb is down, and a severe error has occuredAndroidError
- change master 未指定master_log_fileAST
- 啟動UltraEdit錯誤An error has occured.The application will be shutdown.ErrorAPP
- Git branching: master vs. origin/master vs. remotes/origin/masterGitASTREM
- show master logs 和 show master status 區別AST
- 【HBase】start master 與 start master --backup 的區別AST
- git rebase masterGitAST
- Spark master standalongSparkAST
- Redis master and slaveRedisAST
- MySQL master/slaveMySqlAST
- Scrum Master JobGPTScrumASTGPT
- Bitcoin-ABC incident report (26APR2018)IDE
- xxx is not in the sudoers file.This incident will be reported.的解決方法IDE
- MySQL5.7 Master-Master主主搭建for Centos7MySqlASTCentOS
- 2 新增standby masterAST
- Master-Worker 模式AST模式
- Scrum Master 生存指南ScrumAST
- 1248：Dungeon MasterAST
- Master MVVM in Swift<1>ASTMVVMSwift
- Master Note for Tablespace IssuesAST
- Master-Worker模式AST模式
- 母版頁（Master Pages）AST
- MySql的Master/SlaveMySqlAST
- Master Data Management UpdateAST
- KSV master waitASTAI
- WPF master detail viewASTAIView
- DocumentDB 報錯“not master”AST
- C. Game MasterGAMAST
- master..spt_valuesAST