[pgpool-general: 101] Re: [Pgpool-general] seemingly hung pgpool process consuming 100% CPU

[Lonni J Friedman]

I can certainly test this out, however since I never had any obvious
way of triggering the problem, its going to be close to impossible to
know that this patch fixes it.  Is there any specific feedback that
you'd like?

On Sat, Dec 17, 2011 at 10:53 PM, Tatsuo Ishii <ishii at postgresql.org> wrote:
> Hi Lonni,
>
> Sorry for delaty. Here is the patch to deal with the problem(against V3.1.x).
> Please try and get back to me.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>
>> Yes, I have an idea. In the code path where you saw looping, the case
>> when one of standbys sends spontaneously packet to pgpool is not
>> considered. This could happen when, for example, reloading
>> postgresql.conf. I suspect you hit the case. I've been thinking about
>> how to deal with the case.  Within a few days, I hope to create a
>> patch for this.
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese: http://www.sraoss.co.jp
>>
>>> Hi Tatsuo,
>>> Is there any other information that I can provide?  Do you have any
>>> ideas what might be causing this problem?
>>>
>>> thanks
>>>
>>> On Thu, Dec 8, 2011 at 12:42 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:
>>>> Lonni,
>>>>
>>>> Thanks. I will look into this.
>>>> --
>>>> Tatsuo Ishii
>>>> SRA OSS, Inc. Japan
>>>> English: http://www.sraoss.co.jp/index_en.php
>>>> Japanese: http://www.sraoss.co.jp
>>>>
>>>>> On Thu, Dec 8, 2011 at 12:06 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:
>>>>>>> On Wed, Dec 7, 2011 at 11:10 PM, Tatsuo Ishii <ishii at postgresql.org> wrote:
>>>>>>>> How is your PostgreSQL server configuration?
>>>>>>>
>>>>>>> Did you want a copy of my postgresql.conf ?
>>>>>
>>>>> attached
>>>>>
>>>>>>
>>>>>> Yes, please. Also please show me the output of "show pool_status;".
>>>>>
>>>>>
>>>>> show pool_status ;
>>>>>                  item                 |             value