BUG #14195: "MultiXactId XXXXXX has not been created yet -- apparent wraparound" after upgrade from 9.2

From: sean(dot)hope(at)eroad(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14195: "MultiXactId XXXXXX has not been created yet -- apparent wraparound" after upgrade from 9.2
Date: 2016-06-15 20:38:29
Message-ID: 20160615203829.5798.4594@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14195
Logged by: Sean Hope
Email address: sean(dot)hope(at)eroad(dot)com
PostgreSQL version: 9.4.7
Operating system: Ubuntu 12.04 LTS
Description:

Hi,

We're having issues with 'MultiXactId xxxxxxxxx has not been created yet --
apparent wraparound' log messages upon table vacuums. The vacuums are
cancelled by the system after this message is issued.

These messages have only been seen since upgrading from 9.2.x to 9.4.7 via
pg_upgrade about a month ago. This is a large / high transaction rate (1120
tps) database. We are unable to vacuum the affected tables (5 of them)
currently due to this issue.

Any help most welcome.

Regards,
Sean

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Ranier VF 2016-06-15 21:11:01 Use after free? in fe-connect.c:closePGconn
Previous Message yobas 2016-06-15 19:25:05 BUG #14194: Why do these bases are open to public access?