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

Dzmitry dzmitry.nikitsin at gmail.com
Thu Apr 11 00:56:16 JST 2013


I've set hot_standby_feedback = on on slave - it seems help.
Another issue I faced:
invalid encoding name: utf8 when I am trying to insert/read from DB. Do
you know how to resolve ?


Thanks,
  Dzmitry





On 4/8/13 1:51 PM, "Tatsuo Ishii" <ishii at postgresql.org> wrote:

>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