Re: [External]Re: Postgres Crash Issue

2022-03-15 Thread Adrian Klaver
On 3/15/22 6:30 AM, Menon, Deepak (Deepak) wrote: Hi Depesz, Then what does this message mean ? From here, assuming someone/thing did pg_ctl -m immediate stop: https://www.postgresql.org/docs/current/app-pg-ctl.html "“Immediate” mode will abort all server processes immediately, without a cl

RE: [External]Re: Postgres Crash Issue

2022-03-15 Thread Menon, Deepak (Deepak)
PM To: Menon, Deepak (Deepak) Cc: Sankar, Uma (Uma) **CTR** ; pgsql-gene...@postgresql.org Subject: Re: [External]Re: Postgres Crash Issue On Tue, Mar 15, 2022 at 01:30:25PM +, Menon, Deepak (Deepak) wrote: > Hi Depesz, > > Then what does this message mean ? > > 2022-03-11 0

RE: [External]Re: Postgres Crash Issue

2022-03-15 Thread Menon, Deepak (Deepak)
| Avaya Managed Services-Delivery|+91 9899012875| men...@avaya.com Leave Alert : -Original Message- From: dep...@depesz.com Sent: Tuesday, March 15, 2022 6:58 PM To: Sankar, Uma (Uma) **CTR** Cc: pgsql-gene...@postgresql.org; Menon, Deepak (Deepak) Subject: [External]Re: Postgres Crash

Re: [External]Re: Postgres Crash Issue

2022-03-15 Thread Tom Lane
hubert depesz lubaczewski writes: > On Tue, Mar 15, 2022 at 01:30:25PM +, Menon, Deepak (Deepak) wrote: >> 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,

Re: [External]Re: Postgres Crash Issue

2022-03-15 Thread hubert depesz lubaczewski
On Tue, Mar 15, 2022 at 01:38:04PM +, Menon, Deepak (Deepak) wrote: > Thanks Depesz. Is there anyway to check the source of the command as this HA > setup is managed by using Patroni >From pg perspective it got immediate stop request. There is no way to tell why/how. depesz

Re: [External]Re: Postgres Crash Issue

2022-03-15 Thread hubert depesz lubaczewski
On Tue, Mar 15, 2022 at 01:30:25PM +, 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

Re: Postgres Crash Issue

2022-03-15 Thread hubert depesz lubaczewski
On Tue, Mar 15, 2022 at 07:20:57AM +, Sankar, Uma (Uma) wrote: > Hi All, > > We have a database crash issue last Friday and it's a patroni HA-based > Postgres database running, we have checked the pg logs and it shows > error as shared memory corruptions. Can someone please check the > attach