<div xmlns="http://www.w3.org/1999/xhtml">Dear Ferrell,</div><div xmlns="http://www.w3.org/1999/xhtml"> </div><div xmlns="http://www.w3.org/1999/xhtml">Could you please check the system logs? It looks like it is related with OOM. Or, do you use any extension in the insert function? Maybe a memory leak exists caused by an extension.</div><div xmlns="http://www.w3.org/1999/xhtml"> </div><div xmlns="http://www.w3.org/1999/xhtml">Best regards.</div><div xmlns="http://www.w3.org/1999/xhtml">Samed YILDIRIM</div><div xmlns="http://www.w3.org/1999/xhtml"> </div><div xmlns="http://www.w3.org/1999/xhtml">27.09.2018, 15:40, "Ferrell, Denise SDC" <denise(dot)ferrell(at)sdc-world(dot)com>:</div><blockquote xmlns="http://www.w3.org/1999/xhtml" type="cite"><p>Using Linux/PostgreSQL 9.5 & setup on a VM.<br /><br />I'm receiving the following errors during an insert using a function but this does not happen every time. When this does occur the database/system is unavailable until the processes are killed or the service is restarted.<br /><br />"LOG: server process (PID xxxxx) was terminated by signal 9: Killed<br />DETAIL: Failed process was running<br /> select insert_data ($1, $2,....)<br />WARNING: terminating connection because of crash of another server process<br />DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.<br />HINT: In a moment you should be able to reconnect ....<br />LOG: connection received<br />FATAL: the database system is in recovery mode"<br /><br />The last 2 lines are repeated and logging is not available.<br /><br />How can I determine data/table/shared memory corruption?<br /><br />Thank you in advance for your responses.<br /><br />D. Ferrell</p></blockquote>