Search Postgresql Archives

pglogical trouble on BDR cluster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux