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
