【Xtrabackup捉蟲】Waiting for master thread to be suspended
使用xtrabackup 2.4.6版本,在備份完成後,prepare階段(apply-log的時候)會丟擲該提示:
-
xtrabackup: starting shutdown with innodb_fast_shutdown = 1
-
InnoDB: FTS optimize thread exiting.
-
InnoDB: Starting shutdown...
- InnoDB: Waiting for master thread to be suspended
- InnoDB: Waiting for master thread to be suspended
- InnoDB: Waiting for master thread to be suspended
- InnoDB: Waiting for master thread to be suspended
- InnoDB: Waiting for master thread to be suspended
- ………………………………
-
並且長時間等待仍然被hang住。
檢查percona的bug庫,發現這被判定為一個bug:
- https://bugs.launchpad.net/percona-xtrabackup/+bug/1671437
關於相關程式碼contributor的討論如下:
- https://github.com/percona/percona-xtrabackup/pull/378
既然可能是bug,那麼檢查了一下當前最新的版本為2.4.8,檢查relase note發現該bug已經得以修復:
重新下載並使用當前最新版本的xtrabackup即可解決:
- https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.8/binary/tarball/percona-xtrabackup-2.4.8-Linux-x86_64.tar.gz
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29773961/viewspace-2147175/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Web伺服器捉蟲速記Web伺服器
- 子執行緒 UI 問題捉蟲執行緒UI
- W32DASM8.93捉蟲記 湖北 wuhuashangASM
- MySQL·捉蟲動態·唯一鍵約束失效MySql
- InnoDB儲存引擎——Master Thread工作方式儲存引擎ASTthread
- [捉蟲記錄] access violation writing location _findnext
- 給Chrome“捉蟲”16000個,Google開源bug自檢工具ChromeGo
- 捉蟲記之dozer對映父類屬性被重寫
- [捉蟲記錄]關於Cascade Training Error的bugAIError
- MySQL·捉蟲動態·DROPDATABASE外來鍵約束的GTIDBUGMySqlDatabaseTiDB
- Excel 2021&365 函式與公式應用大全 捉蟲Excel函式公式
- ChunJun 1.16 Release版本即將釋出,bug 捉蟲活動邀您參與!
- The slave I/O thread stops because master and slave have equal MySQL server UUIDthreadASTMySqlServerUI
- MySQL Master/Slave Master/MasterMySqlAST
- 【Xtrabackup】Xtrabackup備份基礎知識
- xtrabackup: Error: cannot open /../../base/xtrabackup_checkpointsError
- XtraBackup工具詳解 Part 2 xtrabackup安裝
- XtraBackup工具詳解 Part 3 XtraBackup工作原理
- HDU-安卓程式開發之簡單儲存/內部儲存/外部儲存 & 捉蟲安卓
- MySQL核心月報2014.10-MySQL· 捉蟲動態·binlog重放失敗MySql
- 安裝xtrabackup
- 【Xtrabackup】Xtrabackup全備、增量備份及恢復示例
- MySQL核心月報2015.03-MySQL·捉蟲動態·pidfile丟失問題分析MySql
- XtraBackup工具詳解 Part 4 XtraBackup許可權及配置
- ! [rejected] master -> master (fetch first)AST
- Mysql5.6 Master+MasterMySqlAST
- MySQL:xtrabackup備份MySql
- RHEL安裝Xtrabackup
- MySQL Percona XtraBackupMySql
- XtraBackup備份MySQLMySql
- Percona XtraBackup 2.4 xtrabackup全量、增量備份恢復流程
- Right here waitingAI
- Mongodb的master-slave模式與master-master模式實驗MongoDBAST模式
- MySQL 備份軟體 Xtrabackup 的 xtrabackup_binlog_pos_innodb和xtrabackup_binlog_info 檔案區別MySql
- 走進JVM,淺水也能捉魚JVM
- MySQL8.0之XtraBackupMySql
- xtrabackup備份mysql innodbMySql
- Xtrabackup安裝及使用