recovery snapshot waiting for non-overflowed snapshot or until oldest active xid on standby is at least 4739126 (now 1422751)

From: "Li EF Zhang" <bjzhangl(at)cn(dot)ibm(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: recovery snapshot waiting for non-overflowed snapshot or until oldest active xid on standby is at least 4739126 (now 1422751)
Date: 2021-01-02 04:11:14
Message-ID: OF042C0C6A.EFC0F13F-ON00258651.0015E12A-00258651.00170073@notes.na.collabserv.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

<div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div dir="ltr" >We have a postgresql database cluster with 3 node, one is primary, the other 2 are secondary. The cluster is managed by patroni. The 3 databases are in respective containers. When we update one secondary container image, the database in this container can not start. It reports "database system is starting up". We tried to delete the container and recover it from primary, the same error is reported.</div>
<div dir="ltr" >&nbsp;</div>
<div dir="ltr" >I checked the db log, there is a message:</div>
<div dir="ltr" >DEBUG:&nbsp; recovery snapshot waiting for non-overflowed snapshot or until oldest active xid on standby is at least 4739126 (now 1422751)#0122020-12-15 07:40:08.513 UTC [146-5182] CONTEXT:&nbsp; WAL redo at 3/ED11B020 for Standby/RUNNING_XACTS: nextXid 4739482 latestCompletedXid 4739475 oldestRunningXid 1422751; 16 xacts: 2716862 2721890 4665244 2495592 2289138 2288820 2287653 1422751 4280517 2288510 2287620 3297674 1757103 4739326 3320989 2259670; subxid ovf</div>
<div dir="ltr" >&nbsp;</div>
<div dir="ltr" >&nbsp;</div>
<div dir="ltr" >Seems snapshot overflowed which causes the secondary can not start up. I am newer to postgresql. I do not know very clearly how this happened and how to fix it. Thanks!<br><br><br>&nbsp;</div></div><BR>

Attachment Content-Type Size
unknown_filename text/html 1.4 KB

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Magnus Hagander 2021-01-02 11:50:06 Re: recovery snapshot waiting for non-overflowed snapshot or until oldest active xid on standby is at least 4739126 (now 1422751)
Previous Message MichaelDBA 2020-12-31 17:30:49 Re: Creating a materialized view causing blocks