public inbox for [email protected]
help / color / mirror / Atom feedRe: Frosen logical replication
2+ messages / 2 participants
[nested] [flat]
* Re: Frosen logical replication
@ 2025-12-05 16:47 Marcos Pegoraro <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Marcos Pegoraro @ 2025-12-05 16:47 UTC (permalink / raw)
To: pgsql-general
Em sex., 5 de dez. de 2025 às 09:03, Marcos Pegoraro <[email protected]>
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 yesterday,
> 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Frosen logical replication
@ 2025-12-05 17:42 Ron Johnson <[email protected]>
parent: Marcos Pegoraro <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Ron Johnson @ 2025-12-05 17:42 UTC (permalink / raw)
To: pgsql-general
On Fri, Dec 5, 2025 at 11:48 AM Marcos Pegoraro <[email protected]> wrote:
> Em sex., 5 de dez. de 2025 às 09:03, Marcos Pegoraro <[email protected]>
> 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 yesterday,
>> 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.
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-12-05 17:42 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-12-05 16:47 Re: Frosen logical replication Marcos Pegoraro <[email protected]>
2025-12-05 17:42 ` Ron Johnson <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox