Home > mailing lists

BDR to ignore table exists error - Mailing list pgsql-general

From	Nikhil
Subject	BDR to ignore table exists error
Date	May 27, 2016 12:34:05
Msg-id	CALo-6YMwgtZkPHAoKKhZW-hKu1W_JzBVbXfWsO4+DbP=KiejSA@mail.gmail.com Whole thread Raw
Responses	Re: BDR to ignore table exists error
List	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

<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

From: Andreas Joseph Krogh
Date: 26 May 2016, 23:26:37
Subject: Slides for PGCon2016; "FTS is dead ? Long live FTS !"

From: Thomas Kellerer
Date: 27 May 2016, 16:25:54
Subject: 9.6beta, parallel execution and cpu_tuple_cost