[pgpool-general: 4786] Re: listen backlog overflowing

[Travis Kirstine]

-----Original Message-----
From: Tatsuo Ishii [mailto:ishii at postgresql.org] 
Sent: July-12-16 6:56 PM
To: Travis Kirstine <tkirstine at firstbasesolutions.com>
Cc: pgpool-general at pgpool.net
Subject: Re: [pgpool-general: 4782] listen backlog overflowing

> What can cause the backlog to overflow?

Have you actually seen something like this?

535 times the listen queue of a socket overflowed

Yes, I get the message


> I've increased the somaxconn and max_backlog  sysctl parameters.
> 
> net.core.somaxconn = 16384
> net.core.netdev_max_backlog = 16384
> 
> pgpool  conf
> 
> listen_backlog_multiplier = 5
> num_init_children = 40
> max_pool = 5
> child_life_time = 300
> child_max_connections = 0
> connection_life_time = 0
> client_idle_limit = 600
> 
> Any ideas would be great!!!

If so, strange... is the server dedicated for pgpool-II? or do you have another software running on the same server which could use the listen queue?


No the server is not dedicated to pgpool only, postgresql is running on it as well.



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