Hi,

When I tried to update the flush LSN position of the logical replication slot for my 11.3 database, using the command select pg_replication_slot_advance(<slotName>, <uptoLsn>)
I get the error:

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

Could you please explain the reason for this error and help resolve it?

Thanks,

Rashmi