Re: BUG #14940: Duplicated records inspite of primary key and unique constraint

On 12/04/2017 04:01 PM, Сергей А. Фролов wrote:
> page inspection is
>
> SELECT * FROM page_header(get_raw_page('nb.nb_basedtl', 0));
> SELECT * FROM heap_page_items(get_raw_page('nb.nb_basedtl', 0));
>
>  lsn | checksum | flags | lower | upper | special | pagesize | version |
> prune_xid
> -----+----------+-------+-------+-------+---------+----------+---------+-----------
>
>  0/0 |        0 |     0 |   320 |   416 |    8192 |     8192 | 4
> |         0
> (1 строка)
>
>  lp | lp_off | lp_flags | lp_len | t_xmin | t_xmax | t_field3 | t_ctid |
> t_infomask2 | t_infomask | t_hoff | t_bits              | t_oid | t_data
> ----+--------+----------+--------+--------+--------+----------+--------+-------------+------------+--------+----------------------------------+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>   1 |   8080 |        1 |    108 | 364507 |      0 |        0 | (0,1) 
> |          27 |       2817 |     32 | 11111110011100111100000010000000
> |       |
>
Thanks. Unfortunately that does not explain anything, and makes it ever
stranger - none of the items on the page is HOT-updated (t_infomask2 is
27, so it only contains number of attributes) or even deleted.

And the only xmin value on the page is 364507. So where did the other
values (370881, 370882) come from?

regards

--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services