Jelte Fennema-Nio

Also I like the `@` sigil for this. But I think we should always have a name after it for clarity, so no bare `@` but `@variant`. `@name` seems like...

Hmm, that's some pretty strange behaviour. ``` 2024-02-05 21:16:48.969 MSK [1502899] LOG started sending cancel request 2024-02-05 21:16:48.975 MSK [1502899] LOG started sending cancel request 2024-02-05 21:16:49.017 MSK [1502899] LOG...

`DEALLOCATE ALL` only applies to the current connection. So no that does not fix the issue.

I agree that that sounds like quite a lot of file descriptors for just 400 connections. Which PgBouncer version is this? And did you change the version when increasing the...

> I can't split this metric by process but I have ERROR in pgbouncer and postgres logs like > Too many open files with server_login_retry for pgbouncer What errors do...

> Maybe there is a global max open file limit in kernel or something else ? pgbouncer takes all fd and postgres doesnt have enought ? fs.file-max is what you...

> I know there are a lot of issues on how to upgrade the max open file for pgbouncer process but I guess if /proc/PID/limit shows 64000, that means the...

> also set > > ``` > sysctl fs.file-max > fs.file-max = 65535 > ``` yeah so, it sounds like that should be set to a larger. Now that you're...

Yeah, I also don't understand why the number is so high. But if PgBouncer is not running, it's pretty much impossible to debug. So that's why I'm suggesting, configure the...

I think mostly using some os tools (`netstat`, `ss`, `lsof`) to find out if it's actually the pgbouncer process that opens the bulk of these files. Or if it's actually...