Re: Possible data corruption - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: Possible data corruption
Date
Msg-id 340478313.1601463.1440786448355.JavaMail.yahoo@mail.yahoo.com
Whole thread Raw
In response to Possible data corruption  (Martijn Meijer <martijn.meijer@fuga.com>)
List pgsql-bugs
Martijn Meijer <martijn.meijer@fuga.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=E2=80=8B.

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

pgsql-bugs by date:

Previous
From: Martijn Meijer
Date:
Subject: Possible data corruption
Next
From: Amit Kapila
Date:
Subject: Re: PQexec() hangs on OOM