MySQL NDB集群备份中止失败且无法启动新备份问题求助
MySQL NDB集群备份中止失败且无法启动新备份问题求助
我现在碰到了NDB集群备份的棘手问题,想向大家求助。
我尝试用以下命令中止一个备份任务:
ndb_mgm> abort backup 2304081512 Abort of backup 2304081512 ordered
执行后虽然提示已经下达中止指令,但备份状态完全没变化,看起来像是卡住了:
ndb_mgm> all report backup Node 2: Backup not started Node 3: Local backup status: backup 2304081512 started from node 12 #Records: 1950 #LogRecords: 8705 Data: 635312 bytes Log: 2676612 bytes Node 4: Local backup status: backup 2304081512 started from node 12 #Records: 1768 #LogRecords: 7211 Data: 522256 bytes Log: 2133088 bytes
更麻烦的是,当我尝试启动新的备份任务时,直接报错说已有备份在运行:
ndb_mgm> start backup 2304091121 snapshotstart Connected to Management Server at: 192.168.169.40:1186 Waiting for completed, this may take several minutes Node 3: Backup request from 12 failed to start. Error: 1302 Backup failed * 3001: Could not start backup * A backup is already running: Permanent error: Application error
另外,除了备份问题,Node 2的NDB引擎日志里还有一条告警信息,不知道和当前问题有没有关联:
2023-04-07 10:31:57 [ndbd] ALERT -- Node 2: Forced node shutdown completed. Caused by error 2315: 'Node declared dead. See error log for details(Arbitration error). Temporary error, restart node'.
现在我完全不知道该怎么解决这个困境,希望有相关经验的朋友能给我一些建议,谢谢大家!
备注:内容来源于stack exchange,提问作者Julien
相关产品推荐
相关产品推荐

