Re: ERROR: MultiXactId xxxx has not been created yet -- apparent wraparound

Paul Smith wrote:
> With PostgreSQL 9.3.5 on Ubuntu 12.04, I'm getting the error:
> 
> ERROR:  MultiXactId 1934308693 has not been created yet -- apparent
> wraparound
> 
> on doing various queries on our database. I don't think it is a wraparound -
> I think the tuple has mistakenly decided it has a MultiXactId related to it.

Yeah, that looks like the case.  According to your pg_controldata
output, you haven't used many multixacts at all:

> Latest checkpoint's NextMultiXactId:  216
> Latest checkpoint's NextMultiOffset:  439

and the fact that you only have these files:

> The pg_multixact directory contains two files
> members/0000
> offsets/0000

confirms this.  You XID counter is also rather low, only 24 million:

> Latest checkpoint's NextXID:          0/24005839

so it doesn't seem plausible that the single bit HEAP_XMAX_IS_MULTI was
turned on accidentally (something which I've never seen happen).

It doesn't look like a randomly corrupt page either; normally you would
see errors about mismatching page headers before you get to the point
where Xmax is read.  I wonder if the data page came from elsewhere.
Maybe you copied a data file from another database?

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