某局点dbman备份缺少文件问题排查分析

无

某局点总行下属有10个分行，10套iMC每天凌晨04:00定时dbman备份数据到本地并传送至同一备机，但其中某两台dbman备份失败缺少部分文件

通过查看dbman_debug.log日志，发现如下报错：

2018-11-22 04:11:08 [ERROR] [locateDb] Can not find strKey: 127.0.0.1@perf_db_imc_perf 

2018-11-22 04:11:08 [ERROR] [CDbBackup::BackupAllDataBase] Fail to found DB file config information 127.0.0.1@perf_db_imc_perf 

2018-11-22 04:11:10 [INFO] [runCommand] runCommand result OK. ret=0, WIFEXITED(ret)=1, WEXITSTATUS(ret)=0 

2018-11-22 04:11:10 [DEBUG] [CDbBackup::BackupOneLocalZipFile] Exec shell log: 

2018-11-22 04:11:13 [INFO] [FuncName] [CRcvFtpClient2::createCtrolConn] Sending content: USER 

2018-11-22 04:11:13 [INFO] [FuncName] [CRcvFtpClient3::createCtrolConn] Received reponse message: 331 Password required for jinhua 

2018-11-22 04:11:13 [INFO] [FuncName] [CRcvFtpClient2::createCtrolConn] Sending content: PASS 

2018-11-22 04:11:13 [INFO] [FuncName] [CRcvFtpClient3::createCtrolConn] Received reponse message: 230 Logged on  

2018-11-22 04:11:16 [ERROR] [FuncName] [CFtpClientTask::sendFileContent] nRet < =0 

2018-11-22 04:11:16 [ERROR] [int FtpPut()] Fail to ftp transfer file:E:\dbmanbak\perf_20181122_040004.zip. to ftp server:21.208.64.63 

2018-11-22 04:11:16 [INFO] [CDbBackup::BackupOneLocalZipFile] ftp trans failed 

2018-11-22 04:11:16 [INFO] [sendTrapAlert] Send trap success 

 2018-11-22 04:11:16 [WARNING] [CDbBackup::BackupAllDataBase] Execute BeforeBackupSQLScript failed. 

2018-11-22 04:11:16 [ERROR] [TimeBackup] Auto backup all db failed

其中 nRet < =0 和Fail to ftp transfer file，问题原因为ftp传输出现问题，查看nRet < =0报错原因可能为网络断开或者抖动不稳定。

现场FTP服务器是开源的，查看ftp服务器配置，最大并发传输极限为10，一般并发性能有有限，不建议同一时间大量向其传输文件。现场10台iMC同一时间集中快速传输数据，FTP在应用层处理不过来，发生中断。

进行分时备份，即将10台iMC dbman自动备份的时间错开，比如其中4台2:00；3台3:00；3台4:00分开进行dbman本地备份并传至备机。