I see a similar behaviour after upgrading to SOGO 5.2.0 with MySQL as database. After a few hours of client usage the Mysql database runs out of available connections.

Greetings
Florian

On 26.11.2021 17:48, Francis Lachapelle (flachape...@inverse.ca) wrote:
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 <users@sogo.nu> wrote:

Without postgre debug, tell me if you want it :

Nov 26 16:26:54 sogod [68388]: 185.215.13.175 "REPORT /SOGo/dav/user.n...@domain.tld/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 vs 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 vs 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

HTH

Cédric Archambeau
Le 26/11/2021 à 15:45, Francis Lachapelle (flachape...@inverse.ca) a écrit :
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

--
users@sogo.nu
https://inverse.ca/sogo/lists

--
______________________________________________________

Florian Unger                    Intego GmbH
Tel.:  +49-9131-61082-121        Henri-Dunant-Straße 8
Fax.:  +49-9131-61082-999        D-91058 Erlangen
Email:florian.un...@intego.de    Germany
_____________________________________________________

Geschäftsführer:                 Registergericht:
Dr. Peter Plankensteiner         Amtsgericht Fürth      
Dr. Thomas Wagner                HRB 7576
--
users@sogo.nu
https://inverse.ca/sogo/lists

Reply via email to