Slave: received 0 length packet from server, apparent master shutdown
又是server-id這個引數的原因
[@more@]過完節第一天檢查資料庫,發現一臺mysql的slave報出大量的
Slave: received 0 length packet from server, apparent master shutdown.
日誌檔案已經2g了.....但是資料倒是還在走,嘗試stop slave再start slave，報錯 ：
Error reading packet from server: log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master (server_errno=1236)
再檢查下mt.cnf果然還是server-id和別的slave的重複造成的，重新設定下第一個錯誤就ok了，第二個錯誤麼可能就是使用了LOAD DATA或者mysqlimp造成的，避免的方法就是在主從2臺上先把要load的文字load到不復制的臨時庫中，再透過sql的方式插入複製的表中，這樣只傳遞sql而不會發生大量資料的傳遞，就不用更改max_allowed_packet 了，否則按照mysql的提示修改雖然能過去，但是下次資料再多點可又要改了，而且還要停master。。。這在生產環境可不是每次都行的
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/79686/viewspace-1016553/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- MySQL報錯Slave: received end packet from server, apparent master shutdownMySqlServerAPPAST
- The last packet successfully received from the server was 2,625 milliseconds ago.ASTServerGo
- The slave I/O thread stops because master and slave have equal MySQL server UUIDthreadASTMySqlServerUI
- Unknown initial character set index ‘255‘ received from server. Initial client character set can beIndexServerclient
- 故障案例：主從同步報錯Fatal error: The slave I/O thread stops because master and slave have equal MySQL server主從同步ErrorthreadASTMySqlServer
- Setup MariaDB Master/Slave Replication for Docker MariaDBASTDocker
- bug:1、the last packet sent successfully to the server was 0 milliseconds ago 2、avoid mutating a propASTServerGo
- “The last packet sent successfully to the server was 0 milliseconds ago. ”異常解決方案ASTServerGo
- MYSQL The Server Shutdown Process(筆記)MySqlServer筆記
- Mysql 5.6 Master和Slave 主備切換MySqlAST
- Renaming the default branch from master to main on GithubASTAIGithub
- Lost connection to MySQL server at 'reading authorization packet'MySqlServer
- 資料庫讀寫分離Master-Slave資料庫AST
- Mysql Master-slave複製簡單配置記錄MySqlAST
- 使用etcd選舉sdk實踐master/slave故障轉移AST
- Mysqldump實現mysql的master-slave主從複製MySqlAST
- mysql slave 跟進 master 的關鍵狀態指標MySqlAST指標
- 分散式資料中的坑（一）Master-Slave架構分散式AST架構
- find the replications and articles from distribution serverServer
- 023 Given an integer n. get the number of 0, 2, 4 from all the values from [0, n]
- 踩坑:在 Laravel 中使用 Swoole server 服務呼叫資料庫模型，MySQL 頻繁出錯 Packets out of order. Expected 1 received 111. Packet sizeLaravelServer資料庫模型MySql
- 聊聊 MySQL 網路緩衝區、net_buffer_length、max_allowed_packet 那些事MySql
- 基於Kubernetes構建企業Jenkins master/slave CI/CD平臺JenkinsAST
- Innobackupex實現mysql線上搭建master-slave主從複製MySqlAST
- MySQL主從複製報錯：Got fatal error 1236 from master when reading data fromMySqlGoErrorAST
- MySQ 資料庫主從同步安裝與配置詳解（Master/Slave）資料庫主從同步AST
- 實屬無奈！Redis 作者被迫修改 master-slave 架構的描述RedisAST架構
- MySQL案例09:Last_IO_Error: Got fatal error 1236 from master when reading data from binary logMySqlASTErrorGo
- how to move a MediaWiki wiki from one server to anotherServer
- 總結SSH登陸故障:expected key exchange group packet form serverORMServer
- Redis for linux原始碼&叢集(cluster)&主從(master-slave)&哨兵(sentinel)安裝配置RedisLinux原始碼AST
- move linux os from disk A to disk B with 0 lossLinux
- mysql char_length和lengthMySql
- Kubernetes安裝之六：配置master之api-serverASTAPIServer
- Java中 length、length()、size()區別Java
- mysql 8 報錯 ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repositoryMySqlErrorAIStruct
- 手把手教你寫一個自己的 master-slave 架構的 TCP 伺服器AST架構TCP伺服器
- jenkins slave節點上的job構建記錄 都只會在master伺服器JenkinsAST伺服器
- CentOS中MySQL5.6 資料庫主從（Master/Slave）同步安裝與配置詳解CentOSMySql資料庫AST