Re: found xmin from before relfrozenxid on pg_catalog.pg_authid

On Mon, Mar 19, 2018 at 3:01 PM, Jeremy Finzel <finzelj(at)gmail(dot)com> wrote:

>
>
> On Mon, Mar 19, 2018 at 2:56 PM, Andres Freund <andres(at)anarazel(dot)de> wrote:
>
>> 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 <(208)%20974-2733>
>> > 7 | 17 | 2090021318
>> > 7 | 18 | 2090021318
>> > 7 | 47 | 2090021898
>> > 7 | 48 | 2090021898
>> > 7 | 49 | 2102749003 <(210)%20274-9003>
>> > 7 | 50 | 2103210571 <(210)%20321-0571>
>> > 7 | 51 | 2103210571 <(210)%20321-0571>
>> > 7 | 54 | 2154640913 <(215)%20464-0913>
>> > 7 | 55 | 2163849781 <(216)%20384-9781>
>> > 7 | 56 | 2295315714 <(229)%20531-5714>
>> > 7 | 57 | 2906288382
>> > 7 | 58 | 2906329443
>> > 7 | 60 | 3131766386
>> > 8 | 1 | 2089844462 <(208)%20984-4462>
>> > 8 | 2 | 2089844462 <(208)%20984-4462>
>> > 8 | 3 | 2089844463 <(208)%20984-4463>
>> > 8 | 6 | 2089844463 <(208)%20984-4463>
>> > 8 | 9 | 2295318868 <(229)%20531-8868>
>> > (25 rows)
>>
>> Could you show the contents of those two pages with a query like I had
>> in an earlier email?
>>
>> Greetings,
>>
>> Andres Freund
>>
>
> SELECT heap_page_items(get_raw_page('pg_authid', 7));
>
>
> heap_page_items
> ------------------------------------------------------------
> ------------------------------------------------------------
> --------------------
> (1,4720,1,108,1897434979,0,0,"(7,1)",11,2825,32,
> 111111111000000000000000000000000000000001011000010011111100
> 001001111000,507769370)
> (2,4608,1,108,1897442758,0,18,"(7,2)",11,2825,32,
> 111111111000000000000000000000000000000011000011101100000010
> 001001111000,507776451)
> (3,4496,1,108,1897442758,0,20,"(7,3)",11,2825,32,
> 111111111000000000000000000000000000000000100011101100000010
> 001001111000,507776452)
> (4,4384,1,108,2040863716,0,37,"(7,4)",11,2313,32,
> 111111111000000000000000000000000000000000110110111011100011
> 001011111000,525105004)
> (5,4272,1,108,2040863716,0,39,"(7,5)",11,2313,32,
> 111111111000000000000000000000000000000010110110111011100011
> 001011111000,525105005)
> (6,0,3,0,,,,,,,,,)
> (7,0,3,0,,,,,,,,,)
> (8,4160,1,108,2041172882,0,49,"(7,8)",11,2313,32,
> 111111111000000000000000000000000000000001110100101011000111
> 001011111000,525219118)
> (9,4048,1,108,2041172882,0,51,"(7,9)",11,2313,32,
> 111111111000000000000000000000000000000011110100101011000111
> 001011111000,525219119)
> (10,0,3,0,,,,,,,,,)
> (11,0,3,0,,,,,,,,,)
> (12,3936,1,108,2041201779,0,181,"(7,12)",11,2313,32,
> 111111111000000000000000000000000000000011010100010111100111
> 001011111000,525236779)
> (13,3824,1,108,2041201779,0,183,"(7,13)",11,2313,32,
> 111111111000000000000000000000000000000000110100010111100111
> 001011111000,525236780)
> (14,0,3,0,,,,,,,,,)
> (15,0,3,0,,,,,,,,,)
> (16,3712,1,108,2089742733 <(208)%20974-2733>,0,0,"(7,16)",11,2313,32,
> 111111111000000000000000000000000000000001000101110011100000
> 001111111000,532706210)
> (17,3600,1,108,2090021318,0,1,"(7,17)",11,2313,32,
> 111111111000000000000000000000000000000001001100001101001000
> 001111111000,532753458)
> (18,3488,1,108,2090021318,0,3,"(7,18)",11,2313,32,
> 111111111000000000000000000000000000000011001100001101001000
> 001111111000,532753459)
> (19,8080,1,108,753125991,0,2,"(7,19)",11,2825,32,
> 111111111000000000000000000000000000000000110001010111001011
> 100001110000,236796556)
> (20,7968,1,108,753125991,0,4,"(7,20)",11,2825,32,
> 111111111000000000000000000000000000000010110001010111001011
> 100001110000,236796557)
> (21,7856,1,108,753125992,0,19,"(7,21)",11,2825,32,
> 111111111000000000000000000000000000000011001001010111001011
> 100001110000,236796563)
> (22,7744,1,108,753125992,0,21,"(7,22)",11,2825,32,
> 111111111000000000000000000000000000000000101001010111001011
> 100001110000,236796564)
> (23,7632,1,108,753125993,0,36,"(7,23)",11,2825,32,
> 111111111000000000000000000000000000000001011001010111001011
> 100001110000,236796570)
> (24,7520,1,108,753125993,0,38,"(7,24)",11,2825,32,
> 111111111000000000000000000000000000000011011001010111001011
> 100001110000,236796571)
> (25,7408,1,108,753125994,0,53,"(7,25)",11,2825,32,
> 111111111000000000000000000000000000000010000101010111001011
> 100001110000,236796577)
> (26,7296,1,108,753125994,0,55,"(7,26)",11,2825,32,
> 111111111000000000000000000000000000000001000101010111001011
> 100001110000,236796578)
> (27,7184,1,108,753125995,0,70,"(7,27)",11,2825,32,
> 111111111000000000000000000000000000000000010101010111001011
> 100001110000,236796584)
> (28,7072,1,108,753125995,0,72,"(7,28)",11,2825,32,
> 111111111000000000000000000000000000000010010101010111001011
> 100001110000,236796585)
> (29,6960,1,108,753125997,0,87,"(7,29)",11,2825,32,
> 111111111000000000000000000000000000000011001101010111001011
> 100001110000,236796595)
> (30,6848,1,108,753125997,0,89,"(7,30)",11,2825,32,
> 111111111000000000000000000000000000000000101101010111001011
> 100001110000,236796596)
> (31,6736,1,108,753125998,0,104,"(7,31)",11,2825,32,
> 111111111000000000000000000000000000000001011101010111001011
> 100001110000,236796602)
> (32,6624,1,108,753125998,0,106,"(7,32)",11,2825,32,
> 111111111000000000000000000000000000000011011101010111001011
> 100001110000,236796603)
> (33,6512,1,108,753125999,0,121,"(7,33)",11,2825,32,
> 111111111000000000000000000000000000000010000011010111001011
> 100001110000,236796609)
> (34,6400,1,108,753125999,0,123,"(7,34)",11,2825,32,
> 111111111000000000000000000000000000000001000011010111001011
> 100001110000,236796610)
> (35,6288,1,108,753126000,0,138,"(7,35)",11,2825,32,
> 111111111000000000000000000000000000000000010011010111001011
> 100001110000,236796616)
> (36,6176,1,108,753126000,0,140,"(7,36)",11,2825,32,
> 111111111000000000000000000000000000000010010011010111001011
> 100001110000,236796617)
> (37,6064,1,108,753126001,0,155,"(7,37)",11,2825,32,
> 111111111000000000000000000000000000000011110011010111001011
> 100001110000,236796623)
> (38,5952,1,108,753126001,0,157,"(7,38)",11,2825,32,
> 111111111000000000000000000000000000000000001011010111001011
> 100001110000,236796624)
> (39,5840,1,108,753126002,0,172,"(7,39)",11,2825,32,
> 111111111000000000000000000000000000000001101011010111001011
> 100001110000,236796630)
> (40,5728,1,108,753126002,0,174,"(7,40)",11,2825,32,
> 111111111000000000000000000000000000000011101011010111001011
> 100001110000,236796631)
> (41,5616,1,108,753126003,0,189,"(7,41)",11,2825,32,
> 111111111000000000000000000000000000000010111011010111001011
> 100001110000,236796637)
> (42,5504,1,108,753126003,0,191,"(7,42)",11,2825,32,
> 111111111000000000000000000000000000000001111011010111001011
> 100001110000,236796638)
> (43,5392,1,108,753126004,0,206,"(7,43)",11,2825,32,
> 111111111000000000000000000000000000000000100111010111001011
> 100001110000,236796644)
> (44,5280,1,108,753126004,0,208,"(7,44)",11,2825,32,
> 111111111000000000000000000000000000000010100111010111001011
> 100001110000,236796645)
> (45,5168,1,108,753126005,0,223,"(7,45)",11,2825,32,
> 111111111000000000000000000000000000000011010111010111001011
> 100001110000,236796651)
> (46,5056,1,108,753126005,0,225,"(7,46)",11,2825,32,
> 111111111000000000000000000000000000000000110111010111001011
> 100001110000,236796652)
> (47,3376,1,108,2090021898,0,18,"(7,47)",11,2313,32,
> 111111111000000000000000000000000000000001000111001101001000
> 001111111000,532753634)
> (48,3264,1,108,2090021898,0,20,"(7,48)",11,2313,32,
> 111111111000000000000000000000000000000000100111001101001000
> 001111111000,532753636)
> (49,3152,1,108,2102749003 <(210)%20274-9003>,0,0,"(7,49)",11,2313,32,
> 111111111000000000000000000000000000000001111011101110010000
> 110100000100,548445662)
> (50,3040,1,108,2103210571 <(210)%20321-0571>,0,107,"(7,50)",11,2313,32,
> 111111111000000000000000000000000000000000010110101100100100
> 110100000100,548556136)
> (51,2928,1,108,2103210571 <(210)%20321-0571>,0,109,"(7,51)",11,2313,32,
> 111111111000000000000000000000000000000010010110101100100100
> 110100000100,548556137)
> (52,0,3,0,,,,,,,,,)
> (53,0,3,0,,,,,,,,,)
> (54,2816,1,108,2154640913 <(215)%20464-0913>,0,0,"(7,54)",11,2313,32,
> 111111111000000000000000000000000000000010111111010010000000
> 100010000100,554701565)
> (55,2704,1,108,2163849781 <(216)%20384-9781>,0,0,"(7,55)",11,2313,32,
> 111111111000000000000000000000000000000000110000001011101001
> 100010000100,555316236)
> (56,2592,1,108,2295315714 <(229)%20531-5714>,0,0,"(7,56)",11,2313,32,
> 111111111000000000000000000000000000000000100101010100001000
> 010001000100,572590756)
> (57,2480,1,108,2906288382,0,0,"(7,57)",11,2313,32,
> 111111111000000000000000000000000000000000001000101101000100
> 111001111100,1047670032)
> (58,2368,1,108,2906329443,0,0,"(7,58)",11,2313,32,
> 111111111000000000000000000000000000000001111001101101000100
> 111001111100,1047670174)
> (59,60,2,0,,,,,,,,,)
> (60,2224,1,144,3131766386,0,0,"(7,60)",32779,10507,32,
> 111111111100000000000000000000000000000000001101010001010011
> 111100000010,1090298544)
> (61,0,0,0,,,,,,,,,)
> (62,0,0,0,,,,,,,,,)
> (63,0,0,0,,,,,,,,,)
> (64,0,0,0,,,,,,,,,)
> (65,0,0,0,,,,,,,,,)
> (66,0,0,0,,,,,,,,,)
> (67,0,0,0,,,,,,,,,)
> (68,0,0,0,,,,,,,,,)
> (69,4944,1,108,1034607755,0,1,"(7,69)",11,2825,32,
> 111111111000000000000000000000000000000000010111011000010010
> 010100001000,279217896)
> (70,4832,1,108,1034607755,0,3,"(7,70)",11,2825,32,
> 111111111000000000000000000000000000000010010111011000010010
> 010100001000,279217897)
> (70 rows)
>

Does the fact that a snapshot does not have this issue suggest it could be
memory-related corruption and a db restart could clear it up?

Thanks,
Jeremy