massmoca pgbouncer open file limits are too low to honor the max allowed connection
the max open file limit is 1024 but the max allowed connection is 2000
In the pgbouncer logs:
2023-05-26 15:25:58.744 UTC [777216] ERROR accept() failed: Too many open files
2023-05-26 15:26:03.747 UTC [777216] ERROR accept() failed: Too many open files
root@massmoca:/proc/777216# cat limits
Limit Soft Limit Hard Limit Units
Max cpu time unlimited unlimited seconds
Max file size unlimited unlimited bytes
Max data size unlimited unlimited bytes
Max stack size 8388608 unlimited bytes
Max core file size 0 unlimited bytes
Max resident set unlimited unlimited bytes
Max processes 1030550 1030550 processes
Max open files 1024 524288 files
Max locked memory 65536 65536 bytes
Max address space unlimited unlimited bytes
Max file locks unlimited unlimited locks
Max pending signals 1030550 1030550 signals
Max msgqueue size 819200 819200 bytes
Max nice priority 0 0
Max realtime priority 0 0
Max realtime timeout unlimited unlimited us
root@massmoca:/proc/777216# ls fd | wc -l
1024