| 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: | Whole Thread | Raw Message | 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.
>
| 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 |