Symptom
You are using HANA Smart Data Access to fetch a large amount of data
form a remote database and to process them within the HANA database. You
are on HANA DB revision 85.02 or lower. During the processing of the
data from the remote database, the used memory of HANA is continously
rising and the memory is not released back afterwards. In the end, you
run into an out of memory problem. The memory allocator pool/itab which
includes temporary column store results is consuming most of the memory.
Environment
You are using HANA database on revision 85.02 or lower. You are also using HANA Smart Data Access.
Reproducing the Issue
The issue can be frequently seen while using Smart Data Access to
fetch a large amount of remote data which are processed in the HANA
database.
Cause
The issue is due to a memory leak problem which is existing on HANA
revision 85.02 or lower. The problem has been solved since HANA revision
91 and the resolution has also been backported to HANA maintenance
revision 85.03.
Resolution
The problem has been solved since HANA revision 91 and the resolution
has also been backported to HANA maintenance revision 85.03. Please
upgrade your database to revision 85.03 or higher.
Keywords
HANA out of memory, pool/itab, memory leak, smart data access
No comments:
Post a Comment