<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
I was not expecting that behavior from PgPool. I was under the impression that a failover would not occur unless the primary/master server had issues.
<div class=""><br class="">
<div>
<blockquote type="cite" class="">
<div class="">On Jan 11, 2017, at 3:32 AM, Muhammad Usama <<a href="mailto:m.usama@gmail.com" class="">m.usama@gmail.com</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">Hi</span>
<div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<br class="">
It seems like there was a temporary network glitch/failure between the two data centers around "Jan 05 00:04:29" time triggered the failover of backend node0.<br class="">
<br class="">
</div>
<div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
If we look at the logs of each node around this time we can see that the Pgpool-II nodes in the first data center (dbserver1 and dbserver2) were not able to connect to PostgreSQL on dbserver3 that is located in the second data center, and at the very same time
the Pgpool-II on dbserver3 was also having the connection problem with PostgreSQL located on the first data center on dbserver1. All this points towards the connectivity issue between the two data centers.<br class="">
<br class="">
Also, apparently the network issue seems to have resolved after a couple of minutes, but till that time the PostgreSQL node failure was already registered by Pgpool-II on dbserver3 and the failover was triggered.
<div class=""><br class="">
</div>
<div class="">Thanks</div>
<div class="">Best regards</div>
<div class="">Muhammad Usama</div>
</div>
</div>
</blockquote>
</div>
<br class="">
</div>
</body>
</html>