[pgpool-general: 5693] Re: Postgres error not processed by pgpool

[Tatsuo Ishii]

Forwarding to the mailing list.

Best regards,
--
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: Re: [pgpool-general: 5683] Postgres error not processed by pgpool
Date: Sat, 05 Aug 2017 05:55:11 +0900 (JST)
Message-ID: <20170805.055511.2064995071833270919.t-ishii at sraoss.co.jp>

> Thanks for quick test and report!
> 
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
> 
>> I got around to building from HEAD and I just wanted to confirm to you that
>> the two problems I've been having (segfaulting and error not returned) are both fixed there.
>> 
>> Thanks!
>> Jeremiah
>> 
>>> -----Original Message-----
>>> From: Tatsuo Ishii [mailto:ishii at sraoss.co.jp]
>>> Sent: Thursday, August 03, 2017 4:16 PM
>>> To: Jeremiah Penery
>>> Cc: pgpool-general at pgpool.net
>>> Subject: Re: [pgpool-general: 5683] Postgres error not processed by pgpool
>>> 
>>> > I'm using Pgpool-II 3.6.5 with Postgres 9.6.3, and seeing issues sometimes
>>> when a SQL statement generates an error in Postgres, that the Pgpool
>>> process seems to wait forever for some kind of response.  This causes
>>> application code to hang as well.
>>> >
>>> > I'm attaching logs from both Pgpool and Postgres (the configuration here is
>>> one machine, everything co-resident).  I can get more logging information or
>>> anything else if necessary.  The issue is easily reproducible, though I don't
>>> think it happens 100% of the time.
>>> >
>>> > Thanks,
>>> > Jeremiah
>>> 
>>> That could be already fixed by this recent commit:
>>> https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=6881a5a88ccb
>>> ef6153cb4723352279904e2ac863
>>> 
>>> Best regards,
>>> --
>>> Tatsuo Ishii
>>> SRA OSS, Inc. Japan
>>> English: http://www.sraoss.co.jp/index_en.php
>>> Japanese:http://www.sraoss.co.jp