Search Postgresql Archives

Re: found xmin from before relfrozenxid on pg_catalog.pg_authid

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux