BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby

From: petr(at)petrovich(dot)kiev(dot)ua
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby
Date: 2013-12-09 13:47:34
Message-ID: E1Vq1BO-00064N-Qn@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

The following bug has been logged on the website:

Bug reference: 8673
Logged by: Serge Negodyuck
Email address: petr(at)petrovich(dot)kiev(dot)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=215ac4ad6589e0f6a31cc4cd867aedba3cd42924

Next question why binary packages for 9.3.0/9.3.1 where removed from
apt.postgresql.org so I cannot downgrade.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Pavel Stehule 2013-12-09 14:18:11 Re: BUG #8672: pg_sleep function doesn't work as expected
Previous Message Fujii Masao 2013-12-09 12:51:51 Re: stats_temp_directory SIGHUP documentation bug

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2013-12-09 14:25:25 Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby
Previous Message Greg Stark 2013-12-09 13:46:51 Re: Time-Delayed Standbys