[pgpool-general: 1576] Re: pgpool 3.2.3 node gets down after some hours of work.

[Tatsuo Ishii]

> May be this will help:
> 
> 2013-04-07 11:48:52 LOG:   pid 9785: do_child: exits with status 1 due to
> error
> 2013-04-07 11:48:52 LOG:   pid 9760: pool_read_kind: error message from 2
> th backend:canceling statement due to conflict with recovery
> 2013-04-07 11:48:53 LOG:   pid 9767: detect_stop_postmaster_error:
> detect_error error
> 2013-04-07 11:48:53 LOG:   pid 9767: detect_postmaster_down_error returns
> error on backend 2. Going to close this session.
> 2013-04-07 11:59:28 LOG:   pid 9651: do_child: exits with status 1 due to
> error

Those themselves do not related to node down or fail over.

Anyway are yo still using 3.2.3? or upgraded to 3.2-stable?

Also do yo see this kind of message?

	 pool_log("postmaster on DB node %d was shutdown by administrative command", i);

If you see this, someone used pg_terminate_backend(). This makes
pgpool confuses because it returned exactly same error code as
postmaster shutdown. So pgpool will detach the node where the function
issued.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp