Re: BUG #15142: ERROR: MultiXactId nnnnn has not been created yet -- apparent wraparound in v9.5

From: molofeev <molofeev3(at)gmail(dot)com>
To: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
Cc: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15142: ERROR: MultiXactId nnnnn has not been created yet -- apparent wraparound in v9.5
Date: 2018-04-04 14:23:19
Message-ID: a970e795-b954-abfd-b797-ee1549cdecea@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Thank you for reply.
First query result has data in each cell except last column.
Second query result has data only in this columns: lp, lp_off, lp_flags, lp_len; other cells empty.
If you need I can send files with query results.

On 04/04/2018 04:53 PM, Andrew Gierth wrote:
>>>>>> "molofeev" == molofeev <molofeev3(at)gmail(dot)com> writes:
> molofeev> Tuple #161 has ctid = (3220145, 81)
>
> try these (after installing the pageinspect extension):
>
> select * from heap_page_items(get_raw_page('tablename',3220145));
>
> select * from heap_page_items(get_raw_page('tablename',3220146));
>
> If you catch me on the irc channel (#postgresql on freenode.net) I
> often talk people through this kind of analysis in real time.
>

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Gierth 2018-04-04 14:45:54 Re: BUG #15142: ERROR: MultiXactId nnnnn has not been created yet -- apparent wraparound in v9.5
Previous Message Andrew Gierth 2018-04-04 13:53:14 Re: BUG #15142: ERROR: MultiXactId nnnnn has not been created yet -- apparent wraparound in v9.5