[pgpool-general: 5019] Re: ***SPAM*** Re: New connection to master cannot initiate when slave goes down

[Krzysztof Mościcki]

W dniu 22.09.2016 o 10:26, Piotr Gbyliczek pisze:
>
>
> 		Piotr Gbyliczek
> ------------------------------------------------------------------------
> Solutions Engineer
> ddi. *08454 210444*
> t. *0845 421 0444*
> e. *P.Gbyliczek at node4.co.uk* 	*Newark Office*
> Node4 Ltd, Innovation House,
> Cafferata Way, Newark, NG24 2TN
>
> 	
> Visit www.node4.co.uk <http://www.node4.co.uk>
>
>
> 	
> Visit www.node4.co.uk <http://www.node4.co.uk>
>
> 		
> Visit Node4 on Twitter <http://www.twitter.co.uk/Node4Ltd>
>
> 		
> Visit Node4 on Linkedin <https://www.linkedin.com/company/node4-ltd>
>
> 		
> Visit Node4 on Facebook <http://www.facebook.com/Node4>
>
> 		
>
> Convergence Summit South 2016 - Visit us at Stand 75 
> <http://south.convergencesummit.co.uk>
>
> On Wednesday 21 September 2016 23:12:27 Krzysztof Mościcki wrote:
> > Hello
> >
> > I have problem with initiate new connection to master node through
> > pgpool, when slave node goes down.
> >
> > I have configuration, where is streamin replication mode, and
> > failover_over_backend_error is off. System Ubuntu 14.04, Pgpool 3.5.3
> > version + patch from:
> > http://www.sraoss.jp/pipermail/pgpool-general/2016-July/004884.html,
> > Postgres version 9.4.
> >
> > I tested this on Google Cloud, when are 3 servers:
> >
> > 1. Postgres master + Pgpool (ip: 10.1.0.19),
> >
> > 2. Postgres slave + Pgpool (ip: 10.1.0.23),
> >
> > 3. Pgpool
> >
> > On second server I run "ifdown eth0", and current connections works, but
> > I can't initiate new connection.
>
> So, if I understand correctly, you are shutting down the network 
> interface on
> server 2 and from that point that server has problem connecting to 
> postgresql
> via pgpool ? Would that be because that server is running active 
> pgpool and
> you connecting locally to it, which means on simulated downtime it has 
> lost
> connection to primary database in pool (which sits on server 1, right )?
>
> Regards
> Piotr
>
I simulate problem with connection to server nr 2, so Postgres slave and 
second Pgpool are down, and I'm trying connection from another (my) 
computer through Pgpool on server nr 1 (and eventually through Pgpool on 
server nr 3, but is the same as through Pgpoolo on server nr 1).
When server 2 goes down (no connection to this server), Pgpool on server 
1 should redirect my connections to Postgres master on the same server 
nr 1. Current connections are working, but if I want initiate new 
connection through Pgpool on server nr 1, I'm waiting long time without 
effect, so I can't create new connection, only I can use current 
connections.
I hope now is clear, I wrote previous mail at night :)

Regards
Kris
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160922/96695028/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 1315 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160922/96695028/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 19451 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160922/96695028/attachment-0007.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 17391 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160922/96695028/attachment-0008.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 16233 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160922/96695028/attachment-0009.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 16168 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160922/96695028/attachment-0010.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 16076 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160922/96695028/attachment-0011.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 18993 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160922/96695028/attachment-0001.gif>