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]

 





On Mon, Mar 19, 2018 at 3:55 PM, Jeremy Finzel <finzelj@xxxxxxxxx> wrote:


On Mon, Mar 19, 2018 at 3:53 PM, Peter Geoghegan <pg@xxxxxxx> wrote:
On Mon, Mar 19, 2018 at 1:01 PM, Jeremy Finzel <finzelj@xxxxxxxxx> wrote:
> SELECT heap_page_items(get_raw_page('pg_authid', 7));

Can you post this?

SELECT * FROM page_header(get_raw_page('pg_authid', 7));

--
Peter Geoghegan

@Peter :

staging=# SELECT * FROM page_header(get_raw_page('pg_authid', 7));
      lsn       | checksum | flags | lower | upper | special | pagesize | version | prune_xid
----------------+----------+-------+-------+-------+---------+----------+---------+-----------
 262B4/10FDC478 |        0 |     1 |   304 |  2224 |    8192 |     8192 |       4 |         0
(1 row)

@Andres :

This is from snapshot (on 9.5.12, but we didn't have the error either on a 9.5.11 snap):

                                                             heap_page_items
-----------------------------------------------------------------------------------------------------------------------------------------
 (1,0,0,0,,,,,,,,,)
 (2,0,0,0,,,,,,,,,)
 (3,0,0,0,,,,,,,,,)
 (4,0,0,0,,,,,,,,,)
 (5,0,0,0,,,,,,,,,)
 (6,8080,1,108,3137434815,0,0,"(7,6)",11,10505,32,111111111000000000000000000000000000000001111110111100001000010010000001,2166427518)
 (7,7936,1,144,3137434816,0,0,"(7,7)",11,10507,32,111111111100000000000000000000000000000001110111000001110101101100001011,3504005358)
 (8,0,0,0,,,,,,,,,)
 (9,0,0,0,,,,,,,,,)
 (10,7792,1,144,3137434817,0,0,"(7,10)",11,10507,32,111111111100000000000000000000000000000001010110001101000011011111101000,401353834)
 (11,7680,1,108,3137434818,0,0,"(7,11)",11,10505,32,111111111000000000000000000000000000000001100011010010010001000001100001,2248708806)
 (12,0,0,0,,,,,,,,,)
 (13,0,0,0,,,,,,,,,)
 (14,7568,1,108,3137434819,0,0,"(7,14)",11,10505,32,111111111000000000000000000000000000000001110011110011011011100010100101,2770187214)
 (15,7456,1,108,3137434820,0,0,"(7,15)",11,10505,32,111111111000000000000000000000000000000011110001010001010011110010100001,2235343503)
 (16,0,0,0,,,,,,,,,)
 (17,0,0,0,,,,,,,,,)
 (18,0,0,0,,,,,,,,,)
 (19,0,0,0,,,,,,,,,)
 (20,0,0,0,,,,,,,,,)
 (21,0,0,0,,,,,,,,,)
 (22,0,0,0,,,,,,,,,)
 (23,0,0,0,,,,,,,,,)
 (24,0,0,0,,,,,,,,,)
 (25,0,0,0,,,,,,,,,)
 (26,0,0,0,,,,,,,,,)
 (27,0,0,0,,,,,,,,,)
 (28,0,0,0,,,,,,,,,)
 (29,0,0,0,,,,,,,,,)
 (30,0,0,0,,,,,,,,,)
 (31,0,0,0,,,,,,,,,)
 (32,0,0,0,,,,,,,,,)
 (33,0,0,0,,,,,,,,,)
 (34,0,0,0,,,,,,,,,)
 (35,0,0,0,,,,,,,,,)
 (36,0,0,0,,,,,,,,,)
 (37,0,0,0,,,,,,,,,)
 (38,0,0,0,,,,,,,,,)
 (39,0,0,0,,,,,,,,,)
 (40,0,0,0,,,,,,,,,)
 (41,0,0,0,,,,,,,,,)
 (42,0,0,0,,,,,,,,,)
 (43,0,0,0,,,,,,,,,)
 (44,0,0,0,,,,,,,,,)
 (45,0,0,0,,,,,,,,,)
 (46,0,0,0,,,,,,,,,)
 (47,0,0,0,,,,,,,,,)
 (48,0,0,0,,,,,,,,,)
 (49,0,0,0,,,,,,,,,)
 (50,0,0,0,,,,,,,,,)
 (51,0,0,0,,,,,,,,,)
 (52,7344,1,108,3137434821,0,0,"(7,52)",11,10505,32,111111111000000000000000000000000000000011011011111110001010010101000001,2191859675)
 (53,7232,1,108,3137434822,0,0,"(7,53)",11,10505,32,111111111000000000000000000000000000000001101011010111100110011011100100,661027542)
 (54,0,0,0,,,,,,,,,)
 (55,0,0,0,,,,,,,,,)
 (56,0,0,0,,,,,,,,,)
 (57,0,0,0,,,,,,,,,)
 (58,0,0,0,,,,,,,,,)
 (59,0,0,0,,,,,,,,,)
 (60,0,0,0,,,,,,,,,)
 (61,7120,1,108,3137434823,0,0,"(7,61)",11,10505,32,111111111000000000000000000000000000000000010111010110000101010111010100,732568296)
 (62,6976,1,144,3137434824,0,0,"(7,62)",11,10507,32,111111111100000000000000000000000000000010100100001001001010110000010100,674571301)
 (63,6864,1,108,3137434825,0,0,"(7,63)",11,10505,32,111111111000000000000000000000000000000010011011011111011100001001010001,2319695577)
 (64,6720,1,144,3137434826,0,0,"(7,64)",11,10507,32,111111111100000000000000000000000000000001000010011001111011100100101000,345892418)
 (65,6608,1,108,3137434827,0,0,"(7,65)",11,10505,32,111111111000000000000000000000000000000001000001010100010010101011001010,1398049410)
 (66,6496,1,108,3137434828,0,0,"(7,66)",11,10505,32,111111111000000000000000000000000000000000101000111100110101001000101010,1414188820)
 (67,6384,1,108,3137434829,0,0,"(7,67)",11,10505,32,111111111000000000000000000000000000000000110101011101111011001110101001,2513301164)
 (68,0,0,0,,,,,,,,,)
 (69,0,0,0,,,,,,,,,)
 (70,0,0,0,,,,,,,,,)
(70 rows)


Thanks,
Jeremy

Any suggestions as to what I can do from this point?  Is it feasible that a server restart would fix this, or are you saying it would just mask the problem?  I can't reproduce it on a snapshot which is quite odd.

FWIW, maybe this is obvious, but the pages look identical on the streamers we have to the master.

Thanks,
Jeremy

[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