[pgpool-general: 5560] Re: Pgpool stops handling connections

[Pierre Timmermans]

Thomas
Maybe you simply need to increase the value of num_init_children. Once the pool is full, i.e. once there are num_init_children active connections, then the next connection attempt will hang until a connection is free. So it will be exactly like the behavior you are seing.
You can do a select from pg_stat_activity (connect directly to postgres, not to pgpool, otherwise you will be queued): it the number of rows is equal to num_init_children then for sure you are hitting this limit
Pierre


On Tuesday, June 6, 2017, 4:01:43 PM GMT+2, Thomas Höll <Thomas.Hoell at neos-it.de> wrote:

 Hi all,
we're having a streaming replication setup as backend for one of our client's application we're hosting.The backend consists of two virtual machines (Fedora Server 25) running PostgreSQL 9.6 and Pgpool 3.6.4 (this also happened with previous Pgpool versions).
Those machines are configured for streaming replication in master/slave mode. The Postgres-Instances are running fine, but Pgpool is giving us troubles.
After some time, Pgpool stops accepting connections. They are not rejected, the application trying to connect simply hangs. I have to stop the corresponding Pgpool-Instanceand the other takes over. The stopping itself takes forever. After some time, systemd simply kills the processes and I have to manually delete the leftover sockets.
I have absolutely no idea what's causing this. The Postgres-Instances are configured to accept up to 1000 connections, which should not be the problem.
About the application accessing the database:
There are multiple instances, each using a separate database. The application uses Activiti, which DOES NOT pool connections. So we're having a pretty high amount ofconnections per second. The problem mostly occurs during peak hours, so load is most likely a factor. 
I've tried plaing around with num_init_children and max_pool. Increasing max_pool and lowering num_init_children made things a lot worse.
Also, Pgpool still accepts pool join requests from other Pgpool instances, it's just that database connections aren't handled anymore.
You can find my pgpool.conf here: https://pastebin.com/4ee2bhhf
Regards,Thomas
-- 

NeosIT GmbH
 
Wir schaffen IT, die die Welt ein Stück einfacher macht.
 
  
 
Schachtweg 1
 
38440 Wolfsburg
 
  
 
Tel. +49 5361 83494-23
 
Fax +49 5361 83494-94

mailto:thomas.hoell at neos-it.de
 
http://www.neos-it.de/
 
http://www.facebook.com/neositgmbh
 
  
 
Handelsregister: Amtsgericht Braunschweig, HRB 203557
 
Geschäftsführer: Sebastian Schier
_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net
http://www.pgpool.net/mailman/listinfo/pgpool-general
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170606/46a25826/attachment-0001.html>