6.0.0-beta1
▾
Tasks
New Task
Search
Photos
Wiki
▾
Tickets
New Ticket
Search
dev.horde.org
Toggle Alerts Log
Help
11/8/25
H
istory
A
ttachments
C
omment
W
atch
Download
Comment on [#13032] ActiveSync: Too many connections due to MySQL sleep processes
*
Your Email Address
*
Spam protection
Enter the letters below:
. ..___. . . | |[__ |_/ | \__|\__|[___| \\__|
Comment
> Hello, > > today I updated my horde packages through pear. These are the updated > packages: > > upgrade ok: channel://pear.horde.org/Horde_Browser-2.0.5 > upgrade ok: channel://pear.horde.org/Horde_Url-2.2.2 > upgrade ok: channel://pear.horde.org/Horde_Mime-2.3.0 > upgrade ok: channel://pear.horde.org/Horde_Group-2.0.3 > upgrade ok: channel://pear.horde.org/Horde_Date-2.0.8 > upgrade ok: channel://pear.horde.org/Horde_Css_Parser-1.0.4 > upgrade ok: channel://pear.horde.org/Horde_Http-2.0.5 > upgrade ok: channel://pear.horde.org/Horde_Vfs-2.2.0 > upgrade ok: channel://pear.horde.org/Horde_Autoloader-2.1.0 > upgrade ok: channel://pear.horde.org/Horde_Auth-2.1.2 > upgrade ok: channel://pear.horde.org/Horde_SessionHandler-2.2.4 > upgrade ok: channel://pear.php.net/File_Find-1.3.3 > upgrade ok: channel://pear.php.net/Text_CAPTCHA-1.0.2 > upgrade ok: channel://pecl.php.net/pecl_http-1.7.6 > upgrade ok: channel://pear.horde.org/Horde_Db-2.1.0 > upgrade ok: channel://pear.horde.org/Horde_Form-2.0.7 > upgrade ok: channel://pear.horde.org/Horde_Editor-2.0.4 > upgrade ok: channel://pear.horde.org/Horde_ActiveSync-2.13.1 > upgrade ok: channel://pear.horde.org/Horde_Alarm-2.1.0 > upgrade ok: channel://pear.horde.org/Horde_Timezone-1.0.5 > upgrade ok: channel://pear.horde.org/Horde_Crypt-2.4.1 > upgrade ok: channel://pear.horde.org/Horde_Imap_Client-2.19.0 > upgrade ok: channel://pear.horde.org/Horde_Dav-1.0.4 > upgrade ok: channel://pear.horde.org/horde-5.1.6 > upgrade ok: channel://pear.horde.org/Horde_Share-2.0.5 > upgrade ok: channel://pear.horde.org/imp-6.1.7 > upgrade ok: channel://pear.horde.org/nag-4.1.4 > upgrade ok: channel://pear.horde.org/ingo-3.1.4 > upgrade ok: channel://pear.horde.org/kronolith-4.1.5 > upgrade ok: channel://pear.horde.org/turba-4.1.4 > upgrade ok: channel://pear.horde.org/gollem-3.0.2 > upgrade ok: channel://pear.horde.org/mnemo-4.1.3 > upgrade ok: channel://pear.horde.org/webmail-5.1.4 > > Soon after upgrading I got the error message > "Could not instantiate PDO with DSN > "mysql:protocol=unix;dbname=horde". PDOException: SQLSTATE[HY000] > [1040] Too many connections" > After restarting Apache it worked, but after some minutes the error > reappeared. > So I had a look at the MySQL processes, there were many "Sleep" > processes originating from horde, just like this: > > | 165103 | horde | localhost | horde | Sleep | 256 > | | NULL | > > I had a look into the ActiveSync configuration and set > "$conf[activesync][ping][heartbeatmax]" to 120 (default was 2700), > after that the sleeping connections were terminated after 120 seconds > and the "too many connections" error disappeared. After resetting it > to 2700 the problem reappears. > > I'm not sure if it is a problem with ActiveSync, maybe the updated > Horde_Db package is responsible? > Is it a problem to set the heartbeatmax value to 120 seconds? What > could be the cause of the connection problem? > > Thanks a lot in advance, > Christian Hailer
Attachment
Watch this ticket
N
ew Ticket
M
y Tickets
S
earch
Q
uery Builder
R
eports
Saved Queries
Open Bugs
Bugs waiting for Feedback
Open Bugs in Releases
Open Enhancements
Enhancements waiting for Feedback
Bugs with Patches
Enhancements with Patches
Release Showstoppers
Stalled Tickets
New Tickets
Horde 5 Showstoppers