[pgpool-hackers: 1413] Item #11, torward pgpool-II 3.6

[Tatsuo Ishii]

Hi,

I'm working on the item #11:

http://pgpool.net/mediawiki/index.php/pgpool-II_3.6_development

Currently pgpool-II kills all child process when fail over (or switch
over by pcp_detach_node) happens. Of course this leads to
disconnecting of all existing client connections because the peer
process which client is connecting is gone. The item #11 is trying to
mitigate the problem.

The reason why we need to kill child process was explained in long
time ago (see attached mails).

Basically the problem is retrying in TCP/IP stack layer when the
connection goes wrong by, for example, the network cable is pulled
out.

If this is not a problem, pgpool-II just closes the connection to
broken backend and can continue its work if the particular connection
is not used in the session, instead of process exiting (if the backend
is used by the current session, the pgpool process needs to exit of
course).

Any idea how to deal with this?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
-------------- next part --------------
An embedded message was scrubbed...
From: Maxence DUNNEWIND <maxence at dunnewind.net>
Subject: [Pgpool-general] TCP connections are *not* closed when a backend
	timeout
Date: Fri, 11 Jul 2008 11:34:37 +0200
Size: 5870
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20160219/9de05541/attachment.mht>
-------------- next part --------------
An embedded message was scrubbed...
From: Tatsuo Ishii <ishii at sraoss.co.jp>
Subject: Re: [Pgpool-general] TCP connections are *not* closed when a
 backend timeout
Date: Sun, 13 Jul 2008 09:41:51 +0900 (JST)
Size: 7689
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20160219/9de05541/attachment-0001.mht>
-------------- next part --------------
An embedded message was scrubbed...
From: Maxence DUNNEWIND <maxence at dunnewind.net>
Subject: Re: [Pgpool-general] TCP connections are *not* closed when a backend timeout
Date: Sun, 13 Jul 2008 11:37:37 +0200
Size: 5760
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20160219/9de05541/attachment-0002.mht>
-------------- next part --------------
An embedded message was scrubbed...
From: Maxence DUNNEWIND <maxence at dunnewind.net>
Subject: Re: [Pgpool-general] TCP connections are *not* closed when a backend timeout
Date: Tue, 15 Jul 2008 10:37:43 +0200
Size: 6694
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20160219/9de05541/attachment-0003.mht>