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

[Pablo Sanchez]

[ 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