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

From Alvaro Herrera
Subject Re: BUG #15142: ERROR: MultiXactId nnnnn has not been created yet --apparent wraparound in v9.5
Date
Msg-id 20180403132319.e2wtdc26ks54qbqt@alvherre.pgsql
Whole thread Raw
In response to BUG #15142: ERROR: MultiXactId nnnnn has not been created yet --apparent wraparound in v9.5  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15142: ERROR: MultiXactId nnnnn has not been created yet --apparent wraparound in v9.5  (molofeev <molofeev3@gmail.com>)
List pgsql-bugs
molofeev wrote:
> Thank you for reply.
> Output of pg_controldata:
> 
> Latest checkpoint's NextMultiXactId:  1
> Latest checkpoint's NextMultiOffset:  0

Uh, this says that this cluster has never used any multixacts.

> Output of [select datminmxid from pg_database where datname =
> current_database();]:
> 
> datminmxid
> ------------
>           1

... and this confirms.

I think the easiest way forward is to identify the problem page and see
what's there.  Please find what command was being run that caused the
error, which might help narrow down which table it is; then scan the
table to see on which page you can see the error.

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


pgsql-bugs by date:

Previous
From: molofeev
Date:
Subject: Re: BUG #15142: ERROR: MultiXactId nnnnn has not been created yet --apparent wraparound in v9.5
Next
From: molofeev
Date:
Subject: Re: BUG #15142: ERROR: MultiXactId nnnnn has not been created yet --apparent wraparound in v9.5