- Pivotal Greenplum Database (GPDB) 4.3.x
- Operating System- Red Hat Enterprise Linux 6.x
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 a way to resolve the issue
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.
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.