BUG #18415: Logical replication errors.

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: koderan(at)yandex(dot)ru
Subject: BUG #18415: Logical replication errors.
Date: 2024-03-28 16:16:23
Message-ID: 18415-3725aa3af8de5ed3@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 18415
Logged by: Andy Kosheen
Email address: koderan(at)yandex(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2024-03-28 17:02:41 Re: BUG #18415: Logical replication errors.
Previous Message PG Bug reporting form 2024-03-28 12:51:15 BUG #18414: When the key values are the same, the memory limit is exceeded when making a hash join