[pgpool-general: 8584] Re: PGPool 4.3.3 hang when Postgres host stopped

[Dave Sisk]

An update:  I just realized I'm actually getting a seg fault from PGPool in
trying to troubleshoot this...image attached.

[image: image.png]

On Thu, Feb 2, 2023 at 2:00 PM Dave Sisk <dave.sisk at bullhorn.com> wrote:

> Hi folks...hope everyone is well.
>
> I'm a former PGPool user and supporter from many prior years...I'm having
> some problems with PGPool 4.3.3 w/ Postgres 14.5 on Debian 11.  Testing 3
> node cluster using streaming replication, 1 primary and 2 standby's...a
> similar configuration that I've used before with great success.
>
> When we 'shutdown -h now' the db primary host, PGPool seems to hang for an
> extended period of time.  It fails-over beautifully if I pcp_detach_node on
> the db primary, it also fails-over beautifully if I stop the Postgres
> primary instance.  However, shutting down the host yields a hung situation
> for PGPool.
>
> Can any advise on PGPool config parameters that I might set or change to
> avoid this hung situation?
>
> Thank you in advance,
> Dave Sisk
>
> --
>
> *Dave Sisk*
>
> *Data Architect*
>
>
> T:
>


-- 

*Dave Sisk*

*Data Architect*


T:

-- 

 <https://www.linkedin.com/company/bullhorn> 
<https://twitter.com/Bullhorn>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230202/7d5695bd/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 89166 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230202/7d5695bd/attachment-0001.png>