pglogical replication dies

Previous Topic Next Topic
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

pglogical replication dies

hubert depesz lubaczewski-2
I tried to setup upgrade using pglogical - from 9.5 to 11.

I did set it up, and after subscription, initial data sync seems to work
fine, but then replication dies.

In logs on subscriber, every 3 minutes I see:

db=,user= LOG:  background worker "pglogical apply 114610049:2875150205" (PID 28020) exited with exit code 1

On provider there are more messages. Every 3 minutes I get:

LOG:  replication connection authorized: user=some_user SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, compression=off)
LOG:  starting logical decoding for slot "pgl_somedb_provider_subscription"
DETAIL:  streaming transactions committing after 4AA0/5B43630, reading WAL from 4AA0/55743C0
LOG:  logical decoding found consistent point at 4AA0/55743C0
DETAIL:  There are no running transactions.
LOG:  could not receive data from client: Connection reset by peer
LOG:  unexpected EOF on standby connection

And that's all.

If it matters there are ~ 3000 tables in the replication set, and we
don't replicate sequences (figured it will be simpler to just sync them
once on switch to new server).

How to debug/diagnose the problem?

Best regards,