From: | "Pweaver (Paul Weaver)" <pweaver(at)panjiva(dot)com> |
---|---|
To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ERROR: could not access status of transaction 283479860 |
Date: | 2015-04-06 19:46:08 |
Message-ID: | CAFTGa=mLWu13=0P1EV3GSorH7nAXCFUSYZqnxHocZBx-uci+ZA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
We figured that out. We were afraid that there was corrupt data due the
counter overflow so we reverted to a backup right before the overflow. We
submitted a bug this morning (bug #12990) to the Postgres bugs mailing list
which has more information and questions.
On Mon, Apr 6, 2015 at 2:17 PM, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
wrote:
> Pweaver (Paul Weaver) wrote:
> > We started getting the following error on some transactions on our
> database
> > (when against particular rows run against the table).
> >
> >
> > PGError: ERROR: could not access status of transaction 283479860 DETAIL:
> > Could not open file "pg_multixact/members/4D6D": No such file or
> directory.
> >
> > We don't know what happen or how to recover. Any advise?
>
> This looks like you overran pg_multixact/members files by wrapping
> around the 32 bit counter (NextMultiOffset in your pg_controldata
> output); a cleanup process later removed files that were still needed.
> This is a Postgres bug, I fear. Recovery is a bit complicated. I see
> that your report was made 5 days ago -- have you had any progress on
> getting things fixed since then?
>
> --
> Álvaro Herrera http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>
--
Thank You,
Pweaver (pweaver(at)panjiva(dot)com)
From | Date | Subject | |
---|---|---|---|
Next Message | Haiming Zhang | 2015-04-07 00:25:53 | Postgres fails to start |
Previous Message | Adam Brusselback | 2015-04-06 19:29:07 | Re: pgAgent |