[pgpool-general: 5666] Re: latest pgpool that get stuck on regular query - log attached

[Tatsuo Ishii]

> Hi,
> 
> I did not verify last time that both nodes were up and attached.  I will run it again today and wait for it to get stuck.   This time I verified that both nodes are up and attached.
> 
> Every once in a while we have strange cases where we have master detached and slave attached.  This is what we had today on one of the setups that got stuck.  I'm sending you the log file, just in case you want to analyze the log of stuck query with master detached and slave attached.

I assume slave is new primary. I have tested with this case and see no
failure.

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

> -----Original Message-----
> From: Tatsuo Ishii [mailto:ishii at sraoss.co.jp]
> Sent: Monday, July 31, 2017 2:16 AM
> To: Avi Weinberg <AviW at gilat.com>
> Cc: pgpool-general at pgpool.net
> Subject: Re: [pgpool-general: 5646] Re: latest pgpool that get stuck on regular query - log attached
> 
> Can you please answer my question. Thanks.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
> 
> From: Tatsuo Ishii <ishii at sraoss.co.jp>
> Subject: [pgpool-general: 5646] Re: latest pgpool that get stuck on regular query - log attached
> Date: Fri, 28 Jul 2017 07:43:07 +0900 (JST)
> Message-ID: <20170728.074307.231131992705574005.t-ishii at sraoss.co.jp>
> 
>> So you only have 1 backend? From the log file it seems node 0 is not
>> used, only node 1 is used.
>>
>> Best regards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese:http://www.sraoss.co.jp
>>
>>> Hi Ishii Tatsuo,
>>>
>>> Attached is another log that got stuck
>>>
>>> Thanks
>>> Avi
>>>
>>>
>>> Hi Ishii Tatsuo,
>>>
>>> Attached please find the log that shows the sequence that cuased regular query to get stuck.  If the files I'm sending you are not what you need please let me know what exactly you need from me.
>>> I also saw that the bug I opened about queries with errors that get stuck was commented by one of the users that it was solved with your fix.  However, when I repeatedly call an error throwing statement at some point I get it stuck even with the patch.  Am I doing something wrong?
>>>
>>> Your comments are most welcome
>>> Avi
>>> IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
> IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.