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

[Lonni J Friedman]

As far as I can tell this patch fixes the problem.  At least it has
not reproduced since I applied the patch.

On Mon, Dec 19, 2011 at 2:50 PM, Tatsuo Ishii <ishii at postgresql.org> wrote:
> Hi Lonni,
>
> I understand it's hard to reproduce the problem. So the only request I
> have is, to test this out and report back to me, occasionaly like a
> week later, a month later and so on.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>
>> 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