BUG #18415: Logical replication errors. - Mailing list pgsql-bugs

The following bug has been logged on the website:

Bug reference:      18415
Logged by:          Andy Kosheen
Email address:      koderan@yandex.ru
PostgreSQL version: 15.4
Operating system:   Oracle Linux Server 8.4
Description:

In the process of logical replication from version 13.3 (on Ubuntu 16.04.6
LTS) to version 15.4 (on Oracle Linux Server 8.4), when most of the data has
already been transferred, the following errors begin to occur, appearing
endlessly until you stop the replication process (this situation occurs on
databases larger than at least 50GB, even if there is a small number of
transactions on the source database):
2024-03-20 03:19:41.410 +07 [3433858] LOG:  logical replication apply worker
for subscription "log_rep_sub" has started
2024-03-20 03:19:41.425 +07 [3433858] ERROR:  could not start WAL streaming:
ERROR:  replication slot "log_rep_sub" does not exist
2024-03-20 03:19:41.426 +07 [1597281] LOG:  background worker "logical
replication worker" (PID 3433858) exited with exit code 1
2024-03-20 03:19:46.434 +07 [3433865] LOG:  logical replication apply worker
for subscription "log_rep_sub" has started
2024-03-20 03:19:46.449 +07 [3433865] ERROR:  could not start WAL streaming:
ERROR:  replication slot "log_rep_sub" does not exist
2024-03-20 03:19:46.450 +07 [1597281] LOG:  background worker "logical
replication worker" (PID 3433865) exited with exit code 1
2024-03-20 03:19:51.459 +07 [3433914] LOG:  logical replication apply worker
for subscription "log_rep_sub" has started
2024-03-20 03:19:51.481 +07 [3433914] ERROR:  could not start WAL streaming:
ERROR:  replication slot "log_rep_sub" does not exist
2024-03-20 03:19:51.484 +07 [1597281] LOG:  background worker "logical
replication worker" (PID 3433914) exited with exit code 1
2024-03-20 03:19:56.493 +07 [3433921] LOG:  logical replication apply worker
for subscription "log_rep_sub" has started
2024-03-20 03:19:56.514 +07 [3433921] ERROR:  could not start WAL streaming:
ERROR:  replication slot "log_rep_sub" does not exist
2024-03-20 03:19:56.517 +07 [1597281] LOG:  background worker "logical
replication worker" (PID 3433921) exited with exit code 1
2024-03-20 03:20:01.525 +07 [3433976] LOG:  logical replication apply worker
for subscription "log_rep_sub" has started
2024-03-20 03:20:01.548 +07 [3433976] ERROR:  could not start WAL streaming:
ERROR:  replication slot "log_rep_sub" does not exist
2024-03-20 03:20:01.551 +07 [1597281] LOG:  background worker "logical
replication worker" (PID 3433976) exited with exit code 1
2024-03-20 03:20:06.559 +07 [3434036] LOG:  logical replication apply worker
for subscription "log_rep_sub" has started
2024-03-20 03:20:06.580 +07 [3434036] ERROR:  could not start WAL streaming:
ERROR:  replication slot "log_rep_sub" does not exist
2024-03-20 03:20:06.583 +07 [1597281] LOG:  background worker "logical
replication worker" (PID 3434036) exited with exit code 1
2024-03-20 03:20:11.591 +07 [3434087] LOG:  logical replication apply worker
for subscription "log_rep_sub" has started
2024-03-20 03:20:11.613 +07 [3434087] ERROR:  could not start WAL streaming:
ERROR:  replication slot "log_rep_sub" does not exist
2024-03-20 03:20:11.616 +07 [1597281] LOG:  background worker "logical
replication worker" (PID 3434087) exited with exit code 1
2024-03-20 03:20:16.624 +07 [3434103] LOG:  logical replication apply worker
for subscription "log_rep_sub" has started
2024-03-20 03:20:16.645 +07 [3434103] ERROR:  could not start WAL streaming:
ERROR:  replication slot "log_rep_sub" does not exist
2024-03-20 03:20:16.648 +07 [1597281] LOG:  background worker "logical
replication worker" (PID 3434103) exited with exit code 1
2024-03-20 03:20:21.656 +07 [3434157] LOG:  logical replication apply worker
for subscription "log_rep_sub" has started
2024-03-20 03:20:21.671 +07 [3434157] ERROR:  could not start WAL streaming:
ERROR:  replication slot "log_rep_sub" does not exist