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

[Igor Yurchenko]

Hi Tatsuo,

I got the same issue and have collected 'strace -f' log. I've attached it
gzipped to this email. I hope it will be accepted by your maillist manager.
As I see there, pgpool doesn't make a try to open the port 9898:

[root at pg-mgrdb2 ~]# grep bind /tmp/pgpool-strace.log
[pid 20486] bind(4, {sa_family=AF_INET, sin_port=htons(9000),
sin_addr=inet_addr("0.0.0.0")}, 16) = 0
[pid 20486] bind(5, {sa_family=AF_UNIX,
sun_path="/var/run/postgresql/.s.PGPOOLWD_CMD.9000"}, 110) = 0
[pid 20486] bind(6, {sa_family=AF_NETLINK, nl_pid=0, nl_groups=0x000011},
12) = 0
[pid 20484] bind(4, {sa_family=AF_UNIX,
sun_path="/var/run/postgresql/.s.PGSQL.9999"}, 110) = 0
[pid 20484] bind(5, {sa_family=AF_NETLINK, nl_pid=0, nl_groups=00000000},
12) = 0
[pid 20484] bind(5, {sa_family=AF_INET, sin_port=htons(9999),
sin_addr=inet_addr("0.0.0.0")}, 16) = 0
[pid 20484] bind(6, {sa_family=AF_INET6, sin6_port=htons(9999),
inet_pton(AF_INET6, "::", &sin6_addr), sin6_flowinfo=htonl(0),
sin6_scope_id=0}, 28) = 0
[pid 20508] bind(4, {sa_family=AF_INET, sin_port=htons(9694),
sin_addr=inet_addr("0.0.0.0")}, 16) = 0
[root at pg-mgrdb2 ~]#

I hope it gives any hint of what is going on. I'll try to check the source
code a bit later.

BR
Igor Yurchenko


On Wed, 10 Apr 2024 at 23:03, Igor Yurchenko <harry.urcen at gmail.com> wrote:

> 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/20240501/d67cee26/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool-strace.log.gz
Type: application/x-gzip
Size: 58095 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-hackers/attachments/20240501/d67cee26/attachment-0001.bin>