Re: Could not open file pg_multixact/offsets/ ERROR on 9.3.4 - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Could not open file pg_multixact/offsets/ ERROR on 9.3.4
Date
Msg-id 20140604153355.GO5146@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: Could not open file pg_multixact/offsets/ ERROR on 9.3.4  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
Andres Freund wrote:

> On 2014-06-04 16:59:10 +0200, Alexey Klyukin wrote:
> > I've recently discovered a peculiar problem on one of our big databases
> > (more than 1TB). The database has been upgraded from 9.2 to 9.3.4 (using
> > hardlinks to speedup the process)  on April 7th around 22:00 local time.
> > When doing  vacuum on any table, the system fails with the following error:
> > 
> > ERROR:  could not access status of transaction 2035987419
> > DETAIL:  Could not open file "pg_multixact/offsets/795A": No such file or
> > directory.

> Looks like you're hitting the issue described in
> http://archives.postgresql.org/message-id/20140530121631.GE25431%40alap3.anarazel.de

Will look into this.  Thanks.

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



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Proposing pg_hibernate
Next
From: Keith Fiske
Date:
Subject: Re: [BUGS] BUG #9652: inet types don't support min/max