SAP Knowledge Base Article - Preview

2621844 - Backup ID provided for DT backint based backups is incorrect - SAP HANA DYNAMIC TIERING

Symptom


When doing a full backup on SAP HANA Dynamic Tiering, there are four invocations of hdbbackint that relate to the full database backup like the following:

2018-02-23 08:36:02.000 backint started:
command: /usr/sap/SUP/SYS/global/hdb/opt/hdbbackint -f backup -p /usr/sap/SUP/SYS/global/hdb/opt/hdbconfig/initSUP.utl -i /var/tmp/hdbbackint_SUP.Sb4rPa -o /var/tmp/hdbbackint_SUP.cyp5In -u XXX -s XXXXX -c 5 -l COMPLETE
pid: 5673
input:
#SOFTWAREID "backint 1.04" "HANA HDB server 1.00.122.15.1516128271"
#PIPE "/usr/sap/SUP/SYS/global/hdb/backint/AFTER_UPDATE_databackup_0_1"

And among them there is an additional one:

2018-02-23 08:36:12.000 backint started:
command: /usr/sap/SUP/SYS/global/hdb/opt/hdbbackint -f backup -p /usr/sap/SUP/SYS/global/hdb/opt/hdbconfig/initSUP.utl -i /var/tmp/hdbbackint_SUP.92f3dT -o /var/tmp/hdbbackint_SUP.P8EnPb -u XXX -s XXXXX -c 1 -l COMPLETE
pid: 5775
input:
#SOFTWAREID "backint 1.04" "HANA HDB server 1.00.122.15.1516128271"
#PIPE "/usr/sap/SUP/SYS/global/hdb/backint/AFTER_UPDATE_databackup_1024_1_1519371361036"

It is supposed not to belong to the backup because argument for parameter -s is different from the other hdbbackint call (1519371372204).
but there are only 4 hdbbackint calls with '-s 1519371361036'.
When checking the backup catalog, the backup with id 1519371361036 consists of 5 objects including the
/usr/sap/SUP/SYS/global/hdb/backint/AFTER_UPDATE_databackup_1024_1_1519371361036.

command: /usr/sap/SSS/SYS/global/hdb/opt/hdbbackint -f backup -p /usr/sap/SSS/SYS/global/hdb/opt/hdbconfig/initSSS.utl -i /var/tmp/hdbbackint_SSS.92f3dT -o /var/tmp/hdbbackint_SSS.P8EnPb -u XXX -s XXXXX -c 1 -l COMPLETE

pid: 5775
input:
#SOFTWAREID "backint 1.04" "HANA HDB server 1.00.122.15.1516128271"
#PIPE "/usr/sap/SSS/SYS/global/hdb/backint/AFTER_UPDATE_databackup_1024_1_1519371361036"

Options '-s' is supposed to be the backup id (here 1519371372204). But in the backup catalog the file gets assigned to backup id 1519371361036.

> hdbsql -U my_key 'select BACKUP_ID,DESTINATION_PATH,DESTINATION_TYPE_NAME,EXTERNAL_BACKUP_ID from M_BACKUP_CATALOG_FILES where BACKUP_ID=1519371361036' | cat
BACKUP_ID,DESTINATION_PATH,DESTINATION_TYPE_NAME,EXTERNAL_BACKUP_ID
1519371361036,"/usr/sap/SSS/SYS/global/hdb/backint/AFTER_UPDATE_databackup_0_1","backint","SSS___A0JDZMHANU"
1519371361036,"/usr/sap/SSS/SYS/global/hdb/backint/AFTER_UPDATE_databackup_1_1","backint","SSS___A0JDZMHANU"
1519371361036,"/usr/sap/SSS/SYS/global/hdb/backint/AFTER_UPDATE_databackup_2_1","backint","SSS___A0JDZMHANU"
1519371361036,"/usr/sap/SSS/SYS/global/hdb/backint/AFTER_UPDATE_databackup_3_1","backint","SSS___A0JDZMHANU"
1519371361036,"/usr/sap/SSS/SYS/global/hdb/backint/AFTER_UPDATE_databackup_1024_1_1519371361036","backint","SSS___A0JDZMHIM3"

So the esserver is considered to be part of the backup. Which matches the hdbbackint command line argument '-c 5'.
That means the backup consists of 5 files.
But there are just 4 hdbbackints started for backup id 1519371361036.
It is missing one hdbbackint call for the esserver and the esserver backup should be started with arguments '-c 5' and '-s 1519371361036' too.


Read more...

Environment

SAP HANA Dynamic Tiering 1.0 Revision 122.15

Product

SAP HANA 1.0, platform edition

Keywords

DT , DYT , Backint , KBA , HAN-DYT , SAP HANA Dynamic Tiering , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.