From: Ferrell, Denise SDC <denise.ferrell@sdc-world.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Data Corruption Errors
Date: Thu, 27 Sep 2018 12:39:33 +0000
Message-ID: <1538051973729.67553@sdc-world.com> (raw)
In-Reply-To: <64b2d16e-6c7c-002a-1e16-209a3ae43bef@2ndquadrant.com>
References: <CAFwQ8rdGB-jUPtrDXpp-gMgS8guWg8SWSkBjkXy0San3rmvj8w@mail.gmail.com>
<64b2d16e-6c7c-002a-1e16-209a3ae43bef@2ndquadrant.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: denise.ferrell@sdc-world.com
Subject: Re: Data Corruption Errors
In-Reply-To: <1538051973729.67553@sdc-world.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox