SQL Assoc Failed Error after Logrotate

[dtinklenberg]

CentOS 7. Cacti 0.8.8b.

Recently the hard drive filled up on the server running Cacti and I noticed that cacti.log had grown to over 31 GB. So, I manually ran a log rotation and also set the log rotation to happen daily rather than monthly. Since then, whenever the log rotation happens, Cacti stops graphing and I get these errors in the log:

08/25/2016 08:00:37 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1017', SQL:"select poller_output.output, poller_output.time, UNIX_TIMESTAMP(poller_output.time) as unix_time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) "

When I run a mysqlcheck, I get this error:

Error : Can't find file: 'poller_output' (errno: 2)
status : Operation failed

If I run the repair-database.php script it says it successfully repairs the poller_output table, but I still keep getting the above errors.

The only thing that resolves the issue is to run "truncate poller_output." Then I stop seeing the above errors and graphing begins again until the logrotate runs again and then the errors start again.

Does anyone have any suggestions for me on how to resolve this?

Thanks.

[dtinklenberg]

Figured out that it's no the logrotation causing the error after I changed the logrotation back to monthly and started getting the SQL Assoc Failed errors at the same time as I did before. I am seeing this error in the log, right before I start getting the SQL Assoc Failed errors:

08/27/2016 03:05:15 AM - POLLER: Poller[0] WARNING: Cron is out of sync with the Poller Interval! The Poller Interval is '300' seconds, with a maximum of a '300' second Cron, but 314 seconds have passed since the last poll!


Any ideas how to resolve this error?