Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vq1c0-0004dz-QI for pgsql-bugs@arkaria.postgresql.org; Mon, 09 Dec 2013 14:15:04 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Vq1c0-0001Ch-64 for pgsql-bugs@arkaria.postgresql.org; Mon, 09 Dec 2013 14:15:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vq1Ba-0002a4-3Q for pgsql-bugs@postgresql.org; Mon, 09 Dec 2013 13:47:46 +0000 Received: from mahout.postgresql.org ([2001:4800:7903:4::123]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vq1BV-000221-Im for pgsql-bugs@postgresql.org; Mon, 09 Dec 2013 13:47:45 +0000 Received: from wrigleys.postgresql.org ([204.145.124.246]) by mahout.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vq1BU-0008RD-5l for pgsql-bugs@postgresql.org; Mon, 09 Dec 2013 13:47:40 +0000 Received: from www-data by wrigleys.postgresql.org with local (Exim 4.80) (envelope-from ) id 1Vq1BO-00064N-Qn for pgsql-bugs@postgresql.org; Mon, 09 Dec 2013 13:47:34 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby To: pgsql-bugs@postgresql.org From: petr@petrovich.kiev.ua Message-Id: Date: Mon, 09 Dec 2013 13:47:34 +0000 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-bugs Precedence: bulk Sender: pgsql-bugs-owner@postgresql.org 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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs