Pivotal Knowledge Base

Follow

Linux addr2line function core generated due to System Out of Memory

Environment

Product Version
Pivotal Greenplum (GPDB) 4.3.x
OS RHEL 6.x

Purpose

Multiple core files got created from gpadmin user due to queries failing with System Out of memory issues. 

Following is sample of core files generated

-rw------- 1 gpadmin gpadmin 20660224 Aug 18 15:36 core.addr2line.401062.1471548998.11.500.500
-rw------- 1 gpadmin gpadmin 31973376 Aug 18 15:36 core.addr2line.401092.1471548998.11.500.500
-rw------- 1 gpadmin gpadmin 23093248 Aug 18 15:36 core.addr2line.401455.1471549003.11.500.500

This article will provide you way to resolve the issue

Cause

The core files were created from Linux function addr2line because of NULL being passed to it from Greenplum function call. Linux addr2line function is called internally from GPDB for error logging and reporting.

Procedure

As this issue is started with Out of Memory (from pg_log), users need to work with their DBA team to resolve the issue.

You can try below steps to remove the out of memory issue:

1)  Run maintenance script(Vacuum,reindex & Analyze of objects) for Database if massive DML operations have been performed

2) Tune the query causing Out of memory issue

After trying both the options, if you still see an issue, please contact Pivotal Support.

Comments

Powered by Zendesk