From: | Andres Freund <andres(at)2ndquadrant(dot)com> |
---|---|
To: | Serge Negodyuck <petr(at)petrovich(dot)kiev(dot)ua> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby |
Date: | 2013-12-09 15:03:45 |
Message-ID: | 20131209150345.GB1123@awork2.anarazel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
On 2013-12-09 16:55:21 +0200, Serge Negodyuck wrote:
> 2013/12/9 Andres Freund <andres(at)2ndquadrant(dot)com>:
> > On 2013-12-09 13:47:34 +0000, petr(at)petrovich(dot)kiev(dot)ua wrote:
> >> PostgreSQL version: 9.3.2
> >
> >> I've installed new slave database on 6th of December. Since there was no
> >> packages on apt.postgresql.org with postgresql 9.3.0 I've set up postgresql
> >> 9.3.2
> >
> >> 2013-12-09 10:10:24 EET 172.18.10.45 main ERROR: could not access status of
> >> transaction 24568845
> >> 2013-12-09 10:10:24 EET 172.18.10.45 main DETAIL: Could not open file
> >> "pg_multixact/members/CD8F": No such file or directory.
> >
> >> My next step was to upgrade to postgresql 9.3.2 on master and to do initial
> >> sync from scratch.
> >> It does not help. I still have the same error.
> >
> > Could you post, as close as possible to the next occurance of that
> > error:
> > * pg_controldata output from the primary
> > * pg_controldata output from the standby
>
> Sorry, I've just downgraded all the cluster to 9.3.0, and this error
> disappeared.
> I can provide output right now, if it make any sence.
Yes, that'd be helpful.
Could you also provide ls -l pg_multixact/ on both primary and standby?
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Langegger ⌂ zoomsquare | 2013-12-09 15:04:30 | UX Bug sets account expires to TODAY by default |
Previous Message | Serge Negodyuck | 2013-12-09 14:55:21 | Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby |
From | Date | Subject | |
---|---|---|---|
Next Message | Serge Negodyuck | 2013-12-09 15:49:34 | Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby |
Previous Message | Serge Negodyuck | 2013-12-09 14:55:21 | Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby |