Re: found xmin from before relfrozenxid on pg_catalog.pg_authid

Hi,

On 2018-03-19 14:53:58 -0500, Jeremy Finzel wrote:
> FWIW, if I remove the last filter, I get these rows and I believe row 7/57/
> 2906288382 is the one generating error:

Oh, yea, that makes sense. It's wrapped around and looks like it's from
the future.

> SELECT * FROM check_rel('pg_authid') LIMIT 100;
> blockno | lp | xmin
> ---------+----+------------
> 7 | 4 | 2040863716
> 7 | 5 | 2040863716
> 7 | 8 | 2041172882
> 7 | 9 | 2041172882
> 7 | 12 | 2041201779
> 7 | 13 | 2041201779
> 7 | 16 | 2089742733
> 7 | 17 | 2090021318
> 7 | 18 | 2090021318
> 7 | 47 | 2090021898
> 7 | 48 | 2090021898
> 7 | 49 | 2102749003
> 7 | 50 | 2103210571
> 7 | 51 | 2103210571
> 7 | 54 | 2154640913
> 7 | 55 | 2163849781
> 7 | 56 | 2295315714
> 7 | 57 | 2906288382
> 7 | 58 | 2906329443
> 7 | 60 | 3131766386
> 8 | 1 | 2089844462
> 8 | 2 | 2089844462
> 8 | 3 | 2089844463
> 8 | 6 | 2089844463
> 8 | 9 | 2295318868
> (25 rows)

Could you show the contents of those two pages with a query like I had
in an earlier email?

Greetings,

Andres Freund