Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vRZpG-00Gv2I-0v for pgsql-general@arkaria.postgresql.org; Fri, 05 Dec 2025 17:42:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vRZpD-009QAh-2Z for pgsql-general@arkaria.postgresql.org; Fri, 05 Dec 2025 17:42:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vRZpD-009QAY-1M for pgsql-general@lists.postgresql.org; Fri, 05 Dec 2025 17:42:35 +0000 Received: from mail-oi1-x22c.google.com ([2607:f8b0:4864:20::22c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vRZpB-003Jl9-2P for pgsql-general@postgresql.org; Fri, 05 Dec 2025 17:42:35 +0000 Received: by mail-oi1-x22c.google.com with SMTP id 5614622812f47-450b8afe3e0so1395071b6e.0 for ; Fri, 05 Dec 2025 09:42:32 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1764956551; x=1765561351; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=8uo1YaU5/PO5FUqbeoxx+123Js3ylyxiw63lBWdeOsA=; b=WksUbAHMOm40HNXe7dPB8dRrWgcga8HTTQVyIbh/tB2hsvfCDIfwdtsmbsObrpdbZC immX4ueii2wr07S81Dl2kWtIT2wO6IUM1+uyDVMs7HJncA3/DUcBA6ebdCpbO0cHxC1L Ps7B3y86sMSErZ7c+sDfbDSJgATFYalWSjKqaL90CHzoIi9nM/B4MPfj/oj7YUOowcfe Myq5WHrRrZ094iBKwIYr9zVMdNQS31yqS33pOliuaptYAa7AKYPoZDh/B8yTBi6lYjZy RQTp4uQWEKRMpYjTXXPIVJeuPXPiKAdOTADSFXXBI/4RUAZoYpHq8FPbnsK/toXPWZuk Y9rw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1764956551; x=1765561351; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=8uo1YaU5/PO5FUqbeoxx+123Js3ylyxiw63lBWdeOsA=; b=LPjKGiui8M/yPoXLFiCnEEYUqAGexFHe9zAdy+r564eGynNfyz5lZ00eHp4+yIoXRV 6jV6H8lKUD1tSZjdBuDSutCVfdn1jwqlbKmCHEp4uR3qoU5A0IbTkTs7EK9mIDU6MY6f ZX4Ybm8q2b2hD5vFlxb2zqC1P1t9dWENIu8SxEM+APuJdCWvIJhoVBzNYaxl+lJt7igz prytP+xvL51rBsbIoaE2JUIQCziMirLjC8Mjs6NqrlOP5kDakQTDmr93U9y5gPMcqtpq M8qs4NtbpH2NAjSAZEIBBVXtrvjRF26qqxAGDPmwF4d1Eq5iI1U0IFwf5q5etUTVENkU Htjg== X-Gm-Message-State: AOJu0YxWdZe4WqIO6Yvq+VxoBzYtemjrft3ff+F96mTlzoK1gE2Ryakf HgyrhCZUrSlW18WBHU5+ozw1DR/c+l/hsNyArnCMQbKOR+IC29vjp9PWCutXFIV2XdtBqXK2H1v +QvixqwdOMHfyM/cT40p3J2zx9jtlL1VIjw== X-Gm-Gg: ASbGncvSLQw6UCohKCvYBuLrhVj05gdsjbm5AzzZNKRKijDEUYc0t1C9iOquSWn1aMq 4KCKMtt+JuzRmNGYlpG+nlDYNeFhddAiN1ghhHbmtNBkAClusjnT7GonR4pSEFhrvrawyZQ2DBj ac4R4XA9rWwM5KGC8/M1zd84Ohe2TXW7FlUz9ZKOlE8BlcouWSh20V+p18CjTV+WkpcVtGXMZXv NBw2xmczdpzm23WagKoYtWSB1v5UQwZONHiZlwT6t1QshyKMJvY9rGfaQY32+Opj7DTA5WB X-Google-Smtp-Source: AGHT+IHXtEAfdCVlvchdFMsrz84lRYh6IWAShEWz7s5/OmccIzH3aa4RxBhAEatYJItBAyDCDt0e0Uu1zwJsu+Euf+g= X-Received: by 2002:a05:6808:bd0:b0:44d:a44f:1e87 with SMTP id 5614622812f47-4536e4f717fmr6374180b6e.40.1764956550983; Fri, 05 Dec 2025 09:42:30 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Fri, 5 Dec 2025 12:42:20 -0500 X-Gm-Features: AQt7F2poeUSgSg6iP_G6PFvw8ewBEFSV-uxUfA4JY3idTOpwAPMIuvTrsDtAMkY Message-ID: Subject: Re: Frosen logical replication To: Postgres General Content-Type: multipart/alternative; boundary="00000000000043f434064537f86e" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000043f434064537f86e Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Fri, Dec 5, 2025 at 11:48=E2=80=AFAM Marcos Pegoraro = wrote: > Em sex., 5 de dez. de 2025 =C3=A0s 09:03, Marcos Pegoraro > escreveu: > >> I have a logical replication where I want to replicate only one schema. >> All worked fine, it copied all tables to subscriber, except one. That >> table has 8GB and it copied 5GB. That copy has been frozen since yesterd= ay, >> as you can see. >> > > I tried these steps. > - Tried to restart subscriber, didn't solve and file didn't change its > size on subscriber. > Subscriber did not try to restart copying from scratch, just did nothing. > DIDN'T SOLVE > > - Tried to restart publisher 2 or 3 times, didn't solve the problem but > file changed > some MBs but was copying from what starting point if server was restarted > and > file was partially transfered ? I don't know. Then on subscriber side I > got some messages like > "could not receive data from WAL stream: SSL error: unexpected eof while > reading" > DIDN'T SOLVE > > - Restarted publisher and while restarting I truncated that table on > subscriber. > How srsubstate was "d" but srsublsn was NULL It had to copy that file > entirely, and it did. > Then that file was completely copied from publisher and until now > everything seems fine. > SOLVED, APPARENTLY > Maybe have multiple replication slots, one per X number of customers? More work for you, but less work required by that single-threaded publisher, and more granular: hopefully most slots will replicate. --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --00000000000043f434064537f86e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Fri, Dec 5, 2025 at 11:48=E2=80=AFAM M= arcos Pegoraro <marcos@f10.com.br> wrote:
I have a logical replication where I want= to replicate only one schema.
All worked fine, it copied all tables to subs= criber, except one. That table has 8GB and it copied 5GB. That copy has bee= n frozen since yesterday, as you can see.

=
= I tried these steps.
- Tried to restart subscriber, didn't solve and fil= e didn't change its size on subscriber.=C2=A0
Subscriber did not try to = restart copying from scratch, just did nothing.
DIDN'T SOLVE

- Tried = to restart publisher 2 or 3 times, didn't solve the problem but file ch= anged=C2=A0
some MBs but was copying from what starting point if server was = restarted and=C2=A0
file was partially transfered ? I don't know. Then o= n subscriber side I got some messages like=C2=A0
"could not receive dat= a from WAL stream: SSL error: unexpected eof while reading"
DIDN'T = SOLVE

- Restarted publisher and while restarting I truncated that table = on subscriber.=C2=A0
How=C2=A0srsubstate was "d" but srsublsn=C2= =A0was NULL It had to copy that file entirely, and it did.
Then that file w= as completely copied from publisher and until now everything seems fine.
SOL= VED, APPARENTLY

Maybe have multiple replication slots, one per X number of customer= s?=C2=A0 More work for you, but less work required by that single-threaded = publisher, and more granular: hopefully most slots will replicate.

--
Death to <Redacted&g= t;, and butter sauce.
Don't boil me, I'm still alive.
<= div><Redacted> lobster!
--00000000000043f434064537f86e--