Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] could not access status of transaction - Mailing list pgsql-admin

From Ashish Tiwari
Subject Re: [ADMIN] could not access status of transaction
Date
Msg-id CAH8UkmGGps7gVzT_teENb=28iD3kDFfQic4Vwn6MkDnn2xzQtw@mail.gmail.com
Whole thread Raw
In response to [ADMIN] could not access status of transaction  (Harsh Patel <harshpatel19@gmail.com>)
List pgsql-admin
Tree view
Can you share your environment details.it seems WAL file is discarded before copying on slave.

On Jul 12, 2017 7:14 PM, "Harsh Patel" <harshpatel19@gmail.com> wrote:
While configuring streaming replication on master(master already had 200gb data), I added the following changes
wal_level = hot_standby
max_wal_senders = 3
wal_keep_segments = 8

and restarted postgres.

I started getting error
could not access status of transaction 243368097
Could not open file "pg_multixact/members/433B": No such file or directory.

What steps should I take to recover from this.

pgsql-admin by date:

Previous
From: Harsh Patel
Date:
Subject: [ADMIN] could not access status of transaction
Next
From: Jerry Sievers
Date:
Subject: Re: [ADMIN] autovacuum logs question