[pgpool-general: 1582] Re: pgpool 3.2.3 node gets down after some hours of work.
Tatsuo Ishii
ishii at postgresql.org
Mon Apr 8 19:51:42 JST 2013
No. The message shows that clients dosconnect to pgpool impolitely.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
> May be this is the case why node shown as down:
> 2013-04-08 07:41:16 LOG: pid 381: ProcessFrontendResponse: failed to
> read kind from frontend. frontend abnormally exited
> 2013-04-08 07:41:16 LOG: pid 444: ProcessFrontendResponse: failed to
> read kind from frontend. frontend abnormally exited
> 2013-04-08 07:41:17 LOG: pid 4113: ProcessFrontendResponse: failed to
> read kind from frontend. frontend abnormally exited
> 2013-04-08 07:44:09 LOG: pid 331: ProcessFrontendResponse: failed to
> read kind from frontend. frontend abnormally exited
> ?
>
>
> Thanks,
> Dzmitry
>
>
>
>
>
> On 4/8/13 2:03 AM, "Tatsuo Ishii" <ishii at postgresql.org> wrote:
>
>>>> 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?
>>
>>Oops. You already told me you 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.
>>
>>More thought. If fail_over_on_backend_error = on, pgpool will trigger
>>fail over when read/write errors are detected on the socket to
>>PostgreSQL connection. Turning this off may help for an environment
>>where network connection is flakey.
>>--
>>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