On Tue, Mar 20, 2018 at 11:19 AM, Jeremy Finzel <finzelj@xxxxxxxxx> wrote:
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,1111111110 000000000000000000000000000000 011111101111000010000100100000 01,2166427518) (7,7936,1,144,3137434816,0,0,"(7,7)",11,10507,32,1111111111 000000000000000000000000000000 011101110000011101011011000010 11,3504005358) (8,0,0,0,,,,,,,,,)(9,0,0,0,,,,,,,,,)(10,7792,1,144,3137434817,0,0,"(7,10)",11,10507,32,11111111 110000000000000000000000000000 000101011000110100001101111110 1000,401353834) (11,7680,1,108,3137434818,0,0,"(7,11)",11,10505,32,11111111 100000000000000000000000000000 000110001101001001000100000110 0001,2248708806) (12,0,0,0,,,,,,,,,)(13,0,0,0,,,,,,,,,)(14,7568,1,108,3137434819,0,0,"(7,14)",11,10505,32,11111111 100000000000000000000000000000 000111001111001101101110001010 0101,2770187214) (15,7456,1,108,3137434820,0,0,"(7,15)",11,10505,32,11111111 100000000000000000000000000000 001111000101000101001111001010 0001,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,11111111 100000000000000000000000000000 001101101111111000101001010100 0001,2191859675) (53,7232,1,108,3137434822,0,0,"(7,53)",11,10505,32,11111111 100000000000000000000000000000 000110101101011110011001101110 0100,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,11111111 100000000000000000000000000000 000001011101011000010101011101 0100,732568296) (62,6976,1,144,3137434824,0,0,"(7,62)",11,10507,32,11111111 110000000000000000000000000000 001010010000100100101011000001 0100,674571301) (63,6864,1,108,3137434825,0,0,"(7,63)",11,10505,32,11111111 100000000000000000000000000000 001001101101111101110000100101 0001,2319695577) (64,6720,1,144,3137434826,0,0,"(7,64)",11,10507,32,11111111 110000000000000000000000000000 000100001001100111101110010010 1000,345892418) (65,6608,1,108,3137434827,0,0,"(7,65)",11,10505,32,11111111 100000000000000000000000000000 000100000101010001001010101100 1010,1398049410) (66,6496,1,108,3137434828,0,0,"(7,66)",11,10505,32,11111111 100000000000000000000000000000 000010100011110011010100100010 1010,1414188820) (67,6384,1,108,3137434829,0,0,"(7,67)",11,10505,32,11111111 100000000000000000000000000000 000011010101110111101100111010 1001,2513301164) (68,0,0,0,,,,,,,,,)(69,0,0,0,,,,,,,,,)(70,0,0,0,,,,,,,,,)(70 rows)Thanks,JeremyAny 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
A server restart and upgrade to 9.5.12 (at the same time), as expected, made the issue go away. Still doesn't give us any answers as to what happened or if it would happen again! Thanks for the feeback.
Jeremy
