[SOGo] BTS activities for Friday, November 26 2021

[SOGo reporter]

Title: BTS activities for Friday, November 26 2021





  
BTS Activities

  Home page: https://sogo.nu/bugs
  Project: SOGo
  For the period covering: Friday, November 26 2021

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
5434
	2021-11-26 08:35:54
	resolved (fixed)
	Web Mail
	Links in HTML emails are erroneously converted to lowercase
	
	  
	
5433
	2021-11-26 08:15:09
	closed (not a bug)
	Backend Mail
	Is SOGoMailAuxiliaryUserAccountsEnabled broken?
	
	  
	
  
  


-- users@sogo.nuhttps://inverse.ca/sogo/lists

Re: [SOGo] PostgreSQL Idle connections from

[Francis Lachapelle]

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  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 
>  
> vspostgresql://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 
>  
> vspostgresql://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  
>>>  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

Re: [SOGo] PostgreSQL Idle connections from

[cedric.archamb...@solidairesfinancespubliques.org]

Hi Francis,

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  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

Re: [SOGo] PostgreSQL Idle connections from

[Francis Lachapelle]

Hi Cédric

> On Nov 26, 2021, at 06:29, Cédric Archambeau  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

[SOGo] PostgreSQL Idle connections from

[cedric.archamb...@solidairesfinancespubliques.org]

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