Hello,
I too am running into this same problem. I have never had issues with MySQL
connections, and usually operate with 550 connections MAX (in my.sql). I
upgraded to 5.3, and I started getting a ton of "out of connection" messages. I
bumped to 1,000 connections just to try and make it through the day, and we are
exceeding that as well! This is a heavily used mailserver (if that wasn't
obvious from the numbers), but it has been rock solid for over 2 years. I'm not
sure where to go - but hoping progress is being made on this issue.
Bill Bushong
From: users-requ...@sogo.nu On Behalf Of Florian Unger
Sent: Wednesday, December 1, 2021 01:29
To: users@sogo.nu
Subject: Re: [SOGo] PostgreSQL Idle connections from
These are the log file entries when sogo runs out of SQL connections:
sogo-mailcow_1 | Nov 30 20:53:18 679d32496afb sogod [67]:
<0x0x5600edf67520[GCSChannelManager]> DBPOOL: reused cached DB channel!
(0x5600ee9aa2e0)
sogo-mailcow_1 | Nov 30 20:53:18 679d32496afb sogod [67]:
<0x0x5600edf67520[GCSChannelManager]> DBPOOL: keeping channel (age 43s, #1,
0x5600edf629c0) :
sogo-mailcow_1 | Nov 30 20:53:18 679d32496afb sogod [67]:
<0x0x5600edf67520[GCSChannelManager]> DBPOOL: reused cached DB channel!
(0x5600ee9aa2e0)
sogo-mailcow_1 | Nov 30 20:53:18 679d32496afb sogod [67]:
<0x0x5600edf67520[GCSChannelManager]> DBPOOL: keeping channel (age 43s, #1,
0x5600edf629c0) :
sogo-mailcow_1 | Nov 30 20:53:18 679d32496afb sogod [67]:
<0x0x5600edf67520[GCSChannelManager]> DBPOOL: reused cached DB channel!
(0x5600ee9aa2e0)
sogo-mailcow_1 | Nov 30 20:54:17 679d32496afb sogod [63]:
<0x0x5600edfb8c60[GCSChannelManager]> DBPOOL: garbage collecting 0 channels.
sogo-mailcow_1 | Nov 30 20:54:17 679d32496afb sogod [71]:
<0x0x5600edf72180[GCSChannelManager]> DBPOOL: garbage collecting 0 channels.
sogo-mailcow_1 | Nov 30 20:56:37 679d32496afb sogod [67]:
<0x0x5600edf67520[GCSChannelManager]> DBPOOL: create new DB channel for
mysql:///var/run/mysqld/mysqld.sock/mailcow/_sogo_static_view
sogo-mailcow_1 | Nov 30 20:56:37 679d32496afb sogod [67]:
<0x0x5600edf67520[GCSChannelManager]> DBPOOL: keeping channel (age 0s, #1,
0x5600ee456510) :
sogo-mailcow_1 | Nov 30 20:56:37 679d32496afb sogod [67]:
<0x0x5600edf67520[GCSChannelManager]> DBPOOL: reused cached DB channel!
(0x5600ee763d70)
sogo-mailcow_1 | Nov 30 20:56:37 679d32496afb sogod [67]:
<0x0x5600edf67520[GCSChannelManager]> DBPOOL: create new DB channel for
mysql:///var/run/mysqld/mysqld.sock/mailcow/sogo_user_profile
sogo-mailcow_1 | Nov 30 20:56:37 679d32496afb 2021-11-30 20:56:37.496
sogod[67:67] EXCEPTION:
NAME:NoMoreConnections REASON:cannot open a additional connection ! INFO:(null)
sogo-mailcow_1 | Nov 30 20:56:37 679d32496afb sogod [67]: 62.63.64.65
"REPORT
/SOGo/dav/test.test%40test.de/Calendar/sek_A_test_D_de_3B-60534C80-59-4A5D0F00/
HTTP/1.0" 501 0/188 0.004 - - 0 - 162
sogo-mailcow_1 | Nov 30 20:56:37 679d32496afb sogod [67]:
<0x0x5600edf67520[GCSChannelManager]> DBPOOL: create new DB channel for
mysql:///var/run/mysqld/mysqld.sock/mailcow/sogo_folder_info
sogo-mailcow_1 | Nov 30 20:56:37 679d32496afb 2021-11-30 20:56:37.578
sogod[67:67] EXCEPTION:
NAME:NoMoreConnections REASON:cannot open a additional connection ! INFO:(null)
sogo-mailcow_1 | Nov 30 20:56:37 679d32496afb sogod [67]: 62.63.64.65
"REPORT /SOGo/dav/test.test%40test.de/Calendar/personal/ HTTP/1.0" 501 0/188
0.002 - - 0 - 162
sogo-mailcow_1 | Nov 30 20:56:39 679d32496afb sogod [67]:
<0x0x5600edf67520[GCSChannelManager]> DBPOOL: create new DB channel for
mysql:///var/run/mysqld/mysqld.sock/mailcow/sogo_folder_info
sogo-mailcow_1 | Nov 30 20:56:39 679d32496afb 2021-11-30 20:56:39.394
sogod[67:67] EXCEPTION:
NAME:NoMoreConnections REASON:cannot open a additional connection ! INFO:(null)
sogo-mailcow_1 | Nov 30 20:56:39 679d32496afb sogod [67]: 62.63.64.65
"REPORT
/SOGo/dav/test.test%40test.de/Calendar/sek_A_test_D_de_44-5E835E00-7-77A0F280/
HTTP/1.0" 501 0/188 0.002 - - 0 - 162Nov 30 20:56:39 sogod [63]:
<0x0x5600edfb8c60[GCSChannelManager]> DBPOOL: reused cached DB channel!
(0x5600ee7b60a0)
sogo-mailcow_1 | Nov 30 20:56:39 679d32496afb sogod [63]:
<0x0x5600edfb8c60[GCSChannelManager]> DBPOOL: reused cached DB channel!
(0x5600eedb2560)
sogo-mailcow_1 | Nov 30 20:56:39 679d32496afb sogod [63]:
<0x0x5600edfb8c60[GCSChannelManager]> DBPOOL: freeing old channel (age 244s,
0x5600eedb2560)
sogo-mailcow_1 | Nov 30 20:56:39 679d32496afb sogod [63]:
<0x0x5600edfb8c60[GCSChannelManager]> DBPOOL: create new DB channel for
mysql:///var/run/mysqld/mysqld.sock/mailcow/sogo_user_profile
sogo-mailcow_1 | Nov 30 20:56:39 679d32496afb sogod [63]:
<0x0x5600edfb8c60[GCSChannelMana