Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kNhDQ-0004ur-9l for pgsql-bugs@arkaria.postgresql.org; Wed, 30 Sep 2020 18:52:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kNhDO-0004TF-Ok for pgsql-bugs@arkaria.postgresql.org; Wed, 30 Sep 2020 18:52:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kNgjC-0005vu-NO for pgsql-bugs@lists.postgresql.org; Wed, 30 Sep 2020 18:21:22 +0000 Received: from shout02.mail.de ([2001:868:100:600::217]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kNgj9-0008KE-Rh for pgsql-bugs@lists.postgresql.org; Wed, 30 Sep 2020 18:21:22 +0000 Received: from postfix01.mail.de (postfix03.bt.mail.de [10.0.121.127]) by shout02.mail.de (Postfix) with ESMTP id 0BF4CC01D2 for ; Wed, 30 Sep 2020 20:21:17 +0200 (CEST) Received: from smtp02.mail.de (smtp02.bt.mail.de [10.0.121.212]) by postfix01.mail.de (Postfix) with ESMTP id E6FD980174 for ; Wed, 30 Sep 2020 20:21:16 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=mail.de; s=mailde202009; t=1601490076; bh=+4CPPlFgJZpTAkJ12rs2G4BXdurzigiLB/5xlj9Pp5I=; h=From:To:Subject:Date:From; b=imdb6L4kx5NlGHSc3MjzVXsso5xVgCREoc45MIk4jbflNKha8gO/3Gt2En8zaCwH0 OTTEoocb1yd0ZKRNufPf5upWFIchu32H9QLNz0GwZXkfnUDt/YeicVsMKa08g4yIo6 bsEZ8wFsAElCnR3Iu6wmRBdPmuc5HbK6DhjqfWyo5hfGOh/ERZGvq7DOUD8gGnTOQm jTCMz8BYn9GXraCTbHIst6AWk49tOJwxmrE7Ky9UsIHx1rgZHYMZ5yBiXFBoMWUy/u aX+VwCyEvIK8lr4JnObspMeRQmC8yG8Qpb8cuGNHYazWr5REyQjg4yGDmZ9guapDEb bHfiEL4vIR7Cw== Received: from [127.0.0.1] (localhost [127.0.0.1]) (using TLSv1.2 with cipher DHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by smtp02.mail.de (Postfix) with ESMTPSA id 0127CA008F for ; Wed, 30 Sep 2020 20:21:15 +0200 (CEST) From: "Michael Weber" To: Subject: Bugreport | Logical replication PostgreSQL 12 | Error after disable / enable replication Date: Wed, 30 Sep 2020 20:20:44 +0200 Message-ID: <038101d69756$6a1dd550$3e597ff0$@mail.de> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0382_01D69767.2DA8C830" Thread-Index: AdaXVmmAsXR3UUCyQayPLElpBYdLSA== Content-Language: de X-purgate: clean X-purgate: This mail is considered clean (visit http://www.eleven.de for further information) X-purgate-type: clean X-purgate-Ad: Categorized by eleven eXpurgate (R) http://www.eleven.de X-purgate: This mail is considered clean (visit http://www.eleven.de for further information) X-purgate: clean X-purgate-size: 17477 X-purgate-ID: 154282::1601490076-0000058E-372C8E36/0/0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_0382_01D69767.2DA8C830 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello PostgreSQL Team, =20 I encountered a problem with logical replication in PostgreSQL 12. After disable/enable of a subscription I get error messages ERROR: could not start WAL streaming: FEHLER: Replikations-Slot = =BBmysub=AB ist aktiv f=FCr PID 21192 =20 Steps to reproduce =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =20 Used PostgreSQL Versions ------------------------ Publisher: Windows 7 / postgresql-12.4-1-windows-x64 Subscriber Debian 9.13 / 12.4-1.pgdg90+1 =20 Step to reproduce ----------------- =20 Publisher: CREATE PUBLICATION mypub FOR TABLE data.table-1 data.table-2 data.table-3 data.table-4 data.table-5 data.table-6 data.table-7 data.table-8; =20 Subscriber CREATE SUBSCRIPTION mysub CONNECTION 'dbname=3D... host=3D... port=3D5433 user=3Dpostgres = password=3D...' PUBLICATION mypub WITH (copy_data =3D false); ; =20 ALTER SUBSCRIPTION "mysub" disable; =20 wait several minutes =20 ALTER SUBSCRIPTION "mysub" enable; =20 Logs 2020-09-30 19:51:14.407 CEST [15578] 00000 LOG: logical = replication apply worker for subscription "mysub" has started =20 2020-09-30 20:00:54.914 CEST [15578] 00000 LOG: logical = replication apply worker for subscription "mysub" will stop because the subscription = was disabled =20 2020-09-30 20:11:34.265 CEST [20198] 00000 LOG: logical = replication apply worker for subscription "mysub" has started 2020-09-30 20:11:34.301 CEST [20198] XX000 ERROR: could not = start WAL streaming: FEHLER: Replikations-Slot =BBmysub=AB ist aktiv f=FCr = PID 21192 2020-09-30 20:11:34.302 CEST [15428] 00000 LOG: background = worker "logical replication worker" (PID 20198) exited with exit code 1 2020-09-30 20:11:39.309 CEST [20212] 00000 LOG: logical = replication apply worker for subscription "mysub" has started 2020-09-30 20:11:39.352 CEST [20212] XX000 ERROR: could not = start WAL streaming: FEHLER: Replikations-Slot =BBmysub=AB ist aktiv f=FCr = PID 21192 2020-09-30 20:11:39.354 CEST [15428] 00000 LOG: background = worker "logical replication worker" (PID 20212) exited with exit code 1 2020-09-30 20:11:44.357 CEST [20222] 00000 LOG: logical = replication apply worker for subscription "mysub" has started 2020-09-30 20:11:44.396 CEST [20222] XX000 ERROR: could not = start WAL streaming: FEHLER: Replikations-Slot =BBmysub=AB ist aktiv f=FCr = PID 21192 2020-09-30 20:11:44.398 CEST [15428] 00000 LOG: background = worker "logical replication worker" (PID 20222) exited with exit code 1 2020-09-30 20:11:49.402 CEST [20225] 00000 LOG: logical = replication apply worker for subscription "mysub" has started 2020-09-30 20:11:49.452 CEST [20225] XX000 ERROR: could not = start WAL streaming: FEHLER: Replikations-Slot =BBmysub=AB ist aktiv f=FCr = PID 21192 2020-09-30 20:11:49.453 CEST [15428] 00000 LOG: background = worker "logical replication worker" (PID 20225) exited with exit code 1 =20 =20 I set up this configuration a few months ago with an earlier version and = it worked. =20 Best regards, Michael =20 =20 =20 ------=_NextPart_000_0382_01D69767.2DA8C830 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello PostgreSQL Team,

 

I encountered a problem with = logical replication in PostgreSQL 12.

After disable/enable of a = subscription I get error messages

=A0=A0 ERROR:=A0 could not start = WAL streaming: FEHLER:=A0 Replikations-Slot =BBmysub=AB ist aktiv f=FCr = PID 21192

 

Steps = to reproduce

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

 

Used = PostgreSQL Versions

------------------------

=A0 = Publisher:

=A0=A0=A0 Windows 7 = / postgresql-12.4-1-windows-x64

=A0 = Subscriber

=A0=A0=A0 Debian = 9.13 / 12.4-1.pgdg90+1

 

Step = to reproduce

-----------------

 

=A0 = Publisher:

=A0=A0=A0 CREATE = PUBLICATION mypub FOR TABLE

=A0=A0=A0=A0=A0 = data.table-1

=A0=A0=A0=A0=A0 data.table-2

=A0=A0=A0=A0=A0 = data.table-3

=A0=A0 = =A0=A0=A0data.table-4

=A0=A0=A0=A0=A0 data.table-5

=A0=A0=A0=A0=A0 = data.table-6

=A0=A0=A0=A0=A0 data.table-7

=A0=A0=A0=A0=A0 = data.table-8;

 

=A0 = Subscriber

=A0=A0=A0=A0=A0 = CREATE SUBSCRIPTION mysub

=A0=A0=A0=A0=A0=A0 = CONNECTION 'dbname=3D... host=3D... port=3D5433 user=3Dpostgres = password=3D...'

=A0=A0=A0=A0=A0=A0 PUBLICATION mypub

=A0=A0=A0=A0=A0=A0 = WITH (copy_data =3D false);

=A0=A0=A0 = ;

 

=A0=A0=A0 ALTER SUBSCRIPTION "mysub" = disable;

 

=A0=A0=A0 wait several minutes

 

=A0=A0=A0 ALTER SUBSCRIPTION "mysub" = enable;

 

=A0=A0=A0 Logs

=A0=A0=A0=A0=A0=A0 2020-09-30 19:51:14.407 CEST [15578]=A0 00000 = LOG:=A0 logical replication apply worker for subscription = "mysub" has started

=A0=A0=A0=A0=A0=A0 =

=A0=A0=A0=A0=A0=A0=A02020-09-30 20:00:54.914 CEST [15578]=A0 00000 = LOG:=A0 logical replication apply worker for subscription = "mysub" will stop because the subscription was = disabled

=A0=A0=A0=A0=A0=A0 =

=A0=A0=A0=A0=A0=A0=A02020-09-30 20:11:34.265 CEST [20198]=A0 00000 = LOG:=A0 logical replication apply worker for subscription = "mysub" has started

=A0=A0=A0=A0=A0=A0 = 2020-09-30 20:11:34.301 CEST [20198]=A0 XX000 ERROR:=A0 could not start = WAL streaming: FEHLER:=A0 Replikations-Slot =BBmysub=AB ist aktiv f=FCr = PID 21192

=A0=A0=A0=A0=A0=A0 = 2020-09-30 20:11:34.302 CEST [15428]=A0 00000 LOG:=A0 background worker = "logical replication worker" (PID 20198) exited with exit code = 1

=A0=A0=A0=A0=A0=A0 = 2020-09-30 20:11:39.309 CEST [20212]=A0 00000 LOG:=A0 logical = replication apply worker for subscription "mysub" has = started

=A0=A0=A0=A0=A0=A0 = 2020-09-30 20:11:39.352 CEST [20212]=A0 XX000 ERROR:=A0 could not start = WAL streaming: FEHLER:=A0 Replikations-Slot =BBmysub=AB ist aktiv f=FCr = PID 21192

=A0=A0=A0=A0=A0=A0 = 2020-09-30 20:11:39.354 CEST [15428]=A0 00000 LOG:=A0 background worker = "logical replication worker" (PID 20212) exited with exit code = 1

=A0=A0=A0=A0=A0=A0 = 2020-09-30 20:11:44.357 CEST [20222]=A0 00000 LOG:=A0 logical = replication apply worker for subscription "mysub" has = started

=A0=A0=A0=A0=A0=A0 = 2020-09-30 20:11:44.396 CEST [20222]=A0 XX000 ERROR:=A0 could not start = WAL streaming: FEHLER:=A0 Replikations-Slot =BBmysub=AB ist aktiv f=FCr = PID 21192

=A0=A0=A0=A0=A0=A0 = 2020-09-30 20:11:44.398 CEST [15428]=A0 00000 LOG:=A0 background worker = "logical replication worker" (PID 20222) exited with exit code = 1

=A0=A0=A0=A0=A0=A0 = 2020-09-30 20:11:49.402 CEST [20225]=A0 00000 LOG:=A0 logical = replication apply worker for subscription "mysub" has = started

=A0=A0=A0=A0=A0=A0 = 2020-09-30 20:11:49.452 CEST [20225]=A0 XX000 ERROR:=A0 could not start = WAL streaming: FEHLER:=A0 Replikations-Slot =BBmysub=AB ist aktiv f=FCr = PID 21192

=A0=A0=A0=A0=A0=A0 = 2020-09-30 20:11:49.453 CEST [15428]=A0 00000 LOG:=A0 background worker = "logical replication worker" (PID 20225) exited with exit code = 1

=A0=A0=A0 =

 

I set = up this configuration a few months ago with an earlier version and it = worked.

 

Best = regards,

Michael

 

 

 

------=_NextPart_000_0382_01D69767.2DA8C830--