Symptom
There are a lot of Alert 88 reported on different tables.
"Delta Merge was not executed successfully on <host_name:port_number> for table <table_name> in schema <schema_name> for 4 occurrences in the last 24 hours."
In HANA DB indexserver trace file, the following error messages are reported:
[513845]{-1}[157/846837006] 2023-08-21 04:09:42.377797 e Mergedog Mergedog.cpp(01311) : Automerge failed: {IndexName: <schema_name>:<table_name>, Trigger: , Critical: 0, ReclaimDelta: false, DeltaMerge: true, OptimizeCompression: false, MainSize: 2967469}, error: Caught exception during delta merge; table = <SID>::<schema_name>:<table_name> (t ####), exception = exception 2030112: Could not delete block, path=3423809-000000fe000d9fa5-00018c03-000000d0-00000001_379502.fileblock, rc=13 (Permission denied)(2488)
[3423942]{-1}[158/846837007] 2023-08-21 04:09:42.439733 i TraceContext TraceContext.cpp(01347) : UserName=, StatementExecutionID=844439493578761
[3423942]{-1}[158/846837007] 2023-08-21 04:09:42.439733 e NonVolatileMemor NVMFileAccess.cpp(00347) : NVM:---------Could not delete '/hana/tmpfs0/<SID>/mnt00001/hdb00003.00003/NVM-Root/PM-VolumeID3/data1/3423809-000000fe000d9fa5-00018c03-000000d0-00000001_379502.fileblock', error code: 13 (Permission denied)
[3423942]{-1}[158/846837007] 2023-08-21 04:09:42.439768 e NonVolatileMemor NVMProvider.cpp(04861) : NVM: => put block 3423809 back to delayed queue, stop working on queue
[3423942]{-1}[158/846837007] 2023-08-21 04:09:42.440097 e delta_merge SaveMergedAttributeJob.cpp(00094) : Caught exception in save merged column job: table = LM3::_SYS_STATISTICS:HOST_SERVICE_THREAD_CALLSTACKS_BASE (t 177335), column id = 201, column name = SNAPSHOT_ID, rc = 2488, exception = exception 1: no.2030112 (Basis/MemoryManager/impl/NVMProvider.cpp:4865) TID: 3423942
Could not delete block, path=3423809-000000fe000d9fa5-00018c03-000000d0-00000001_379502.fileblock, rc=13 (Permission denied)
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Read more...
Environment
- SAP HANA, platform edition 1.0
- SAP HANA, platform edition 2.0
Product
Keywords
Alert 88, Automerge failed, Could not delete block, Permission denied , KBA , HAN-DB , SAP HANA Database , 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.