<div dir="ltr">Hi Tatsuo,<div><br></div><div>I am following up on a customer enquiry in pgpool failover mechanism. If you are running a pgpool master/slave environment and the clients are connected to the master node, the slave goes down due to any odd reason, the failover process is initiated and the client are not able to execute queries on master until the failover is completed. </div>
<div><br></div><div>I understand that this is done by design. Do you know the reasoning behind this behaviour? </div><div><br></div><div>-- Ahsan <br><br><div class="gmail_quote">---------- Forwarded message ----------<br>
From: <b class="gmail_sendername">Ahsan Hadi</b> <span dir="ltr"><<a href="mailto:ahsan.hadi@enterprisedb.com">ahsan.hadi@enterprisedb.com</a>></span><br>Date: Mon, Nov 11, 2013 at 7:06 PM<br>Subject: Re: Issue: about redundancy of pgpool-II, Ticket# 15058-20802, Customer: SIOS Engineers, Account: SIOS Technology,Inc.<br>
To: Sivananda Reddy <<a href="mailto:sivananda.reddy@enterprisedb.com">sivananda.reddy@enterprisedb.com</a>><br>Cc: Arshu Arora <<a href="mailto:arshu.arora@enterprisedb.com">arshu.arora@enterprisedb.com</a>>, Yuji Fujita <<a href="mailto:yuji.fujita@enterprisedb.com">yuji.fujita@enterprisedb.com</a>>, Tom Kincaid <<a href="mailto:tom.kincaid@enterprisedb.com">tom.kincaid@enterprisedb.com</a>>, Deepanshu Sharma <<a href="mailto:deepanshu.sharma@enterprisedb.com">deepanshu.sharma@enterprisedb.com</a>>, Katsuji Takatsuru <<a href="mailto:katsuji.takatsuru@enterprisedb.com">katsuji.takatsuru@enterprisedb.com</a>>, Naveed Shaikh <<a href="mailto:naveed.shaikh@enterprisedb.com">naveed.shaikh@enterprisedb.com</a>>, Baji Shaik <<a href="mailto:baji.shaik@enterprisedb.com">baji.shaik@enterprisedb.com</a>>, Asif Naeem <<a href="mailto:asif.naeem@enterprisedb.com">asif.naeem@enterprisedb.com</a>>, pgpool-escalations <<a href="mailto:pgpool-escalations@enterprisedb.com">pgpool-escalations@enterprisedb.com</a>>, Muhammad Usama <<a href="mailto:muhammad.usama@enterprisedb.com">muhammad.usama@enterprisedb.com</a>>, Team Support <<a href="mailto:teamsupport@enterprisedb.com">teamsupport@enterprisedb.com</a>>, Ibrar Ahmed <<a href="mailto:ibrar.ahmed@enterprisedb.com">ibrar.ahmed@enterprisedb.com</a>><br>
<br><br><div dir="ltr"><br><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Nov 11, 2013 at 10:19 AM, Sivananda Reddy <span dir="ltr"><<a href="mailto:sivananda.reddy@enterprisedb.com" target="_blank">sivananda.reddy@enterprisedb.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi All,<div><br></div><div>We have received below update from the customer. Kindly advise on this.</div>
<div><br></div><div><b>Customer's e-mail:</b></div><div><b>================</b></div><div><br></div>
<div><b>-Quote-</b></div><div><span style="background-color:rgb(254,254,253);color:rgb(29,29,29);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:12px;line-height:16px"><br></span></div><div><span style="background-color:rgb(254,254,253);color:rgb(29,29,29);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:12px;line-height:16px">Hi,</span><br>
</div><div><p style="margin:1em 0px;padding:0px;color:rgb(29,29,29);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:12px;line-height:16px;background-color:rgb(254,254,253)"></p><p style="margin:1em 0px;padding:0px;color:rgb(29,29,29);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:12px;line-height:16px;background-color:rgb(254,254,253)">
Thanks for the comments.</p><p style="margin:1em 0px;padding:0px;color:rgb(29,29,29);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:12px;line-height:16px;background-color:rgb(254,254,253)"></p>
<p style="margin:1em 0px;padding:0px;color:rgb(29,29,29);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:12px;line-height:16px;background-color:rgb(254,254,253)">
Okay, let's make it clarify what are the customer's requests.</p><p style="margin:1em 0px;padding:0px;color:rgb(29,29,29);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:12px;line-height:16px;background-color:rgb(254,254,253)">
</p><p style="margin:1em 0px;padding:0px;color:rgb(29,29,29);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:12px;line-height:16px;background-color:rgb(254,254,253)">We have already talked a lot about two scenarios of master/slave pgpool-II actually, those tickets were mentioned below. Then you can see its detailed information.</p>
<p style="margin:1em 0px;padding:0px;color:rgb(29,29,29);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:12px;line-height:16px;background-color:rgb(254,254,253)"></p><p style="margin:1em 0px;padding:0px;color:rgb(29,29,29);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:12px;line-height:16px;background-color:rgb(254,254,253)">
1. #15058-20802 - pgpool-II active/standby with streaming replication(asynchronous)</p><p style="margin:1em 0px;padding:0px;color:rgb(29,29,29);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:12px;line-height:16px;background-color:rgb(254,254,253)">
2. #15058-34335 - FB id #23381, pgpool-II active/standby with slony-I(asynchronous)</p><p style="margin:1em 0px;padding:0px;color:rgb(29,29,29);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:12px;line-height:16px;background-color:rgb(254,254,253)">
</p><p style="margin:1em 0px;padding:0px;color:rgb(29,29,29);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:12px;line-height:16px;background-color:rgb(254,254,253)">But we think we could consider that a point of these stories has something in common.</p>
<p style="margin:1em 0px;padding:0px;color:rgb(29,29,29);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:12px;line-height:16px;background-color:rgb(254,254,253)">Which should be that the client always should be able to access and use its master db even when its slave has an error or down status. So we could also say that the client should not be affected by slave db error.</p>
<p style="margin:1em 0px;padding:0px;color:rgb(29,29,29);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:12px;line-height:16px;background-color:rgb(254,254,253)"></p><p style="margin:1em 0px;padding:0px;color:rgb(29,29,29);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:12px;line-height:16px;background-color:rgb(254,254,253)">
Here is the customer's requirements and their opinions.</p><p style="margin:1em 0px;padding:0px;color:rgb(29,29,29);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:12px;line-height:16px;background-color:rgb(254,254,253)">
</p><p style="margin:1em 0px;padding:0px;color:rgb(29,29,29);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:12px;line-height:16px;background-color:rgb(254,254,253)">They have a master/slave pgpool-II setup, and the clients are connected to the master (primary) instance. Then when the slave (secondary) instance goes down due to an error, it triggers a failover(failover handler) and all the clients have to wait until the failover handler is done. It looked like current pgpool-II specification for now. However according to the customer's opinion, all the clients should be able to maintain existing connections to the master (primary) instance and also execute sql queries for the master even during the failover handler working. Because this is an asynchronous replication and as the master instance have no problem at that time actually, so the client should be able to use the master database normally at least. This is what the customer is expecting to achieve.</p>
</div></div></blockquote><div><br></div><div>Thanks for the explanation. We are now able to reproduce the behaviour. The clients have to wait until the failover process is completed before they can run any more queries against the master node.</div>
<div><br></div><div>You are right, this is pgpool's documented behaviour. This needs a detailed study before we can say whether it is possible to change this behaviour and if it will require any architectural changes to provide this functionality.</div>
<div><br></div><div>I will also discuss this on pgpool hackers.</div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>
<p style="margin:1em 0px;padding:0px;color:rgb(29,29,29);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:12px;line-height:16px;background-color:rgb(254,254,253)"></p><p style="margin:1em 0px;padding:0px;color:rgb(29,29,29);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:12px;line-height:16px;background-color:rgb(254,254,253)">
(pgpool-II config file)</p><p style="margin:1em 0px;padding:0px;color:rgb(29,29,29);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:12px;line-height:16px;background-color:rgb(254,254,253)">
* Please have a attached file.</p><p style="margin:1em 0px;padding:0px;color:rgb(29,29,29);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:12px;line-height:16px;background-color:rgb(254,254,253)">
- The file name corresponds its issue number.</p><p style="margin:1em 0px;padding:0px;color:rgb(29,29,29);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:12px;line-height:16px;background-color:rgb(254,254,253)">
</p><p style="margin:1em 0px;padding:0px;color:rgb(29,29,29);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:12px;line-height:16px;background-color:rgb(254,254,253)">Regards,</p><p style="margin:1em 0px;padding:0px;color:rgb(29,29,29);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:12px;line-height:16px;background-color:rgb(254,254,253)">
<b>Un-Quote-</b></p></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Nov 7, 2013 at 2:16 PM, Ahsan Hadi <span dir="ltr"><<a href="mailto:ahsan.hadi@enterprisedb.com" target="_blank">ahsan.hadi@enterprisedb.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><br><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Nov 7, 2013 at 1:26 PM, Arshu Arora <span dir="ltr"><<a href="mailto:arshu.arora@enterprisedb.com" target="_blank">arshu.arora@enterprisedb.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div><div><div>Hi Yuji,<br><br></div>Yes, the meeting was requested by Ahsan on 21st Oct to understand the request.<br>
<br></div>Hi Ahsan,<br><br></div>We have also received a call from SIOS and they also wanted to continue over the email. Could you please guide us how to proceed further on this.<br></div></div></div></blockquote><div><br>
</div><div>I am happy to continue discussing this over emails. From our perspective we want some clarity on the enhancement request. Please have the customer describe the current behaviour that they are seeing with fail-over and the proposed behaviour that they want., Please ask them to share their pgpool configuration file. </div>
<div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div>
<br></div>Regards,<br></div>Arshu<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Nov 6, 2013 at 8:06 PM, Yuji Fujita <span dir="ltr"><<a href="mailto:yuji.fujita@enterprisedb.com" target="_blank">yuji.fujita@enterprisedb.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<div>Hi Arshu,<br>
<br>
Is this for between Ahsan and Watanabe-san of SIOS in Japan?<br>
<br>
My understanding is just to confirm the requirement from customer<br>
Watanabe-san could do it in writing.<br>
<br>
Why we have to do by Webex.<br>
And even so, should we do in groups?<br>
<br>
I do not not see the reason why this should be organizaed in this
big meeting set up?<br>
Correct me if I am wrong.<br>
<br>
Thanks<br>
Yuji<br>
<br>
(2013/11/06 18:04), Arshu Arora wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>
<div>Hi Ahsan,<br>
<br>
</div>
User has confirmed their availability for webex in the below
timeslots. Kindly confirm your availability.<br>
<br>
</div>
<b>Quote:</b><br>
<br>
<p>Apologies for getting back to you late on
this.</p>
<p>Please take one hour from these candidate time
slots, though it seemed</p>
<p>to be difficult for people in U.S..</p>
<p>Then kindly tell us what is needed to attend
the webex.</p>
<p>Day 1.</p>
<p>---</p>
<p>23:00 - 01:30 EST 6th Nov.(Wed) ~ 7th
Nov.(Thu) - New York (UTC -5)</p>
<p>09:30 - 12:00 IST 7th Nov.(Thu)
- New Delhi (UTC +5.5)</p>
<p>13:00 - 15:30 JST 7th Nov.(Thu)
- Tokyo (UTC +9)</p>
<p>---</p>
<p>Day 2.</p>
<p>---</p>
<p>20:00 - 03:00 EST 7th Nov.(Thu) ~ 8th
Nov.(Fri) - New York (UTC -5)</p>
<p>06:30 - 13:30 IST 8th Nov.(Fri)
- New Delhi (UTC +5.5)</p>
<p>10:00 - 17:00 JST 8th Nov.(Fri)
- Tokyo (UTC +9)</p>
<p><b>Unquote:</b></p>
<p>Regards,</p>
<p>Arshu<br>
</p>
<br>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Mon, Oct 21, 2013 at 2:58 PM, Yuji
Fujita <span dir="ltr"><<a href="mailto:yuji.fujita@enterprisedb.com" target="_blank">yuji.fujita@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>Ahsan,<br>
<br>
Thank you very much.<br>
<br>
Deepush, <br>
Will you send that questions to Watanabe-san of SIOS
through support channel?<br>
He knew the detail of the requirements and he is right
person to answer thsi question.<br>
<br>
I also inform this to Watanabe-san of SIOS and
Takatsuru-san our SE to look into this<br>
before support team reach him<br>
<br>
Thanks<br>
Yuji<br>
<br>
(2013/10/21 18:13), Ahsan Hadi wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr"><br>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Mon, Oct 21, 2013 at
3:14 AM, Tom Kincaid <span dir="ltr"><<a href="mailto:tom.kincaid@enterprisedb.com" target="_blank">tom.kincaid@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">
<div><br>
</div>
<div>Thanks for the clarification Yuji. Ahsan
can Usama take care of this?</div>
</div>
</blockquote>
<div><br>
</div>
<div>Sure we can take care of this but we need to
understand the enhancement request or bug first.
Here is a quote from the end-user...</div>
<div><br>
</div>
<div>"</div>
<div><span style="background-color:rgb(254,254,253)"><font color="#1d1d1d" face="georgia, serif"><span style="line-height:16px">So taken
together, what the customer/end user asked
us is to change pgpool-II behaviour when
it's during a failover so that all client
connections are able to connect
pgpool-II(master db), and also execute any
SQLs for the master db even when it's
during a failover triggered by backend(a
slave db) error.</span></font></span><br>
</div>
<div><span style="color:rgb(29,29,29);font-family:georgia,serif;font-size:13px;line-height:16px;background-color:rgb(254,254,253)">"</span></div>
<div><span style="color:rgb(29,29,29);font-family:georgia,serif;font-size:13px;line-height:16px;background-color:rgb(254,254,253)">So
we have a master/slave pgpool setup and the
clients are connected to the master (primary)
instance, the slave (secondary) instance goes
down due to an error. This triggers a
fail-over and when this happen all the clients
should be able to connect to the master
(primary) instance and execute sql queries
when the fail-over is happening.</span></div>
<div><br>
</div>
<div><font color="#1d1d1d" face="georgia, serif"><span style="line-height:16px">Is that what the
customer is expecting to achieve? We did
some pgpool fail-over testing and found the
fail-over to be working correctly for the
above scenario. The client is not able to
connect to pgpool for a few seconds when the
fail-over is happening but it is able to
successfully connect shortly after. Is the
customer concerned about the few seconds
where the client is not able to connect to
pgpool?</span></font></div>
<div><font color="#1d1d1d" face="georgia, serif"><span style="line-height:16px"><br>
</span></font></div>
<div><font color="#1d1d1d" face="georgia, serif"><span style="line-height:16px">Is it possible the
customer can show us the behaviour on webex
sometime so we can completely understand the
request.</span></font></div>
<div><span style="color:rgb(29,29,29);font-family:georgia,serif;font-size:13px;line-height:16px;background-color:rgb(254,254,253)"><br>
</span></div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Sun, Oct 20, 2013
at 5:55 PM, Yuji Fujita <span dir="ltr"><<a href="mailto:yuji.fujita@enterprisedb.com" target="_blank">yuji.fujita@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>Hi Deepunshu,<br>
<br>
He is not requesting us to develop a
custom code of pgpool for the client.<br>
This is pgpool community issue and
should be handled by communty core to
take care.<br>
And this requires the chages of the
specification of pgpool II.<br>
<br>
He is suggesting and requesting to
post the requirements from customer to
the pgpool<br>
community on the wab and let pgpool II
development core members to consider
the specification changes.<br>
<br>
In short, he is requesting to pass
this enhancement request to pgpool
community core.<br>
Not holding us that requirements
within.<br>
<br>
Thanks<br>
Yuji<br>
<br>
(2013/10/20 19:29), Deepanshu Sharma
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Hi <span style="font-family:arial,sans-serif">Katsuji,</span>
<div><span style="font-family:arial,sans-serif"><br>
</span></div>
<div><font color="#000000" face="arial, sans-serif">Apologies
but there is some confusion on
our side on what needs to be
done next.</font></div>
<div><font color="#000000" face="arial, sans-serif">Are you
suggesting that EnterpriseDB
develops a custom code of pgpool
for the client?</font></div>
<div><font color="#000000" face="arial, sans-serif"><br>
</font></div>
<div> <font color="#000000" face="arial, sans-serif">Regards,</font></div>
<div><font color="#000000" face="arial, sans-serif">Deepanshu </font></div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Wed, Oct
9, 2013 at 2:12 PM, Arshu Arora <span dir="ltr"><<a href="mailto:arshu.arora@enterprisedb.com" target="_blank">arshu.arora@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">Adding <font>Katsuji
Takatsuru</font></div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On
Wed, Oct 9, 2013 at 2:06 PM,
Arshu Arora <span dir="ltr"><<a href="mailto:arshu.arora@enterprisedb.com" target="_blank">arshu.arora@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">
<div>
<div>
<div>
<div>
<div><font>Hi
all,<br>
<br>
</font></div>
<font>We have
received a
below response
from sales
engineer in
Japan:<br>
<br>
</font></div>
<font><b>Quote:</b><br>
<br>
This is Katsuji
Takatsuru who am
working as a
sales engineer
in Japan,<br>
and I have been
supported SIOS
corporation too.<br>
Let me consult
you about
ticket#15058-39039.<br>
</font> <font><br>
They
understand the
specification of
pgpool-II well
and they have
been <br>
tried to
persuadetheir
customer that
this behavior is
besed on the
specification<br>
of pgpool-II.<br>
However their
customer have
not accepted
it so far.<br>
They are
familiar with
Oracle RAC, and
they seem to
pursue high
availability<br>
near it.<br>
</font> <font><br>
"Even when the
slave database
goes down,
pgpool-II
restart its
child
processes."<br>
As far as my
opinion, I feel
that the
specification
is somewhat
strange. <br>
I think
fail-over
process is
unnecessary in
case of slave
database down.<br>
</font> <font><br>
Could you
please contibute
this issue to
the community?<br>
Then, Japan
team , including
me , is willing
to follow this
issue.<br>
Thank you in
advance.<br>
<br>
</font></div>
<font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font><b>Unquote:</b><br>
</font><br>
</font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></div>
<font>Regards,<br>
</font></div>
<font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font size="+1"><font>Arshu</font><br>
</font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On
Tue, Oct 1, 2013 at
4:54 PM, Naveed Shaikh
<span dir="ltr"><<a href="mailto:naveed.shaikh@enterprisedb.com" target="_blank">naveed.shaikh@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">Hi
All,
<div><br>
</div>
<div>We have
received
following
feedback from
the customer.
Kindly advice.</div>
<div> <br>
</div>
<div><b><u>Customer
email:-</u></b></div>
<div><b><u><br>
</u></b></div>
<div><font face="georgia,
serif"><span style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">Hi
team,</span><br style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">
<br style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">
<span style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">Thank
you for
considering
about this
issue.</span><br style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">
<span style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">We
are of course
okay to have a
web-ex
meeting.</span><br style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">
<span style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">However
what we can
tell you so
far is just
the customer's
request like
mentioned
below.</span><br style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">
<br style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">
<span style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">---
quote ---</span><br style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">
<span style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">So
taken
together, what
the
customer/end
user asked us
is to change
pgpool-II
behavior when
it's during a
failover so
that all
client
connections
are able to
connect
pgpool-II(master
db), and also
execute any
SQLs for the
master db even
when it's
during a
failover
triggered by
backend(a
slave db)
error.</span><br style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">
<span style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">---
unquote ---</span><br style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">
<br style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">
<span style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">We
think that
current
pgpool-II
architecture
or other HA
cluster
software can
not realize
such behavior.</span><br style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">
<span style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">To
execute
failover
safely in
pgpool-II, we
need to
restart all
the child
processes, and
this makes
disabling new
client
connection
temporarily.</span><br style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">
<span style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">In
contrast, the
customer's
request is to
be able to
connect to
master db even
when it's
during a
failover.</span><br style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">
<br style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">
<span style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">We
appreciate
your offer to
have a web-ex
session with
your
development
team, but
before that,</span><br style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">
<span style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">we
think we are
going to talk
with Mr.
Fujita about
this on
tomorrow.</span><br style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">
<br style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">
<span style="color:rgb(29,29,29);line-height:16px;background-color:rgb(254,254,253)">Kindly
give us for
some time to
give you an
update.</span></font><b><u><br>
</u></b></div>
<div><br>
</div>
<div> <br>
<div><br>
</div>
<div><br>
</div>
</div>
</div>
<div class="gmail_extra"><br clear="all">
<div>
<div dir="ltr">
<div>
<div>--</div>
<div>Thanks
& Regards,</div>
<div>Naveed
Shaikh</div>
<div>
EnterpriseDB
Corporation</div>
<div>
<div>The
Enterprise
PostgreSQL
Company</div>
</div>
<div><br>
</div>
</div>
<div>To reach
Support Call:</div>
<div>US: <a href="tel:%2B1-732-331-1320" value="+17323311320" target="_blank">+1-732-331-1320</a>
- UK: +44 - <a href="tel:2033719820" value="+12033719820" target="_blank">2033719820</a></div>
<div>Brazil: <a href="tel:%2B55-2139581371" value="+552139581371" target="_blank">+55-2139581371</a> - India: <a href="tel:%2B91-20-30589491" value="+912030589491" target="_blank">+91-20-30589491</a></div>
<div><br>
</div>
<div>Website:
<a href="http://www.enterprisedb.com" target="_blank">www.enterprisedb.com</a></div>
<div>EnterpriseDB
Blog: <a href="http://blogs.enterprisedb.com" target="_blank">http://blogs.enterprisedb.com</a></div>
<div>Follow us
on Twitter: <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a></div>
<div><br>
</div>
<div>This
e-mail message
(and any
attachment) is
intended for
the use of the
individual or
entity to whom
it is
addressed.
This message
contains
information
from
EnterpriseDB
Corporation
that may be
privileged,
confidential,
or exempt from
disclosure
under
applicable
law. If you
are not the
intended
recipient or
authorized to
receive this
for the
intended
recipient, any
use,
dissemination,
distribution,
retention,
archiving, or
copying of
this
communication
is strictly
prohibited. If
you have
received this
e-mail in
error, please
notify the
sender
immediately by
reply e-mail
and delete
this message.</div>
</div>
</div>
<br>
<br>
<div class="gmail_quote">On
Fri, Sep 27,
2013 at 5:41 PM,
Naveed Shaikh <span dir="ltr"><<a href="mailto:naveed.shaikh@enterprisedb.com" target="_blank">naveed.shaikh@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">Hi
Ahsan,
<div><br>
</div>
<div>Thanks
for the
update. We
will ask the
customer for
the web-ex and
will update
you soon as
per their
feedback on
this.</div>
<div class="gmail_extra"><br clear="all">
<div>
<div dir="ltr">
<div>
<div>--</div>
<div>Thanks
& Regards,</div>
<div>Naveed
Shaikh</div>
<div>EnterpriseDB
Corporation</div>
<div>
<div>The
Enterprise
PostgreSQL
Company</div>
</div>
<div><br>
</div>
</div>
<div>To reach
Support Call:</div>
<div> US: <a href="tel:%2B1-732-331-1320" value="+17323311320" target="_blank">+1-732-331-1320</a> - UK: +44 - <a href="tel:2033719820" value="+12033719820" target="_blank">2033719820</a></div>
<div>Brazil: <a href="tel:%2B55-2139581371" value="+552139581371" target="_blank">+55-2139581371</a> - India: <a href="tel:%2B91-20-30589491" value="+912030589491" target="_blank">+91-20-30589491</a></div>
<div><br>
</div>
<div>Website:
<a href="http://www.enterprisedb.com" target="_blank">www.enterprisedb.com</a></div>
<div>
EnterpriseDB
Blog: <a href="http://blogs.enterprisedb.com" target="_blank">http://blogs.enterprisedb.com</a></div>
<div>Follow us
on Twitter: <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a></div>
<div><br>
</div>
<div>This
e-mail message
(and any
attachment) is
intended for
the use of the
individual or
entity to whom
it is
addressed.
This message
contains
information
from
EnterpriseDB
Corporation
that may be
privileged,
confidential,
or exempt from
disclosure
under
applicable
law. If you
are not the
intended
recipient or
authorized to
receive this
for the
intended
recipient, any
use,
dissemination,
distribution,
retention,
archiving, or
copying of
this
communication
is strictly
prohibited. If
you have
received this
e-mail in
error, please
notify the
sender
immediately by
reply e-mail
and delete
this message.</div>
</div>
</div>
<br>
<br>
<div class="gmail_quote">On
Fri, Sep 27,
2013 at 5:39
PM, Ahsan Hadi
<span dir="ltr"><<a href="mailto:ahsan.hadi@enterprisedb.com" target="_blank">ahsan.hadi@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">Hi
Naveed,
<div><br>
</div>
<div>Since we
aren't able to
reproduce the
issue, do you
think it makes
sense if the
customer shows
us the issue
over a webex
session
sometime next
week? </div>
<div><br>
</div>
<div> -- Ahsan</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On
Fri, Sep 27,
2013 at 5:04
PM, Naveed
Shaikh <span dir="ltr"><<a href="mailto:naveed.shaikh@enterprisedb.com" target="_blank">naveed.shaikh@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">Hi
Ahsan,
<div><br>
</div>
<div>We have
received
following
update from
the customer.
Kindly advice.</div>
<div> <br>
</div>
<div><b>Customer
email:-</b></div>
<div><b>===================</b></div>
<div><br>
</div>
<div> <span>Hi,</span><br>
<br>
<span>Thank
you for your
notification.</span><br>
<br>
<span>We think
that current
point that we
are discussing
is mentioned
below.</span><br>
<br>
<span>---
quote ---</span><br>
<span>So taken
together, what
the
customer/end
user asked us
is to change
pgpool-II
behavior when
it's during a
failover so
that all
client
connections
are able to
connect
pgpool-II(master
db), and also
execute any
SQLs for the
master db even
when it's
during a
failover
triggered by
backend(a
slave db)
error.</span><br>
<span>---
unquote ---</span><br>
<br>
<span>However
we also know
that current
pgpool-II
implementation
can not
realize the
customer's
system
requirements
mentioned
above, and
then we have
already told
them that it
needs very
long time to
meet their
requirement
and it also
not sure that
pgpool-II can
be like so or
not.</span><br>
<span>So what
we expect you
is talking
with the
pgpool-II
community and
raising the
customer's
request to
them, though
we also think
that it's very
difficult to
implement it
because it
needs change
of software
design.</span><br>
<br>
<span>Regards,</span><br>
</div>
</div>
<div class="gmail_extra"><br clear="all">
<div>
<div dir="ltr">
<div>
<div>--</div>
<div>Thanks
& Regards,</div>
<div>Naveed
Shaikh</div>
<div>EnterpriseDB
Corporation</div>
<div>
<div>The
Enterprise
PostgreSQL
Company</div>
</div>
<div><br>
</div>
</div>
<div>To reach
Support Call:</div>
<div>US: <a href="tel:%2B1-732-331-1320" value="+17323311320" target="_blank">+1-732-331-1320</a>
- UK: <a href="tel:%2B44%20-%202033719820" value="+442033719820" target="_blank">+44
- 2033719820</a></div>
<div>Brazil: <a href="tel:%2B55-2139581371" value="+552139581371" target="_blank">+55-2139581371</a> - India: <a href="tel:%2B91-20-30589491" value="+912030589491" target="_blank">+91-20-30589491</a></div>
<div><br>
</div>
<div> Website:
<a href="http://www.enterprisedb.com" target="_blank">www.enterprisedb.com</a></div>
<div>EnterpriseDB
Blog: <a href="http://blogs.enterprisedb.com" target="_blank">http://blogs.enterprisedb.com</a></div>
<div>Follow us
on Twitter: <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a></div>
<div><br>
</div>
<div>This
e-mail message
(and any
attachment) is
intended for
the use of the
individual or
entity to whom
it is
addressed.
This message
contains
information
from
EnterpriseDB
Corporation
that may be
privileged,
confidential,
or exempt from
disclosure
under
applicable
law. If you
are not the
intended
recipient or
authorized to
receive this
for the
intended
recipient, any
use,
dissemination,
distribution,
retention,
archiving, or
copying of
this
communication
is strictly
prohibited. If
you have
received this
e-mail in
error, please
notify the
sender
immediately by
reply e-mail
and delete
this message.</div>
</div>
</div>
<br>
<br>
<div class="gmail_quote">On
Wed, Sep 11,
2013 at 12:25
PM, Ahsan Hadi
<span dir="ltr"><<a href="mailto:ahsan.hadi@enterprisedb.com" target="_blank">ahsan.hadi@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr"><br>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On
Wed, Sep 11,
2013 at 11:46
AM, Arshu
Arora <span dir="ltr"><<a href="mailto:arshu.arora@enterprisedb.com" target="_blank">arshu.arora@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">
<div>
<div>
<div>
<div>
<div>Hi all,<br>
<br>
</div>
We have
received
following
feedback from
the user.
Kindly advice
how to proceed
further on
this.<br>
<br>
</div>
<b>Quote:</b><br>
<br>
Let us clarify
about the
customer/end
user's current
argument on
this issue.<br>
<br>
<br>
<br>
* end user
means "
Softbank
mobile"
actually.<br>
<br>
<br>
<br>
First, we
understood
that
"fail_over_on_backend_error
= on" gives us
a failover
when the
pgpool detects
slave database
failure, and
which also
gives us
pgpool child
process
restart to
refresh any
tcp
connections
between the
clients and
the pgpool-II
node. So,<br>
this pgpool-II
mechanism
should work
properly to
receive new
client
connections
after
finishing the
failover
because all
connection
should be
refreshed by
it, and this
is also what
you pointed
out which
should solve
the customer's
problem.<br>
<br>
<br>
<br>
However,
especially the
end user
insists that
pgpool-II(and
its master db)
should do
accept new
client
connections
even when it's
during a
failover. One
of their
reason and
their idea
based on the
2nd fact
mentioned
below, we
think.<br>
<br>
<br>
<br>
[facts
confirmed by
the customer]<br>
<br>
What they saw
was 2 fact
mentioned
below.<br>
<br>
---<br>
<br>
1. A client
new connection
was not
accepted
pgpool=II
whatever
"fail_over_on_backend_error"
is on or off.
This was
confirmed by
you, the
customer and <span>SIOS</span>.<br>
<br>
* <span>SIOS</span>
think that
this is very
common
behavior
because it's
pgpoll-II
specification.<br>
<br>
2. The user
confirm that
established
connection(already
connected to a
master db
through
pgpool-II)
between a
client anda
pgpool-II(Master
db) is not
affected by a
failover
triggered by
backend(a
slave db)
error, which
means that
they can
execute any
SQL for<br>
the master db
even when it's
during the
failover. We
talked about
this with you
on the "Ticket
#:
15058-29968"
actually.<br>
<br>
* As far as we
<span>SIOS</span>
confirm the
phenomenon, we
couldn't
execute SQLs
for master db
through
pgpool-II when
it's during a
failover . So
this is a
difference
between the
customer ans
us(<span>SIOS</span>).<br>
</div>
</div>
</div>
</div>
</blockquote>
<div><br>
</div>
<div>That's
the part we
are not able
to reproduce
locally, I was
able to
execute sql
statement on
the master db
through pgpool
when slave db
was stopped.
It falls over
to master db
when slave
goes down and
falls over to
slave db when
master goes
down. </div>
<div><br>
</div>
<div>We are
currently
doing some
failover and
watchdog
testing of
pgpool so we
will test this
scenario again
with multiple
physical
machine's and
see if we are
able to
reproduce the
issue.</div>
<div><br>
</div>
<div>Is the
customer not
able to
connect to the
master db for
a few seconds
when slave
goes down and
is able to
connect again
after a little
while?</div>
<div> </div>
<div> </div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">
<div>
<div>
<div><br>
---<br>
<br>
<br>
<br>
So taken
together, what
the
customer/end
user asked us
is to change
pgpool-II
behavior when
it's during a
failover so
that all
client
connections
are able to
connect
pgpool-II(master
db), and also
execute any
SQLs for the
master db even
when it's
during a
failover<br>
triggered by
backend(a
slave db)
error.<br>
<br>
<br>
<br>
(back ground
of their
opinion)<br>
<br>
They got
service outage
on their
commercial
system
actually,
because of
this pgpool-II
mechanism.<br>
<br>
<br>
<br>
<br>
<br>
It'll helpful
if you could
give us your
opinion.<br>
<br>
</div>
<b>Unquote:</b><br>
<br>
</div>
Regards,<br>
</div>
Arshu<br>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On
Fri, Aug 30,
2013 at 7:39
PM, Naveed
Shaikh <span dir="ltr"><<a href="mailto:naveed.shaikh@enterprisedb.com" target="_blank">naveed.shaikh@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">Hi
Ahsan,
<div><br>
</div>
<div>Thanks
for following
up this. We
are still
waiting a
response from
customer. We
will update
you soon as
per we get an
update from a
customer.</div>
<div><br>
</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br clear="all">
<div>
<div dir="ltr">
<div>
<div>--</div>
<div>Thanks
& Regards,</div>
<div>Naveed
Shaikh</div>
<div>EnterpriseDB
Corporation</div>
<div>
<div>The
Enterprise
PostgreSQL
Company</div>
</div>
<div><br>
</div>
</div>
<div>To reach
Support Call:</div>
<div>US: <a href="tel:%2B1-732-331-1320" value="+17323311320" target="_blank">+1-732-331-1320</a>
- UK: <a href="tel:%2B44%20-%202033719820" value="+442033719820" target="_blank">+44
- 2033719820</a></div>
<div>Brazil: <a href="tel:%2B55-2139581371" value="+552139581371" target="_blank">+55-2139581371</a> - India: <a href="tel:%2B91-20-30589491" value="+912030589491" target="_blank">+91-20-30589491</a></div>
<div><br>
</div>
<div> Website:
<a href="http://www.enterprisedb.com" target="_blank">www.enterprisedb.com</a></div>
<div>EnterpriseDB
Blog: <a href="http://blogs.enterprisedb.com" target="_blank">http://blogs.enterprisedb.com</a></div>
<div>Follow us
on Twitter: <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a></div>
<div><br>
</div>
<div>This
e-mail message
(and any
attachment) is
intended for
the use of the
individual or
entity to whom
it is
addressed.
This message
contains
information
from
EnterpriseDB
Corporation
that may be
privileged,
confidential,
or exempt from
disclosure
under
applicable
law. If you
are not the
intended
recipient or
authorized to
receive this
for the
intended
recipient, any
use,
dissemination,
distribution,
retention,
archiving, or
copying of
this
communication
is strictly
prohibited. If
you have
received this
e-mail in
error, please
notify the
sender
immediately by
reply e-mail
and delete
this message.</div>
</div>
</div>
<br>
<br>
<div class="gmail_quote">On
Fri, Aug 30,
2013 at 7:31
PM, Ahsan Hadi
<span dir="ltr"><<a href="mailto:ahsan.hadi@enterprisedb.com" target="_blank">ahsan.hadi@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">Hi
Baji,
<div><br>
</div>
<div>I tried
reproducing
this again
today. I am
able to
connect to the
master even
when i stop
the slave
running in
another
session.</div>
<div><br>
</div>
<div>Did you
get any more
updates on
this from the
customer?</div>
<div><br>
</div>
<div>-- Ahsan</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On
Thu, Aug 29,
2013 at 2:53
PM, Baji Shaik
<span dir="ltr"><<a href="mailto:baji.shaik@enterprisedb.com" target="_blank">baji.shaik@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">Hi
Ahsan,
<div><br>
</div>
<div>Yes, we
were able to
reproduce this
issue once(for
1 or 2 sec),
however not
after that.
Their pgpool
configuration
file shows
"ssl = off".
they say, <span>even
they set to
"fail_over_on_backend_error
= on", the
pgpool-II
behavior was
not improved
on their
environment. </span> We
will get a
confirmation
from customer
on this and we
will update
you.</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On
Wed, Aug 28,
2013 at 9:14
PM, Ahsan Hadi
<span dir="ltr"><<a href="mailto:ahsan.hadi@enterprisedb.com" target="_blank">ahsan.hadi@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">Hi
Support,
<div><br>
</div>
<div>We are
trying to
reproduce the
issue locally
but no success
so far. Did
you say that
you were able
to reproduce
the issue
successfully
one but not
after that? Is
the customer
consistently
not able to
connect to the
master when
one of the
slave is down?
Is the
customer
running with
SSL enabled?</div>
<div><br>
</div>
<div>-- Ahsan</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On
Tue, Aug 27,
2013 at 3:24
PM, Ahsan Hadi
<span dir="ltr"><<a href="mailto:ahsan.hadi@enterprisedb.com" target="_blank">ahsan.hadi@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr"><br>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On
Tue, Aug 27,
2013 at 3:14
PM, Naveed
Shaikh <span dir="ltr"><<a href="mailto:naveed.shaikh@enterprisedb.com" target="_blank">naveed.shaikh@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">Hi
All,
<div><br>
</div>
<div>Do we
have any
update on this
issue.</div>
</div>
</blockquote>
<div><br>
</div>
<div> Not
yet...We have
multiple
PGPOOL issues
that we are
dealing with
right now.
Will have
update on it
later this
week, I am
going to try
and reproduce
the customer
behaviour to
start with.</div>
<div><br>
</div>
<div> </div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div class="gmail_extra"><br clear="all">
<div>
<div dir="ltr">
<div>
<div>--</div>
<div>Thanks
& Regards,</div>
<div>Naveed
Shaikh</div>
<div>EnterpriseDB
Corporation</div>
<div>
<div>The
Enterprise
PostgreSQL
Company</div>
</div>
<div><br>
</div>
</div>
<div>To reach
Support Call:</div>
<div>US: <a href="tel:%2B1-732-331-1320" value="+17323311320" target="_blank">+1-732-331-1320</a>
- UK: <a href="tel:%2B44%20-%202033719820" value="+442033719820" target="_blank">+44
- 2033719820</a></div>
<div>Brazil: <a href="tel:%2B55-2139581371" value="+552139581371" target="_blank">+55-2139581371</a> - India: <a href="tel:%2B91-20-30589491" value="+912030589491" target="_blank">+91-20-30589491</a></div>
<div><br>
</div>
<div>Website:
<a href="http://www.enterprisedb.com" target="_blank">www.enterprisedb.com</a></div>
<div>EnterpriseDB
Blog: <a href="http://blogs.enterprisedb.com" target="_blank">http://blogs.enterprisedb.com</a></div>
<div>Follow us
on Twitter: <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a></div>
<div><br>
</div>
<div>This
e-mail message
(and any
attachment) is
intended for
the use of the
individual or
entity to whom
it is
addressed.
This message
contains
information
from
EnterpriseDB
Corporation
that may be
privileged,
confidential,
or exempt from
disclosure
under
applicable
law. If you
are not the
intended
recipient or
authorized to
receive this
for the
intended
recipient, any
use,
dissemination,
distribution,
retention,
archiving, or
copying of
this
communication
is strictly
prohibited. If
you have
received this
e-mail in
error, please
notify the
sender
immediately by
reply e-mail
and delete
this message.</div>
</div>
</div>
<br>
<br>
<div class="gmail_quote">On
Mon, Aug 26,
2013 at 6:40
PM, Baji Shaik
<span dir="ltr"><<a href="mailto:baji.shaik@enterprisedb.com" target="_blank">baji.shaik@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">
<div>Hi All,</div>
<div><br>
</div>
<div>Customer
has came back
on this issue.
They complaint
that even they
have enabled
the
"fail_over_on_backend_error
= on"
parameter,
they are not
able to
connect to
Master for
sometime when
Slave is down
from OS
command prompt
using psql, it
is not
reproducible
through psql
prompt(find
the detailed
attachments).
We have tried
to reproduce
the issue,
however it was
reproduced
once, and we
are not sure
why it was not
able to
connect for a
second. And We
have tested
with creating
a script which
runs psql
command
multiple times
and shutdown
the Slave on
other session.
However we
cant see that
error again.</div>
<div><br>
</div>
<div><font face="courier
new,
monospace">-bash-4.1$
cat
pgpool.conf|grep
-i
'fail_over_on_backend_error'</font></div>
<div><font face="courier
new,
monospace"><b>fail_over_on_backend_error
= on</b></font></div>
<div><font face="courier
new,
monospace">-bash-4.1$ </font></div>
<div><font face="courier
new,
monospace">-bash-4.1$ </font></div>
<div><font face="courier
new,
monospace">-bash-4.1$
<b>date;
./psql -p 9999
-h localhost
-U
enterprisedb
-c "select
current_timestamp;"
</b>edb2013-08-26
12:29:52 GMT
LOG: received
fast shutdown
request</font></div>
<div><font face="courier
new,
monospace">2013-08-26
12:29:52 GMT
LOG: aborting
any active
transactions</font></div>
<div><font face="courier
new,
monospace">2013-08-26
12:29:52 GMT
FATAL:
terminating
walreceiver
process due to
administrator
command</font></div>
<div><font face="courier
new,
monospace">2013-08-26
12:29:52 GMT
FATAL:
terminating
connection due
to
administrator
command</font></div>
<div><font face="courier
new,
monospace">2013-08-26
12:29:52 GMT
LOG: shutting
down</font></div>
<div><font face="courier
new,
monospace">2013-08-26
12:29:52 GMT
LOG: database
system is shut
down</font></div>
<div><font face="courier
new,
monospace"><br>
</font></div>
<div><font face="courier
new,
monospace"><b>Mon
Aug 26
12:29:53 GMT
2013</b></font></div>
<div><font face="courier
new,
monospace"><b>psql:
-bash-4.1$
2013-08-26
12:29:53 GMT
LOG:
incomplete
startup packet</b></font></div>
<div><font face="courier
new,
monospace"><b>2013-08-26
12:29:53 GMT
LOG:
connection
failed during
start up
processing:
user=
database=</b></font></div>
<div><font face="courier
new,
monospace">date;
./psql -p 9999
-h localhost
-U
enterprisedb
-c "select
current_timestamp;"
edb</font></div>
<div><font face="courier
new,
monospace">Mon
Aug 26
12:29:55 GMT
2013</font></div>
<div><font face="courier
new,
monospace">
current_timestamp
</font></div>
<div><font face="courier
new,
monospace">----------------------------------</font></div>
<div><font face="courier
new,
monospace"> 26-AUG-13
12:29:55.063265
+00:00</font></div>
<div><font face="courier
new,
monospace">(1
row)</font></div>
<div><br>
</div>
<div>Other
sesion I ran:</div>
<div><br>
</div>
<div><font face="courier
new,
monospace">-bash-4.1$date;
<b>./pg_ctl -D
rep/slave/
stop -mf</b></font></div>
<div><font face="courier
new,
monospace">Mon
Aug 26
12:29:52 GMT
2013</font></div>
<div><font face="courier
new,
monospace">waiting
for server to
shut down....
done</font></div>
<div><font face="courier
new,
monospace">server
stopped</font></div>
<div><br>
</div>
<div><br>
</div>
<div><b>Below
is the
response from
the Customer:</b></div>
<div><b><br>
</b></div>
<div><b>Quote:</b></div>
<div><br>
</div>
<div>Kindly
let us ask you
about "Ticket
#:
15058-21131".</div>
<div><br>
</div>
<div>Though we
understood
what you told
us before that
psql
connection is
not accepted
by pgpool-II
because of
new_connection()
of
pgpool3.2.1/pool_connection_pool.c
source code
logic, however
even the
customer set
to
"fail_over_on_backend_error
= on", the
pgpool-II
behavior was
not improved
on their
environment
like your test
case. Could
you have a
look at
attached log
file and its
pgpool
configuration
file?</div>
<div><br>
</div>
<div>As far as
we had looked
at the
pgpool3.2.1/pool_connection_pool.c
source, it
seemed that
psql
connection was
not accepted
even they set
"fail_over_on_backend_error
= on".
According to
our tracing
source codes,
customer
system looked
like and
should have
been going to
notice_backend_error()
->
degenerate_backend_set()
-> parallel
mode =
off(from
customer's
pgpool.conf)
->
use_watchdog =
off (from
customer's
pgpool.conf)
->
*new_connection()
returns NULL?</div>
<div><br>
</div>
<div>So we'd
like to know
your opinions
about the
customer case.</div>
<div><br>
</div>
<div><br>
</div>
<div>Regards,</div>
<div><br>
</div>
<div><br>
</div>
<div>Your test
case (With
fail_over_on_backend_error
= on:)</div>
<div>* You
gave us this
on 5/17/2013
12:52 AM EDT
of "Ticket #:
15058-2113"</div>
<div>---</div>
<div>With
fail_over_on_backend_error
= on:</div>
<div>-------------------------------</div>
<div><br>
</div>
<div>-bash-4.1$
more
pgpool.conf|grep
fail_over_on_backend_error</div>
<div>fail_over_on_backend_error
= on</div>
<div><br>
</div>
<div>-bash-4.1$
date;./pg_ctl
-D rep/slave
stop -mf</div>
<div>Fri May
10 00:31:20
GMT 2013</div>
<div>waiting
for server to
shut
down...2013-05-10
00:31:20 GMT
LOG: received
fast shutdown
request</div>
<div><br>
</div>
<div><br>
</div>
<div>-bash-4.1$
date;./psql -p
9999 -c
"select 1;"
edb</div>
<div>Fri May
10 00:31:21
GMT 2013</div>
<div>?column?
</div>
<div>----------</div>
<div>1</div>
<div>(1 row)</div>
<div><br>
</div>
<div>-bash-4.1$
date;./psql -p
9999 -c
"select 1;"
edb</div>
<div>Fri May
10 00:31:22
GMT 2013</div>
<div>?column?
</div>
<div>----------</div>
<div>1</div>
<div>(1 row)</div>
<div><br>
</div>
<div>-bash-4.1$
date;./psql -p
9999 -c
"select 1;"
edb</div>
<div>Fri May
10 00:31:23
GMT 2013</div>
<div>?column?
</div>
<div>----------</div>
<div>1</div>
<div>(1 row)</div>
<div><br>
</div>
<div><br>
</div>
<div><b>Unquote:</b></div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On
Tue, Jul 2,
2013 at 8:45
PM, Ahsan Hadi
<span dir="ltr"><<a href="mailto:ahsan.hadi@enterprisedb.com" target="_blank">ahsan.hadi@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">Hi
Naveed,
<div><br>
</div>
<div>Did we
communicate
the findings
and
suggestions to
the customer
that Asif
shared on this
email chain on
May 9th?</div>
<div><br>
</div>
<div>As i
recall we
concluded that
with "<span style="font-family:arial,sans-serif;font-size:13px">fail_over_on_backend_error"
enabled, the
customer
issues is
solved, did
the customer
try that? This
was something
that support
(baji) also
tested and
verified.</span></div>
<div><span style="font-family:arial,sans-serif;font-size:13px"><br>
</span></div>
<div><span style="font-family:arial,sans-serif;font-size:13px">The
last email on
this thread is
from May 10th.
So i am not
sure what type
of progress
you were
expecting to
make on this
ticket.</span></div>
<div><span style="font-family:arial,sans-serif;font-size:13px"><br>
</span></div>
<div><span style="font-family:arial,sans-serif;font-size:13px">--
Ahsan</span></div>
<div><span style="font-family:arial,sans-serif;font-size:13px"><br>
</span></div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On
Tue, Jul 2,
2013 at 8:01
PM, Naveed
Shaikh <span dir="ltr"><<a href="mailto:naveed.shaikh@enterprisedb.com" target="_blank">naveed.shaikh@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">
<div>HI All,</div>
<div><br>
</div>
<div>We
have received
following
email from the
customer
regarding the
progress of
the<font face="arial,
helvetica,
sans-serif"><b> </b><span style="background-color:rgb(254,254,253);color:rgb(29,29,29);line-height:16px;white-space:pre-wrap"><b>Fogbug
#23381. </b>We
have checked
the FB#23381
and we didn't
see any
progress which
we can share
with the
customer.
Kindly advice.
</span></font></div>
<div><font face="arial,
helvetica,
sans-serif"><span style="background-color:rgb(254,254,253);color:rgb(29,29,29);line-height:16px;white-space:pre-wrap"><br>
</span></font></div>
<div><font face="arial,
helvetica,
sans-serif"><span style="background-color:rgb(254,254,253);color:rgb(29,29,29);line-height:16px;white-space:pre-wrap"><b><u>Customer
email:-</u></b></span></font></div>
<div><font face="arial,
helvetica,
sans-serif"><span style="background-color:rgb(254,254,253);color:rgb(29,29,29);line-height:16px;white-space:pre-wrap"><br>
</span></font></div>
<div><span>Hi,</span><br>
<br>
<span>As we
have got an
extra inquiry
regarding
#15058-21131(Fogbug
#23381) and
#15058-21088
from the
customer.</span><br>
<span>Kindly
let us ask you
about it
again.</span><br>
<br>
<span>According
to the
customer
saying, the
point of what
they want to
insist is
differences
between a new
connection
which is not
connected yet
and a
connection
which is
already
connected.</span><br>
<span>In
short, they
pointed out
that 2nd
connected case
should have
been incorrect
or the 1st new
connection
case should
have been able
to accept
queries like
the 2nd case.</span><br>
<span>Specifically,
please have a
look at the
attached excel
file as we
translated
diagram of the
system and the
phenomenon.</span><br>
<span>Hopefully
you'll see it,
and could give
us your
opinion about
it.</span><br>
<br>
<span>(Conditions)</span></div>
<div><br>
<span>- PPAS
9.2.1.3</span><br>
<span>-
RHEL5.4(x86_64)</span><br>
- Attachment:
pgpool_info.zip</div>
<div><br style="background-color:rgb(254,254,253)">
<span>Regards,</span></div>
<div><span><br>
</span></div>
<div><span><br>
</span></div>
<div><br>
</div>
--<br clear="all">
<div>
<div dir="ltr">
<div>
<div>Thanks
& Regards,</div>
<div>Naveed
Shaikh</div>
<div>EnterpriseDB
Corporation</div>
<div>The
Postgres
Database
Company</div>
<div><br>
</div>
<div> To reach
Support Call:</div>
<div>US: <a href="tel:%2B1-732-331-1320" value="+17323311320" target="_blank">+1-732-331-1320</a>
- UK: <a href="tel:%2B44%20-%202033719820" value="+442033719820" target="_blank">+44
- 2033719820</a></div>
<div>Brazil: <a href="tel:%2B55-2139581371" value="+552139581371" target="_blank">+55-2139581371</a> - India: <a href="tel:%2B91-20-30589491" value="+912030589491" target="_blank">+91-20-30589491</a></div>
<div><br>
</div>
<div> Website:
<a href="http://www.enterprisedb.com" target="_blank">www.enterprisedb.com</a></div>
<div>EnterpriseDB
Blog: <a href="http://blogs.enterprisedb.com" target="_blank">http://blogs.enterprisedb.com</a></div>
<div>Follow us
on Twitter: <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a></div>
<div><br>
</div>
<div>This
e-mail message
(and any
attachment) is
intended for
the use of the
individual or
entity to whom
it is
addressed.
This message
contains
information
from
EnterpriseDB
Corporation
that may be
privileged,
confidential,
or exempt from
disclosure
under
applicable
law. If you
are not the
intended
recipient or
authorized to
receive this
for the
intended
recipient, any
use,
dissemination,
distribution,
retention,
archiving, or
copying of
this
communication
is strictly
prohibited. If
you have
received this
e-mail in
error, please
notify the
sender
immediately by
reply e-mail
and delete
this message.</div>
</div>
</div>
</div>
<br>
<br>
<div class="gmail_quote">On
Fri, May 10,
2013 at 11:58
AM, Ahsan Hadi
<span dir="ltr"><<a href="mailto:ahsan.hadi@enterprisedb.com" target="_blank">ahsan.hadi@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div>Yes I
don't see why
we shouldn't.<br>
<hr>
<div><b>From:
</b>
Venkatesulu J
<<a href="mailto:venkatesulu.j@enterprisedb.com" target="_blank">venkatesulu.j@enterprisedb.com</a>>
</div>
<div><b>Date:
</b>Fri, 10
May 2013
11:42:11 +0530</div>
<div><b>To: </b><<a href="mailto:ahsan.hadi@enterprisedb.com" target="_blank">ahsan.hadi@enterprisedb.com</a>></div>
<div><b>Cc: </b>Team
Support<<a href="mailto:teamsupport@enterprisedb.com" target="_blank">teamsupport@enterprisedb.com</a>>;
support-escalations<<a href="mailto:support-escalations@enterprisedb.com" target="_blank">support-escalations@enterprisedb.com</a>></div>
<div><b>Subject:
</b>Re: Issue:
about
redundancy of
pgpool-II,
Ticket#
15058-20802,
Customer: SIOS
Engineers,
Account: SIOS
Technology,Inc.</div>
<div><br>
</div>
<div dir="ltr"><font color="#3366ff"><font face="verdana,sans-serif">Hi Ahsan,</font></font>
<div><font color="#3366ff"><font face="verdana,sans-serif"><br>
</font></font></div>
<div><font color="#3366ff"><font face="verdana,sans-serif">Please confirm, can we share this information
to the
customer?</font></font></div>
<div><font color="#3366ff"><font face="verdana,sans-serif"><br>
</font></font></div>
<div><font color="#3366ff"><font face="verdana,sans-serif">Regards,</font></font></div>
<div><font color="#3366ff"><font face="verdana,sans-serif">Venkat.</font></font></div>
<div><font color="#3366ff"><font face="verdana,sans-serif"><br>
</font></font><br>
<div class="gmail_quote">On
Fri, May 10,
2013 at 9:51
AM, Ahsan Hadi
<span dir="ltr"><<a href="mailto:ahsan.hadi@enterprisedb.com" target="_blank">ahsan.hadi@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div>Great.<br>
<br>
Are you going
to communicate
this
configuration
setting change
to the
customer?<br>
<hr>
<div> <b>From:
</b> Baji
Shaik <<a href="mailto:baji.shaik@enterprisedb.com" target="_blank">baji.shaik@enterprisedb.com</a>>
</div>
<div><b>Date:
</b>Fri, 10
May 2013
06:20:23 +0530</div>
<div><b>To: </b>Asif
Naeem<<a href="mailto:asif.naeem@enterprisedb.com" target="_blank">asif.naeem@enterprisedb.com</a>></div>
<div><b>Cc: </b>Venkatesulu
J<<a href="mailto:venkatesulu.j@enterprisedb.com" target="_blank">venkatesulu.j@enterprisedb.com</a>>;
Ahsan Hadi<<a href="mailto:ahsan.hadi@enterprisedb.com" target="_blank">ahsan.hadi@enterprisedb.com</a>>;
Team
Support<<a href="mailto:teamsupport@enterprisedb.com" target="_blank">teamsupport@enterprisedb.com</a>>;
support-escalations<<a href="mailto:support-escalations@enterprisedb.com" target="_blank">support-escalations@enterprisedb.com</a>></div>
<div><b>Subject:
</b>Re: Issue:
about
redundancy of
pgpool-II,
Ticket#
15058-20802,
Customer: SIOS
Engineers,
Account: SIOS
Technology,Inc.</div>
<div><br>
</div>
Hi Asif,
<div><br>
</div>
<div>Thank you
very much for
your efforts
on this.</div>
<div><br>
</div>
<div>I have
tested this
with enabling
and disabling
the
"fail_over_on_backend_error"
parameter.</div>
<div><br>
</div>
<div> When
"fail_over_on_backend_error"
parameter is
disabled, as
you said, we
cannot connect
to master
during health
check. And if
this parameter
is enabled,
they we have
not face this
issue.</div>
<div><br>
</div>
<div> <b>With
fail_over_on_backend_error
= off:</b></div>
<div><b><font face="courier
new,
monospace">-------------------------------</font></b></div>
<div><b><font face="courier
new,
monospace"><br>
</font></b></div>
<div>
<div><font face="courier
new,
monospace">-bash-4.1$
more
pgpool.conf|grep
fail_over_on_backend_error</font></div>
<div><font face="courier
new,
monospace"><b>fail_over_on_backend_error
= off</b></font></div>
<div><font face="courier
new,
monospace"><br>
</font></div>
<div><font face="courier
new,
monospace">-bash-4.1$
date;./pg_ctl
-D rep/slave
stop -mf</font></div>
<div><font face="courier
new,
monospace"><b>Fri
May 10
00:25:56 GMT
2013</b></font></div>
<div><font face="courier
new,
monospace">waiting
for server to
shut
down....2013-05-10
00:25:56 GMT
LOG: received
fast shutdown
request</font></div>
<div><font face="courier
new,
monospace"><br>
</font></div>
<div><font face="courier
new,
monospace"><br>
</font></div>
<div><font face="courier
new,
monospace">-bash-4.1$
date;./psql -p
9999 -c
"select 1;"
edb</font></div>
<div><font face="courier
new,
monospace"><b>Fri
May 10
00:25:57 GMT
2013</b></font></div>
<div><font face="courier
new,
monospace">psql:
-bash-4.1$
2013-05-10
00:25:57 GMT
LOG:
incomplete
startup packet</font></div>
<div> <font face="courier
new,
monospace">2013-05-10
00:25:57 GMT
LOG:
connection
failed during
start up
processing:
user=
database=</font></div>
<div><font face="courier
new,
monospace"><br>
</font></div>
<div><font face="courier
new,
monospace">-bash-4.1$
date;./psql -p
9999 -c
"select 1;"
edb</font></div>
<div><font face="courier
new,
monospace">Fri
May 10
00:26:01 GMT
2013</font></div>
<div><font face="courier
new,
monospace">psql:
2013-05-10
00:26:01 GMT
LOG:
incomplete
startup packet</font></div>
<div><font face="courier
new,
monospace">2013-05-10
00:26:01 GMT
LOG:
connection
failed during
start up
processing:
user=
database=</font></div>
<div><font face="courier
new,
monospace"><br>
</font></div>
<div><font face="courier
new,
monospace">-bash-4.1$
date;./psql -p
9999 -c
"select 1;"
edb</font></div>
<div><font face="courier
new,
monospace"><b>Fri
May 10
00:26:06 GMT
2013</b></font></div>
<div><font face="courier
new,
monospace">psql:
-bash-4.1$
2013-05-10
00:26:06 GMT
LOG:
incomplete
startup packet</font></div>
<div><font face="courier
new,
monospace">2013-05-10
00:26:06 GMT
LOG:
connection
failed during
start up
processing:
user=
database=</font></div>
<div><font face="courier
new,
monospace"><br>
</font></div>
<div><font face="courier
new,
monospace">-bash-4.1$
date;./psql -p
9999 -c
"select 1;"
edb</font></div>
<div><font face="courier
new,
monospace"><b>Fri
May 10
00:26:08 GMT
2013</b></font></div>
<div><font face="courier
new,
monospace"> ?column? </font></div>
<div><font face="courier
new,
monospace">----------</font></div>
<div><font face="courier
new,
monospace">
1</font></div>
<div><font face="courier
new,
monospace">(1
row)</font></div>
<div><br>
</div>
<div>==================================================================</div>
<div><br>
</div>
<div>
<div><b>With
fail_over_on_backend_error
= on:</b></div>
<div><b><font face="courier
new,
monospace">-------------------------------</font></b></div>
</div>
<div><br>
</div>
<div><font face="courier
new,
monospace">-bash-4.1$
more
pgpool.conf|grep
fail_over_on_backend_error</font></div>
<div><b><font face="courier
new,
monospace">fail_over_on_backend_error
= on</font></b></div>
<div><font face="courier
new,
monospace"><br>
</font></div>
<div><font face="courier
new,
monospace">-bash-4.1$
date;./pg_ctl
-D rep/slave
stop -mf</font></div>
<div><b><font face="courier
new,
monospace">Fri
May 10
00:31:20 GMT
2013</font></b></div>
<div><font face="courier
new,
monospace">waiting
for server to
shut
down...2013-05-10
00:31:20 GMT
LOG: received
fast shutdown
request</font></div>
<div><font face="courier
new,
monospace"><br>
</font></div>
<div><font face="courier
new,
monospace"><br>
</font></div>
<div><font face="courier
new,
monospace">-bash-4.1$
date;./psql -p
9999 -c
"select 1;"
edb</font></div>
<div><b><font face="courier
new,
monospace">Fri
May 10
00:31:21 GMT
2013</font></b></div>
<div> <font face="courier
new,
monospace"> ?column? </font></div>
<div><font face="courier
new,
monospace">----------</font></div>
<div><font face="courier
new,
monospace">
1</font></div>
<div><font face="courier
new,
monospace">(1
row)</font></div>
<div><font face="courier
new,
monospace"><br>
</font></div>
<div><font face="courier
new,
monospace">-bash-4.1$
date;./psql -p
9999 -c
"select 1;"
edb</font></div>
<div><font face="courier
new,
monospace">Fri
May 10
00:31:22 GMT
2013</font></div>
<div><font face="courier
new,
monospace"> ?column? </font></div>
<div><font face="courier
new,
monospace">----------</font></div>
<div><font face="courier
new,
monospace">
1</font></div>
<div><font face="courier
new,
monospace">(1
row)</font></div>
<div><font face="courier
new,
monospace"><br>
</font></div>
<div><font face="courier
new,
monospace">-bash-4.1$
date;./psql -p
9999 -c
"select 1;"
edb</font></div>
<div><font face="courier
new,
monospace">Fri
May 10
00:31:23 GMT
2013</font></div>
<div><font face="courier
new,
monospace"> ?column? </font></div>
<div><font face="courier
new,
monospace">----------</font></div>
<div><font face="courier
new,
monospace">
1</font></div>
<div><font face="courier
new,
monospace">(1
row)</font></div>
</div>
<div><br>
</div>
<div><br>
</div>
<div>Regards,</div>
<div>Baji
Shaik.</div>
<div><br>
<div class="gmail_quote">On
Thu, May 9,
2013 at 4:48
PM, Asif Naeem
<span dir="ltr"><<a href="mailto:asif.naeem@enterprisedb.com" target="_blank">asif.naeem@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div>It seems
that customer
is using
pgpool
configuration
file
(config.zip.zip)
as shared on
parature
ticket
15058-20802.
It contains
following
related
settings i.e.</div>
<div>
<div><br>
</div>
<div>pgpool.conf</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
backend_flag0
=
'ALLOW_TO_FAILOVER'<br>
backend_flag1
=
'ALLOW_TO_FAILOVER'<br>
fail_over_on_backend_error
= off <br>
health_check_period
= 5<br>
health_check_timeout
= 1<br>
health_check_max_retries
= 2<br>
health_check_retry_delay
= 5</blockquote>
<div><br>
</div>
<div>Customer
reported the
following
issue i.e. </div>
<div>When the
slave server
got an error
during the
healthcheck
retries
function
enabled,
pgpool
requests in
spite of
select or
update query
won't be
accepted any
more during
the
healthcheck is
trying to
retry.</div>
<div><br>
</div>
<div>According
to <a href="http://www.pgpool.net/docs/latest/pgpool-en.html" target="_blank">pgpool
documentation</a></div>
<div>pgpool-II
periodically
tries to
connect to the
backends to
detect any
error on the
servers or
networks. This
error check
procedure is
called "health
check". If an
error is
detected,
pgpool-II
tries to
perform
failover or
degeneration.</div>
<div> </div>
<div>health_check_timeout</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
This
parameter
serves to
prevent the
health check
from waiting
for a long
time in a case
such as
unplugged
network cable.<br>
</blockquote>
<div> </div>
health_check_max_retries<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
The
maximum number
of times to
retry a failed
health check
before giving
up and
initiating
failover. This
setting can be
useful in
spotty
networks, when
it is expected
that health
checks will
fail
occasionally
even when the
master is
fine. Default
is 0, which
means do not
retry. It is
advised that
you
disable fail_over_on_backend_error
if you want to
enable
health_check_max_retries.<br>
</blockquote>
<div> </div>
<div>fail_over_on_backend_error</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
If
true, and an
error occurs
when
reading/writing
to the backend
communication,
pgpool-II will
trigger the
fail over
procedure. If
set to false,
pgpool will
report
an error and
disconnect the
session.</blockquote>
<div><br>
</div>
<div>Customer
has enabled
failover and
seems
following
pgpool
documentation
recommendation
to disable
"fail_over_on_backend_error"
when
"health_check_max_retries"
is being used.
As customer is
experiencing,
It is a
feature that
pgpool health
check retries
to connect to
backend server
(nodes) to
detect errors
until it
expires, then
triggers
failover if
required. When
node
disconnection
happens and
customer is
not able to
connect to
pgpool anymore
(until health
check
complete)
because of
following code
snippet i.e.</div>
<div><br>
</div>
<div>pgpool3.2.1/pool_connection_pool.c </div>
<div> 619
static
POOL_CONNECTION_POOL
*new_connection(POOL_CONNECTION_POOL
*p)</div>
<div> 620 {</div>
<div> 621
POOL_CONNECTION_POOL_SLOT
*s;</div>
<div> 622
int
active_backend_count
= 0;</div>
<div> 623
int i;</div>
<div> 624</div>
<div> 625
for
(i=0;i<NUM_BACKENDS;i++)</div>
<div> 626
{</div>
<div> 627
pool_debug("new_connection:
connecting %d
backend", i);</div>
<div> 628</div>
<div> 629
if
(!VALID_BACKEND(i))</div>
<div> 630
{</div>
<div> 631
pool_debug("new_connection:
skipping slot
%d because
backend_status
= %d",</div>
<div> 632
i,
BACKEND_INFO(i).backend_status);</div>
<div> 633
continue;</div>
<div> 634
}</div>
<div> 635</div>
<div> 636
s =
malloc(sizeof(POOL_CONNECTION_POOL_SLOT));</div>
<div> 637
if (s == NULL)</div>
<div> 638
{</div>
<div> 639
pool_error("new_connection:
malloc()
failed");</div>
<div> 640
return
NULL;</div>
<div> 641
}</div>
<div> 642</div>
<div> 643
if
(create_cp(s,
i) == NULL)</div>
<div> 644
{</div>
<div> 645
/*
connection
failed. mark
this backend
down */</div>
<div> 646
pool_error("new_connection:
create_cp()
failed");</div>
<div> 647</div>
<div> 648
/* If
fail_over_on_backend_error
is true, do
failover.</div>
<div> 649
*
Otherwise,
just exit this
session.</div>
<div> 650
*/</div>
<div> 651
if
(pool_config->fail_over_on_backend_error)</div>
<div> 652
{</div>
<div> 653
notice_backend_error(i);</div>
<div> 654
}</div>
<div> 655
child_exit(1);</div>
<div> 656
}</div>
<div><br>
</div>
<div>If there
is error in
connection to
any of the
node that have
valid status
(and
"fail_over_on_backend_error"
option is
disabled), it
abort the
child process
that is making
new connection
attempt. That
is why pgpool
is not
allowing new
connection to
pgpool when
any of node
disconnected
until node
status changed
(status change
is done via
failover/degeneration).</div>
<div><br>
</div>
<div>If
customer
enabled
"fail_over_on_backend_error"
it will solve
customer
issue. Now if
there is node
disconnection
occurs and
either health
check
complete/expires
or new
connection
attempt made,
it will
trigger
failover. </div>
<div><br>
</div>
<div>Health
check behavior
can be
observed in
pgpool 3.2.4
(latest
verison) too.
I believe it
is a pgpool
feature that
customer is
facing. Please
do let me know
if I missed
something or
any change is
required.
Thanks.</div>
</div>
<div><br>
</div>
Best Regards,
<div>Asif
Naeem<br>
<br>
<div class="gmail_quote">On
Thu, May 9,
2013 at 11:23
AM,
Venkatesulu J
<span dir="ltr"><<a href="mailto:venkatesulu.j@enterprisedb.com" target="_blank">venkatesulu.j@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr"><font color="#3366ff"><font face="verdana,sans-serif">Hi Ahsan,<br>
<br>
We have
received below
response from
the user .
Kindly comment
on this.<br>
<br>
<b>Customer's
e-mail:<br>
<br>
-Quote-<br>
</b><br>
</font></font>Thank
you for the
comment.<br>
<br>
We understood
your intention
of the
question, the
phenomenon
shouldn't have
occurred if
the failover
enabled base
on the
pgpool-II
source codes.
Is this right?<br>
<br>
Unfortunately,
it's very
difficult to
confirm about
the details of
the customer's
test case
anymore,
because the
customer has
already
concluded this
issue like the
understanding
mentioned
before. Then
based on the
customer's
conclusion,
they asked us
to raise this
story as a
bug/enhancement
report.<br>
<br>
If the fact is
different from
the customer's
understanding,
we have to
make it clear
about the
pgpool
behavior
without
customer's
feedback/comments,
and give them
some
explanations.<br>
As this issue
(originally
from the
#15058-20802)
takes very
long time,
it's about
over 3 months
since it's
opened, we
think we need
to resolve
this issue on
our side.<br>
Thank you for
your patience
and
understanding.<br>
<b><br>
-Unquote-</b><br>
<br>
<br>
<br>
-Venkat.<br>
<br>
<br>
<div class="gmail_quote">On
Wed, May 8,
2013 at 3:23
AM, Ahsan Hadi
<span dir="ltr"><<a href="mailto:ahsan.hadi@enterprisedb.com" target="_blank">ahsan.hadi@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div>Hi
Venkatesulu,</div>
<div><br>
</div>
Further to the
last update
from the
customer on
this issue,
can you check
if the
customer has
failover
enabled when
they run into
this issue? <br>
<div><br>
</div>
<div>-- Ahsan</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On
Tue, May 7,
2013 at 2:35
PM, Ahsan Hadi
<span dir="ltr"><<a href="mailto:ahsan.hadi@enterprisedb.com" target="_blank">ahsan.hadi@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div dir="ltr"><br>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">
<div>On Tue,
May 7, 2013 at
2:02 PM,
Venkatesulu J
<span dir="ltr"><<a href="mailto:venkatesulu.j@enterprisedb.com" target="_blank">venkatesulu.j@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div dir="ltr"><font color="#3366ff"><font face="verdana,sans-serif">Hi Ahsan,<br>
<br>
Do we have any
update on this
issue.<br>
</font></font></div>
</blockquote>
<div><br>
</div>
</div>
<div>Hi
Venkate,</div>
<div><br>
</div>
<div>I was
hoping Asif
would spend
sometime on
this on Monday
but he wasn't
able to since
he was trying
to wrap up
something that
was working on
since last
week. We will
surely test
this scenario
with the
latest pgpool
stable version
and this week
and get back
to you.</div>
<span><font color="#888888">
<div><br>
</div>
<div>-- Ahsan </div>
</font></span>
<div>
<div>
<div> </div>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div dir="ltr"><font color="#3366ff"><font face="verdana,sans-serif"><br>
-Venkat.<br>
<br>
<br>
</font></font><br>
<div class="gmail_quote">On
Fri, May 3,
2013 at 2:46
AM, Ahsan Hadi
<span dir="ltr"><<a href="mailto:ahsan.hadi@enterprisedb.com" target="_blank">ahsan.hadi@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div dir="ltr">We
are going to
try and test
this issue
with pgpool
3.2.3 and if
it is fixed in
that branch.
If it is still
not fixed then
we already
have an issue
reported for
this on pgpool
hackers.
<div> <br>
</div>
<div> Will
update on this
on Monday.</div>
<div> </div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On
Fri, May 3,
2013 at 12:16
AM, Abdul
Sayeed <span dir="ltr"><<a href="mailto:abdul.sayeed@enterprisedb.com" target="_blank">abdul.sayeed@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
Hi
All,
<div><br>
</div>
<div>We have
received below
update from
the customer.
Kindly advice.</div>
<div> <br>
</div>
<div><b><u>Customer's
Email:</u></b></div>
<div><br>
</div>
<div><b>-Quote-</b></div>
<div><br>
</div>
<div>
<div> Hi,</div>
<div><br>
</div>
<div>We have
got an update
on this issue
from the
customer.</div>
<div><br>
</div>
<div>According
to the
customer
saying, they
understood
that pgpool
does same
behavior
regardless of
the failure
node is master
or slave,
which means
client
requests won't
be accept when
a node failure
happens on
master/slave.</div>
<div><br>
</div>
<div>If the
customer
understanding
is right, they
ask us to
raise this
issue to
bugzilla as an
enhancement
request. If
not, tell us
please.</div>
<div><br>
</div>
<div>Thanks in
advance.</div>
<div><br>
</div>
<div> <b>-Unquote-</b></div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>Best
Regards,</div>
<div>Abdul
Sayeed</div>
<br>
<div class="gmail_quote">On
Tue, Apr 23,
2013 at 5:12
PM, Asif Naeem
<span dir="ltr"><<a href="mailto:asif.naeem@enterprisedb.com" target="_blank">asif.naeem@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div>AFAIR,
While testing
pgpool 3.2.3
with failover
enabled with
customer
scenario,
issue don't
appear any
more because
failover got
triggered when
new connection
attempt being
made, I hope
customer is
not going to
face this
issue with
pgpool 3.2.3
as per my
previous
comment on the
same email
thread i.e.</div>
<div><br>
</div>
<div>
<div>On Wed,
Feb 27, 2013
at 5:12 AM,
Asif Naeem
<<a href="mailto:asif.naeem@enterprisedb.com" target="_blank">asif.naeem@enterprisedb.com</a>>
wrote:</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
Hi,<br>
I am following
it up on the
community on
the following
issue id i.e.<br>
<a href="http://www.pgpool.net/mantisbt/view.php?id=50" target="_blank">http://www.pgpool.net/mantisbt/view.php?id=50</a><br>
pgpool-II
community
recently
released
version 3.2.3
(2013/02/18),
Main purpose
of this
release is to
fix fatal
problem with
pgpool-II
3.2.2's health
checking. Now
in the case of
fail over is
enabled it
tries to
"solve" the
customer issue
via triggering
fail over but
if fail over
is disabled it
shows same old
behavior.
Thanks.</blockquote>
</div>
<div><br>
</div>
<div>On Tue,
Apr 23, 2013
at 4:00 PM,
Abdul Sayeed <span dir="ltr"><<a href="mailto:abdul.sayeed@enterprisedb.com" target="_blank">abdul.sayeed@enterprisedb.com</a>></span>
wrote:</div>
<div>
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div><span>AFAIU
discussing it
with you and
the developer.</span><br>
<span>It
seemed to talk
about when the
DISALLOW_TO_FAILOVER
flag was set
mainly.</span><br>
<span>Besides,
the developer
said that
"It's a
feature if you
disable fail
over." as
well.</span><br>
</div>
</blockquote>
<div><br>
</div>
<div>I
continued
putting effort
for this
because EDB
don't
recommend
failover to
customers.
Thanks.</div>
<div> </div>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div><span><a href="http://www.sraoss.jp/pipermail/pgpool-hackers/2013-April/000185.html" target="_blank">http://www.sraoss.jp/pipermail/pgpool-hackers/2013-April/000185.html</a></span><br>
<br>
<span>However,
the customer
didn't get the
meaning and
the point of
the
discussion,</span><br>
<span>because
the actual
customer's
configuration
is
ALLOW_TO_FAILOVER.</span><br>
<span>Then
they didn't
see the reason
/ senario why
they faced to
have been
waiting</span><br>
<span>until
the
health_check
was finished. </span><br>
<br>
<span>As far
as we SIOS
looked at the
source code
mentioned
below, the
reason</span><br>
<span>seemed
because of
prallel_mode
setting which
is off on
their
configuration.</span><br>
<br>
<span>./pgpool-II-3.2.1/main.c</span><br>
<span>---</span><br>
<span>757 if
(!pool_config->parallel_mode)</span><br>
<span>758 {</span><br>
<span>759 if
(POOL_DISALLOW_TO_FAILOVER(BACKEND_INFO(sts).flag))</span><br>
<span>760 {</span><br>
<span>761
pool_log("health_check:
%d failover is
canceld
because
failover is
disallowed",
sts);</span><br>
<span>762 }</span><br>
<span>763 else
if (retrycnt
<=
pool_config->health_check_max_retries)</span><br>
<span>764 {</span><br>
<span>765 /*
continue to
retry */</span><br>
<span>766
sleep_time =
pool_config->health_check_retry_delay;</span><br>
<span>767
pool_log("health
check retry
sleep time: %d
second(s)",
sleep_time);</span><br>
<span>768
pool_sleep(sleep_time);</span><br>
<span>769
retrying =
true;</span><br>
<span>770
continue;</span><br>
<span>771 }</span><br>
<span>(snip)</span><br>
<span>---</span><br>
<br>
<span>If our
understanding
is wrong, tell
us please.
Then kindly
tell us the</span><br>
<span>reason
or scenario
why the
customer were
waiting until
the
health_check</span><br>
<span>was
finished.</span><br>
<br>
<b>-Quote-</b></div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>Best
Regards,</div>
<div>Abdul
Sayeed</div>
<div><br>
</div>
<div><br>
<div class="gmail_quote">On
Thu, Apr 11,
2013 at 1:10
PM, Arshu
Arora <span dir="ltr"><<a href="mailto:arshu.arora@enterprisedb.com" target="_blank">arshu.arora@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
Thanks
Ahsan.<br>
<br>
We will share
this with SIOS
and will
update you
with their
feedback.<br>
<br>
Regards,<br>
Arshu<br>
<br>
<div class="gmail_quote">On
Thu, Apr 11,
2013 at 1:07
PM, Ahsan Hadi
<span dir="ltr"><<a href="mailto:ahsan.hadi@enterprisedb.com" target="_blank">ahsan.hadi@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div dir="ltr">Hi
Deepanshu,
<div><br>
</div>
<div>Is there
anything more
to be done on
this from our
end? As per
the discussion
on hackers,
the behavior
that the
customer is
seeing is
expected when
fail over is
disabled.</div>
<div><br>
</div>
<div>regards,</div>
<div><br>
</div>
<div>Ahsan</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On
Thu, Apr 11,
2013 at 10:29
AM, Asif Naeem
<span dir="ltr"><<a href="mailto:asif.naeem@enterprisedb.com" target="_blank">asif.naeem@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div>Failover
seems only
available
option i.e.</div>
<div><br>
</div>
<div><a href="http://www.pgpool.net/pipermail/pgpool-hackers/2013-April/000196.html" target="_blank">http://www.pgpool.net/pipermail/pgpool-hackers/2013-April/000196.html</a></div>
<div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
>
AFAIU
discussing it
with you that
it is a
feature not a
bug. In the<br>
> presented
scenario, If
any of slave
got down or
missing (
maybe because
of<br>
> network
issue ), until
it become
available/up
again, pgpool
will be non<br>
>
responsive to
any new
connection
(with no
warning or
message). Do
you agree<br>
> ?.
Thanks.<br>
It's a feature
if you disable
fail over.<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc.
Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a></blockquote>
</div>
<div><br>
</div>
<div>Please do
let me know if
I missed
something or
any more info
is required.
Thanks.</div>
<div><br>
</div>
Best Regards,
<div>Asif
Naeem<br>
<br>
<div class="gmail_quote">On
Mon, Apr 8,
2013 at 1:59
PM, Asif Naeem
<span dir="ltr"><<a href="mailto:asif.naeem@enterprisedb.com" target="_blank">asif.naeem@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div>Hi
Deepanshu,</div>
<div><br>
</div>
<div>Sorry for
delay, I was
working on
other tasks. I
have looked at
the latest
pgpool2
(3.2.3) source
code, failover
seems the only
option that
can help in
customer issue
(Although it
seems that EDB
don't
recommend
failover). I
have postted
my findings on
pgpool-hackers
available at
i.e.</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<a href="http://www.pgpool.net/pipermail/pgpool-hackers/2013-April/000185.html" target="_blank">http://www.pgpool.net/pipermail/pgpool-hackers/2013-April/000185.html</a></blockquote>
<div><br>
</div>
<div>Please do
let me know if
I missed
something or
any info is
required.
Thanks.</div>
<div><br>
</div>
Best Regards,
<div>Asif
Naeem<br>
<br>
<div class="gmail_quote">On
Sat, Apr 6,
2013 at 11:58
PM, Deepanshu
Sharma <span dir="ltr"><<a href="mailto:deepanshu.sharma@enterprisedb.com" target="_blank">deepanshu.sharma@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div style="word-wrap:break-word">Hi
Asif,
<div><br>
</div>
<div>Would it
be possible
for you to
share with is
the link to
the post at
which this
issues is
being
discussed on
PGpool
Hackers.</div>
<div><br>
</div>
<div>Regards,</div>
<div>Deepanshu<br>
<div>
<div>
<div>On Mar
29, 2013, at
9:58 AM, Ahsan
Hadi wrote:</div>
<br>
<blockquote type="cite">Hi
Deepanshu,
<div><br>
</div>
<div><br>
<div class="gmail_quote">On
Fri, Mar 29,
2013 at 1:32
AM, Deepanshu
Sharma <span dir="ltr"><<a href="mailto:deepanshu.sharma@enterprisedb.com" target="_blank">deepanshu.sharma@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div style="word-wrap:break-word">
Hi,
<div><br>
</div>
<div>Is there
any progress
on this?</div>
<div>Looking
at <a href="http://www.pgpool.net/mantisbt/view.php?id=50" target="_blank">http://www.pgpool.net/mantisbt/view.php?id=50</a>
the patch
seems to have
been rejected.</div>
</div>
</blockquote>
<div><br>
</div>
<div>Yes the
patches
submitted so
far have an
issue which
needs to
progressed
further on
pgpool-hackers.
I believe Asif
submitted
those patches
to the
hackers. In
any case we
are going to
spend more
time on this
issue next
week to
address the
issues raised
in the patch.</div>
<div> </div>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div style="word-wrap:break-word">
<div><br>
</div>
<div>Reagards,</div>
<div>Deepanshu<br>
<div>
<div>On Mar
15, 2013, at
4:58 PM, Ahsan
Hadi wrote:</div>
<br>
<blockquote type="cite">
<div dir="ltr">There
is some
traction on
this in the
community,
Takatsuru-san
has looked at
the patches
submitted by
Asif and
posted an
issue caused
by the patch.
We are going
to move the
discussion to
pgpool hackers
as suggested
by Takatsuru
and work on
the issue
identified by
him.<br>
<br>
<div class="gmail_quote">On
Wed, Mar 13,
2013 at 2:02
PM, Ahsan Hadi
<span dir="ltr"><<a href="mailto:ahsan.hadi@enterprisedb.com" target="_blank">ahsan.hadi@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div dir="ltr"><br>
<br>
<div class="gmail_quote">On
Wed, Mar 13,
2013 at 2:30
PM, Asif Naeem
<span dir="ltr"><<a href="mailto:asif.naeem@enterprisedb.com" target="_blank">asif.naeem@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
On
Wed, Mar 13,
2013 at 1:36
PM, Katsuji
Takatsuru <span dir="ltr"><<a href="mailto:katsuji.takatsuru@enterprisedb.com" target="_blank">katsuji.takatsuru@enterprisedb.com</a>></span> wrote:<br>
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div style="word-wrap:break-word">
<div>Hi Ahsan,</div>
<div>cc om,</div>
<div><br>
</div>
<div> As
Fujita-san
said,
Ishii-san did
not know that
a patch for
this issue had
posted into
the community.</div>
<div> We asked
him if this
patch is
acceptable,
and he is
going to do.</div>
<div> So, can
you please
tell me any
number that he
can identify
your request?</div>
</div>
</blockquote>
<div><br>
</div>
<div>
<div>Hi
Katsuji,</div>
<div><br>
</div>
<div>Related
issue is
logged as ID:
<a href="http://www.pgpool.net/mantisbt/view.php?id=50" target="_blank">0000050</a> on pgpool
Bug Tracker.
Thanks. </div>
</div>
</div>
</blockquote>
<div><br>
</div>
<div>There are
couple of
patches
submitted by
Asif on this
thread that
needs to be
reviewed.</div>
<div> </div>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div class="gmail_quote">
<div>
<div><br>
</div>
<div>Best
Regards,</div>
<div>Asif
Naeem</div>
</div>
<div> </div>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div style="word-wrap:break-word">
<div> </div>
<div>Best
Regards,</div>
<div>Katsuji</div>
<br>
<div>
<div>On
2013/03/13, at
11:48, Yuji
<<a href="mailto:yuji.fujita@enterprisedb.com" target="_blank">yuji.fujita@enterprisedb.com</a>>
wrote:</div>
<br>
<blockquote type="cite">
<div bgcolor="#FFFFFF" text="#000000">
<div>Hi Ahsan,<br>
cc Tom,<br>
<br>
Thank you very
much.<br>
Takatsuru-san
and I had the
meeting with
Ishii-san and
his team
yesterday<br>
and he would
like to know
the id or bug
number that he
can identify
on his pgpool
web site.<br>
He looks he
was not aware
of it.<br>
<br>
Takatsuru-san
will send you
the follow up
e-mail on
this.<br>
Will you
respond to his
quesry?<br>
So that he
will
communicate
this with
Ishii-san
directly.<br>
<br>
Thanks<br>
Yuji<br>
<br>
(2013/03/13
11:42), Ahsan
Hadi wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr"><br>
<br>
<div class="gmail_quote">On
Tue, Mar 12,
2013 at 2:03
AM, Tom
Kincaid <span dir="ltr"><<a href="mailto:tom.kincaid@enterprisedb.com" target="_blank">tom.kincaid@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div><br>
</div>
Thank you
Yuji,
<div><br>
</div>
<div>We just
need Ishii to
have somebody
look at the
patch Asif
Rana submitted
to the
community.</div>
</blockquote>
<div><br>
</div>
<div>Asif
Naeem
submitted the
patch..</div>
<div> </div>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div><br>
<br>
<div class="gmail_quote">
On Mon, Mar
11, 2013 at
4:59 PM, Yuji
<span dir="ltr"><<a href="mailto:yuji.fujita@enterprisedb.com" target="_blank">yuji.fujita@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>Hi Tom,<br>
<br>
This is Yuji.<br>
Takatsuru-san,SE,
and myself
happens to
have the
meeting with
Ishii-san this
afternoon.<br>
We could talk
on this from
our end as
well.<br>
<br>
Takatsuru-san
will be able
to update you
on the
technical
side.<br>
<br>
Thank you for
working on
this.<br>
<br>
Yuji<br>
<br>
<br>
<br>
(2013/03/11
23:45), Tom
Kincaid wrote:<br>
</div>
<blockquote type="cite">
<div><br>
</div>
OK, can
somebody send
a message
to "Tatsuo
Ishii" <<a href="mailto:ishii@sraoss.co.jp" target="_blank">ishii@sraoss.co.jp</a>>
asking for the
community to
review that
patch?
<div><br>
<br>
<div class="gmail_quote">
On Mon, Mar
11, 2013 at
10:29 AM,
Ahsan Hadi <span dir="ltr"><<a href="mailto:ahsan.hadi@enterprisedb.com" target="_blank">ahsan.hadi@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div dir="ltr"><br>
<br>
<div class="gmail_quote">On
Mon, Mar 11,
2013 at 5:15
PM, Tom
Kincaid <span dir="ltr"><<a href="mailto:tom.kincaid@enterprisedb.com" target="_blank">tom.kincaid@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div><br>
</div>
Ahsan / Asif?
<div>
<div>
<div><br>
</div>
</div>
</div>
</blockquote>
<div> </div>
<div> Hi Tom,</div>
<div><br>
</div>
<div>We have
created a
redmine case
for this
"30138", there
is a possible
patch for this
issue which is
attached in
the redmine
case. This
patch is also
submitted to
the community
but it is not
checked in
yet.</div>
<div><br>
</div>
<div>Robert or
Bruce can take
a look at this
patch and
share there
thoughts.
Meanwhile Asif
is following
this up with
the community
and also
testing the
patch in more
detail.</div>
<div> </div>
<div>Thanks,</div>
<div><br>
</div>
<div>-- Ahsan</div>
<div>
<div>
<div> </div>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div>
<div>
<div><br>
<br>
<div class="gmail_quote">
On Sun, Mar
10, 2013 at
11:38 PM,
Naveed Shaikh
<span dir="ltr"><<a href="mailto:naveed.shaikh@enterprisedb.com" target="_blank">naveed.shaikh@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div>
<div>Hi All,</div>
<div><br>
</div>
<div>Do we
have any
updates on
this issue.</div>
<div><br>
</div>
</div>
--<br clear="all">
<div>
<div dir="ltr">
<div>
<div>
<div>Thanks
& Regards,</div>
<div>Naveed
Shaikh</div>
</div>
<div>
<div>EnterpriseDB
Corporation</div>
<div>The
Enterprise
PostgreSQL
Company</div>
<div><br>
</div>
<div>To reach
Support Call:</div>
<div>US: <a href="tel:%2B1-732-331-1320" value="+17323311320" target="_blank">+1-732-331-1320</a>
- UK: <a href="tel:%2B44%20-%202033719820" value="+442033719820" target="_blank">+44
- 2033719820</a></div>
<div>Brazil: <a href="tel:%2B55-2139581371" value="+552139581371" target="_blank">+55-2139581371</a> - India: <a href="tel:%2B91-20-30589491" value="+912030589491" target="_blank">+91-20-30589491</a></div>
<div><br>
</div>
<div> Website:
<a href="http://www.enterprisedb.com/" target="_blank">www.enterprisedb.com</a></div>
<div>EnterpriseDB
Blog: <a href="http://blogs.enterprisedb.com/" target="_blank">http://blogs.enterprisedb.com</a></div>
<div>Follow us
on Twitter: <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a></div>
<div><br>
</div>
</div>
<div>
<div>This
e-mail message
(and any
attachment) is
intended for
the use of the
individual or
entity to whom
it is
addressed.
This message
contains
information
from
EnterpriseDB
Corporation
that may be
privileged,
confidential,
or exempt from
disclosure
under
applicable
law. If you
are not the
intended
recipient or
authorized to
receive this
for the
intended
recipient, any
use,
dissemination,
distribution,
retention,
archiving, or
copying of
this
communication
is strictly
prohibited. If
you have
received this
e-mail in
error, please
notify the
sender
immediately by
reply e-mail
and delete
this message.</div>
</div>
</div>
</div>
</div>
<div>
<div> <br>
<br>
<div class="gmail_quote">On
Mon, Mar 4,
2013 at 5:50
PM, Ahsan Hadi
<span dir="ltr"><<a href="mailto:ahsan.hadi@enterprisedb.com" target="_blank">ahsan.hadi@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
Hi Arshu,
<div><br>
</div>
<div>Asif
Naeem had
submitted a
patch to the
community
which seem to
have fixed
this issue
"cannot
connect to
master when
slave shuts
down abruptly and
health-check
is in
progress".
There has been
some
discussion on
the community
since then but
it seems that
the community
is not
responding
very promptly
on this.</div>
<div><br>
</div>
<div>I have
asked Asif to
follow-up with
the community
on this issue.
In the
meantime we
can test our
patch to get a
higher comfort
level that it
doesn't break
anything else.</div>
<div><br>
</div>
<div>Thanks,</div>
<div>Ahsan</div>
<div>
<div>
<div> </div>
<div><br>
<br>
<div class="gmail_quote">On
Mon, Mar 4,
2013 at 4:19
PM, Arshu
Arora <span dir="ltr"><<a href="mailto:arshu.arora@enterprisedb.com" target="_blank">arshu.arora@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
Hi
all,<br>
<br>
We have
received a
below feedback
from the user.<br>
<br>
<b>Quote:</b><br>
<br>
<span>Hi
EnterpriseDB
team,</span><br>
<br>
<span>We've
got a feedback
from the
customer.</span><br>
<br>
<span>***
business
impact of this
issue ***</span><br>
<br>
<span>The
system facing
to this issue
is now
providing
commercial
service,</span><br>
<span>which is
mobile phone
remote
management
service
actually.</span><br>
<span>Besides,
the number of
users on the
service is
about
30,000,000,
and</span><br>
<span>the
company
providing the
service is
Softbank
mobile as you
might have
been already
known.</span><br>
<br>
<span>According
to the end
user's saying,
since the
system is
providing the
service for</span><br>
<span>24/7/365,
if there's a
service
unavailable
hours they
might be
accused of
something</span><br>
<span>for it.
Therefore they
recognized the
bug as serious
problem.</span><br>
<br>
<span>So we'd
like you to
think about
priority
redefinition
of this issue.</span><br>
<br>
<b>Unquote:</b><br>
<br>
Regards,<br>
Arshu
<div>
<div><br>
<br>
<div class="gmail_quote">On
Fri, Mar 1,
2013 at 1:45
AM, Deepanshu
Sharma <span dir="ltr"><<a href="mailto:deepanshu.sharma@enterprisedb.com" target="_blank">deepanshu.sharma@enterprisedb.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div style="word-wrap:break-word">Adding Katsuji
Takatsu in the
mail chain
he is working
with Yuji on
this.
<div><br>
</div>
<div>Regards,</div>
<div>Deepanshu
<div>
<div><br>
<div>
<div>On Feb
28, 2013, at
3:29 PM,
Deepanshu
Sharma wrote:</div>
<br>
<blockquote type="cite">
<div style="word-wrap:break-word">Hi
Tom,
<div><br>
</div>
<div>We had
requested Yuji
to get in
touch with the
client in
order to gage
the priority
of the issue
and he has
comeback
stating that
having a fix
for this is
critical for
them.</div>
<div>I am
adding Yuji to
this mail
chain for his
inputs.</div>
<div><br>
</div>
<div>Regards,</div>
<div>Deepanshu <br>
<div>
<div>On Feb
27, 2013, at
7:23 PM, Asif
Naeem wrote:</div>
<br>
<blockquote type="cite"><br>
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
Do
you have
visibility
into other
issues that
fixed in this
release? If
there are a
large number
of low risk
fixes on other
fronts I would
like to see if
we can get
those through
our system.</blockquote>
<div><br>
</div>
<div>Hi Tom,</div>
<div><br>
</div>
<div>According
to <a href="http://www.pgpool.net/docs/pgpool-II-3.2.3/NEWS.txt" target="_blank">pgpool-II
3.2.3 release
note</a>, there
are the
following
fixes in this
release i.e. </div>
<div> <br>
</div>
<div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
* Version
3.2.3<br>
This is
a bug fix
release
against
pgpool-II
3.2.2. Main
purpose<br>
of this
release is to
fix fatal
problem with
pgpool-II
3.2.2's<br>
health
checking. If
all of
following
conditions are
met, pgpool<br>
main
process
disappeared
and all client
connections to
pgpool-II<br>
hang
forever when
failover
happens. And
the only way
to recover<br>
from it
is, manualy
killing the
pgpool child
process and
restart<br>
pgpool-II.<br>
- health
checking is
enabled<br>
-
connecting
method to
PostgreSQL is
TCP/IP, not
UNIX domain<br>
socket(i.e.
"backend_hostnameN"
is not empty
string)<br>
__________________________________________________________________<br>
* Bug fixes<br>
- Fix
connect_inet_domain_socket_by_port()
bug introduced
in<br>
3.2.2.
(Tatsuo Ishii)<br>
When non
blocking
connect()
reports
EINPROGRESS or
EALREADY, it<br>
calls
select(2) to
wait for read
or write fd
ready. However
it<br>
mistakenly
checks error
condition
using
getsockopt().
It should<br>
be
called when
select()
returns >
0, rather than
0. Because of<br>
this,
connect_inet_domain_socket_by_port()
could return<br>
succeeded fd
even it
actually
failed.<br>
And what
is worse, this
health_check()
mistakenly
believes that<br>
backend
is alive and
tries to write
to backend
socket, which
of<br>
course
fails. This
triggers to
call
notice_backend_error(),<br>
which
sends SIGUSR1
signal to
pgpool main's
parent
process. This<br>
will
result in
various weird
things: for
example, <b>if
you start<br>
pgpool
from a shell,
the signal
kills the
shell.</b> If
you start<br>
pgpool
in background,
pgpool's
parent is the
process #1. As
long<br>
as you
started pgpool
as non root,
it's ok. Even
if you start<br>
pgpool
as root, init
just reopens
/dev/initctl
by receiving<br>
SIGUSR1.
These all
annoying bugs
have been
there since
pgpool<br>
was
born. The
connect_inet_domain_socket_by_port()
bug just<br>
reveals
it. To fix
this, I
modified
notice_backend_error
and<br>
child_exit()
so that it
does nothing
when called
from pgpool<br>
main
process itself
to prevent
pgpool from
shooting
itself in<br>
the
foot.<br>
- Fix to
show
pool_passwd in
"SHOW
pool_status".
(Yugo Nagata)<br>
- Fix a
typo at
configure's
help in <a href="http://configure.in/" target="_blank">configure.in</a>. (Yugo
Nagata)</blockquote>
</div>
<div><br>
</div>
<div>While
working on
this issue, it
was
really uncomfortable
when pgpool
keep killing
my shell that
I used to run
it. They fixed
it in 3.2.3
version.
Thanks.</div>
<div><br>
</div>
<div>Best
Regards,</div>
<div>Asif
Naeem</div>
<div> </div>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div>Thanks,</div>
<div>Tom<br>
<div> <br>
</div>
<div>
<div>
<div><br>
<br>
<div class="gmail_quote">On
Wed, Feb 27,
2013 at 5:12
AM, Asif Naeem
<<a href="mailto:asif.naeem@enterprisedb.com" target="_blank">asif.naeem@enterprisedb.com</a>>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
Hi,
I am
following it
up on the
community on
the following
issue id i.e.
<a href="http://www.pgpool.net/mantisbt/view.php?id=50" target="_blank">http://www.pgpool.net/mantisbt/view.php?id=50</a>
pgpool-II
community
recently
released
version 3.2.3
(2013/02/18),
Main purpose
of this
release is to
fix fatal
problem with
pgpool-II
3.2.2's health
checking. Now
in the case of
fail over is
enabled it
tries to
"solve" the
customer issue
via triggering
fail over but
if fail over
is disabled it
shows same
old behavior.
Thanks.
Best
Regards,
Asif
Naeem
On Wed,
Feb 27, 2013
at 2:46 PM,
Ahsan Hadi
<<a href="mailto:ahsan.hadi@enterprisedb.com" target="_blank">ahsan.hadi@enterprisedb.com</a>>
wrote: Asif
Naeem has bee
following up
on this issue
with the
community.
Adding Asif
for an update.
On Wed, Feb
27, 2013 at
2:40 PM, Arshu
Arora
<<a href="mailto:arshu.arora@enterprisedb.com" target="_blank">arshu.arora@enterprisedb.com</a>>
wrote: Hi
Bruce, Would
it possible
for you to
give some
inputs on this
issue. Below
is the issue
reported: We
have received
below pgpool
request from
one of our
Partner
Customer(SIOS
Technology,Inc).
OS version:
RHEL5.5 x86_64
Product
Version: PPAS
9.2.1.3 Pgpool
Version:
pgpool-II-3.2.1
Issue
Reported: When
load_balance
mode is on and
slave is down,
we can not
connect to
pgpool even
master is up.
Customer's
Email: Kindly
let us ask you
about
pgpool-II
behavior.
(Conditions)
DB : PPAS
9.2.1.3 OS :
RHEL5.5 x86_64
Server: HP
ProLiant
BL460c G7 x 2
* Streaming
Replication
(async)
Master/Slave
configuration
(Phenomenon)
When the slave
server got an
error during
the
healthcheck
retries
function
enabled,
pgpool
requests in
spite of
select or
update query
won't be
accepted any
more during
the
healthcheck is
trying to
retry. (Reason
why they ask
you) The
customer think
that the
phenomenon
(can't access
to the
database)
shouldn't be
happened even
though it's
master/slave
configuration,
besides
enabling the
helthcheck
retries
function is
required for
their system
not to
disconnect to
the DB even
when an
instantaneous
network
interruption
is happened.
(Additional
info)
According to
the customer
saying based
on their
investigation
of the
pgpool-II-3.2.1
source codes,
it seemed that
a connection
to the slave
node also
happens when
an user
requests to
connect to the
master node
during the
slave node is
getting error.
Then if the
connection
request fails,
users can't
connect to the
pgpool any
more. The
corresponding
source codes
of the
phenomenon ---
pool_connection_pool.c
static
POOL_CONNECTION_POOL
*new_connection(POOL_CONNECTION_POOL
*p) {
POOL_CONNECTION_POOL_SLOT
*s; int
active_backend_count
= 0; int i;
for
(i=0;i<NUM_BACKENDS;i++)
{
pool_debug("new_connection:
connecting %d
backend", i);
if
(!VALID_BACKEND(i))
{
pool_debug("new_connection:
skipping slot
%d because
backend_status
= %d", i,
BACKEND_INFO(i).backend_status);
continue; } s
=
malloc(sizeof(POOL_CONNECTION_POOL_SLOT));
if (s == NULL)
{
pool_error("new_connection:
malloc()
failed");
return NULL; }
if
(create_cp(s,
i) == NULL) {
/* connection
failed. mark
this backend
down */
pool_error("new_connection:
create_cp()
failed"); /*
If fail_over_
</blockquote>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</blockquote>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
...<br>
<br>
[Message
clipped] </blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
Ahsan Hadi<br>
Snr Director
Product
Development<br>
EnterpriseDB
Corporation<br>
The Enterprise
Postgres
Company<br>
<br>
Phone: <a href="tel:%2B92-51-8358874" value="+92518358874" target="_blank">+92-51-8358874</a>
<br>
Mobile: <a href="tel:%2B92-333-5162114" value="+923335162114" target="_blank">+92-333-5162114</a><br>
<br>
Website: <a href="http://www.enterprisedb.com" target="_blank">www.enterprisedb.com</a><br>
EnterpriseDB
Blog: <a href="http://blogs.enterprisedb.com/" target="_blank">http://blogs.enterprisedb.com/</a><br>
Follow us on
Twitter: <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a><br>
<br>
This e-mail
message (and
any
attachment) is
intended for
the use of the
individual or
entity to whom
it is
addressed.
This message
contains
information
from
EnterpriseDB
Corporation
that may be
privileged,
confidential,
or exempt from
disclosure
under
applicable
law. If you
are not the
intended
recipient or
authorized to
receive this
for the
intended
recipient, any
use,
dissemination,
distribution,
retention,
archiving, or
copying of
this
communication
is strictly
prohibited. If
you have
received this
e-mail in
error, please
notify the
sender
immediately by
reply e-mail
and delete
this message.
</div>
</blockquote>
</div>
<br>
<br clear="all">
<br>
-- <br>
<div dir="ltr"><span>Thanks
& Regards,<br>
Venkatesulu.J.D<br>
EnterpriseDB
Corporation<br>
The Enterprise
PostgreSQL
Company<br>
<p style="margin:0px;font-style:normal;font-variant:normal;font-weight:normal;font-size:13px;line-height:normal;font-family:Arial;min-height:15px">
<font color="#232323"><br>
</font></p>
<p style="margin:0px;font-style:normal;font-variant:normal;font-weight:normal;font-size:13px;line-height:normal;font-family:Arial;color:rgb(35,35,35)">To
reach Support
Call:</p>
<p style="margin:0px;font-style:normal;font-variant:normal;font-weight:normal;font-size:13px;line-height:normal;font-family:Arial;color:rgb(35,35,35)">US:
<a href="tel:%2B1-732-331-1320" value="+17323311320" target="_blank">+1-732-331-1320</a> -
UK: <a href="tel:%2B44%20-%202033719820" value="+442033719820" target="_blank">+44
- 2033719820</a></p>
<p style="margin:0px;font-style:normal;font-variant:normal;font-weight:normal;font-size:13px;line-height:normal;font-family:Arial;color:rgb(35,35,35)">Brazil:
<a href="tel:%2B55-2139581371" value="+552139581371" target="_blank">+55-2139581371</a>
- India: <a href="tel:%2B91-20-30589491" value="+912030589491" target="_blank">+91-20-30589491</a></p>
<p style="margin:0px;font-style:normal;font-variant:normal;font-weight:normal;font-size:13px;line-height:normal;font-family:Arial;color:rgb(35,35,35);min-height:15px">
<br>
</p>
Website: <a href="http://www.enterprisedb.com/" target="_blank">www.enterprisedb.com</a><br>
EnterpriseDB
Blog: <a href="http://blogs.enterprisedb.com/" target="_blank">http://blogs.enterprisedb.com</a><br>
Follow us on
Twitter: <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a><br>
<br>
<span style="border-collapse:collapse"><i>This
e-mail message
(and any
attachment) is
intended for
the use of the
individual or
entity to whom
it is
addressed.
This message
contains
information
from
EnterpriseDB
Corporation
that may be
privileged,
confidential,
or exempt from
disclosure
under
applicable
law. If you
are not the
intended
recipient or
authorized to
receive this
for the
intended
recipient, any
use,
dissemination,
distribution,
retention,
archiving, or
copying of
this
communication
is strictly
prohibited. If
you have
received this
e-mail in
error, please
notify the
sender
immediately by
reply e-mail
and delete
this message</i></span><span><i>.</i></span></span><br>
<p><br>
</p>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
<br>
</div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr"><span>Thanks
& Regards,<br>
Venkatesulu.J.D<br>
EnterpriseDB
Corporation<br>
The Enterprise
PostgreSQL
Company<br>
<p style="margin:0px;font-style:normal;font-variant:normal;font-weight:normal;font-size:13px;line-height:normal;font-family:Arial;min-height:15px">
<font color="#232323"><br>
</font></p>
<p style="margin:0px;font-style:normal;font-variant:normal;font-weight:normal;font-size:13px;line-height:normal;font-family:Arial;color:rgb(35,35,35)">To
reach Support
Call:</p>
<p style="margin:0px;font-style:normal;font-variant:normal;font-weight:normal;font-size:13px;line-height:normal;font-family:Arial;color:rgb(35,35,35)">US:
<a href="tel:%2B1-732-331-1320" value="+17323311320" target="_blank">+1-732-331-1320</a> -
UK: <a href="tel:%2B44%20-%202033719820" value="+442033719820" target="_blank">+44
- 2033719820</a></p>
<p style="margin:0px;font-style:normal;font-variant:normal;font-weight:normal;font-size:13px;line-height:normal;font-family:Arial;color:rgb(35,35,35)">Brazil:
<a href="tel:%2B55-2139581371" value="+552139581371" target="_blank">+55-2139581371</a>
- India: <a href="tel:%2B91-20-30589491" value="+912030589491" target="_blank">+91-20-30589491</a></p>
<p style="margin:0px;font-style:normal;font-variant:normal;font-weight:normal;font-size:13px;line-height:normal;font-family:Arial;color:rgb(35,35,35);min-height:15px">
<br>
</p>
Website: <a href="http://www.enterprisedb.com/" target="_blank">www.enterprisedb.com</a><br>
EnterpriseDB
Blog: <a href="http://blogs.enterprisedb.com/" target="_blank">http://blogs.enterprisedb.com</a><br>
Follow us on
Twitter: <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a><br>
<br>
<span style="border-collapse:collapse"><em>This
e-mail message
(and any
attachment) is
intended for
the use of the
individual or
entity to whom
it is
addressed.
This message
contains
information
from
EnterpriseDB
Corporation
that may be
privileged,
confidential,
or exempt from
disclosure
under
applicable
law. If you
are not the
intended
recipient or
authorized to
receive this
for the
intended
recipient, any
use,
dissemination,
distribution,
retention,
archiving, or
copying of
this
communication
is strictly
prohibited. If
you have
received this
e-mail in
error, please
notify the
sender
immediately by
reply e-mail
and delete
this message</em></span><span><em>.</em></span></span><br>
<p><br>
</p>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
Ahsan Hadi<br>
Snr Director
Product
Development<br>
EnterpriseDB
Corporation<br>
The Enterprise
Postgres
Company<br>
<br>
Phone: <a href="tel:%2B92-51-8358874" value="+92518358874" target="_blank">+92-51-8358874</a>
<br>
Mobile: <a href="tel:%2B92-333-5162114" value="+923335162114" target="_blank">+92-333-5162114</a><br>
<br>
Website: <a href="http://www.enterprisedb.com" target="_blank">www.enterprisedb.com</a><br>
EnterpriseDB
Blog: <a href="http://blogs.enterprisedb.com/" target="_blank">http://blogs.enterprisedb.com/</a><br>
Follow us on
Twitter: <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a><br>
<br>
This e-mail
message (and
any
attachment) is
intended for
the use of the
individual or
entity to whom
it is
addressed.
This message
contains
information
from
EnterpriseDB
Corporation
that may be
privileged,
confidential,
or exempt from
disclosure
under
applicable
law. If you
are not the
intended
recipient or
authorized to
receive this
for the
intended
recipient, any
use,
dissemination,
distribution,
retention,
archiving, or
copying of
this
communication
is strictly
prohibited. If
you have
received this
e-mail in
error, please
notify the
sender
immediately by
reply e-mail
and delete
this message.
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<div><span>Thanks
& Regards,</span></div>
<div><span>Baji
Shaik,</span></div>
<span>EnterpriseDB
Corporation,</span><br>
<span>The
Postgres
Database
Company.</span><br>
<br>
<span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif">To
reach Support
Call:</span><br style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif">US </span><a href="tel:%2B1-732-331-1320" value="+17323311320" target="_blank">+1-732-331-1320</a><span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif"> or </span><a href="tel:1-800-235-5891" value="+18002355891" target="_blank">1-800-235-5891</a><span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif"> </span><br style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif">UK </span><a href="tel:%2B44-2033%207198%2020" value="+442033719820" target="_blank">+44-2033 7198 20</a><span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif"> -
BRAZIL</span><a href="tel:%2B55-2129%205813%2071" value="+552129581371" target="_blank">+55-2129 5813 71</a><span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif"> -
INDIA</span><a href="tel:%2B91-20-32677197" value="+912032677197" target="_blank">+91-20-32677197</a><span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif">.</span>
<div> <font color="#222222" face="arial,
sans-serif"><br>
</font><span>Website: </span><a href="http://www.enterprisedb.com/" target="_blank">www.enterprisedb.com</a><br>
<span>EnterpriseDB
Blog : </span><a href="http://blogs.enterprisedb.com/" target="_blank">http://blogs.enterprisedb.com</a><br>
<span>Follow
us on Twitter
: </span><a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a><br>
<br>
<span>This
e-mail message
(and any
attachment) is
intended for
the use of the
individual or
entity to whom
it is
addressed.
This message
contains
information
from
EnterpriseDB
Corporation
that may be
privileged,
confidential,
or exempt from
disclosure
under
applicable
law. If you
are not the
intended
recipient or
authorized to
receive this
for the
intended
recipient, any
use,
dissemination,
distribution,retention,
archiving, or
copying of
this
communication
is strictly
prohibited. If
you have
received this
e-mail in
error, please
notify the
sender
immediately by
reply e-mail
and delete
this message.</span></div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
Ahsan Hadi<br>
Snr Director
Product
Development<br>
EnterpriseDB
Corporation<br>
The Enterprise
Postgres
Company<br>
<br>
Phone: <a href="tel:%2B92-51-8358874" value="+92518358874" target="_blank">+92-51-8358874</a>
<br>
Mobile: <a href="tel:%2B92-333-5162114" value="+923335162114" target="_blank">+92-333-5162114</a><br>
<br>
Website: <a href="http://www.enterprisedb.com" target="_blank">www.enterprisedb.com</a><br>
EnterpriseDB
Blog: <a href="http://blogs.enterprisedb.com/" target="_blank">http://blogs.enterprisedb.com/</a><br>
Follow us on
Twitter: <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a><br>
<br>
This e-mail
message (and
any
attachment) is
intended for
the use of the
individual or
entity to whom
it is
addressed.
This message
contains
information
from
EnterpriseDB
Corporation
that may be
privileged,
confidential,
or exempt from
disclosure
under
applicable
law. If you
are not the
intended
recipient or
authorized to
receive this
for the
intended
recipient, any
use,
dissemination,
distribution,
retention,
archiving, or
copying of
this
communication
is strictly
prohibited. If
you have
received this
e-mail in
error, please
notify the
sender
immediately by
reply e-mail
and delete
this message.
</div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
Ahsan Hadi<br>
Snr Director
Product
Development<br>
EnterpriseDB
Corporation<br>
The Enterprise
Postgres
Company<br>
<br>
Phone: <a href="tel:%2B92-51-8358874" value="+92518358874" target="_blank">+92-51-8358874</a>
<br>
Mobile: <a href="tel:%2B92-333-5162114" value="+923335162114" target="_blank">+92-333-5162114</a><br>
<br>
Website: <a href="http://www.enterprisedb.com" target="_blank">www.enterprisedb.com</a><br>
EnterpriseDB
Blog: <a href="http://blogs.enterprisedb.com/" target="_blank">http://blogs.enterprisedb.com/</a><br>
Follow us on
Twitter: <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a><br>
<br>
This e-mail
message (and
any
attachment) is
intended for
the use of the
individual or
entity to whom
it is
addressed.
This message
contains
information
from
EnterpriseDB
Corporation
that may be
privileged,
confidential,
or exempt from
disclosure
under
applicable
law. If you
are not the
intended
recipient or
authorized to
receive this
for the
intended
recipient, any
use,
dissemination,
distribution,
retention,
archiving, or
copying of
this
communication
is strictly
prohibited. If
you have
received this
e-mail in
error, please
notify the
sender
immediately by
reply e-mail
and delete
this message.
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<div><span>Thanks
& Regards,</span></div>
<div><span>Baji
Shaik,</span></div>
<span>EnterpriseDB
Corporation,</span><br>
<span>The
Postgres
Database
Company.</span><br>
<br>
<span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif">To
reach Support
Call:</span><br style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif">US </span><a href="tel:%2B1-732-331-1320" value="+17323311320" target="_blank">+1-732-331-1320</a><span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif"> or </span><a href="tel:1-800-235-5891" value="+18002355891" target="_blank">1-800-235-5891</a><span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif"> </span><br style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif">UK </span><a href="tel:%2B44-2033%207198%2020" value="+442033719820" target="_blank">+44-2033 7198 20</a><span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif"> -
BRAZIL</span><a href="tel:%2B55-2129%205813%2071" value="+552129581371" target="_blank">+55-2129 5813 71</a><span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif"> -
INDIA</span><a href="tel:%2B91-20-32677197" value="+912032677197" target="_blank">+91-20-32677197</a><span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif">.</span>
<div> <font color="#222222" face="arial,
sans-serif"><br>
</font><span>Website: </span><a href="http://www.enterprisedb.com/" target="_blank">www.enterprisedb.com</a><br>
<span>EnterpriseDB
Blog : </span><a href="http://blogs.enterprisedb.com/" target="_blank">http://blogs.enterprisedb.com</a><br>
<span>Follow
us on Twitter
: </span><a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a><br>
<br>
<span>This
e-mail message
(and any
attachment) is
intended for
the use of the
individual or
entity to whom
it is
addressed.
This message
contains
information
from
EnterpriseDB
Corporation
that may be
privileged,
confidential,
or exempt from
disclosure
under
applicable
law. If you
are not the
intended
recipient or
authorized to
receive this
for the
intended
recipient, any
use,
dissemination,
distribution,retention,
archiving, or
copying of
this
communication
is strictly
prohibited. If
you have
received this
e-mail in
error, please
notify the
sender
immediately by
reply e-mail
and delete
this message.</span></div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
Ahsan Hadi<br>
Snr Director
Product
Development<br>
EnterpriseDB
Corporation<br>
The Enterprise
Postgres
Company<br>
<br>
Phone: <a href="tel:%2B92-51-8358874" value="+92518358874" target="_blank">+92-51-8358874</a>
<br>
Mobile: <a href="tel:%2B92-333-5162114" value="+923335162114" target="_blank">+92-333-5162114</a><br>
<br>
Website: <a href="http://www.enterprisedb.com" target="_blank">www.enterprisedb.com</a><br>
EnterpriseDB
Blog: <a href="http://blogs.enterprisedb.com/" target="_blank">http://blogs.enterprisedb.com/</a><br>
Follow us on
Twitter: <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a><br>
<br>
This e-mail
message (and
any
attachment) is
intended for
the use of the
individual or
entity to whom
it is
addressed.
This message
contains
information
from
EnterpriseDB
Corporation
that may be
privileged,
confidential,
or exempt from
disclosure
under
applicable
law. If you
are not the
intended
recipient or
authorized to
receive this
for the
intended
recipient, any
use,
dissemination,
distribution,
retention,
archiving, or
copying of
this
communication
is strictly
prohibited. If
you have
received this
e-mail in
error, please
notify the
sender
immediately by
reply e-mail
and delete
this message.
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<br>
-- <br>
Regards,<br>
Arshu Arora<br>
EnterpriseDB
Corporation<br>
The Postgres
Database
Company<br>
<br>
To reach
Support Call:<br>
US: <a href="tel:%2B1-732-331-1320" value="+17323311320" target="_blank">+1-732-331-1320</a> -
UK: <a href="tel:%2B44%20-%202033719820" value="+442033719820" target="_blank">+44
- 2033719820</a><br>
Brazil: <a href="tel:%2B55-2139581371" value="+552139581371" target="_blank">+55-2139581371</a>
- India: <a href="tel:%2B91-20-32676535" value="+912032676535" target="_blank">+91-20-32676535</a><br>
<br>
<br>
Website: <a href="http://www.enterprisedb.com/" target="_blank">www.enterprisedb.com</a><br>
EnterpriseDB
Blog : <a href="http://blogs.enterprisedb.com/" target="_blank">http://blogs.enterprisedb.com</a><br>
Follow us on
Twitter : <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a><br>
<br>
This e-mail
message (and
any
attachment) is
intended for
the use of the
individual or
entity to whom
it is
addressed.
This message
contains
information
from
EnterpriseDB
Corporation
that may be
privileged,
confidential,
or exempt from
disclosure
under
applicable
law. If you
are not the
intended
recipient or
authorized to
receive this
for the
intended
recipient, any
use,
dissemination,
distribution,retention,
archiving, or
copying of
this
communication
is strictly
prohibited. If
you have
received this
e-mail in
error, please
notify the
sender
immediately by
reply e-mail
and delete
this message.
<div> <font face="Arial"><br>
</font></div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
Ahsan Hadi<br>
Snr Director
Product
Development<br>
EnterpriseDB
Corporation<br>
The Enterprise
Postgres
Company<br>
<br>
Phone: <a href="tel:%2B92-51-8358874" value="+92518358874" target="_blank">+92-51-8358874</a>
<br>
Mobile: <a href="tel:%2B92-333-5162114" value="+923335162114" target="_blank">+92-333-5162114</a><br>
<br>
Website: <a href="http://www.enterprisedb.com" target="_blank">www.enterprisedb.com</a><br>
EnterpriseDB
Blog: <a href="http://blogs.enterprisedb.com/" target="_blank">http://blogs.enterprisedb.com/</a><br>
Follow us on
Twitter: <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a><br>
<br>
This e-mail
message (and
any
attachment) is
intended for
the use of the
individual or
entity to whom
it is
addressed.
This message
contains
information
from
EnterpriseDB
Corporation
that may be
privileged,
confidential,
or exempt from
disclosure
under
applicable
law. If you
are not the
intended
recipient or
authorized to
receive this
for the
intended
recipient, any
use,
dissemination,
distribution,
retention,
archiving, or
copying of
this
communication
is strictly
prohibited. If
you have
received this
e-mail in
error, please
notify the
sender
immediately by
reply e-mail
and delete
this message.
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
Ahsan Hadi<br>
Snr Director
Product
Development<br>
EnterpriseDB
Corporation<br>
The Enterprise
Postgres
Company<br>
<br>
Phone: <a href="tel:%2B92-51-8358874" value="+92518358874" target="_blank">+92-51-8358874</a>
<br>
Mobile: <a href="tel:%2B92-333-5162114" value="+923335162114" target="_blank">+92-333-5162114</a><br>
<br>
Website: <a href="http://www.enterprisedb.com" target="_blank">www.enterprisedb.com</a><br>
EnterpriseDB
Blog: <a href="http://blogs.enterprisedb.com/" target="_blank">http://blogs.enterprisedb.com/</a><br>
Follow us on
Twitter: <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a><br>
<br>
This e-mail
message (and
any
attachment) is
intended for
the use of the
individual or
entity to whom
it is
addressed.
This message
contains
information
from
EnterpriseDB
Corporation
that may be
privileged,
confidential,
or exempt from
disclosure
under
applicable
law. If you
are not the
intended
recipient or
authorized to
receive this
for the
intended
recipient, any
use,
dissemination,
distribution,
retention,
archiving, or
copying of
this
communication
is strictly
prohibited. If
you have
received this
e-mail in
error, please
notify the
sender
immediately by
reply e-mail
and delete
this message.
</div>
</blockquote>
</div>
<br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<br>
-- <br>
Regards,<br>
Arshu Arora<br>
EnterpriseDB Corporation<br>
The Postgres Database
Company<br>
<br>
To reach Support Call:<br>
US: <a href="tel:%2B1-732-331-1320" value="+17323311320" target="_blank">+1-732-331-1320</a> -
UK: <a href="tel:%2B44%20-%202033719820" value="+442033719820" target="_blank">+44
- 2033719820</a><br>
Brazil: <a href="tel:%2B55-2139581371" value="+552139581371" target="_blank">+55-2139581371</a>
- India: <a href="tel:%2B91-20-32676535" value="+912032676535" target="_blank">+91-20-32676535</a><br>
<br>
<br>
Website: <a href="http://www.enterprisedb.com/" target="_blank">www.enterprisedb.com</a><br>
EnterpriseDB Blog : <a href="http://blogs.enterprisedb.com/" target="_blank">http://blogs.enterprisedb.com</a><br>
Follow us on Twitter : <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a><br>
<br>
This e-mail message (and
any attachment) is
intended for the use of
the individual or entity
to whom it is addressed.
This message contains
information from
EnterpriseDB Corporation
that may be privileged,
confidential, or exempt
from disclosure under
applicable law. If you
are not the intended
recipient or authorized
to receive this for the
intended recipient, any
use, dissemination,
distribution,retention,
archiving, or copying of
this communication is
strictly prohibited. If
you have received this
e-mail in error, please
notify the sender
immediately by reply
e-mail and delete this
message.
<div> <font face="Arial"><br>
</font></div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<br>
-- <br>
Regards,<br>
Arshu Arora<br>
EnterpriseDB Corporation<br>
The Postgres Database Company<br>
<br>
To reach Support Call:<br>
US: <a href="tel:%2B1-732-331-1320" value="+17323311320" target="_blank">+1-732-331-1320</a> -
UK: <a href="tel:%2B44%20-%202033719820" value="+442033719820" target="_blank">+44
- 2033719820</a><br>
Brazil: <a href="tel:%2B55-2139581371" value="+552139581371" target="_blank">+55-2139581371</a>
- India: <a href="tel:%2B91-20-32676535" value="+912032676535" target="_blank">+91-20-32676535</a><br>
<br>
<br>
Website: <a href="http://www.enterprisedb.com/" target="_blank">www.enterprisedb.com</a><br>
EnterpriseDB Blog : <a href="http://blogs.enterprisedb.com/" target="_blank">http://blogs.enterprisedb.com</a><br>
Follow us on Twitter : <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a><br>
<br>
This e-mail message (and any
attachment) is intended for
the use of the individual or
entity to whom it is
addressed. This message
contains information from
EnterpriseDB Corporation that
may be privileged,
confidential, or exempt from
disclosure under applicable
law. If you are not the
intended recipient or
authorized to receive this for
the intended recipient, any
use, dissemination,
distribution,retention,
archiving, or copying of this
communication is strictly
prohibited. If you have
received this e-mail in error,
please notify the sender
immediately by reply e-mail
and delete this message.
<div> <font face="Arial"><br>
</font></div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<span><font color="#888888"><span><font color="#888888">
<div><br>
</div>
-- <br>
Thanks & Regards,<br>
Deepanshu Sharma </font></span></font></span></div>
<span><font color="#888888"> </font></span></blockquote>
<span><font color="#888888"> <br>
</font></span></div>
<span><font color="#888888"> </font></span></blockquote>
</div>
<span><font color="#888888"><br>
<br clear="all">
<div><br>
</div>
-- <br>
Tom Kincaid<br>
Vice President Products and Engineering
<div><img src="http://www.enterprisedb.com/sites/default/files/EDB-logo-4c.png"><br>
<br>
The Postgres Database Company<br>
2013 HP AllianceOne Partner of the Year
Mission Critical Computing Category<br>
c: 978-828-6006<br>
o:781-357-3209</div>
</font></span></div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
Ahsan Hadi<br>
Snr Director Product Development<br>
EnterpriseDB Corporation<br>
The Enterprise Postgres Company<br>
<br>
Phone: <a href="tel:%2B92-51-8358874" value="+92518358874" target="_blank">+92-51-8358874</a> <br>
Mobile: <a href="tel:%2B92-333-5162114" value="+923335162114" target="_blank">+92-333-5162114</a><br>
<br>
Website: <a href="http://www.enterprisedb.com" target="_blank">www.enterprisedb.com</a><br>
EnterpriseDB Blog: <a href="http://blogs.enterprisedb.com/" target="_blank">http://blogs.enterprisedb.com/</a><br>
Follow us on Twitter: <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a><br>
<br>
This e-mail message (and any attachment) is intended
for the use of the individual or entity to whom it
is addressed. This message contains information from
EnterpriseDB Corporation that may be privileged,
confidential, or exempt from disclosure under
applicable law. If you are not the intended
recipient or authorized to receive this for the
intended recipient, any use, dissemination,
distribution, retention, archiving, or copying of
this communication is strictly prohibited. If you
have received this e-mail in error, please notify
the sender immediately by reply e-mail and delete
this message. </div>
</div>
</blockquote>
<br>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<br>
-- <br>
<div dir="ltr">Regards,<br>
Arshu Arora<br>
EnterpriseDB Corporation<br>
The Postgres Database Company<br>
<br>
<div><span><span>Are you updated:
Latest version of Postgres Plus Advanced Servers
9.2.5.13-1, 9.1.10.17-1. </span></span></div>
<div><span><font color="#0b5394"><br>
</font></span></div>
To reach Support Call:<br>
US: <a href="tel:%2B1-732-331-1320" value="+17323311320" target="_blank">+1-732-331-1320</a> - UK: <a href="tel:%2B44%20-%202033719820" value="+442033719820" target="_blank">+44 - 2033719820</a><br>
Brazil: <a href="tel:%2B55-2139581371" value="+552139581371" target="_blank">+55-2139581371</a> - India: <a href="tel:%2B91-20-32676535" value="+912032676535" target="_blank">+91-20-32676535</a><br>
<br>
<br>
Website: <a href="http://www.enterprisedb.com/" target="_blank">www.enterprisedb.com</a><br>
EnterpriseDB Blog : <a href="http://blogs.enterprisedb.com/" target="_blank">http://blogs.enterprisedb.com</a><br>
Follow us on Twitter : <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a><br>
<br>
This e-mail message (and any attachment) is intended for the
use of the individual or entity to whom it is addressed. This
message contains information from EnterpriseDB Corporation
that may be privileged, confidential, or exempt from
disclosure under applicable law. If you are not the intended
recipient or authorized to receive this for the intended
recipient, any use, dissemination, distribution,retention,
archiving, or copying of this communication is strictly
prohibited. If you have received this e-mail in error, please
notify the sender immediately by reply e-mail and delete this
message.
<div>
<font face="Arial"><br>
</font></div>
</div>
</div>
</blockquote>
<br>
</div>
</blockquote></div><br><br clear="all"><br>-- <br><div dir="ltr">Regards,<br>
Arshu Arora<br>EnterpriseDB Corporation<br>The Postgres Database Company<br><br><div><span><span>Are you updated: Latest version of Postgres Plus Advanced Servers 9.2.5.13-1, 9.1.10.17-1. </span></span></div>
<div><span><font color="#0b5394"><br></font></span></div>To reach Support Call:<br>US: <a href="tel:%2B1-732-331-1320" value="+17323311320" target="_blank">+1-732-331-1320</a> - UK: <a href="tel:%2B44%20-%202033719820" value="+442033719820" target="_blank">+44 - 2033719820</a><br>
Brazil: <a href="tel:%2B55-2139581371" value="+552139581371" target="_blank">+55-2139581371</a> - India: <a href="tel:%2B91-20-32676535" value="+912032676535" target="_blank">+91-20-32676535</a><br><br><br>Website: <a href="http://www.enterprisedb.com/" target="_blank">www.enterprisedb.com</a><br>
EnterpriseDB Blog : <a href="http://blogs.enterprisedb.com/" target="_blank">http://blogs.enterprisedb.com</a><br>
Follow us on Twitter : <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a><br><br>This
e-mail message (and any attachment) is intended for the use of the
individual or entity to whom it is addressed. This message contains
information from EnterpriseDB Corporation that may be privileged,
confidential, or exempt from disclosure under applicable law. If you are
not the intended recipient or authorized to receive this for the
intended recipient, any use, dissemination, distribution,retention,
archiving, or copying of this communication is strictly prohibited. If
you have received this e-mail in error, please notify the sender
immediately by reply e-mail and delete this message.<div>
<font face="Arial"><br></font></div></div>
</div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>Ahsan Hadi<br>Snr Director Product Development<br>EnterpriseDB Corporation<br>The Enterprise Postgres Company<br><br>Phone: <a href="tel:%2B92-51-8358874" value="+92518358874" target="_blank">+92-51-8358874</a> <br>
Mobile: <a href="tel:%2B92-333-5162114" value="+923335162114" target="_blank">+92-333-5162114</a><br>
<br>Website: <a href="http://www.enterprisedb.com" target="_blank">www.enterprisedb.com</a><br>EnterpriseDB Blog: <a href="http://blogs.enterprisedb.com/" target="_blank">http://blogs.enterprisedb.com/</a><br>Follow us on Twitter: <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a><br>
<br>This e-mail message (and any attachment) is intended for the use of the individual or entity to whom it is addressed. This message contains information from EnterpriseDB Corporation that may be privileged, confidential, or exempt from disclosure under applicable law. If you are not the intended recipient or authorized to receive this for the intended recipient, any use, dissemination, distribution, retention, archiving, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and delete this message.
</div></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><span><div><div> </div><div>Thanks & Regards,</div><div>Sivananda Reddy,</div><div>EnterpriseDB Corporation,</div><div>The Postgres Database Company.</div>
<div><br></div><div>Are you updated: Latest version of Postgres Plus Advanced Servers 9.2.5.13-1, 9.1.10.17-1.<br></div><div><br></div><div>To reach Support Call:</div><div>US <a href="tel:%2B1-732-331-1320" value="+17323311320" target="_blank">+1-732-331-1320</a> or 1-800-235-5891 </div>
<div>
UK <a href="tel:%2B44-2033%207198%2020" value="+442033719820" target="_blank">+44-2033 7198 20</a> - BRAZIL<a href="tel:%2B55-2129%205813%2071" value="+552129581371" target="_blank">+55-2129 5813 71</a> - INDIA<a href="tel:%2B91-20-32677197" value="+912032677197" target="_blank">+91-20-32677197</a>.</div>
<div><br></div><div>Website: <a href="http://www.enterprisedb.com" target="_blank">www.enterprisedb.com</a></div><div>EnterpriseDB Blog : <a href="http://blogs.enterprisedb.com" target="_blank">http://blogs.enterprisedb.com</a></div>
<div>Follow us on Twitter : <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a></div><div><br></div><div>This e-mail message (and any attachment) is intended for the use of the individual or entity to whom it is addressed. This message contains information from EnterpriseDB Corporation that may be privileged, confidential, or exempt from disclosure under applicable law. If you are not the intended recipient or authorized to receive this for the intended recipient, any use, dissemination, distribution,retention, archiving, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and delete this message.</div>
</div></span></div>
</div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>Ahsan Hadi<br>Snr Director Product Development<br>EnterpriseDB Corporation<br>The Enterprise Postgres Company<br><br>Phone: <a href="tel:%2B92-51-8358874" value="+92518358874" target="_blank">+92-51-8358874</a> <br>
Mobile: <a href="tel:%2B92-333-5162114" value="+923335162114" target="_blank">+92-333-5162114</a><br>
<br>Website: <a href="http://www.enterprisedb.com" target="_blank">www.enterprisedb.com</a><br>EnterpriseDB Blog: <a href="http://blogs.enterprisedb.com/" target="_blank">http://blogs.enterprisedb.com/</a><br>Follow us on Twitter: <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a><br>
<br>This e-mail message (and any attachment) is intended for the use of the individual or entity to whom it is addressed. This message contains information from EnterpriseDB Corporation that may be privileged, confidential, or exempt from disclosure under applicable law. If you are not the intended recipient or authorized to receive this for the intended recipient, any use, dissemination, distribution, retention, archiving, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and delete this message.
</div></div>
</div><br><br clear="all"><div><br></div>-- <br>Ahsan Hadi<br>Snr Director Product Development<br>EnterpriseDB Corporation<br>The Enterprise Postgres Company<br><br>Phone: +92-51-8358874 <br>Mobile: +92-333-5162114<br>
<br>Website: <a href="http://www.enterprisedb.com">www.enterprisedb.com</a><br>EnterpriseDB Blog: <a href="http://blogs.enterprisedb.com/">http://blogs.enterprisedb.com/</a><br>Follow us on Twitter: <a href="http://www.twitter.com/enterprisedb">http://www.twitter.com/enterprisedb</a><br>
<br>This e-mail message (and any attachment) is intended for the use of the individual or entity to whom it is addressed. This message contains information from EnterpriseDB Corporation that may be privileged, confidential, or exempt from disclosure under applicable law. If you are not the intended recipient or authorized to receive this for the intended recipient, any use, dissemination, distribution, retention, archiving, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and delete this message.
</div></div>