From: | Kyotaro HORIGUCHI <kyota(dot)horiguchi(at)gmail(dot)com> |
---|---|
To: | Dang Minh Huong <kakalot49(at)gmail(dot)com> |
Cc: | Amit Kapila <amit(dot)kapila(at)huawei(dot)com>, "<pgsql-hackers(at)postgresql(dot)org>" <pgsql-hackers(at)postgresql(dot)org>, "<pgsql-bugs(at)postgresql(dot)org>" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: replication_timeout not effective |
Date: | 2013-04-10 13:38:07 |
Message-ID: | CAM103DuLWwRPXXfpn-6HzXnGOfOuA04gQoRt8EW28m8bpy8Crg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
Hello,
On Wed, Apr 10, 2013 at 6:57 PM, Dang Minh Huong <kakalot49(at)gmail(dot)com> wrote:
> In 9.3, it sounds replication_timeout is replaced by wal_sender_timeout.
> So if it is solved in 9.3 i think there is a way to terminate it.
> I hope it is fixed in 9.1 soon
Hmm. He said that,
> But in my environment the sender process is hang up (in several tens of minunites) if i turn off (by power off) Standby PC while *pg_basebackup* is excuting.
Does basebackup run only on 'replication connection' ?
As far as I saw base backup uses 'base backup' connection in addition
to 'streaming' connection. The former seems not under the control of
wal_sender_timeout or replication_timeout and easily blocked at
send(2) after sudden cut out of the network connection underneath.
Although the latter indeed is terminated by them.
Blocking in send(2) might could occur for async-rep connection but not
likely for sync-rep since it does not fill the buffers of libpq and
socket easilly.
I suppose he says about this.
This seems to occur as of the latest 9.3dev.
regards,
--
Kyotaro Horiguchi
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2013-04-10 13:55:15 | Re: replication_timeout not effective |
Previous Message | Dickson S. Guedes | 2013-04-10 11:19:45 | Re: BUG #8056: postgres forgets hstore over time |
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2013-04-10 13:55:15 | Re: replication_timeout not effective |
Previous Message | Amit Kapila | 2013-04-10 12:03:23 | Re: Inconsistent DB data in Streaming Replication |