Re: MultiXactId 24018 has not been created yet -- apparentwraparound error - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: MultiXactId 24018 has not been created yet -- apparentwraparound error
Date
Msg-id 20180823140745.qi6ebxhsyvfq5rvh@alvherre.pgsql
Whole thread Raw
In response to MultiXactId 24018 has not been created yet -- apparent wraparound error  (Dean Armada <dean@unnotech.com>)
List pgsql-general
On 2018-Aug-23, Dean Armada wrote:

> My team is confused as we are not doing anything then we experienced this
> in our staging environment. It's happening only in one of our tables. When
> we try fetch in that table, the message below returns
> 
> project=# SELECT * FROM table_table;
> ERROR:  MultiXactId 24018 has not been created yet -- apparent wraparound
> 
> Please take note that I am using docker containers and my image is
> postgres:9.6.3-alpine

Quite a few bugs in this area have been fixed in releases after 9.6.3.
I suggest an upgrade (9.6.10 is latest in that branch), and report back
if it still happens.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-general by date:

Previous
From: Andres Freund
Date:
Subject: Re: "checkpointer process" is consuming more memory. How to controlit?
Next
From: Naveen Dabas
Date:
Subject: Re: pg_sample