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

[Tatsuo Ishii]

> 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

You should type:
git checkout V3_4_STABLE

git master is for 3.5 development. I don't know if the cause of your
error is this or not. I will invest the error you have any way.

> - 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
>