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 1vRYz6-00GS5M-1L for pgsql-general@arkaria.postgresql.org; Fri, 05 Dec 2025 16:48:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vRYz5-009DiJ-0C for pgsql-general@arkaria.postgresql.org; Fri, 05 Dec 2025 16:48:43 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vRYz4-009Di9-1V for pgsql-general@lists.postgresql.org; Fri, 05 Dec 2025 16:48:43 +0000 Received: from mail-ed1-x536.google.com ([2a00:1450:4864:20::536]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vRYyz-003JBx-0s for pgsql-general@postgresql.org; Fri, 05 Dec 2025 16:48:39 +0000 Received: by mail-ed1-x536.google.com with SMTP id 4fb4d7f45d1cf-64175dfc338so3811358a12.0 for ; Fri, 05 Dec 2025 08:48:37 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=f10-com-br.20230601.gappssmtp.com; s=20230601; t=1764953316; x=1765558116; 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=+QUKkj6HaJFh5Ssy2XIxGXlHOSlQkS6WOW5pU1Ye/iQ=; b=eiZFjuZmkx7vLkIi7tpvDomd/ILNmkT99jbzYVeugpHMc546Kx6SsxAffkeVXLJSNC vsOogO9aJDjWxREJ0jRDOa9IQqZjXEtlJ/3ERPEpnfQLWaCsQ7+iGOAfCNIY1JIT4qpv 5c0IqxsxhdQgpQs/vCfQa2zBIKXLZ2QsYkG199rVP36Lioc4El0ziWEipUoYYMB8Nguo ark0WwbWRA/wvO635a2dmQrELO4T71VKps+cDbjK9knhxWGDFm1Qid7KVHy78imNck24 6vlH5o7etWSwLkOoiIxT16zcVranigxzmnD2yX1SvNSiBn5mpADY2MOA8pxsqZUBQWw2 RPrA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1764953316; x=1765558116; 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=+QUKkj6HaJFh5Ssy2XIxGXlHOSlQkS6WOW5pU1Ye/iQ=; b=nZZHOVlGMOwOdXTxZBHVnnxl1fSjyfLwWLeYt9BmZgIgOZEh2Xqg9kuJQkyX4aYK6O 6k/D5kuqjwBpYiw4WQajgt5bpVP8aA9w7ncXgSRg1QKFBkcWXk68TCsNFON+l5I9d86k 00Ana2gzDKXqdNOKXPQS0Lze9DiuVN9nCLahB0hAxJE0Xz8y4hp3YJjbY+Z29Fdw5kku IRFTjX4Fs6Auqc0aK2vHU73g6GdKRYk1tHUfZ4vPoR868SADUWpnqLtgQmCAN2OSEVay zXCHj/KRMC70pfgDwC3GmIF+CurPNGhJN8ue6y/9wp6lblRquoO8jtw9pXbH2KhqkfXX oeZg== X-Gm-Message-State: AOJu0YzzydImFEQUHMSTxmNafDPcvEXq714Ig593fvKl4v8CkyHKe0/n jRs9zcOg1FWasXhgyMlIvHUzb4HYuZYl9SEAZzpx6DUUJjSahLLqojm13/fw7tqwSaxWqxeT39g CFyeuMF6glf23UhsgnF6rvmsfXQ/dS2YqiKxLU6si5HwZe9ixtEkIWw== X-Gm-Gg: ASbGncs41qnzd6kQ5SwoJoJ6zyQhWpmtHY+O5qo7arycksuywZBS/3ot3XkO1KiqG7s 60yoQItL9MhHGqwIxQ9dW01LBu/O0JzaR+eT5iypjJfF1moZfIC204FnybdNcFj19SrFBohk17y VrU+cAYGJNZfeTR6q2N7KReHuGZGwK+fVb6y3s+QtolHkoFmHmiCSp2gJfu40cbu275e1x1jteZ HzR1EsFILEW/x+eX5LHei7Zo2ZZb+q3zXmkdE3x7+fvOT2JH6p+thVtlRDeV6/YZKRPIJoGDg== X-Google-Smtp-Source: AGHT+IHpk8uyI4BBKiaYGhTvIqjFPumU5am66C4YON6oCS91L37HNtEpHkS25wYs24+ngs4B2M61sFyK+JTTWsiT1gE= X-Received: by 2002:a17:907:c24:b0:b73:7974:94d1 with SMTP id a640c23a62f3a-b79dc51af3emr1106301366b.36.1764953315531; Fri, 05 Dec 2025 08:48:35 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Marcos Pegoraro Date: Fri, 5 Dec 2025 13:47:58 -0300 X-Gm-Features: AWmQ_bl5tMV1oNIv3_X78NTfMtpGB6-lDVXLwotwtxy37GLW39FxxG2tIAvZm4M Message-ID: Subject: Re: Frosen logical replication To: Postgres General Content-Type: multipart/alternative; boundary="0000000000006af0c606453737eb" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000006af0c606453737eb Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 yesterda= y, > 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 regards Marcos --0000000000006af0c606453737eb Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Em sex., 5 de dez. de 2025 =C3=A0s 0= 9:03, Marcos Pegoraro <marcos@f10.c= om.br> escreveu:
I hav= e a logical replication where I want to replicate only one schema.
All worke= d fine, it copied all tables to subscriber, except one. That table has 8GB = and it copied 5GB. That copy has been frozen since yesterday, as you can se= e.

I tried these s= teps.
- Tried to restart subscriber, didn't solv= e and file didn't change its size on subscriber.=C2=A0
Subscriber did not try to restart copying from scratch, just did no= thing.
DIDN'T SOLVE

<= /div>
- Tried to restart publisher 2 or 3 times, didn'= t solve the problem but file changed=C2=A0
some MBs = but was copying from what starting point if server was restarted and=C2=A0<= /div>
file was partially transfered ? I don't know. Th= en on subscriber side I got some messages like=C2=A0
"could not receive data from WAL stream: SSL error: unexpected eof wh= ile reading"
DIDN'T SOLVE

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

regards
Marcos
--0000000000006af0c606453737eb--