SAP Knowledge Base Article - Preview

3368400 - Alert 88 about Delta Merge failure due to OS exception "Permission Denied"

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

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

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.