Re: ecpg test thread/alloc hangs on sidewinder running NetBSD 9.3

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