Re: Regression tests fail on OpenBSD due to low semmns value

Alexander Lakhin <exclusion@gmail.com> writes:

I deployed OpenBSD 7.4 locally and reproduced "too many clients" and that
hang as well. It turned out that OpenBSD has semmns as low as 60 (see [4])
and as a consequence, initdb sets max_connections = 20 for the regression
test database. (This can be helpful sometimes, see e.g., [5].) At the same
time, paralell_schedule contains groups of 20 tests, for instance:

Yeah.  That was more-or-less okay before we invented parallel query,
but now there needs to be some headroom.  I've thought about adjusting
initdb to not allow max_connections less than 25 (can't remember if
I actually proposed that on-list though).  The other way would be to
rearrange parallel_schedule to make the max group size less than 20,
but that seems like a lot of effort for little benefit.

25 seems perfectly reasonable, these days. The current minimum was set nearly 7 years ago.

cheers

andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com