[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] could not access status of transaction
From:       Ashish Tiwari <tashish786 () gmail ! com>
Date:       2017-07-12 15:22:26
Message-ID: CAH8UkmGGps7gVzT_teENb=28iD3kDFfQic4Vwn6MkDnn2xzQtw () mail ! gmail ! com
[Download RAW message or body]

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

[Attachment #3 (text/html)]

<div dir="auto"><div>Can you share your environment <a \
href="http://details.it">details.it</a> seems WAL file is discarded before copying on \
slave.<br><div class="gmail_extra"><br><div class="gmail_quote">On Jul 12, 2017 7:14 \
PM, &quot;Harsh Patel&quot; &lt;<a href="mailto:harshpatel19@gmail.com" \
target="_blank">harshpatel19@gmail.com</a>&gt; wrote:<br \
type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">While configuring \
streaming replication on master(master already had 200gb data), I added the following \
changes<div><div>wal_level = hot_standby</div><div>max_wal_senders = \
3</div><div>wal_keep_segments = 8</div></div><div><br></div><div>and restarted \
postgres.<br><br>I started getting error</div><div><div>could not access status of \
transaction 243368097</div><div>Could not open file \
&quot;pg_multixact/members/433B&quot;: No such file or \
directory.</div></div><div><br></div><div>What steps should I take to recover from \
this.</div></div> </blockquote></div></div>
</div></div>



[prev in list] [next in list] [prev in thread] [next in thread]