[pgpool-hackers: 4445] Re: Pgpool PCP get disabled. How it is possible?

[Igor Yurchenko]

Hi Tatsuo,

No, pgpool is definitely started. It's reflected in output of ps -ef and ss
-pln. It starts listening to 9999, 9000 ports and establish connections to
a postgresql cluster.
But both nodes were in state down. But didn't be succeed to make them up
because PCP management port 9898 was unavailable. And restart of pgpool
didn't help.

I haven't figured out to check with strace. Unfortunately, the cluster was
redeployed, and the issue gone.
If I meet it, I check it.
Thanks for advice...

BR
Igor Yurchenko


On Fri, 5 Apr 2024, 12:54 Tatsuo Ishii, <ishii at sraoss.co.jp> wrote:

> > Hi guys,
> >
> > I broke my brain completely. For unclear reasons, pgpool 4.2 (see the
> same
> > on pgpool 3.6) doesn't connect to port 9898 for a PCP management nor
> create
> > respective socket (/var/run/postgresql/.s.*.9898). And of course, all
> pcp_*
> > tools fail.
>
> I assume that pgpool does not start.  Can you share pgpool log and the
> out put of "strace -f" against pgpool starting up?
>
> Best reagards,
> --
> Tatsuo Ishii
> SRA OSS LLC
> English: http://www.sraoss.co.jp/index_en/
> Japanese:http://www.sraoss.co.jp
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-hackers/attachments/20240410/b7dcc7d2/attachment.htm>