Some subscriptions fail (while some succeed) with pglogical

From: xiaolongc <xiaolong(dot)ch(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Some subscriptions fail (while some succeed) with pglogical
Date: 2017-09-13 00:20:42
Message-ID: 1505262042242-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hey guys, I'm setting up logical replication with pglogical, and found out
that some of my subscriptions are working well but others are not. They are
set up in the same way tho, and both master and replica are running pg9.5.

Below is subscription status on the replica:

\# select subscription_name, status, replication_sets from
pglogical.show_subscription_status();

parking_sub | down | {parking_schema}
public_sub | replicating | {public_schema}
stripe_sub | replicating | {stripe_schema}
zip_sub | down | {zip_schema}

Checked logs on the replica:

2017-09-13 00:00:14 UTC [2850-1] LOG: starting apply for subscription
zip_sub
2017-09-13 00:00:14 UTC [2850-2] ERROR: subscriber zip_sub initialization
failed during nonrecoverable step (d), please try the setup again
2017-09-13 00:00:14 UTC [2850-3] LOG: apply worker [2850] at slot 3
generation 70 crashed
2017-09-13 00:00:14 UTC [1573-136] LOG: worker process: pglogical apply
16384:743118875 (PID 2850) exited with exit code 1

I checked my replication set on the master and it looks valid. All tables
in the replication set have a Primary Key constraint.

What else do you think could have gone wrong? Thanks in advance!

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2017-09-13 00:31:34 Re: More flexible LDAP auth search filters?
Previous Message Andreas Joseph Krogh 2017-09-13 00:11:25 Re: Clarification in pg10's pgupgrade.html step 10 (upgrading standby servers)