cancel
Showing results for 
Search instead for 
Did you mean: 

SAP HANA BACKUP Failing Due to Out of Memory

okhan
Discoverer
0 Kudos
1,506

I am trying to use a new backup solution for one of our test SAP HANA servers and it is giving an out of memory issue. Here are the errors that I get when I try to back up.

447: backup could not be completed: [1000002] Allocation failed ; $size$=262144; $name$=<unnamed>; $type$=UnsynchronizedObjectCacheAllocator; $failure_type$=GLOBAL_ALLOCATION_LIMIT; $failure_flag$= (early exit) SQLSTATE: HY000

4: cannot allocate enough memory: [9] Memory allocation failed;exception 1000002: Allocation failed ; $size$=1352; $name$=X2InstanceAllocator; $type$=pool; $inuse_count$=9; $allocated_size$=2512; $failure_type$=GLOBAL_ALLOCATION_LIMIT
; $failure_flag$= (early exit)

4: cannot allocate enough memory: Out of memory on query open SQLSTATE: HY000

Here is the current state of mounted drives on the server.

The log drive is almost full as this server was disconnected from the data domain to be connected to the new backup solution. The system is also using a large amount of its available physical memory. I have disabled THP. I have also decreased the data backup buffer from 512 to 256 but its still runs out of memory. Does anyone here faced any issue like this and have any strategies on how to resolve this?

Accepted Solutions (1)

Accepted Solutions (1)

eason_chen
Product and Topic Expert
Product and Topic Expert

Hi,

You may troubleshooting OOM issue with note 1999997.
It would also be helpful for you to run following SQLs attached in note 1969700 to check what may caused OOM.
HANA_Memory_Overview (in tenant DB)
HANA_Backups_CatalogSize_1.00.90+_MDC (in SYSTEMDB)

Best Regards,
Eason Chen

okhan
Discoverer
0 Kudos

Thank you. I will try this and will let you know

Answers (0)