HANA 数据库备份hang住的解决办法

今天遇到 HANA 数据库备份hang住的情况。经过查 SAP NOTE 解决，记录一下过程。两个NOTE如下：

2452735 - HANA Backup failing with "[447]: backup could not be completed: [110122] A data backup cannot be created because another data backup is running or a storage snapshot has been prepared."https://launchpad.support.sap.com/#/notes/24527352827950 - How-To: Cancel Hanging Backup on SAP HANAhttps://launchpad.support.sap.com/#/notes/2827950负责备份同事报告，HANA 数据库备份失败。报错如下，完全符合NOTE 2452735中的描述，因为同一时间只能有一个备份执行，所有要把未能正常结束的备份进程杀掉。

"[447]: backup could not be completed: [110122] A data backup cannot be created because another data backup is running or a storage snapshot has been prepared."

打开 HANA Studio 开启 SQL Console 执行NOTE中的 sql 查看中备份情况，发现有一个ID为1633757933867 的 Backint 类型备份没有正常结束。

 select * from  "SYS"."M_BACKUP_CATALOG" where STATE_NAME = 'running';

打开 Backup 页面，ID为 1633757933867 的备份当时Status列没有绿黄红灯状态，状态未知。

根据NOTE，找到并查看日志文件 /hana/shared/<SID>/HDB00/<HOSTNAME>/trace/<DB_tenentdbSID>/backint.log  

locate backint.log

vim /hana/shared/<SID>/HDB00/<HOSTNAME>/trace/<DB_tenentdbSID>/backint.log

 在日志中按照时间和备份的ID号，找到相应的 pid （是37023），把这个出问题的进程 kill 掉。 

xxxx-xx-xx xx:xx:xx.xxx backint started:
 command: /usr/sap/SID/SYS/global/hdb/opt/hdbbackint -f backup -i /var/tmp/hdbbackint_SID.XXXXXX -o /var/tmp/hdbbackint_SID.XXXXXX -u SID -s 1604925958336 -c 1 -l LOG
 pid: 1887 <-- Process to kill
 input:
 #SOFTWAREID "backint 1.04" "HANA HDB server 4.50.000.00.0000000000"

kill -9 37023

再发起备份就完全正常了。