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

Tatsuo Ishii ishii at sraoss.co.jp
Tue Jun 26 22:11:56 JST 2018


> 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


More information about the pgpool-general mailing list