[pgpool-general: 3401] Re: v3.4.0.(3)? - memory issue and connection hangs

[Pablo Sanchez]

[ Comments below, in-line ]

On 01/02/2015 10:43 PM, Tatsuo Ishii wrote:
> I think I have identified the problem. pgpool-II 3.4.x seems to forget
> to close connections to clients if connection_cache is on. This causes
> CLOSE_WAIT flood. Included is a patch trying to fix the problem. Could
> you please try it out?

Hi Tatsuo,

I applied the patch against my clone'd Master copy.  I compiled and 
installed PGPool and unfortunately, there seems to be an issue bringing 
up the VIP (ens224:0) [1].

I believe I've followed the proper process:

o As a regular user ...
- git clone
- git apply ~/tmp/child.c.patch # applied without errors
- ./configure --prefix=/usr --with-pgsql=/usr/pgsql-9.3
- make -j

o As root ...
- service pgpool stop # the current version
- make install

Please let me know.

Thank you!

::: [1] - pgpool.log :::

2015-01-04 12:15:17 - [No Connection] (pid 10184): [No Connection][No 
Connection]: DETAIL:  memcache blocks :64
2015-01-04 12:15:17 - [No Connection] (pid 10184): [No Connection][No 
Connection]: WARNING:  unable to execute command "/bin/rm -fr 
/var/log/pgpool/oiddir/[0-9]*"
2015-01-04 12:15:17 - [No Connection] (pid 10184): [No Connection][No 
Connection]: DETAIL:  system() command failed with error "No child 
processes"
2015-01-04 12:15:17 - [No Connection] (pid 10184): [No Connection][No 
Connection]: WARNING:  watchdog escalation command exit abnormally
SIOCSIFADDR: Operation not permitted
SIOCSIFFLAGS: Operation not permitted
SIOCSIFNETMASK: Operation not permitted
2015-01-04 12:15:17 - [No Connection] (pid 10184): [No Connection][No 
Connection]: WARNING:  watchdog failed to bring up delegate IP, 
'if_up_cmd' failed
Sun Jan  4 12:15:17 EST 2015 - Waiting for ens224:0 ...
2015-01-04 12:15:18 - [No Connection] (pid 10187): [No Connection][No 
Connection]: LOG:  checking pgpool status by heartbeat
2015-01-04 12:15:18 - [No Connection] (pid 10187): [No Connection][No 
Connection]: DETAIL:  pgpool: 1 at "10.201.3.1:5432" status is down
Sun Jan  4 12:15:18 EST 2015 - Waiting for ens224:0 ...
2015-01-04 12:15:18 - [No Connection] (pid 10184): [No Connection][No 
Connection]: LOG:  sending watchdog response
2015-01-04 12:15:18 - [No Connection] (pid 10184): [No Connection][No 
Connection]: DETAIL:  receive add request from 10.201.3.1:5432 and accept it
Sun Jan  4 12:15:19 EST 2015 - Waiting for ens224:0 ...
Sun Jan  4 12:15:20 EST 2015 - Waiting for ens224:0 ...
Sun Jan  4 12:15:20 EST 2015 - Waiting for ens224:0 ...
Sun Jan  4 12:15:21 EST 2015 - Waiting for ens224:0 ...
Sun Jan  4 12:15:22 EST 2015 - Waiting for ens224:0 ...
Sun Jan  4 12:15:23 EST 2015 - Waiting for ens224:0 ...
Sun Jan  4 12:15:24 EST 2015 - Waiting for ens224:0 ...

--
Pablo Sanchez - Blueoak Database Engineering, Inc
Ph:    819.459.1926         Blog:  http://pablo-blog.blueoakdb.com
iNum:  883.5100.0990.1054