Failed to increase the restart LSN of PostgreSQL logical replication slot

Started by Rashmi V Bharadwajover 6 years ago1 messagesgeneral
Jump to latest
#1Rashmi V Bharadwaj
rvbharad@in.ibm.com

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