[pgpool-general: 6145] Re: What happens when node is assigned as shutdown

[Mariel Cherkassky]

The moment the pool assign the shutdown status to a specific node all
active session to that node are closed immediatly ?

2018-06-26 16:11 GMT+03:00 Tatsuo Ishii <ishii at sraoss.co.jp>:

> > Hi,
> > I wanted to understand what happens to a session that was opened from the
> > pool to   one of the nodes in my cluster (query that is taking x time).
> > Suddenly there was a network conflict between the pool node and the
> > database node and the pool change the status of the database node to
> > shutdown(the node is slave). What happens to the query that runned ? What
> > happens to the session that was open ?
>
> The session will be closed. This is pretty much similar when you
> directly connect to PostgreSQL.
>
> > Will the output of the query will
> > come back to the user ?
>
> Though it really depends on the timing of failure, probably the output
> of the query will not come bacl to the user in most cases.
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180626/d2d679b6/attachment-0001.html>