Hello,
I'm migrating from mailman 2.1 to the latest version (3.3.9) on Almalinux 9 (python 3.19, postgresql 13.16). Have followed the instructions here https://docs.list.org/en/latest/install/virtualenv.html#virtualenv-install to perform a clean install on a new VM.
Everything seems to be working (well, I just created one list and doing some basic tests). What I have noticed is hundreds of PGsql connections from mailmanweb. Once mailmanweb service is started there are new non-stop DB connections requests (from Django I guess), here is just 1 second from PGsql log:
2024-10-10 12:15:37.112 EDT [3217] DEBUG: forked new backend, pid=3747 socket=10 2024-10-10 12:15:37.113 EDT [3217] DEBUG: server process (PID 3746) exited with exit code 0 2024-10-10 12:15:37.318 EDT [3217] DEBUG: forked new backend, pid=3748 socket=10 2024-10-10 12:15:37.318 EDT [3217] DEBUG: server process (PID 3747) exited with exit code 0 2024-10-10 12:15:37.523 EDT [3217] DEBUG: forked new backend, pid=3749 socket=10 2024-10-10 12:15:37.524 EDT [3217] DEBUG: server process (PID 3748) exited with exit code 0 2024-10-10 12:15:37.728 EDT [3217] DEBUG: forked new backend, pid=3750 socket=10 2024-10-10 12:15:37.729 EDT [3217] DEBUG: server process (PID 3749) exited with exit code 0 2024-10-10 12:15:37.934 EDT [3217] DEBUG: forked new backend, pid=3751 socket=10 2024-10-10 12:15:37.935 EDT [3217] DEBUG: server process (PID 3750) exited with exit code 0
Few minutes later there are around 300 dead (TIME_WAIT) connections to port 5432 like these:
tcp 0 0 127.0.0.1:33728 127.0.0.1:5432 TIME_WAIT
tcp 0 0 127.0.0.1:40392 127.0.0.1:5432 TIME_WAIT
tcp 0 0 127.0.0.1:50860 127.0.0.1:5432 TIME_WAIT
tcp 0 0 127.0.0.1:40254 127.0.0.1:5432 TIME_WAIT
tcp 0 0 127.0.0.1:40218 127.0.0.1:5432 TIME_WAIT
tcp 0 0 127.0.0.1:40110 127.0.0.1:5432 TIME_WAIT
I'm totally unfamiliar with Django so not sure where even to look, but that doesn't looks right to me.
Thanks