Re: Data Corruption Errors

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Dear Ferrell,
 
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.
 
Best regards.
Samed YILDIRIM
 
27.09.2018, 15:40, "Ferrell, Denise SDC" <denise.ferrell@xxxxxxxxxxxxx>:

Using Linux/PostgreSQL 9.5 & setup on a VM.

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.

"LOG: server process (PID xxxxx) was terminated by signal 9: Killed
DETAIL: Failed process was running
   select insert_data ($1, $2,....)
WARNING: terminating connection because of crash of another server process
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.
HINT: In a moment you should be able to reconnect ....
LOG: connection received
FATAL: the database system is in recovery mode"

The last 2 lines are repeated and logging is not available.

How can I determine data/table/shared memory corruption?

Thank you in advance for your responses.

D. Ferrell


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux