apport information
** Tags added: apport-collected xenial
** Description changed:
Ubuntu 16.04 LTS
Cacti 0.8.8f which is the default version for Ubuntu 16.04 uses invalid
datetime values ("0000-00-00 00:00:00"). MySQL 5.7 does not support
zero-dates, this causes the Cacti poller script to run amok and execute
the same SQL queries over and over. In my case this ends up with MySQL
consuming about 35% CPU and php (via the poller) about 15% CPU.
- This probably goes for clean installs as well (as Cacti has this invalid
- datetime in a number of the php-files supplied by the Cacti package)
+ This probably goes for clean installs as well (as Cacti has this invalid
datetime in a number of the php-files supplied by the Cacti package)
+ ---
+ ApportVersion: 2.20.1-0ubuntu2
+ Architecture: amd64
+ DistroRelease: Ubuntu 16.04
+ InstallationDate: Installed on 2013-11-08 (915 days ago)
+ InstallationMedia: Ubuntu-Server 13.10 "Saucy Salamander" - Release amd64
(20131016)
+ Package: cacti 0.8.8f+ds1-4ubuntu4 [modified:
usr/share/cacti/site/lib/database.php]
+ PackageArchitecture: all
+ ProcVersionSignature: Ubuntu 4.4.0-22.39-generic 4.4.8
+ Tags: xenial
+ Uname: Linux 4.4.0-22-generic x86_64
+ UpgradeStatus: Upgraded to xenial on 2016-05-03 (8 days ago)
+ UserGroups: adm cdrom dip lpadmin media plugdev sambashare sudo www-data
+ _MarkForUpload: True
+ modified.conffile..etc.cron.d.cacti:
+ #MAILTO=root
+ #*/5 * * * * www-data php --define suhosin.memory_limit=512M
/usr/share/cacti/site/poller.php 2>&1 >/dev/null | if [ -f /usr/bin/ts ] ; then
ts ; else tee ; fi >> /var/log/cacti/poller-error.log
+ mtime.conffile..etc.cron.d.cacti: 2016-05-04T14:31:46.265760
** Attachment added: "Dependencies.txt"
https://bugs.launchpad.net/bugs/1578144/+attachment/4661049/+files/Dependencies.txt
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1578144
Title:
Cacti causes high CPU load via MySQL after upgrade to Ubuntu 16.04
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/cacti/+bug/1578144/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
