| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)2ndquadrant(dot)com> |
| Cc: | Alexey Klyukin <alexk(at)hintbits(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Could not open file pg_multixact/offsets/ ERROR on 9.3.4 |
| Date: | 2014-06-04 15:33:56 |
| Message-ID: | 20140604153355.GO5146@eldon.alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keith Fiske | 2014-06-04 15:44:50 | Re: [BUGS] BUG #9652: inet types don't support min/max |
| Previous Message | Amit Kapila | 2014-06-04 15:21:10 | Re: Proposing pg_hibernate |