Skip site navigation (1) Skip section navigation (2)

Re: BUG #7534: walreceiver takes long time to detect n/w breakdown

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: amit(dot)kapila(at)huawei(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #7534: walreceiver takes long time to detect n/w breakdown
Date: 2012-09-12 16:41:44
Message-ID: CABUevEwBneuOdTcBhZDa84=bO63m+th4OLSAQbiiDQw0=2jf_g@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
On Wed, Sep 12, 2012 at 1:54 PM,  <amit(dot)kapila(at)huawei(dot)com> wrote:
> The following bug has been logged on the website:
>
> Bug reference:      7534
> Logged by:          Amit Kapila
> Email address:      amit(dot)kapila(at)huawei(dot)com
> PostgreSQL version: 9.2.0
> Operating system:   Suse 10
> Description:
>
> 1. Both master and standby machine are connected normally,
> 2. then you use the command: ifconfig ip down; make the network card of
> master and standby down,
>
> Observation
> master can detect connect abnormal, but the standby can't detect connect
> abnormal and show a connected channel long time.

The master will detect it quicker, because it will get an error when
it tries to send something.

But the standby should detect it either when sending the feedback
message (what's your wal_receiver_status_interval set to?) or when
ythe kernel does (have you configured the tcp keepalive on the slave
somehow?)

Oh, and what do you actually mean by "long time"?


-- 
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/


In response to

Responses

pgsql-hackers by date

Next:From: Fujii MasaoDate: 2012-09-12 16:45:05
Subject: Re: BUG #7534: walreceiver takes long time to detect n/w breakdown
Previous:From: Andrew DunstanDate: 2012-09-12 15:57:06
Subject: docs bug

pgsql-bugs by date

Next:From: Fujii MasaoDate: 2012-09-12 16:45:05
Subject: Re: BUG #7534: walreceiver takes long time to detect n/w breakdown
Previous:From: ldmDate: 2012-09-12 14:25:30
Subject: BUG #7535: ERROR: variable not found in subplan target list

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group