[pgpool-general: 6145] Re: What happens when node is assigned as shutdown
mariel.cherkassky at gmail.com
Tue Jun 26 22:35:33 JST 2018
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
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general