Hi there,
We have a problem with Postgresql connections from SOGo 5.3.0 since few
days (last update monday 22 - community version).
Or we had it before but didn't see it ;-)
Connections stay idle, mainly with an adressbook (PostgreSQL view with
right columns) query from Thunderbird dav (with sogo-connector).
We're using ubuntu server 20.04 (PostgreSQL 12.9 - no pooler),
everything up to date. We configured
idle_in_transaction_session_timeout='5min' as workaround, the job is
done for most of connections, but not on dav queries (maybe because of
the client response?). These dav connections stay, and new ones are
created every 30 min. With few clients we reached tuesday the default
max amount of connections for Postgresql (100). Never happened in five
years of happy use ;-)
With [PGDebugEnabled = YES;], no special observation, queries seem to be
fine.
Restarting SOGo is the only way to clean up everything.
Any idea?
Regards
--
Cédric Archambeau
--
users@sogo.nu
https://inverse.ca/sogo/lists