Package: horde2 Version: 2.2.7-3 Severity: normal Here's the "show processlist" output of the MySQL server I'm using to run horde2:
+--------+----------+-----------------+---------+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +--------+----------+-----------------+---------+---------+------+-------+------------------+ | 766583 | hordemgr | localhost | horde2 | Sleep | 2955 | | | | 766661 | hordemgr | localhost | horde2 | Sleep | 2072 | | | | 766745 | hordemgr | localhost | horde2 | Sleep | 925 | | | | 766750 | hordemgr | localhost | horde2 | Sleep | 1898 | | | | 766942 | hordemgr | localhost | horde2 | Sleep | 1604 | | | | 766943 | hordemgr | localhost | horde2 | Sleep | 1604 | | | | 766945 | hordemgr | localhost | horde2 | Sleep | 1602 | | | | 767389 | hordemgr | localhost | horde2 | Sleep | 944 | | | | 767939 | root | localhost:47105 | | Query | 0 | | show processlist | +--------+----------+-----------------+---------+---------+------+-------+------------------+ As you can see, there are many idle and useless connections from `hordemgr' lasting for up to over 45 minutes. I've looked at the configurations files but I can't see anything related to persistent MySQL connections so I guess this is a bug. In this case, I want this to be fixed. On the over hand, if I'm wrong and if this is a feature, I'd like to find a nice and implicit way to avoid it in the configuration files. Thanks. -- System Information: Debian Release: 3.1 APT prefers unstable APT policy: (500, 'unstable') Architecture: i386 (i686) Kernel: Linux 2.6.9-2-686 Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) Versions of packages horde2 depends on: ii apache [httpd] 1.3.33-3 versatile, high-performance HTTP s ii apache-ssl [httpd] 1.3.33-3 versatile, high-performance HTTP s ii apache2 2.0.52-3 Next generation, scalable, extenda ii apache2-mpm-prefork [httpd] 2.0.52-3 Traditional model for Apache2 ii binutils 2.15-5 The GNU assembler, linker and bina ii debconf 1.4.42 Debian configuration management sy ii gettext 0.14.1-10 GNU Internationalization utilities ii libapache-mod-php4 [phpapi-20 4:4.3.10-2 server-side, HTML-embedded scripti ii logrotate 3.7-2 Log rotation utility ii make 3.80-9 The GNU version of the "make" util ii perl 5.8.4-6 Larry Wall's Practical Extraction ii php4 4:4.3.10-2 server-side, HTML-embedded scripti ii php4-cgi [phpapi-20020918] 4:4.3.10-2 server-side, HTML-embedded scripti ii php4-cli [phpapi-20020918] 4:4.3.10-2 command-line interpreter for the p ii php4-pear 4:4.3.10-2 PEAR - PHP Extension and Applicati ii php4-pear-log 1.6.0-1.1 Log module for PEAR ii wwwconfig-common 0.0.42 Debian web auto configuration -- debconf information: * horde2/welcome: * horde2/databasemgr_port: 3306 * horde2/databasemgr_server: localhost * horde2/dbmyadmin: root * horde2/webserver_type: Apache * horde2/database_user: hordemgr * horde2/databasemgr_type: MySQL * horde2/database_name: horde2 horde2/dbpgadmin: postgres -- Cyril Bouthors
pgpMa5vs2siH3.pgp
Description: PGP signature