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.
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 |
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 |