SAP Knowledge Base Article - Preview

3259677 - Snapshot deletion when the data volume is high

Symptom

Facing with a high Data volume situation and see a disk full event in the indexserver trace.

[53856]{-1}[-1/-1] 2022-08-12 15:23:56.170342 i EventHandler     LocalFileCallback.cpp(00495) : [DISKFULL] (1st request) [W] , buffer= 0x0001ff6b82330000, offset= 1970802786304, size= 0/16777216, file= "<root>/datavolume_0000.dat" ((open, mode= RW, access= rw-rw-r--, flags= ASYNC|DIRECT|MUST_NOT_EXIST|LOCK), factory= (root= "/hana/data/<SID> /mnt00001/hdb00003.00003/" (access= rw-rw-r--, flags= AUTOCREATE_PATH, usage= DATA, 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)}
[54947]{-1}[-1/-1] 2022-07-08 14:48:44.170390 i EventHandler     EventManagerImpl.cpp(00675) : New event reported: 'DiskFullEvent[id= 2, path= /hana/data/<SID>/mnt00001/hdb00003.00003/, state= NEW]'
[54947]{-1}[-1/-1] 2022-07-08 14:48:44.170399 i Logger           LoggerImpl.cpp(00104) : Logger notified of new DiskFull: DiskFullEvent[id= 2, path= /hana/data/<SID> /mnt00001/hdb00003.00003/, state= NEW]

Executing the following script (HANA_Disks_Data_Overview_*) from the following SAP Note 1969700 - SQL Statement Collection for SAP HANA and the result is something like this:

HOST,PORT,ALLOC_GB,USED_GB,COLTAB_GB,ROWTAB_GB,FLOB_GB,PLOB_GB,HISTORY_GB,SHADOW_GB,LIVECACHE_GB,DOCSTORE_GB,OTHER_GB
"vhslkz4mnh23","31450"," 3792.14"," 4457.72"," 2748.52"," 27.18"," 9.12"," 4.78"," 0.24"," 341.74"," 0.00"," 0.00"," 1512.40"

At the result there is a high usage at OTHER_GB.

Also experiencing large replication snapshots in the system and would like to drop these, but got the following lock situation:

"vhslkz4mnh23 ",30450,"indexserver","?","2022-08-08 13:21:13.521937000",44604,"Request","pers/dropreplicationsnapshots","?","Mutex Wait","TRUE",1901345,"","","?","?","?","?",-1,-1,-1,"?","?","?","?",76,76,"?",-1,-1,"Other","SnapshotDirectoryLock",102086,"",5,0,0,0x,"",0x,-1,"","",3
"vhslkz4mnh23 ",30450,"indexserver","?","2022-08-08 13:51:17.268331000",44604,"Request","pers/dropreplicationsnapshots","?","Mutex Wait","TRUE",2505092,"","","?","?","?","?",-1,-1,-1,"?","?","?","?",77,77,"?",-1,-1,"Other","SnapshotDirectoryLock",102086,"",5,0,0,0x,"",0x,-1,"","",3
"vhslkz4mnh23 ",30450,"indexserver","?","2022-08-08 16:27:30.317521000",44604,"Request","pers/dropreplicationsnapshots","?","Mutex Wait","TRUE",6478141,"","","?","?","?","?",-1,-1,-1,"?","?","?","?",76,76,"?",-1,-1,"Other","SnapshotDirectoryLock",102086,"",5,0,0,0x,"",0x,-1,"","",3
6346 rows selected (overall time 8762.401 msec; server time 1647.270 msec)


Read more...

Environment

SAP HANA, platform edition 2.0

SAP HANA, platform edition 1.0

Product

SAP HANA, platform edition all versions

Keywords

OTHER_GB, data volume, HANA, SNAPSHOT, savepoint, diskfull, LocalFileCallback.cpp, DiskFullEvent, EventManagerImpl.cpp , KBA , HAN-DB-PER , SAP HANA Database Persistence , Problem

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.