BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby
От | petr@petrovich.kiev.ua |
---|---|
Тема | BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby |
Дата | |
Msg-id | E1Vq1BO-00064N-Qn@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #8673: Could not open file
"pg_multixact/members/xxxx" on slave during hot_standby
|
Список | pgsql-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=215ac4ad6589e0f6a31cc4cd867aedba3cd42924 Next question why binary packages for 9.3.0/9.3.1 where removed from apt.postgresql.org so I cannot downgrade.
В списке pgsql-bugs по дате отправления: