public inbox for [email protected]
help / color / mirror / Atom feedFrom: Tatsuo Ishii <[email protected]>
To: [email protected]
Cc: [email protected]
Subject: Re: Proposal: Recent mutated table tracking in memory
Date: Mon, 09 Mar 2026 14:18:39 +0900 (JST)
Message-ID: <[email protected]> (raw)
In-Reply-To: <CACeKOO1SCQLwx4=4gp6+swH5NW_GLJCd0uOSL0cU2U7VFR_o8g@mail.gmail.com>
References: <CACeKOO0gEfwBQ1J6sdpXDV_=2RYhg9wemE=x=LOEDimvyH5Xfg@mail.gmail.com>
<[email protected]>
<CACeKOO1SCQLwx4=4gp6+swH5NW_GLJCd0uOSL0cU2U7VFR_o8g@mail.gmail.com>
Hi Nadav,
Sorry for late response. I have been working on this issue.
> > Added some handling for possible causes - works now.
>
> Unfortunately this doesn't work here. Still 042 test fails if it is
> executed *after* 041. i.e.
>
> ./regress.sh 04[12] <-- 042 fails
> ./regress.sh 042 <-- Ok
I ran following script to see if some sockets are left after the 041 test.
./regress.sh '041';netstat -ap|grep 11000;./regress.sh 042
:
testing 041.external_replication_delay...ok.
out of 1 ok:1 failed:0 timeout:0
(一部のプロセスが識別されますが, 所有していないプロセスの情報は
表示されません。それら全てを見るにはルートになる必要があります.)
tcp 0 0 0.0.0.0:11000 0.0.0.0:* LISTEN 1401942/bash
tcp 0 0 localhost:36366 localhost:11000 TIME_WAIT -
tcp 0 0 localhost:36380 localhost:11000 TIME_WAIT -
tcp 0 0 localhost:36384 localhost:11000 TIME_WAIT -
tcp 0 0 localhost:36390 localhost:11000 TIME_WAIT -
tcp 0 0 localhost:43580 localhost:11000 TIME_WAIT -
tcp 0 0 localhost:43596 localhost:11000 TIME_WAIT -
tcp6 0 0 [::]:11000 [::]:* LISTEN 1401942/bash
unix 2 [ ACC ] STREAM LISTENING 10164557 1401942/bash /tmp/.s.PGSQL.11000
creating pgpool-II temporary installation ...
moving pgpool_setup to temporary installation path ...
moving watchdog_setup to temporary installation path ...
using pgpool-II at /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/temp/installed
*************************
REGRESSION MODE : install
Pgpool-II version : pgpool-II version 4.8devel (mitsukakeboshi)
Pgpool-II install path : /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/temp/installed
PostgreSQL bin : /usr/local/pgsql/bin
PostgreSQL Major version : 18
pgbench : /usr/local/pgsql/bin/pgbench
PostgreSQL jdbc : /usr/local/pgsql/share/postgresql-9.2-1003.jdbc4.jar
*************************
testing 042.track_table_mutation...failed.
out of 1 ok:0 failed:1 timeout:0
It seems the cause of the issue is the bash process:
unix 2 [ ACC ] STREAM LISTENING 10164557 1401942/bash /tmp/.s.PGSQL.11000
It keeps on listening to the socket even after the test and it
prevents pgpool in 042 test from binding the socket, which causes the
test failure. Possible solutions are:
1) fix the external replication delay checking to close the listening
socket before starting bash.
2) close the listening socket when the streaming replication check
worker process forks.
While invensting the issue, I found similar problem is in other
places. For example, pcp process inherits pgpool listening sockets
which are not necessary for pcp. I posted a proposal to fix the issue:
https://www.postgresql.org/message-id/20260302.100028.1346768433787074248.ishii%40postgresql.org
This includes the fix #2. I plan to commit the patch today. After our
buildfarm reports no new problem (it will take 2- 3 days), I am going
to test your patch again.
Best regards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Proposal: Recent mutated table tracking in memory
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox