[pgpool-general: 3403] Re: v3.4.0.(3)? - memory issue and connection hangs
Tatsuo Ishii
ishii at postgresql.org
Mon Jan 5 10:42:12 JST 2015
> 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
>
More information about the pgpool-general
mailing list