And Hans, if you are using spine, does the problem go away with the
change and using cmd.php as poller?
** Also affects: cacti-spine (Ubuntu)
Importance: Undecided
Status: New
** Changed in: cacti-spine (Ubuntu Xenial)
Assignee: (unassigned) => Paul Gevers (paul-climbing)
** Changed in: cacti-spine (Ubuntu Yakkety)
Assignee: (unassigned) => Paul Gevers (paul-climbing)
** Changed in: cacti-spine (Ubuntu Xenial)
Importance: Undecided => Critical
** Changed in: cacti-spine (Ubuntu Yakkety)
Importance: Undecided => Critical
** Summary changed:
- Cacti causes high CPU load via MySQL after upgrade to Ubuntu 16.04
+ cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
--
You received this bug notification because you are a member of नेपाली
भाषा समायोजकहरुको समूह, which is subscribed to Xenial.
Matching subscriptions: Ubuntu 16.04 Bugs
https://bugs.launchpad.net/bugs/1578144
Title:
cacti and cacti-spine are not compatible with MySQL 5.7 default
sql_mode
Status in Cacti:
Incomplete
Status in cacti package in Ubuntu:
Confirmed
Status in cacti-spine package in Ubuntu:
New
Status in cacti source package in Xenial:
Confirmed
Status in cacti-spine source package in Xenial:
New
Status in cacti source package in Yakkety:
Confirmed
Status in cacti-spine source package in Yakkety:
New
Bug description:
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)
---
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
To manage notifications about this bug go to:
https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~group.of.nepali.translators
Post to : group.of.nepali.translators@lists.launchpad.net
Unsubscribe : https://launchpad.net/~group.of.nepali.translators
More help : https://help.launchpad.net/ListHelp
