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

[Tatsuo Ishii]

Great news. Thanks.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> 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