Re: Possible data corruption

From: Kevin Grittner <kgrittn(at)ymail(dot)com>
To: Martijn Meijer <martijn(dot)meijer(at)fuga(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Possible data corruption
Date: 2015-08-28 18:27:28
Message-ID: 340478313.1601463.1440786448355.JavaMail.yahoo@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Martijn Meijer <martijn(dot)meijer(at)fuga(dot)com> wrote:

> ERROR: could not access status of transaction 552079857
> DETAIL: Could not open file "pg_multixact/members/60D4": No such file or directory.

> PostgreSQL version number you are running:
>
> 9.3.4​.

There are known bugs in that version which can cause corruption
resulting in the error you are seeing. If you had stayed
up-to-date with bug-fixes as they were issued, you probably would
have been running with the fix before the IDs wrapped around and
caused corruption.

http://www.postgresql.org/support/versioning/

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2015-08-28 22:01:21 Re: [BUGS] Compile fails on AIX 6.1
Previous Message Tom Lane 2015-08-28 13:58:46 Re: [BUGS] Compile fails on AIX 6.1