Bug: position can be out of range of replication slot

[lyuboxa]

Bug description

Replication slots can be reused or preconfigured. An issue can occur where the replication slot was replaced during runtime, or the replication slot was preconfigured and modified during connector downtown. In this situation a position can contain an LSN which points to WAL which was cleaned up.

The solution is to ensure that the position LSN is within the replication slot range during open, when the replication slot exists.

Steps to reproduce

1. Create table t1
2. Start connector in CDC mode for table t1 and replication slot name slot_t1
3. Insert changes in t1
4. Stop connector
5. Delete replication slot and re-create it.
6. Insert few more changes in t1
7. Resume connector

Version

latest