Skip to Content

HANA 2 Memory Leak after Upgrade

Hi,


some weeks ago we upgraded our Solution Manager 7.2 from HANA 1.0 SP12 to HANA 2.0 SP4 Rev 2.

Now we have a memory leak problem on the JAVA System of the SM. (ABAP is fine with same DB Version).

Before the upgrade the system used 30GB Memory. Now the System gathers more and more memory until it allocats all (100GB) and then the errors start, backup fails, due to insufficent memory, ...

On the OS we see that the hdbindexserver is using this memory.

It's only on the JAVA production System. JAVA Development is running fine, with the same DB Version.

Did we miss to set a Parameter ? Or any other suggestions ?

Thanks

Lukas

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Oct 16, 2019 at 05:54 AM

    Hello Lukas,

    As you can see HANA heap memory takes around 78 GB of memory and below allocators uses the most.

    Pool/RowEngine/QueryExecution/SearchAlloc - 23 GB

    Pool/RowEngine/Session - 14 GB

    Pool/Statistics - 11 GB

    If possible kindly check below SAP Note, as solution manager java uses jdbc connection to connect to java database. Below SAP Note suggest similar symptoms.

    2711824 - High Number of Prepared Statements Causing High Usage of Memory Allocator Pool/Statistics

    If you have upgrade HANA databases, kindly update HANA client on SolMan JAVA application servers as well to version 2.3.38 (or higher).

    Regards,

    Dennis Padia

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.