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 -- 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
