Hi Cédric > On Nov 26, 2021, at 06:29, Cédric Archambeau <users@sogo.nu> wrote: > > 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.
Can you enable GCSChannelManagerPoolDebugEnabled and share the log entries? Thanks, Francis -- users@sogo.nu https://inverse.ca/sogo/lists
