Thread: [HACKERS] Some subscriptions fail (while some succeed) with pglogical

[HACKERS] Some subscriptions fail (while some succeed) with pglogical

From
xiaolongc
Date:
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


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Some subscriptions fail (while some succeed) with pglogical

From
xiaolongc
Date:
Never mind.  The problem was actually a minor one -- I need to truncate the
table before re-subscribe (otherwise table copy would fail when syncing data
with master).





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


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers