2962726 - HANA DB generating many catalog backup files

You observed that HANA DB is generating backup catalog history files every few minutes with size of more than 7GB and which is causing file system to DISK FULL situation.

On indexserver trace you can see messages similar with the example below:

>>><<<
-13658]{-1}[-1/-1] 2020-06-26 11:59:26.781577 i Backup BackupExecutor.cpp(00550) : Starting serial FILE backup in 1 chunks. 1.: Backup of BackupSource: [CATALOG] Version 1 @ 0x00007f0f00e87240 into BackupDestination: [FILE][/usr/sap/ABC/ABC03/backup/log/DB_ABC/log_backup_0_0_0_0.1593143966778], max size 18446744073709551615, version 10 @ 0x00007f1e537fc180, channel="<root>/.log_backup_0_0_0_0.1593143966778" ((open, mode= W, access= rw-r-----, flags= ASYNC|DIRECT|TRUNCATE|UNALIGNED_SIZE), factory= (root= "/usr/sap/ABC/ABC03/backup/log/DB_ABC/" (access= rw-r-----, flags= AUTOCREATE_PATH|DISKFULL_ERROR, usage= CATALOG_BACKUP, fs= xfs, config= (async_write_submit_active=on,async_write_submit_blocks=all,async_read_submit=on,num_submit_queues=1,num_completion_queues=1,size_kernel_io_queue=512,max_parallel_io_requests=64,min_submit_batch_size=16,max_submit_batch_size=64)), callback=0x00007f0f00863240
[13146]{-1}[-1/-1] 2020-06-26 11:59:39.518772 e FileIO LocalFileCallback.cpp(00354) : ERROR in async. file transfer: exception 1: no.2000008 (Basis/IO/FileAccess/impl/LocalFileCompletionThread.cpp:320) TID: 13146
Error during asynchronous file transfer (io_getevents), rc=28: No space left on device; $fileCallback$=[W] , buffer= 0x00007f1815440000, offset= 6291460096, size= 0/8388608, file= "<root>/.log_backup_0_0_0_0.1593143966778" ((open, mode= W, access= rw-r-----, flags= ASYNC|DIRECT|TRUNCATE|UNALIGNED_SIZE), factory= (root= "/usr/sap/ABC/ABC03/backup/log/DB_ABC/" (access= rw-r-----, flags= AUTOCREATE_PATH|DISKFULL_ERROR, usage= CATALOG_BACKUP, fs= xfs, config= (async_write_submit_active=on,async_write_submit_blocks=all,async_read_submit=on,num_submit_queues=1,num_completion_queues=1,size_kernel_io_queue=512,max_parallel_io_requests=64,min_submit_batch_size=16,max_submit_batch_size=64))) {shortRetries= 0, fullRetries= 0 (0/10)}

.

.

exception 2: no.2000008 (Basis/IO/FileAccess/impl/LocalFileCompletionThread.cpp:320) TID: 13146

Error during asynchronous file transfer (io_getevents), rc=28: No space left on device; $fileCallback$=[W] , buffer= 0x00007f1815440000, offset= 6291460096, size= 0/8388608, file= "<root>/.log_backup_0_0_0_0.1593143966778" ((open, mode= W, access= rw-r-----, flags= ASYNC|DIRECT|TRUNCATE|UNALIGNED_SIZE), factory= (root= "/usr/sap/ABC/ABC03/backup/log/DB_ABC/" (access= rw-r-----, flags= AUTOCREATE_PATH|DISKFULL_ERROR, usage= CATALOG_BACKUP, fs= xfs, config= (async_write_submit_active=on,async_write_submit_blocks=all,async_read_submit=on,num_submit_queues=1,num_completion_queues=1,size_kernel_io_queue=512,max_parallel_io_requests=64,min_submit_batch_size=16,max_submit_batch_size=64))) {shortRetries= 0, fullRetries= 0 (0/10)}
>>><<<

And you´ve already performed the Housekeeping as mentioned in the following documentation:

• SAP Note 2505218 - Large Log Backups due to large backup catalog
• SAP Note 2582445 - HANA Log backup are growing to 16GB file size
• SAP Note 2096851 - Backup Catalog Housekeeping within HANA DB

But the size of the Backup catalog will not reduced and be still written every few minutes in the full 7Gb size.

• SAP HANA PLATFORM EDITION 1.0
• SAP HANA PLATFORM EDITION 2.0

high, big, overloaded, backupcatalog , KBA , HAN-DB-BAC , SAP HANA Backup & Recovery , How To