group.of.nepali.translators team mailing list archive

[Paul Gevers <1578144@xxxxxxxxxxxxxxxxxx>]

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