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

[Tatsuo Ishii]

> [ Comments below, in-line ]
> 
> On 01/04/2015 08:42 PM, Tatsuo Ishii wrote:
>> 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.
> 
> Hi Tatsuo,
> 
> The connection test now works after using /V3_4_STABLE/  Thank you!
> 
> The patch previously provided wouldn't apply so I inspected /child.c/
> and I see the patch had been applied.

I would like to make sure.  Your enormous memory leak problem was
solved by using 3.4-stable tree *without* my patch?

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> I did see a couple of things in /pgpool.log/ that I hadn't seen before
> with 3.4.0.  Perhaps these are new messages which can be safely
> ignored and I'm not accustomed to seeing them ...
> 
> First[1], were a couple of /ping/ and /ifconfig up/ messages.  I
> confirmed the VIP did come up so perhaps the messages are spurious.
> 
> Second[2], I see messages about /child process with pid: %d exits with
> status 512/
> 
> Once again, thank you for your assistance.
> 
> [1] - /ping/ and /ifconfig up/ errors
> 
> 2015-01-05 07:23:30 - [No Connection] (pid 2908): [No Connection][No
> Connection]: DETAIL: connecting host=10.201.1.1 port=49778
> 2015-01-05 07:23:30 - [No Connection] (pid 2823): [No Connection][No
> Connection]: WARNING: failed to execute ping, '/bin/ping' exited
> abnormally
> 2015-01-05 07:23:32 - [No Connection] (pid 2823): [No Connection][No
> Connection]: WARNING: failed to execute ping, '/bin/ping' exited
> abnormally
> 2015-01-05 07:23:33 - [No Connection] (pid 2820): [No Connection][No
> Connection]: LOG: watchdog escalation
> 2015-01-05 07:23:33 - [No Connection] (pid 2820): [No Connection][No
> Connection]: DETAIL: escalating to master pgpool
> 2015-01-05 07:23:33 - [No Connection] (pid 2820): [No Connection][No
> Connection]: LOG: watchdog escalation
> 2015-01-05 07:23:33 - [No Connection] (pid 2820): [No Connection][No
> Connection]: DETAIL: clearing all the query cache on shared memory
> 2015-01-05 07:23:33 - [No Connection] (pid 2820): [No Connection][No
> Connection]: LOG: memory cache initialized
> 2015-01-05 07:23:33 - [No Connection] (pid 2820): [No Connection][No
> Connection]: DETAIL: memcache blocks :64
> 2015-01-05 07:23:33 - [No Connection] (pid 2820): [No Connection][No
> Connection]: WARNING: unable to execute command "/bin/rm -fr
> /var/log/pgpool/oiddir/[0-9]*"
> 2015-01-05 07:23:33 - [No Connection] (pid 2820): [No Connection][No
> Connection]: DETAIL: system() command failed with error "No child
> processes"
> 2015-01-05 07:23:33 - [No Connection] (pid 2820): [No Connection][No
> Connection]: WARNING: watchdog escalation command exit abnormally
> 2015-01-05 07:23:34 - [unknown] (pid 2911): netforevote4db: LOG:
> pool_reuse_block: blockid: 0
> 2015-01-05 07:23:34 - [No Connection] (pid 2823): [No Connection][No
> Connection]: WARNING: failed to execute ping, '/bin/ping' exited
> abnormally
> 2015-01-05 07:23:34 - [No Connection] (pid 2823): [No Connection][No
> Connection]: WARNING: watchdog failed to bring up delegate IP,
> 'ifconfig up' failed
> 2015-01-05 07:23:34 - [No Connection] (pid 2820): [No Connection][No
> Connection]: LOG: sending watchdog response
> 
> [2] - child process exits with status 512
> 
> 2015-01-05 07:39:04 - [No Connection] (pid 2816): [No Connection][No
> Connection]: LOG: child process with pid: 2831 exits with status 512
> 2015-01-05 07:39:04 - [No Connection] (pid 2816): [No Connection][No
> Connection]: LOG: fork a new child process with pid: 4503
> 2015-01-05 07:39:04 - [No Connection] (pid 2816): [No Connection][No
> Connection]: LOG: child process with pid: 2915 exits with status 512
> 2015-01-05 07:39:04 - [No Connection] (pid 2816): [No Connection][No
> ...
> 
> --
> Pablo Sanchez - Blueoak Database Engineering, Inc
> Ph:    819.459.1926         Blog:  http://pablo-blog.blueoakdb.com
> iNum:  883.5100.0990.1054
> 
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general