[pgpool-general: 6162] Re: Fwd: repeat the check of the trusted servers

[Piotr Gbyliczek]

Hi, 

Sorry for reviving old thread, but I've recently gone up to 3.6.7 and observed 
same behavior. 

As I understand it, trusted_servers is a mechanism that should prevent standby 
pgpool service to bring up the delegated IP, and cause split brain where there 
is a network partition between pgpool servers. 

But struggling to see why standby that is able to communicate with it's master 
over watchdog channel would declare itself dead upon failing to contact 
trusted_servers. 

In fact I've had two scenarios : 
 - standby pgpool declared itself dead on failing to contact trusted server, 
which was discovered when master pgpool was manually stopped and there was no 
standby to fall back to.
- master declared itself dead on failing to contact trusted server, which 
initiated failover procedure and standby picked up the master role, bringing 
up the delegated IP. this is correct behavior in general, but have been 
noticed by customers and monitoring, hence some question have been raised. 

I would say both could be avoided, and were unnecessary downtime for the 
delegated IP. 

Was there any conclusion to this issue, or design explanation to the behavior 
? 

Thanks, 
Piotr
--

Piotr Gbyliczek
Solutions Engineer

Node4 Ltd, The POD, 10 Bottle Ln, Nottingham NG1 2HL
ddi. 08454 210444 | t. 0845 123 2222
e. P.Gbyliczek at node4.co.uk



Node4 Limited is registered in England No: 04759927 and has its registered office at Millennium Way, Pride Park, Derby, DE24 8HZ
The information contained in this email is confidential and is intended for the exclusive use of the email addressee shown.
If you are not the addressee, any disclosure, reproduction, distribution or other dissemination or use of this communication is strictly prohibited.
If you have received this mail in error, please notify our mail manager at abuse at node4.co.uk and delete it from your system.
Opinions expressed in this email are those of the individual not the company, unless specifically indicated to that effect.

This email has been scanned inbound by Node4's Email Security System.

This email message has been delivered safely and archived online by Mimecast.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180723/160bea15/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 118072315553502789.jpg
Type: image/jpeg
Size: 10120 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180723/160bea15/attachment-0002.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 118072315553502989.png
Type: image/png
Size: 1315 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180723/160bea15/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 118072315553503189.png
Type: image/png
Size: 16076 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180723/160bea15/attachment-0007.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 118072315553503389.png
Type: image/png
Size: 19451 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180723/160bea15/attachment-0008.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 118072315553503589.png
Type: image/png
Size: 16233 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180723/160bea15/attachment-0009.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 118072315553503789.png
Type: image/png
Size: 16168 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180723/160bea15/attachment-0010.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 118072315553503989.png
Type: image/png
Size: 17391 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180723/160bea15/attachment-0011.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 118072315553504189.jpg
Type: image/jpeg
Size: 10763 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180723/160bea15/attachment-0003.jpg>