Pg11 -- MultiXactId xxxx has not been created yet -- apparent wraparound

From: Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it>
To: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Pg11 -- MultiXactId xxxx has not been created yet -- apparent wraparound
Date: 2019-10-04 14:57:13
Message-ID: b14c00bc-0344-65f1-6631-4cb2f69e1de8@evolu-s.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<html>
<head>

<meta http-equiv="content-type" content="text/html; charset=ISO-8859-15">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi all,<br>
    I'm encountering this issue in a Windows 10/Pg11.5<br>
<br>
<br>
I followed the thread @
<a class="moz-txt-link-freetext" href="https://postgrespro.com/list/thread-id/2380690">https://postgrespro.com/list/thread-id/2380690</a><br>
<br>
but examining heap pages is far beyond my knowledge, so if any of
the gurus would spend some time on it, I would be very grateful.<br>
<br>
So, here comes the facts<br>
<br>
database0=# select datminmxid from pg_database where datname =
current_database();<br>
 datminmxid<br>
------------<br>
        365<br>
(1 row)<br>
<br>
<br>
The CTID of the tuple BEFORE the failing one is 3159,51:<br>
<br>
database0=# select ctid from tablename offset 368 limit 1;<br>
ERROR:  MultiXactId 12800 has not been created yet -- apparent
wraparound<br>
database0=# select ctid from tablename offset 367 limit 1;<br>
   ctid<br>
-----------<br>
 (3159,51)<br>
(1 row)<br>
<br>
Now, I started issuing the queries<br>
<pre>select * from heap_page_items(get_raw_page('tablename',3159));
select * from heap_page_items(get_raw_page('tablename',3160));

and so on for about 5 or 6 pages.
What do I need to search for?
Or is it better to \copy them to and send 'em as an attachment?
How many pages do I need to search for?
Until I see the error again?

Thanks in advance
Moreno.-
</pre>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 1.6 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andres Freund 2019-10-04 15:06:10 Re: Postgres 12: backend crashes when creating non-deterministic collation
Previous Message Tom Lane 2019-10-04 14:52:38 Re: Postgres 12: backend crashes when creating non-deterministic collation