Ubuntu
cacti package

  1. Bug #1578144
  2. Comment #3

Comment 3 for bug 1578144

Revision history for this message
Paul Gevers (paul-climbing) wrote : Re: Cacti causes high CPU load via MySQL after upgrade to Ubuntu 16.04

Hi Hans (and all others that experience this issue),

Can you log into your MySQL server (preferably with the same credentials as cacti) and run the following command and report the outcome here:
mysql> SELECT @@global.sql_mode, @@session.sql_mode, @@sql_mode;

On my system, this returns:
mysql> SELECT @@global.sql_mode, @@session.sql_mode, @@sql_mode;
+-------------------+--------------------+------------+
| @@global.sql_mode | @@session.sql_mode | @@sql_mode |
 +-------------------+--------------------+------------+
| | | |
 +-------------------+--------------------+------------+
1 row in set (0.06 sec)

I suspect that you have somewhere sql_mode NO_ZERO_DATE defined. If that is true, I think what I need to request from upstream is that they are robust against that option by clearing that mode in their connection.

Also, I like to know if this was a fresh install (because I expect this issue would cause the install to fail on your system).

And just so we have all the required info, please run:
apport-collect 1578144

Paul