Comment 4 for bug 1578144

Revision history for this message
Andrew (b-u1) wrote : Re: Cacti causes high CPU load via MySQL after upgrade to Ubuntu 16.04

Hi Paul. I'm the "other" who has reported this problem.

Here's your requested output (tidied up a tiny bit):

| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |

You are indeed correct that NO_ZERO_IN_DATE is in there.

This is not a fresh install on my system. It's been running for a while, originally installed with Ubuntu 14.10, then upgraded to 15.04, and finally now to 16.04 LTS, which is when the reported problem appeared.

I have not run apport-collect, as I am not the original reporter of this problem, but I can certainly provide any additional information from my system if you need it.

-andrew