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
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.
SAP Knowledge Base Article - Preview