<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="gmail_extra"><br><div class="gmail_quote"><div dir="ltr">2018-06-26 16:11 GMT+03:00 Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@sraoss.co.jp" target="_blank">ishii@sraoss.co.jp</a>></span>:</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">> Hi,<br>
> I wanted to understand what happens to a session that was opened from the<br>
> pool to one of the nodes in my cluster (query that is taking x time).<br>
> Suddenly there was a network conflict between the pool node and the<br>
> database node and the pool change the status of the database node to<br>
> shutdown(the node is slave). What happens to the query that runned ? What<br>
> happens to the session that was open ?<br>
<br>
</span>The session will be closed. This is pretty much similar when you<br>
directly connect to PostgreSQL.<br>
<span class=""><br>
> Will the output of the query will<br>
> come back to the user ?<br>
<br>
</span>Though it really depends on the timing of failure, probably the output<br>
of the query will not come bacl to the user in most cases.<br>
<br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_<wbr>en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.<wbr>jp</a><br>
</blockquote></div><br></div>