Bug#344519: Reload cacti graph page generates mysql zombie process for every graph
severity 344519 normal tags 344519 - moreinfo thanks hi eppie, On Tue, Jan 03, 2006 at 09:37:44PM +0100, Eppie 1305 wrote: I've done some more testing and it seems that it wasn't Cacti. adding a variable thread_cache_size 0 in my.cnf did the trick for me. This bug can be closed. thanks for following up on this. i'll put something in README.Debian for others to find, and close the bug when i do so. in the meantime i'll re-adjust the severity. sean signature.asc Description: Digital signature
Bug#344519: Reload cacti graph page generates mysql zombie process for every graph
Hello, I've done some more testing and it seems that it wasn't Cacti. adding a variable thread_cache_size 0 in my.cnf did the trick for me. This bug can be closed. Regards, Epco -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#344519: Reload cacti graph page generates mysql zombie process for every graph
i'll need some more information if you would like to have help with resolving this. here are a few questions off the top of my head: - what version of mysql? mysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i386) - remote mysql server or local? local - what's in my.cnf? grep -v '#' my.cnf gives: [client] port= 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] err-log = /var/log/mysql/mysql.err socket = /var/run/mysqld/mysqld.sock [mysqld] user= mysql pid-file= /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port= 3306 log = /var/log/mysql/mysql.log basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language= /usr/share/mysql/english skip-locking log-slow-queries= /var/log/mysql/mysql-slow.log skip-innodb [mysqldump] quick max_allowed_packet = 1M [mysql] [isamchk] key_buffer = 64M - how many devices (and what kind) are you monitoring? 4 devices (Linux and Windows box, on Linux the number of processes in/out bytes, number of simutaneous users etc. On Windows in/out bytes and processes. - have you tried the suggestions from the forum report mentioned? Yes, but no difference - is this problem present with both cactid and cmd.php? I haven't tried it with cactid. I will do this. - what else is using the database? a webphotoalbum and my ftp server. - does the problem immediately happen after reboot, or only after running for some period of time? yes, as soon as the page is opened, the number of zombieprocesses rises with every refresh and run of cmd.php/poller.php i'm tagging this as moreinfo and unreproducible... if i can't find a way to reproduce it within some period of time, i'm going to downgrade the severity too. Ok, but I have disabled cacti for now. Regards, Epco -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#344519: Reload cacti graph page generates mysql zombie process for every graph
Package: cacti Version: 0.8.6c-7sarge2 Severity: critical Justification: breaks the whole system When I do a reload of the cacti graph page, I see that there is a zombie mysql daemon process created for every graph shown. In the end this results in over 1000 zombie processes and mysql server cannot create any threads anymore. A similar problem is described in http://forums.cacti.net/post-37044.htmlhighlight= Kind regards, Epco -- System Information: Debian Release: 3.1 APT prefers testing APT policy: (500, 'testing') Architecture: i386 (i686) Kernel: Linux 2.4.18-1-686 Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Versions of packages cacti depends on: ii apache 1.3.33-6sarge1 versatile, high-performance HTTP s ii debconf 1.4.30.13 Debian configuration management sy ii libphp-adodb 4.52-1 The 'adodb' database abstraction l ii logrotate3.7-5 Log rotation utility ii mysql-client 4.0.24-10sarge1 mysql database client binaries ii php4 4:4.3.10-16 server-side, HTML-embedded scripti ii php4-cli 4:4.3.10-16 command-line interpreter for the p ii php4-mysql 4:4.3.10-16 MySQL module for php4 ii php4-snmp4:4.3.10-16 SNMP module for php4 di rrdtool 1.0.49-1Time-series data storage and displ ii snmp 5.1.2-6.2 NET SNMP (Simple Network Managemen ii ucf 1.17Update Configuration File: preserv -- debconf information: * cacti/password: (password omitted) cacti/confirm: (password omitted) cacti/root_password: (password omitted) * cacti/username: cacti * cacti/mysql_server: panoramix * cacti/webserver: Apache cacti/save_rootpw: true cacti/upgrade_warning: cacti/root_mysql: root * cacti/no_automagic: cacti/purge_db: true * cacti/database: cacti cacti/mismatch: -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#344519: Reload cacti graph page generates mysql zombie process for every graph
tags 344519 unreproducible moreinfo thanks hi epco, i'll need some more information if you would like to have help with resolving this. here are a few questions off the top of my head: - what version of mysql? - remote mysql server or local? - what's in my.cnf? - how many devices (and what kind) are you monitoring? - have you tried the suggestions from the forum report mentioned? - is this problem present with both cactid and cmd.php? - what else is using the database? - does the problem immediately happen after reboot, or only after running for some period of time? i'm tagging this as moreinfo and unreproducible... if i can't find a way to reproduce it within some period of time, i'm going to downgrade the severity too. sean -- signature.asc Description: Digital signature
