While looking at the failures recently in this PR:
https://github.com/debezium/debezium/pull/5711

I noticed that the sinkNotificationWillCorrectlySaveOffsetAfterSnapshot test will fail and then causes the next test notificationCorrectlySentOnItsTopic to also fail.

This was observed on MariaDB and PostgreSQL16; however, specifically with PostgreSQL16 this lead to the entire test suite failing from that point forward because the replication slot remained in an active state, which is unexpected.

MariaDB:
https://productionresultssa2.blob.core.windows.net/actions-results/75e85656-c111-4626-a936-65f177b31fa7/workflow-job-run-95059a44-e992-5095-b2a4-7c8df288c93f/logs/job/job-logs.txt?rsct=text%2Fplain&se=2024-07-26T19%3A23%3A46Z&sig=XPtO7HHeaI3ge%2FM%2Bz8%2BEscSN0HScttLjghSkA5EKqbU%3D&ske=2024-07-27T03%3A43%3A46Z&skoid=ca7593d4-ee42-46cd-af88-8b886a2f84eb&sks=b&skt=2024-07-26T15%3A43%3A46Z&sktid=398a6654-997b-47e9-b12b-9515b896b4de&skv=2024-05-04&sp=r&spr=https&sr=b&st=2024-07-26T19%3A13%3A41Z&sv=2024-05-04

PostgreSQL:
https://productionresultssa2.blob.core.windows.net/actions-results/75e85656-c111-4626-a936-65f177b31fa7/workflow-job-run-8e0987bd-2f76-5528-f62d-e412634cbde0/logs/job/job-logs.txt?rsct=text%2Fplain&se=2024-07-26T19%3A14%3A55Z&sig=jG%2Fjb0nc0C6dLLStetr5NBd3vKPuf6GFi9hU4c%2FIOu4%3D&ske=2024-07-27T03%3A43%3A46Z&skoid=ca7593d4-ee42-46cd-af88-8b886a2f84eb&sks=b&skt=2024-07-26T15%3A43%3A46Z&sktid=398a6654-997b-47e9-b12b-9515b896b4de&skv=2024-05-04&sp=r&spr=https&sr=b&st=2024-07-26T19%3A04%3A50Z&sv=2024-05-04