Search Postgresql Archives

RE: [External]Re: Postgres Crash Issue

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

 



Thanks Depesz. Is there anyway to check the source of the command as this HA setup is managed by using Patroni 

Deepak Menon| Avaya Managed Services-Delivery|+91 9899012875| menond@xxxxxxxxx
Leave Alert : 

-----Original Message-----
From: depesz@xxxxxxxxxx <depesz@xxxxxxxxxx> 
Sent: Tuesday, March 15, 2022 7:02 PM
To: Menon, Deepak (Deepak) <menond@xxxxxxxxx>
Cc: Sankar, Uma (Uma) **CTR** <usankar@xxxxxxxxx>; pgsql-general@xxxxxxxxxxxxxx
Subject: Re: [External]Re: Postgres Crash Issue

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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux