Cacti

  1. Bug #1578144
  2. Comment #15

Comment 15 for bug 1578144

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

Hans,

On 13-05-16 17:23, Hans Rönnbäck wrote:
> Ah, checking the cacti log, it still emits a number of date-related
> errors like:
>
> ERROR: SQL Failed! Error:'1292', Message:'Incorrect datetime value:
> '0000-00-00 00:00:00' for column 'end_time' at row 1', SQL
> Fragment:'INSERT INTO poller_time (poller_id, pid, start_time, end_time)
> VALUES (0, 12814, NOW(), '0000-00-00 00:00:00')'
>
> Tried expanding the patch to remove the NO_ZERO_IN_DATE as well which
> still emits the same error.

Are you by any chance using spine as the poller?

Paul