<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
tt
{mso-style-priority:99;
font-family:"Courier New";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EstiloCorreo19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EstiloCorreo20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EstiloCorreo21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1212307877;
mso-list-type:hybrid;
mso-list-template-ids:1033404902 1555432610 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F06E;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;
mso-fareast-font-family:Calibri;
mso-bidi-font-family:"Times New Roman";}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l1
{mso-list-id:1243370402;
mso-list-type:hybrid;
mso-list-template-ids:-241244600 67698705 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l1:level1
{mso-level-text:"%1\)";
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l1:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l1:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=ES link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D;mso-fareast-language:EN-US'>Is </span><tt><span style='font-size:10.0pt'>fail_over_on_backend_error on or off?<o:p></o:p></span></tt></p><p class=MsoNormal><tt><span style='font-size:10.0pt'><o:p> </o:p></span></tt></p><p class=MsoNormal><tt><span style='font-size:10.0pt'>Try with off?<o:p></o:p></span></tt></p><p class=MsoNormal><tt><span style='font-size:10.0pt'><o:p> </o:p></span></tt></p><p class=MsoNormal><tt><span style='font-size:10.0pt'>Regards.</span></tt><span style='color:#1F497D;mso-fareast-language:EN-US'><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b>De:</b> pgpool-general-bounces@pgpool.net [mailto:pgpool-general-bounces@pgpool.net] <b>En nombre de </b>David Sisk -X (dsisk - TEKSYSTEMS INC at Cisco)<br><b>Enviado el:</b> viernes, 10 de febrero de 2017 05:00 p. m.<br><b>Para:</b> pgpool-general@pgpool.net<br><b>Asunto:</b> [pgpool-general: 5325] Re: URGENT: Split-brain scenario...how to prevent?<br><b>Importancia:</b> Alta<o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><a name="_MailEndCompose"><span lang=EN-US style='color:#1F497D'>Can anyone provide any insight into how to prevent this split brain scenario from happening? Any responses appreciated.<o:p></o:p></span></a></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Thanks and regards,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Dave Sisk<o:p></o:p></span></p><div><p class=MsoNormal><span lang=EN-GB style='font-size:12.0pt;font-family:"Times New Roman","serif";color:#1F497D'><o:p> </o:p></span></p><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=400 style='width:300.0pt'><tr><td style='padding:0cm 15.0pt 0cm 18.0pt'><p class=MsoNormal><span style='font-size:7.5pt;font-family:"Arial","sans-serif";color:#009900'><o:p> </o:p></span></p></td></tr><tr><td style='padding:0cm 15.0pt 0cm 18.0pt'><p class=MsoNormal><span style='font-size:7.5pt;font-family:"Arial","sans-serif";color:#999999'><o:p> </o:p></span></p></td></tr></table></div><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US>From:</span></b><span lang=EN-US> <a href="mailto:pgpool-general-bounces@pgpool.net">pgpool-general-bounces@pgpool.net</a> [<a href="mailto:pgpool-general-bounces@pgpool.net">mailto:pgpool-general-bounces@pgpool.net</a>] <b>On Behalf Of </b>David Sisk -X (dsisk - TEKSYSTEMS INC at Cisco)<br><b>Sent:</b> Thursday, February 9, 2017 2:38 PM<br><b>To:</b> <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br><b>Subject:</b> [pgpool-general: 5321] URGENT: Split-brain scenario...how to prevent?<o:p></o:p></span></p></div></div><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>Hi folks…PGPool 3.5.4 with Postgres 9.3, streaming replication mode with primary and one standby. I found a scenario that caused a split-brain (luckily, it’s in a lab environment instead of a prod environment).<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l1 level1 lfo2'><![if !supportLists]><span lang=EN-US><span style='mso-list:Ignore'>1)<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span lang=EN-US>Auto-failover occurred, original standby is now primary.<o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l1 level1 lfo2'><![if !supportLists]><span lang=EN-US><span style='mso-list:Ignore'>2)<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span lang=EN-US>Prior primary/eminent standby at status 3 NOT reset/sync’d in any way yet (not replicating and not in standby mode).<o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l1 level1 lfo2'><![if !supportLists]><span lang=EN-US><span style='mso-list:Ignore'>3)<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span lang=EN-US>pcp_attach_node 0 not only attaches the faulty standby, it actually promotes the faulty standby back to primary! :-0<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>What configuration parameters will prevent this from happening? I’d prefer to get an error from pcp_attach_node and/or have the node stay at status 3.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>Here are the health checks I have defined:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>health_check_period = 10# NON-DEFAULT<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>health_check_timeout = 20<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>health_check_user = 'postgres' # NON-DEFAULT<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>health_check_password = 'postgres' # NON-DEFAULT<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>health_check_database = ''<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>health_check_max_retries = 2# NON-DEFAULT<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>health_check_retry_delay = 10# NON-DEFAULT<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo4'><![if !supportLists]><span lang=EN-US style='font-family:Wingdings'><span style='mso-list:Ignore'>n<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span lang=EN-US>Not sure if this is used for load-balancing only, or also used to manage node status<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>sr_check_period = 10<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>sr_check_user = 'postgres' # NON-DEFAULT<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>sr_check_password = 'postgres' # NON-DEFAULT<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>sr_check_database = 'postgres'<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>delay_threshold = 100000# NON-DEFAULT<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=543 style='width:407.25pt'><tr><td colspan=3 style='padding:0cm 0cm 0cm 0cm'><p class=MsoNormal><img border=0 width=543 height=70 id="Picture_x0020_1" src="cid:image001.png@01D283C3.9F90E420" alt=banner2><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p></td></tr><tr style='height:7.5pt'><td style='padding:0cm 0cm 0cm 0cm;height:7.5pt'><p class=MsoNormal><span style='font-size:1.0pt;font-family:"Times New Roman","serif"'> <o:p></o:p></span></p></td><td style='padding:0cm 0cm 0cm 0cm;height:7.5pt'></td><td style='padding:0cm 0cm 0cm 0cm;height:7.5pt'></td></tr><tr><td nowrap valign=top style='padding:0cm 0cm 0cm 18.0pt'><p class=MsoNormal><b><span style='font-size:8.5pt;font-family:"Arial","sans-serif";color:#666666'>David Sisk</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif";color:#666666'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:8.5pt;font-family:"Arial","sans-serif";color:#666666'>Engineer - Software<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:8.5pt;font-family:"Arial","sans-serif";color:#666666'><a href="mailto:dsisk@cisco.com"><span style='color:#666666;text-decoration:none'>dsisk@cisco.com</span></a></span><o:p></o:p></p><p class=MsoNormal><span style='font-size:8.5pt;font-family:"Arial","sans-serif";color:#666666'>Tel: <o:p></o:p></span></p></td><td width=275 valign=top style='width:206.25pt;padding:0cm 0cm 0cm 15.0pt'><p class=MsoNormal><b><span style='font-size:8.5pt;font-family:"Arial","sans-serif";color:#666666'>Cisco Systems, Inc.<o:p></o:p></span></b></p><p class=MsoNormal><span style='font-size:8.5pt;font-family:"Arial","sans-serif";color:#666666'>7025-6 Kit Creek Road PO Box 14987<br>RESEARCH TRIANGLE PARK<br>27709-4987<br>United States<br>cisco.com<o:p></o:p></span></p></td><td style='padding:0cm 0cm 0cm 0cm'></td></tr></table><p class=MsoNormal><span lang=EN-GB style='font-size:12.0pt;font-family:"Times New Roman","serif";display:none'><o:p> </o:p></span></p><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=400 style='width:300.0pt'><tr><td style='padding:0cm 15.0pt 0cm 18.0pt'><p class=MsoNormal><span style='font-size:7.5pt;font-family:"Arial","sans-serif";color:#009900'><img border=0 width=18 height=19 id="Picture_x0020_3" src="cid:image002.gif@01D283C3.9F90E420" alt="http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif">Think before you print.<o:p></o:p></span></p></td></tr><tr><td style='padding:0cm 15.0pt 0cm 18.0pt'><p class=MsoNormal><span style='font-size:7.5pt;font-family:"Arial","sans-serif";color:#999999'>This email may contain confidential and privileged material for the sole use of the intended recipient. Any review, use, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender by reply email and delete all copies of this message.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:7.5pt;font-family:"Arial","sans-serif";color:#999999'>Please <a href="http://www.cisco.com/web/about/doing_business/legal/cri/index.html" title="Legal Information"><span style='color:#0E58A0'>click here</span></a> for Company Registration Information.<o:p></o:p></span></p></td></tr></table><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p></div></body></html>