I decided to rebuild pg 10 first.
I commented out the lines of code with duplicate checking
(/src/backend/commands/async.c)
// if (AsyncExistsPendingNotify(channel, payload))
// return;
and launched this version of pg into production.
This was the only way I could figure out if there
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
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| men...@avaya.com
Leave Alert :
-Original Message-
From: dep...@depesz.com
Sent: Tuesday, March 15, 2022 7:02 PM
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
Jorel Casal writes:
> During a Patroni leader switchover, we had a situation where a unique index
> stopped "working", the index did not have records
> that were in fact in the table and the table had duplicate records which
> should have been prevented by said unique index.
If the index was on a
Hi All, has anyone experienced corrupted unique indexes?
During a Patroni leader switchover, we had a situation where a unique index
stopped "working", the index did not have records
that were in fact in the table and the table had duplicate records which
should have been prevented by said unique
On 3/14/22 23:42, Shukla, Pranjal wrote:
Thanks Adrian,
Can we say that, "Despite an informational Error, entire data got imported with sanity in the original case"?
Yes.
To verify see that the public schema is there and has tables and other
objects in it.
Also, can we say that either of th
=?UTF-8?B?0JDRgNGB0LXQvSDQkNGA0YPRgtGO0L3Rj9C9?= writes:
> i looked at the file "\src\backend\commands\async.c"
> there is a check for duplicate messages
Yup.
> Is this slowdown related to this check?
[ shrug... ] You've provided no evidence either for or against that
possibility.
It seems a
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,
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
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
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
i looked at the file "\src\backend\commands\async.c"
there is a check for duplicate messages
/ PG 10
if (AsyncExistsPendingNotify(channel, payload))
return;
***/
/ PG 13
if (AsyncExistsPendingNotify(n))
{
…...
}
***/
Is this slowdown related to this check?
Is it
Thanks Adrian,
Can we say that, "Despite an informational Error, entire data got imported with
sanity in the original case"? Also, can we say that either of the approaches
mentioned i.e. Approach 1 & 2 are equally good to do migration from PG 10 to PG
12?
Thanks & Regards
Pranjal Shukla
On 3/
> How many partitions do you expect to have? Why are you partitioning on that
> column? Do you have need to drop old data all at the same time? How many rows
> in each partition or in total do you expect to have?
In my case there is a hierarchy so the partitions are based on certain
parts of the
15 matches
Mail list logo
