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

[Yugo Nagata]

Hi Pablo,

> Connection]: WARNING:  failed to execute ping, '/bin/ping' exited abnormally

> Connection]: DETAIL:  system() command failed with error "No child 
> processes"

The cause of these errors would be SIGCHLD handler. 
This is set to SIG_IGN always.
http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=2f99ccc125a730c0bcbd0258cd5d700d467ac537

I attached a patch. Could you please try it?

On Mon, 05 Jan 2015 08:27:19 -0500
Pablo Sanchez <pablo at blueoakdb.com> wrote:

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


-- 
Yugo Nagata <nagata at sraoss.co.jp>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: wd_if.patch
Type: text/x-diff
Size: 1289 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20150106/784edcb4/attachment.bin>