[pgpool-general: 6344] Re: Pgpool is not accepting any new connections

[Pierre Timmermans]

What is in the log of the pgpool on server B ? You should see in the log of pgpool on node B a lot of information, normally the watchdog detects that the primary pgpool is lost, then it logs about the new consensus and the election of a new leader. If the node B takes over the primary role, you will see that the VIP is acquired by node B,...Also because the primary postgres was also lost, in the log of on node B you should also see that the promotion of the standby database (on node B) to primary was done.

Maybe you can try the pcp_watchdog_info utility on the pgpool of server B, if it does not respond than indeed pgpool B might be stuck..
Maybe you can post the log of the pgpool B at the time you shutted down the server A ?

Pierre 

    On Thursday, December 13, 2018, 8:08:01 PM GMT+1, Juan Carlos Michaca <jcmichaca at vinkos.com> wrote:  
 
 Hi Pierre;
Thanks for your reply.
Currently I have just 2 connections in  pg_stat_activity, and num_init_children is set to 32 in pgpool.conf.
I set num_init_children to 50 and problem persists, I should restart pgpool force it to accept connections.
I share my pgpool.conf

Regards.



On Thu, Dec 13, 2018 at 8:33 AM Pierre Timmermans <ptim007 at yahoo.com> wrote:

Hi 

The most common reason for that is when the parameter num_init_children is too low: when there are more connections to postgres than num_init_children then pgpool does not give an error but it refuses (or it queues it maybe) without giving an error.
So count the number of connection (from pg_stat_activity) and if it is equal to num_init_children then you have the answer...

Pierre 

    On Thursday, December 13, 2018, 2:13:52 AM GMT+1, Juan Carlos Michaca <jcmichaca at vinkos.com> wrote:  
 
 
Hi all,


I am testing pgpool in this scenario


Pgpool A(Master) + PG Backend A (primary)

Pgpool B(Standby) + PG Backend B (replica with streaming replication)


At this point I'm able to run queries to pgpool from any address in my network.





If I shut down Pgpool A(Master) and its PG Backend (primary), Pgpool B(now master) is not accepting any connections until I restart it. 




After restarting Pgpool B(now master) I can connect to pgpool from any host and run queries.


Please, can you help to figure out what's could be wrong?


Regards
_______________________________________________
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/20181213/bde40ea8/attachment.html>