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