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

Tatsuo Ishii ishii at postgresql.org
Tue Dec 20 07:50:50 JST 2011


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


More information about the pgpool-general mailing list