BDR to ignore table exists error

From: Nikhil <nikhilsmenon(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: BDR to ignore table exists error
Date: 2016-05-27 09:33:36
Message-ID: CALo-6YMwgtZkPHAoKKhZW-hKu1W_JzBVbXfWsO4+DbP=KiejSA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have a BDR setup with two nodes. If I bring one node down i am seeing that
the replication slot is becoming inactive with below error.

<10.106.43.152(43253)nsxpostgres798452016-05-25 23:58:19 GMTnsxdb%DETAIL:
streaming transactions committing after 0/111A91
48, reading WAL from 0/110F03F8
<10.106.43.152(43253)nsxpostgres798452016-05-25 23:58:19 GMTnsxdb%LOG:
logical decoding found consistent point at 0/110F03
F8
<10.106.43.152(43253)nsxpostgres798452016-05-25 23:58:19 GMTnsxdb%DETAIL:
Logical decoding will begin using saved snapshot
.
<10.106.43.152(43253)nsxpostgres798452016-05-25 23:58:19 GMTnsxdb%LOG:
unexpected EOF on standby connection
<127.0.0.1(31185)nsxroot792492016-05-25 23:58:19 GMTnsxdb%LOG: duration:
0.437 ms
<127.0.0.1(31185)nsxroot792492016-05-25 23:58:19 GMTnsxdb%LOG: duration:
0.462 ms
<127.0.0.1(31185)nsxroot792492016-05-25 23:58:19 GMTnsxdb%LOG: duration:
0.096 ms
<127.0.0.1(31185)nsxroot792492016-05-25 23:58:19 GMTnsxdb%LOG: duration:
0.101 ms
<3462016-05-25 23:58:20 GMT%LOG: starting background worker process "bdr
(6288505144157102317,1,16384,)->bdr (628851211361
7339435,2,"
<798462016-05-25 23:58:20 GMT%ERROR: relation "af_npx_device_l3_16_149_10"
already exists

Thanks & Regards,
Nikhil

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2016-05-27 13:25:27 9.6beta, parallel execution and cpu_tuple_cost
Previous Message Andreas Joseph Krogh 2016-05-26 20:26:31 Slides for PGCon2016; "FTS is dead ? Long live FTS !"