From: petr@petrovich.kiev.ua
To: pgsql-bugs@postgresql.org
Subject: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby
Date: Mon, 09 Dec 2013 13:47:34 +0000
Message-ID: <E1Vq1BO-00064N-Qn@wrigleys.postgresql.org> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-bugs>
The following bug has been logged on the website:
Bug reference: 8673
Logged by: Serge Negodyuck
Email address: petr@petrovich.kiev.ua
PostgreSQL version: 9.3.2
Operating system: Linux 3.2.0-57-generic amd64. Ubuntu 12.04.3
Description:
I'm using postgresql 9.3.0, with WAL streaming replication, i.e.:
postgresql.conf:
hot_standby = on
recovery.conf:
standby_mode = 'on'
primary_conninfo = 'host=master port=5432 user=postgres
password=password'
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
I see a lot of messages in slave server log like :
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.
--
2013-12-09 10:11:59 EET 172.18.10.30 main ERROR: could not access status of
transaction 31724554
2013-12-09 10:11:59 EET 172.18.10.30 main DETAIL: Could not open file
"pg_multixact/members/F615": No such file or directory.
--
2013-12-09 10:12:20 EET 172.18.10.7 main ERROR: could not access status of
transaction 25496296
2013-12-09 10:12:20 EET 172.18.10.7 main DETAIL: Could not open file
"pg_multixact/members/D31E": 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.
I think it may be tied to this commit:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=215ac4ad6589e0f6a31cc4cd867aedba3c...
Next question why binary packages for 9.3.0/9.3.1 where removed from
apt.postgresql.org so I cannot downgrade.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: petr@petrovich.kiev.ua, pgsql-bugs@postgresql.org
Subject: Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby
In-Reply-To: <E1Vq1BO-00064N-Qn@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox