On 2025-08-30 22:00, Alexander Lakhin wrote:
Upgrade to NetBSD 9.4 fixed the issue for me.
It reproduced even on a commit from 2017-01-01, so it's not clear why
there were no such timeouts before...
[1]
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=sidewinder&dt=2025-08-22%2011%3A29%3A27
[2]
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=sidewinder&dt=2025-08-27%2016%3A35%3A01
[3]
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=sidewinder&dt=2025-08-29%2012%3A35%3A01
[4] https://portal.cloud.hashicorp.com/vagrant/discover/generic/netbsd9
[5] https://github.com/jemalloc/jemalloc/issues/2402
Hi,
One change I did pretty recently is that I upgraded the build farm
client from 14 to 19.1 a couple of weeks ago.
I might have lowered wait_timeout initially but now it's higher (14400)
than before (10800).
I also have note that there are stuck processes some times. Like:
netbsd9_3-pgbf# ps aux | grep ^pgbf
pgbf 1610 0.0 0.1 34068 2200 ? I Wed07PM 0:00.00 gmake
NO_LOCALE=1 NO_TEMP_INSTALL=yes check
pgbf 3083 0.0 0.3 1903704 6164 ? Il 22Aug25 0:00.04
/home/pgbf/buildroot/HEAD/pgsql.build/src/interfaces/ecpg/test/thr
pgbf 3101 0.0 0.2 57892 4160 ? I Fri03PM 0:00.01
postdrop -r
pgbf 4490 0.0 0.3 1902676 6068 ? Il Wed07PM 0:00.04
/home/pgbf/buildroot/REL_18_STABLE/pgsql.build/src/interfaces/ecpg
pgbf 8739 0.0 0.1 18948 2196 ? I 22Aug25 0:00.00 gmake
-C test check
pgbf 8927 0.0 0.1 20008 1780 ? I 22Aug25 0:00.00 sh -c
{ cd pgsql.build/src/interfaces/ecpg && gmake NO_LOCALE=1 N
pgbf 10380 0.0 0.2 57876 4184 ? Is Wed07PM 0:00.00
sendmail -FCronDaemon -odi -oem -oi -t
pgbf 10579 0.0 0.3 1900136 6172 ? Il Fri03PM 0:00.04
/home/pgbf/buildroot/HEAD/pgsql.build/src/interfaces/ecpg/test/thr
pgbf 11374 0.0 0.2 57872 4180 ? Is Fri03PM 0:00.01
sendmail -FCronDaemon -odi -oem -oi -t
pgbf 13147 0.0 0.2 43260 3804 ? I Fri03PM 0:00.34
./pg_regress --expecteddir=. --dbname=ecpg1_regression,ecpg2_regre
pgbf 14484 0.0 0.0 0 0 ? Z - 0:00.00 (ksh)
pgbf 14711 0.0 0.0 0 0 ? Z - 0:00.00 (ksh)
pgbf 16040 0.0 0.2 57896 4160 ? I Wed07PM 0:00.01
postdrop -r
pgbf 17707 0.0 0.1 32400 2196 ? I 22Aug25 0:00.00 gmake
NO_LOCALE=1 NO_TEMP_INSTALL=yes check
pgbf 18244 0.0 0.1 30100 2204 ? I Fri03PM 0:00.00 gmake
-C test check
pgbf 20348 0.0 0.1 20008 1780 ? I Fri03PM 0:00.00 sh -c
{ cd pgsql.build/src/interfaces/ecpg && gmake NO_LOCALE=1 N
pgbf 22704 0.0 0.2 57896 4164 ? I 22Aug25 0:00.01
postdrop -r
pgbf 23701 0.0 0.2 48960 3788 ? I Wed07PM 0:00.29
./pg_regress --expecteddir=. --dbname=ecpg1_regression,ecpg2_regre
pgbf 24016 0.0 0.2 39292 3792 ? I 22Aug25 0:00.29
./pg_regress --expecteddir=. --dbname=ecpg1_regression,ecpg2_regre
pgbf 24387 0.0 0.1 30888 2200 ? I Fri03PM 0:00.00 gmake
NO_LOCALE=1 NO_TEMP_INSTALL=yes check
pgbf 24945 0.0 0.2 57876 4176 ? Is 22Aug25 0:00.01
sendmail -FCronDaemon -odi -oem -oi -t
pgbf 25730 0.0 0.1 18852 2216 ? I Wed07PM 0:00.00 gmake
-C test check
pgbf 26757 0.0 0.1 22684 1776 ? I Wed07PM 0:00.00 sh -c
{ cd pgsql.build/src/interfaces/ecpg && gmake NO_LOCALE=1 N
pgbf 29079 0.0 0.0 0 0 ? Z - 0:00.00 (ksh)
/Mikael
