Cédric I need the debugging entries during a busy period, until you reach the maximum number of connections of your PostgreSQL server. I'm looking at entries such as:
- DBPOOL: create new DB channel - DBPOOL: keeping channel - DBPOOL: garbage collecting Thanks, Francis > On Nov 26, 2021, at 10:43, Cédric Archambeau <[email protected]> wrote: > > Without postgre debug, tell me if you want it : > > Nov 26 16:26:54 sogod [68388]: 185.215.13.175 "REPORT > /SOGo/dav/[email protected]/Contacts/pg_addressbook_name/ HTTP/1.1" 207 > 1517/4915 0.064 27386 94% 0 - 16 > Nov 26 16:26:54 sogod [68388]: <0x0x55bde5374dc0[GCSChannelManager]> DBPOOL: > reused cached DB channel! (0x55bde58f5ad0) > Nov 26 16:26:54 sogod [68388]: <0x0x55bde5374dc0[GCSChannelManager]> DBPOOL: > keeping channel (age 125s, #2, 0x55bde598c160) : > <0x0x55bde58f5ad0[PostgreSQL72Channel]: > connection=<0x0x55bde59b8090[PGConnection]: connection=0x0x55bde59b8250>> > Nov 26 16:26:54 sogod [68388]: <0x0x55bde5374dc0[GCSChannelManager]> DBPOOL: > reused cached DB channel! (0x55bde60e3d80) > Nov 26 16:26:54 sogod [68388]: <0x0x55bde5374dc0[GCSChannelManager]> DBPOOL: > keeping channel (age 41s, #2, 0x55bde5aa1eb0) : > <0x0x55bde60e3d80[PostgreSQL72Channel]: > connection=<0x0x55bde5f93910[PGConnection]: connection=0x0x55bde5b7e560>> > Nov 26 16:26:54 sogod [68388]: <0x0x55bde5374dc0[GCSChannelManager]> DBPOOL: > cannot use handle > (postgresql://dbuser:dbpass@localhost:5432/dbname/table_pg_addressbook > <postgresql://dbuser:dbpass@localhost:5432/dbname/table_pg_addressbook> > vspostgresql://dbuser:dbpass@localhost:5432/sogo/sogocontacts0012926777a > <postgresql://dbuser:dbpass@localhost:5432/sogo/sogocontacts0012926777a>) > Nov 26 16:26:54 sogod [68388]: <0x0x55bde5374dc0[GCSChannelManager]> DBPOOL: > cannot use handle > (postgresql://dbuser:dbpass@localhost:5432/dbname/table_pg_addressbook > <postgresql://dbuser:dbpass@localhost:5432/dbname/table_pg_addressbook> > vspostgresql://dbuser:dbpass@localhost:5432/sogo/sogo_sessions_folder > <postgresql://dbuser:dbpass@localhost:5432/sogo/sogo_sessions_folder>) > Nov 26 16:26:54 sogod [68388]: <0x0x55bde5374dc0[GCSChannelManager]> DBPOOL: > create new DB channel for postgresql://localhost/dbname/table_pg_addressbook > <postgresql://localhost/dbname/table_pg_addressbook> > > HTH > > Cédric Archambeau > Le 26/11/2021 à 15:45, Francis Lachapelle ([email protected] > <mailto:[email protected]>) a écrit : >> Hi Cédric >> >>> On Nov 26, 2021, at 06:29, Cédric Archambeau <[email protected]> >>> <mailto:[email protected]> 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 >> > > -- > [email protected] > https://inverse.ca/sogo/lists -- [email protected] https://inverse.ca/sogo/lists
