We recently upgraded Bacula from v9.4 to v9.6 as part of a Ubuntu 18.04 to Ubuntu 20.04 upgrade, and immediately we started noticing hundreds of database connections left open in a read state. As I write this we have 400+ PostgreSQL connections open to the bacula database, all idle, here is a random sample of some of those connections: ( https://pastebin.com/dpPqLwMD ) -- Notice many of the dates are days old now, and the "wait_event" is "ClientRead", if I try to run many of the queries manually they return instantly.
We also had to raise our "ulimit" for open files substantially after this upgrade, which I assume could be related, currently "lsof" shows 112906 entries related to bacula. Sample of these is here: ( https://pastebin.com/VzV6ZPm0 ) We are using bacula.org .deb repo ( http://www.bacula.org/packages/.../debs/9.6.7/focal/amd64/ ) on a fairly stock Ubuntu 20.04 install, the entire server is dedicated to Bacula and nothing else. Any ideas how we could fix this? Thanks.
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
