Re: BDR replication slots

[Nikhil <nikhilsmenon@xxxxxxxxx>]

On interface down:

------------------

<10.102.31.213(27599)postgres13082016-04-19 06:31:36 GMTprocess_journal%LOG:  terminating walsender process due to replication timeout

Once interface is brought back

----------------------------------------

 425906 <12692016-04-19 08:32:58 GMT%LOG:  starting background worker process "bdr (6275149074578269365,2,16386,)->bdr (6275135922714263763,1,"

 425907 <597732016-04-19 08:32:58 GMT%ERROR:  relation "mygroup" already exists

 425908 <597732016-04-19 08:32:58 GMT%CONTEXT:  during DDL replay of ddl statement: CREATE  TABLE  public.mygroup (id pg_catalog."varchar"(14)  NOT NULL COLLATE pg_catalog."default", name pg_catalog."varchar"(100)   COLLATE pg_catalog."default", device_type pg_catalog."varchar"(30)   COLLATE pg_catalog."default", platform_type pg_catalog."varchar"(30)   COLLATE pg_catalog."default", CONSTRAINT mygroup_pkey PRIMARY KEY (id) )  WITH (oids=OFF)

 425909 <12692016-04-19 08:32:58 GMT%LOG:  worker process: bdr (6275149074578269365,2,16386,)->bdr (6275135922714263763,1,(PID 59773) exited with exit code 1

 425910 <10.102.31.213(13467)postgres597742016-04-19 08:32:59 GMTprocess_journal%LOG:  starting logical decoding for slot "bdr_16386_6275135922714263763_1_16386__"

 425911 <10.102.31.213(13467)postgres597742016-04-19 08:32:59 GMTprocess_journal%DETAIL:  streaming transactions committing after 0/1014CEE8, reading WAL from 0/1014A920

 425912 <10.102.31.213(13467)postgres597742016-04-19 08:32:59 GMTprocess_journal%LOG:  logical decoding found consistent point at 0/1014A920

 425913 <10.102.31.213(13467)postgres597742016-04-19 08:32:59 GMTprocess_journal%DETAIL:  There are no running transactions.

 425914 <10.102.31.213(13467)postgres597742016-04-19 08:32:59 GMTprocess_journal%LOG:  unexpected EOF on standby connection

On Tue, Apr 19, 2016 at 10:29 AM, Alvaro Aguayo Garcia-Rada <aaguayo@xxxxxxxxxxxxxxx> wrote:

Hello,

What do you see on each node's log after enablibg interfaces?

Regards,

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

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

Sent from my Sony Xperia™ smartphone

---- Nikhil wrote ----

Hello,

I have a 2 node BDR group and replication is happening properly. if i bring down one of the node's interface, after sometime the replication slots are becoming inactive (pg_replication_slots view). Then if i bring back interface slots are not turning active automatically and replication stops. Any idea why automatically its not re-established ?

Best Regards,

Nikhil