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)
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. Deepak Menon| Avay

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