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

Tatsuo Ishii ishii at postgresql.org
Sun Dec 18 15:53:13 JST 2011


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
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pool_process_query.patch
Type: text/x-patch
Size: 3070 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20111218/ac8f62e4/attachment.bin>


More information about the pgpool-general mailing list