<div dir="rtl"><div dir="ltr">But what if my standby didnt fail ? I mean, in my case I had a network conflict between the standby and the pool. The standby was up and was working. In that case stil the session will be disconneced ? And why only in case the load_balance_mode is off the seesion will not be disrupted ? Isnt it suppose to be the the opposite ? I have 2 standbys and In case one of my standby`s is down or doesnt work all the current sessions to him will be moved to the second standby.</div><div dir="ltr"><br></div><div dir="ltr">Mariel.</div></div><div class="gmail_extra"><br><div class="gmail_quote"><div dir="ltr">2018-06-26 17:20 GMT+03:00 Pierre Timmermans <span dir="ltr"><<a href="mailto:ptim007@yahoo.com" target="_blank">ptim007@yahoo.com</a>></span>:</div><blockquote class="gmail_quote" style="margin:0 .8ex;border-left:1px #ccc solid;border-right:1px #ccc solid;padding-left:1ex;padding-right:1ex"><div><div style="font-family:Helvetica Neue,Helvetica,Arial,sans-serif;font-size:16px"><div style="font-family:Helvetica Neue,Helvetica,Arial,sans-serif;font-size:16px"><div><div>Note that if standby node fails and if load_balance_node is off, then the pgpool connection will not be disrupted by the failover happening on the standby (at least with recent version of pgpool): this is documented in the doc and I can confirm that it is working in my tests.</div><div><br></div><div>In all other cases the backend connection will be disconnected and I suppose the client will receive an error and the query result will be lost</div><div><br></div><div class="m_-3424521531282266262ydp57d84567signature">Pierre</div></div>
<div><br></div><div><br></div>
</div><div id="m_-3424521531282266262ydpdb77f298yahoo_quoted_0655257114" class="m_-3424521531282266262ydpdb77f298yahoo_quoted">
<div style="font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:13px;color:#26282a"><div><div class="h5">
<div>
On Tuesday, June 26, 2018, 3:35:41 PM GMT+2, Mariel Cherkassky <<a href="mailto:mariel.cherkassky@gmail.com" target="_blank">mariel.cherkassky@gmail.com</a>> wrote:
</div>
<div><br></div>
<div><br></div>
</div></div><div><div><div class="h5"><div id="m_-3424521531282266262ydpdb77f298yiv7752762545"><div><div dir="rtl"><div dir="ltr">The moment the pool assign the shutdown status to a specific node all active session to that node are closed immediatly ?</div></div><div class="m_-3424521531282266262ydpdb77f298yiv7752762545gmail_extra"><br clear="none"><div class="m_-3424521531282266262ydpdb77f298yiv7752762545gmail_quote"><div class="m_-3424521531282266262ydpdb77f298yiv7752762545yqt5650194902" id="m_-3424521531282266262ydpdb77f298yiv7752762545yqtfd50073"><div dir="ltr">2018-06-26 16:11 GMT+03:00 Tatsuo Ishii <span dir="ltr"><<a shape="rect" href="mailto:ishii@sraoss.co.jp" rel="nofollow" target="_blank">ishii@sraoss.co.jp</a>></span>:</div><blockquote class="m_-3424521531282266262ydpdb77f298yiv7752762545gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="m_-3424521531282266262ydpdb77f298yiv7752762545">> Hi,<br clear="none">
> I wanted to understand what happens to a session that was opened from the<br clear="none">
> pool to one of the nodes in my cluster (query that is taking x time).<br clear="none">
> Suddenly there was a network conflict between the pool node and the<br clear="none">
> database node and the pool change the status of the database node to<br clear="none">
> shutdown(the node is slave). What happens to the query that runned ? What<br clear="none">
> happens to the session that was open ?<br clear="none">
<br clear="none">
</span>The session will be closed. This is pretty much similar when you<br clear="none">
directly connect to PostgreSQL.<br clear="none">
<span class="m_-3424521531282266262ydpdb77f298yiv7752762545"><br clear="none">
> Will the output of the query will<br clear="none">
> come back to the user ?<br clear="none">
<br clear="none">
</span>Though it really depends on the timing of failure, probably the output<br clear="none">
of the query will not come bacl to the user in most cases.<br clear="none">
<br clear="none">
Best regards,<br clear="none">
--<br clear="none">
Tatsuo Ishii<br clear="none">
SRA OSS, Inc. Japan<br clear="none">
English: <a shape="rect" href="http://www.sraoss.co.jp/index_en.php" rel="nofollow" target="_blank">http://www.sraoss.co.jp/index_ en.php</a><br clear="none">
Japanese:<a shape="rect" href="http://www.sraoss.co.jp" rel="nofollow" target="_blank">http://www.sraoss.co. jp</a><br clear="none">
</blockquote></div></div><div class="m_-3424521531282266262ydpdb77f298yiv7752762545yqt5650194902" id="m_-3424521531282266262ydpdb77f298yiv7752762545yqtfd56664"><br clear="none"></div></div></div></div></div></div><div class="m_-3424521531282266262ydpdb77f298yqt5650194902" id="m_-3424521531282266262ydpdb77f298yqtfd77811">______________________________<wbr>_________________<br clear="none">pgpool-general mailing list<br clear="none"><a shape="rect" href="mailto:pgpool-general@pgpool.net" rel="nofollow" target="_blank">pgpool-general@pgpool.net</a><br clear="none"><a shape="rect" href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="nofollow" target="_blank">http://www.pgpool.net/mailman/<wbr>listinfo/pgpool-general</a><br clear="none"></div></div>
</div>
</div></div></div></blockquote></div><br></div>