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
_______________________________________________
Mailman-users mailing list -- mailman-users@mailman3.org
To unsubscribe send an email to mailman-users-le...@mailman3.org
https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/
Archived at: 
https://lists.mailman3.org/archives/list/mailman-users@mailman3.org/message/YEEPVPEV3XHFPL6GOIGHR4JNBK3VB2VQ/

This message sent to arch...@mail-archive.com

Reply via email to