Re: [External]Re: Postgres Crash Issue - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: [External]Re: Postgres Crash Issue
Date
Msg-id 20220315133213.GC10372@depesz.com
Whole thread Raw
In response to Postgres Crash Issue  ("Sankar, Uma (Uma)" <usankar@avaya.com>)
Responses Re: [External]Re: Postgres Crash Issue
RE: [External]Re: Postgres Crash Issue
List pgsql-general
On Tue, Mar 15, 2022 at 01:30:25PM +0000, Menon, Deepak (Deepak) wrote:
> Hi Depesz,
> 
> Then what does this message mean ?
> 
> 2022-03-11 08:58:42.956 UTC [17115] DETAIL:  The postmaster has commanded this server process to roll back the
currenttransaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 
 


When someone issues pg_ctl -m immediate stop (which is the immediate
shutdown). pg basically shutd backends in their head. This, in turn,
means that all other have to exit to avoid shared memory corruption.

Sometimes such exit happens before pg_ctl will kill next backend,
sometimes not. So you sometimes can get such messages.

depesz



pgsql-general by date:

Previous
From: "Menon, Deepak (Deepak)"
Date:
Subject: RE: [External]Re: Postgres Crash Issue
Next
From: "Menon, Deepak (Deepak)"
Date:
Subject: RE: [External]Re: Postgres Crash Issue