On Mon, Mar 19, 2018 at 3:01 PM, Jeremy Finzel <finzelj@xxxxxxxxx> wrote:
On Mon, Mar 19, 2018 at 2:56 PM, Andres Freund <andres@xxxxxxxxxxx> 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.
Could you show the contents of those two pages with a query like I had
> 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)
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, 111111111000000000000000000000 000000000001011000010011111100 001001111000,507769370) (2,4608,1,108,1897442758,0,18,"(7,2)",11,2825,32, 111111111000000000000000000000 000000000011000011101100000010 001001111000,507776451) (3,4496,1,108,1897442758,0,20,"(7,3)",11,2825,32, 111111111000000000000000000000 000000000000100011101100000010 001001111000,507776452) (4,4384,1,108,2040863716,0,37,"(7,4)",11,2313,32, 111111111000000000000000000000 000000000000110110111011100011 001011111000,525105004) (5,4272,1,108,2040863716,0,39,"(7,5)",11,2313,32, 111111111000000000000000000000 000000000010110110111011100011 001011111000,525105005) (6,0,3,0,,,,,,,,,)(7,0,3,0,,,,,,,,,)(8,4160,1,108,2041172882,0,49,"(7,8)",11,2313,32, 111111111000000000000000000000 000000000001110100101011000111 001011111000,525219118) (9,4048,1,108,2041172882,0,51,"(7,9)",11,2313,32, 111111111000000000000000000000 000000000011110100101011000111 001011111000,525219119) (10,0,3,0,,,,,,,,,)(11,0,3,0,,,,,,,,,)(12,3936,1,108,2041201779,0,181,"(7,12)",11,2313,32, 111111111000000000000000000000 000000000011010100010111100111 001011111000,525236779) (13,3824,1,108,2041201779,0,183,"(7,13)",11,2313,32, 111111111000000000000000000000 000000000000110100010111100111 001011111000,525236780) (14,0,3,0,,,,,,,,,)(15,0,3,0,,,,,,,,,)(16,3712,1,108,2089742733,0,0,"(7,16)",11,2313,32, 111111111000000000000000000000 000000000001000101110011100000 001111111000,532706210) (17,3600,1,108,2090021318,0,1,"(7,17)",11,2313,32, 111111111000000000000000000000 000000000001001100001101001000 001111111000,532753458) (18,3488,1,108,2090021318,0,3,"(7,18)",11,2313,32, 111111111000000000000000000000 000000000011001100001101001000 001111111000,532753459) (19,8080,1,108,753125991,0,2,"(7,19)",11,2825,32, 111111111000000000000000000000 000000000000110001010111001011 100001110000,236796556) (20,7968,1,108,753125991,0,4,"(7,20)",11,2825,32, 111111111000000000000000000000 000000000010110001010111001011 100001110000,236796557) (21,7856,1,108,753125992,0,19,"(7,21)",11,2825,32, 111111111000000000000000000000 000000000011001001010111001011 100001110000,236796563) (22,7744,1,108,753125992,0,21,"(7,22)",11,2825,32, 111111111000000000000000000000 000000000000101001010111001011 100001110000,236796564) (23,7632,1,108,753125993,0,36,"(7,23)",11,2825,32, 111111111000000000000000000000 000000000001011001010111001011 100001110000,236796570) (24,7520,1,108,753125993,0,38,"(7,24)",11,2825,32, 111111111000000000000000000000 000000000011011001010111001011 100001110000,236796571) (25,7408,1,108,753125994,0,53,"(7,25)",11,2825,32, 111111111000000000000000000000 000000000010000101010111001011 100001110000,236796577) (26,7296,1,108,753125994,0,55,"(7,26)",11,2825,32, 111111111000000000000000000000 000000000001000101010111001011 100001110000,236796578) (27,7184,1,108,753125995,0,70,"(7,27)",11,2825,32, 111111111000000000000000000000 000000000000010101010111001011 100001110000,236796584) (28,7072,1,108,753125995,0,72,"(7,28)",11,2825,32, 111111111000000000000000000000 000000000010010101010111001011 100001110000,236796585) (29,6960,1,108,753125997,0,87,"(7,29)",11,2825,32, 111111111000000000000000000000 000000000011001101010111001011 100001110000,236796595) (30,6848,1,108,753125997,0,89,"(7,30)",11,2825,32, 111111111000000000000000000000 000000000000101101010111001011 100001110000,236796596) (31,6736,1,108,753125998,0,104,"(7,31)",11,2825,32, 111111111000000000000000000000 000000000001011101010111001011 100001110000,236796602) (32,6624,1,108,753125998,0,106,"(7,32)",11,2825,32, 111111111000000000000000000000 000000000011011101010111001011 100001110000,236796603) (33,6512,1,108,753125999,0,121,"(7,33)",11,2825,32, 111111111000000000000000000000 000000000010000011010111001011 100001110000,236796609) (34,6400,1,108,753125999,0,123,"(7,34)",11,2825,32, 111111111000000000000000000000 000000000001000011010111001011 100001110000,236796610) (35,6288,1,108,753126000,0,138,"(7,35)",11,2825,32, 111111111000000000000000000000 000000000000010011010111001011 100001110000,236796616) (36,6176,1,108,753126000,0,140,"(7,36)",11,2825,32, 111111111000000000000000000000 000000000010010011010111001011 100001110000,236796617) (37,6064,1,108,753126001,0,155,"(7,37)",11,2825,32, 111111111000000000000000000000 000000000011110011010111001011 100001110000,236796623) (38,5952,1,108,753126001,0,157,"(7,38)",11,2825,32, 111111111000000000000000000000 000000000000001011010111001011 100001110000,236796624) (39,5840,1,108,753126002,0,172,"(7,39)",11,2825,32, 111111111000000000000000000000 000000000001101011010111001011 100001110000,236796630) (40,5728,1,108,753126002,0,174,"(7,40)",11,2825,32, 111111111000000000000000000000 000000000011101011010111001011 100001110000,236796631) (41,5616,1,108,753126003,0,189,"(7,41)",11,2825,32, 111111111000000000000000000000 000000000010111011010111001011 100001110000,236796637) (42,5504,1,108,753126003,0,191,"(7,42)",11,2825,32, 111111111000000000000000000000 000000000001111011010111001011 100001110000,236796638) (43,5392,1,108,753126004,0,206,"(7,43)",11,2825,32, 111111111000000000000000000000 000000000000100111010111001011 100001110000,236796644) (44,5280,1,108,753126004,0,208,"(7,44)",11,2825,32, 111111111000000000000000000000 000000000010100111010111001011 100001110000,236796645) (45,5168,1,108,753126005,0,223,"(7,45)",11,2825,32, 111111111000000000000000000000 000000000011010111010111001011 100001110000,236796651) (46,5056,1,108,753126005,0,225,"(7,46)",11,2825,32, 111111111000000000000000000000 000000000000110111010111001011 100001110000,236796652) (47,3376,1,108,2090021898,0,18,"(7,47)",11,2313,32, 111111111000000000000000000000 000000000001000111001101001000 001111111000,532753634) (48,3264,1,108,2090021898,0,20,"(7,48)",11,2313,32, 111111111000000000000000000000 000000000000100111001101001000 001111111000,532753636) (49,3152,1,108,2102749003,0,0,"(7,49)",11,2313,32, 111111111000000000000000000000 000000000001111011101110010000 110100000100,548445662) (50,3040,1,108,2103210571,0,107,"(7,50)",11,2313,32, 111111111000000000000000000000 000000000000010110101100100100 110100000100,548556136) (51,2928,1,108,2103210571,0,109,"(7,51)",11,2313,32, 111111111000000000000000000000 000000000010010110101100100100 110100000100,548556137) (52,0,3,0,,,,,,,,,)(53,0,3,0,,,,,,,,,)(54,2816,1,108,2154640913,0,0,"(7,54)",11,2313,32, 111111111000000000000000000000 000000000010111111010010000000 100010000100,554701565) (55,2704,1,108,2163849781,0,0,"(7,55)",11,2313,32, 111111111000000000000000000000 000000000000110000001011101001 100010000100,555316236) (56,2592,1,108,2295315714,0,0,"(7,56)",11,2313,32, 111111111000000000000000000000 000000000000100101010100001000 010001000100,572590756) (57,2480,1,108,2906288382,0,0,"(7,57)",11,2313,32, 111111111000000000000000000000 000000000000001000101101000100 111001111100,1047670032) (58,2368,1,108,2906329443,0,0,"(7,58)",11,2313,32, 111111111000000000000000000000 000000000001111001101101000100 111001111100,1047670174) (59,60,2,0,,,,,,,,,)(60,2224,1,144,3131766386,0,0,"(7,60)",32779,10507,32, 111111111100000000000000000000 000000000000001101010001010011 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, 111111111000000000000000000000 000000000000010111011000010010 010100001000,279217896) (70,4832,1,108,1034607755,0,3,"(7,70)",11,2825,32, 111111111000000000000000000000 000000000010010111011000010010 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