Subject: Re: Data Corruption Errors
To: pgsql-admin@lists.postgresql.org
References: 
 <CAFwQ8rdGB-jUPtrDXpp-gMgS8guWg8SWSkBjkXy0San3rmvj8w@mail.gmail.com>
 <64b2d16e-6c7c-002a-1e16-209a3ae43bef@2ndquadrant.com>
 <1538051973729.67553@sdc-world.com>
From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Message-ID: <78ea6e8f-a55b-5724-c86e-723a4e7b9e19@matrix.gatewaynet.com>
Date: Thu, 27 Sep 2018 16:13:55 +0300
User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:60.0) Gecko/20100101
 Thunderbird/60.0.1
MIME-Version: 1.0
In-Reply-To: <1538051973729.67553@sdc-world.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Precedence: bulk

On 27/9/18 3:39 μ.μ., Ferrell, Denise SDC wrote:
> 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"

Did your DB eventually recover? Have you ruled reasons like OOM, non-optimal vm.swapiness , etc ?

>
> 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


-- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt