Re: found xmin from before relfrozenxid on pg_catalog.pg_authid - Mailing list pgsql-general

From Maxim Boguk
Subject Re: found xmin from before relfrozenxid on pg_catalog.pg_authid
Date
Msg-id CAK-MWwTEz4uRDtDW6GEfKS-D7B5ZPaW0fVcp3diaFzT+4BuKaA@mail.gmail.com
Whole thread Raw
In response to Re: found xmin from before relfrozenxid on pg_catalog.pg_authid  (Andres Freund <andres@anarazel.de>)
Responses Re: found xmin from before relfrozenxid on pg_catalog.pg_authid
List pgsql-general



> ​About gdb bt - it's tricky because it is mission critical master db of
> huge project.
> I'll will try promote backup replica and check is issue persist there and
> if yes - we will have our playground for a while, but it will require
> sometime to arrange.​

You should be ok to just bt that in the running cluster, but I
definitely understand if you don't want to do that...  I'd appreciate if
you set up the a playground, because this seems like something that'll
reappear.

Greetings,

Andres Freund

​Ok this issue reproducible on promoted replica.
So now I have my playground.
Will provide gdb info in few hours.​


--
Maxim Boguk
Senior Postgresql DBA
http://dataegret.com/

Phone RU: +7  985 433 0000
Phone UA: +380 99 143 0000
Phone AU: +61  45 218 5678

LinkedIn: http://www.linkedin.com/pub/maksym-boguk/80/b99/b1b
Skype: maxim.boguk

"Доктор, вы мне советовали так не делать, но почему мне по-прежнему больно когда я так делаю ещё раз?"

pgsql-general by date:

Previous
From: Alexey Bashtanov
Date:
Subject: Re: partition table query allocate much memory
Next
From: "Peter J. Holzer"
Date:
Subject: Re: Renice on Postgresql process