Re: Frosen logical replication

Em sex., 5 de dez. de 2025 às 09:03, Marcos Pegoraro <marcos@f10.com.br> 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