From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: koderan@yandex.ru
Subject: BUG #18415: Logical replication errors.
Date: Thu, 28 Mar 2024 16:16:23 +0000
Message-ID: <18415-3725aa3af8de5ed3@postgresql.org> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, koderan@yandex.ru
Subject: Re: BUG #18415: Logical replication errors.
In-Reply-To: <18415-3725aa3af8de5ed3@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox