pglogical replication dies

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: pgsql-general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: pglogical replication dies
Date: 2019-08-09 11:49:45
Message-ID: 20190809114945.GA20969@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
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,

depesz

Browse pgsql-general by date

  From Date Subject
Next Message Paolo Saudin 2019-08-09 12:28:07 Re: Recomended front ends?
Previous Message Ramesh Maddi 2019-08-09 11:25:13 Re: Understanding PostgreSQL installer debug log