pglogical trouble on BDR cluster

From: Alvaro Aguayo Garcia-Rada <aaguayo(at)opensysperu(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: pglogical trouble on BDR cluster
Date: 2017-07-02 19:28:54
Message-ID: 042101d2f369$5712c810$05385830$@opensysperu.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi. I currently have a two-server BDR replication setup. Apart from the two
master nodes, I have another two servers which I want to have read only
replication for some tables only.

I first had to deal with some trouble regarding CREATE EXTENSION being
replicated by BDR, and that causing the schema creation for the extension to
be run on both servers, thus locking the entire cluster. I solved that by
creating the schema, tables and function manually, and replacing the
extension SQL file with an empty one.

Now, after joining the subscriber to the provider, I keep getting the
following log in the provider:

< 2017-07-02 13:30:38.776 -05 >ERROR: missing required parameter
"startup_params_format"

< 2017-07-02 13:30:38.776 -05 >CONTEXT: slot
"pgl_ocs_test_dayana_jimena_dayana", output plugin "pglogical_output", in
the startup callback

And in the subscriber:

< 2017-07-02 13:29:39.824 CEST >LOG: registering background worker
"pglogical apply 192166:2763588059"

< 2017-07-02 13:29:39.824 CEST >LOG: starting background worker process
"pglogical apply 192166:2763588059"

< 2017-07-02 13:29:39.827 CEST >LOG: starting apply for subscription
jimena_dayana

< 2017-07-02 13:29:39.833 CEST >ERROR: data stream ended

< 2017-07-02 13:29:39.834 CEST >LOG: apply worker [5632] at slot 2
generation 127 crashed

< 2017-07-02 13:29:39.835 CEST >LOG: worker process: pglogical apply
192166:2763588059 (PID 5632) exited with exit code 1

< 2017-07-02 13:29:39.835 CEST >LOG: unregistering background worker
"pglogical apply 192166:2763588059"

I've searched all around the source code & document5ation, but I see no way
to set that parameter, so I'm stucked here. Any help would be appreciated.

Regards,

Alvaro Aguayo
Jefe de Operaciones
Open Comb Systems E.I.R.L.

Oficina: (+51-1) 3377813 | RPM: (+51) (#) 995540103 | RPC: (+51) 954183248
Website: www.ocs.pe <http://www.ocs.pe>

Browse pgsql-general by date

  From Date Subject
Next Message Craig de Stigter 2017-07-02 20:15:15 Re: Config for fast huge cascaded updates
Previous Message twoflower 2017-07-02 18:41:39 Re: Text search dictionary vs. the C locale