Failed to increase the restart LSN of PostgreSQL logical replication slot

From: "Rashmi V Bharadwaj" <rvbharad(at)in(dot)ibm(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Failed to increase the restart LSN of PostgreSQL logical replication slot
Date: 2019-10-24 09:15:32
Message-ID: OFB9438289.136406B3-ON0025849D.00327F25-0025849D.0032DC9F@notes.na.collabserv.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<font face="Verdana,Arial,Helvetica,sans-serif" size="2"><div>Hi,</div><div><br></div><div>When I tried to update the flush LSN position of the logical replication slot for my 11.3 database, using the command <i><b>select pg_replication_slot_advance(&lt;slotName&gt;, &lt;uptoLsn&gt;)</b></i><br>I get the error:<br></div><div><br></div><div><i>user=cdcpsqlsrc,db=db_dsn_test03,app=PostgreSQL JDBC Driver,client=172.24.42.236 DEBUG: failed to increase restart lsn: proposed 0/B05EE120, after 0/D0664DC8, current candidate 0/A5180928, current after 0/A5180928, flushed up to 0/A5119080</i></div><div><br></div><div>Could you please explain the reason for this error and help resolve it?<br><br>Thanks,</div><div>Rashmi<br></div><br><br></font><BR>

Attachment Content-Type Size
unknown_filename text/html 751 bytes

Browse pgsql-general by date

  From Date Subject
Next Message stan 2019-10-24 10:52:27 A very puzzling backup/restore problem
Previous Message Laiszner Tamás 2019-10-24 08:12:28 Re: Composite type storage overhead