SAP Knowledge Base Article - Preview

2736379 - HANA DB Driver with SAP Hybris Commerce consumes an increasing amount of memory

Symptom

When running intensive DB operations such as data imports or synchronization jobs, after a long period of time Java heap memory usage increases and is never released. The import or sync job will run for a long time without much progress and a lot of CPU time will be spent doing garbage collection. It may result in an OutOfMemoryError and the node becoming unresponsive.

When taking thread dumps, you will likely see the "Finalizer" thread BLOCKED with a stack trace related to the DB Driver:

"Finalizer" #3 daemon prio=8 os_prio=0 cpu=60210.00 [reset 60210.00] ms elapsed=8670.72 [reset 8670.72] s allocated=68480 B (66.88 KB) [reset 68480 B (66.88 KB)] defined_classes=1
INFO | jvm 1 | main | 2018/01/0106:14:45.454 | io= file i/o: 636/0 B, net i/o: 0/0 B, files opened:-157, socks opened:0 [reset file i/o: 636/0 B, net i/o: 0/0 B, files opened:-157, socks opened:0 ] 
INFO | jvm 1 | main | 2018/01/01 06:14:45.454 | tid=0x00007ff7d9510000 nid=0x1b7a / 7034 pthread-id=140701779883776 waiting for monitor entry [_thread_blocked (_at_safepoint), stack(0x00007ff7af8bf000,0x00007ff7af9c0000)] [0x00007ff7af9be000] top_bci: 0
INFO | jvm 1 | main | 2018/01/01 06:14:45.454 | java.lang.Thread.State: BLOCKED (on object monitor)
INFO | jvm 1 | main | 2018/01/0106:14:45.454 | at com.sap.db.jdbc.ConnectionSapDB.isClosed()Z(ConnectionSapDB.java:398)
INFO | jvm 1 | main | 2018/01/01 06:14:45.454 | - waiting to lock <0x00000004e82b2b90> (a com.sap.db.jdbc.ConnectionSapDBFinalize)

...

If you take a heap dump you will notice the largest object by retained size is of class java.lang.ref.Finalizer and many of the classes contained in the heap dump are related to the HANA DB Driver (com.sap.db.jdbc.*)


Read more...

Environment

Hybris Commerce 6.x

HANA DB

Product

SAP Hybris Commerce 6.6 ; SAP Hybris Commerce 6.7

Keywords

HANA, OutOfMemoryException, OutOfMemoryError , KBA , CEC-COM-CPS , SAP Commerce , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.