From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
---|---|
To: | Andres Freund <andres(at)anarazel(dot)de> |
Cc: | Maxim Boguk <maxim(dot)boguk(at)gmail(dot)com>, Peter Geoghegan <pg(at)bowt(dot)ie>, Jeremy Finzel <finzelj(at)gmail(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: found xmin from before relfrozenxid on pg_catalog.pg_authid |
Date: | 2018-05-24 21:13:11 |
Message-ID: | 20180524211311.tnswfnjwnii54htx@alvherre.pgsql |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On 2018-May-24, Andres Freund wrote:
> On 2018-05-24 16:49:40 -0400, Alvaro Herrera wrote:
> > BTW is it just a coincidence or are all the affected tables pg_authid?
> > Maybe the problem is shared relations ..? Maybe the fact that they have
> > separate relfrozenxid (!?) in different databases?
>
> Yes, that appears to be part of the problem. I've looked at a number of
> shared relation related codepaths, but so far my theory is that the
> relcache is wrong. Note that one of the reports in this thread clearly
> had a different relcache relfrozenxid than in the catalog.
Hmm ... is that because they read the values on different databases?
Are you referring to the reports by Maxim Boguk? I see one value from
template1, another value from template0.
> Then there's also:
> http://archives.postgresql.org/message-id/1527193504642.36340%40amazon.com
ah, so deleting the relcache file makes the problem to go away? That's
definitely pretty strange. I see no reason for the value in relcache to
become out of step with the catalogued value in the same database ... I
don't think we transmit in any way values of one database to another.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2018-05-24 21:17:38 | Re: found xmin from before relfrozenxid on pg_catalog.pg_authid |
Previous Message | Andrew Bartley | 2018-05-24 21:09:47 | Re: Performance opportunities for write-only audit tables? |
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2018-05-24 21:17:38 | Re: found xmin from before relfrozenxid on pg_catalog.pg_authid |
Previous Message | Jeremy Finzel | 2018-05-24 20:59:15 | Re: found xmin from before relfrozenxid on pg_catalog.pg_authid |