Help with Cacti [EZ 0.6] - it just barfed on me, what to do?

[vodka]

Hi gang, I'm hoping someone can point me in the right direction as I'm trying to fix my issue.

I'm running CactiEZ in VM (version 0.6 32bit) on my windows 7 machine. Details.

acti Version 0.8.7c
Plugin Architecture 2.2
Poller Type Cactid v
Server Info Linux 2.6.9-78.0.13.ELsmp
Web Server Apache/2.0.63 (CentOS)
PHP Version 5.1.6
PHP Extensions libxml, xml, wddx, tokenizer, sysvshm, sysvsem, sysvmsg, standard, SimpleXML, sockets, SPL, shmop, session, Reflection, pspell, posix, mime_magic, iconv, hash, gmp, gettext, ftp, exif, date, curl, ctype, calendar, bz2, zlib, pcre, openssl, apache2handler, gd, ldap, mysql, mysqli, PDO, pdo_mysql, pdo_sqlite, snmp, eAccelerator
MySQL Version 5.0.68
RRDTool Version 1.2.23
SNMP Version 5.1.2
Plugins Global Plugin Settings (settings - v0.5)
Large Site Performane Booster for Cacti (boost - v2.2)
Device Monitoring (monitor - v0.8.2)
Network Discovery (discovery - v0.8.5)
Network Tools (tools - v0.3)
Syslog Monitoring (syslog - v0.5.2)
Device Tracking (mactrack - v1.1)
Login Page Mod (loginmod - v1.0)
Update Checker (update - v0.4)
FlowView (flowview - v0.6)
Host Info (hostinfo - v0.2)
Error Images (errorimage - v0.1)
PHP Network Weathermap (weathermap - v0.95b)
docs
Cacti-ReportIt (reportit - v0.6.1)
Router Configs (routerconfigs - v0.1)
WMI Query (wmi - v0.1)
Realtime for Cacti (realtime - v0.35)

When I installed it, everything was running fine, until one day when I noticed the graphs weren't working.. then noticed in the VM window all kinds of syslog errors...

-Looked it up, found posts on running mysql fix statements... errors gone it looked like, bunch of things fixed.
-Restarted, nothing is happening, no graphs, and VERY sluggish response (even when SSH in, takes like minutes to get the next prompt)
-Restarted again, getting errors on the file system, forget the exact error. Looked it up, suggestion fsck... ran this and it seemed to find issues and fixed it
-Restarted, still no graphs... looked at the log, I'm totally lost. I'm posting a bit of it below.

Now I don't know if I can just save the devices configuration, start it from scratch and just rebuild; of course I have also added scripts and such that I didn't document.

Is there a way to purge the database of the polled data, and set it back to "clean settings" without losing all my scripts, and device configurations?

Thanks in advance.

12/09/2015 06:01:30 PM - SPINE: Poller[0] ERROR: Spine Timed Out While Processing Hosts Internal
12/09/2015 06:02:01 PM - POLLER: Poller[0] WARNING: Cron is out of sync with the Poller Interval! The Poller Interval is '60' seconds, with a maximum of a '300' second Cron, but 91 seconds have passed since the last poll!
12/09/2015 06:02:12 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_incoming','52158')'
12/09/2015 06:02:12 PM - SPINE: Poller[0] Host[1] ERROR: Empty result [127.0.0.1]: '/usr/bin/php -q /var/www/html/plugins/syslog/syslog_counter.php'
12/09/2015 06:02:37 PM - SPINE: Poller[0] Host[1] ERROR: The POPEN timed out
12/09/2015 06:03:00 PM - POLLER: Poller[0] Maximum runtime of 58 seconds exceeded. Exiting.
12/09/2015 06:03:11 PM - SPINE: Poller[0] ERROR: Spine Timed Out While Processing Hosts Internal
12/09/2015 06:03:15 PM - SYSTEM STATS: Time:74.0319 Method:spine Processes:1 Threads:1 Hosts:8 HostsPerProcess:8 DataSources:148 RRDsProcessed:0
12/09/2015 06:03:17 PM - POLLER: Poller[0] WARNING: Cron is out of sync with the Poller Interval! The Poller Interval is '60' seconds, with a maximum of a '300' second Cron, but 76 seconds have passed since the last poll!
12/09/2015 06:03:18 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_incoming','52176')'
12/09/2015 06:03:18 PM - SPINE: Poller[0] Host[1] ERROR: Empty result [127.0.0.1]: '/usr/bin/php -q /var/www/html/plugins/syslog/syslog_counter.php'
12/09/2015 06:03:43 PM - SPINE: Poller[0] Host[1] ERROR: The POPEN timed out
12/09/2015 06:04:16 PM - POLLER: Poller[0] Maximum runtime of 58 seconds exceeded. Exiting.
12/09/2015 06:04:16 PM - SYSTEM STATS: Time:59.1643 Method:spine Processes:1 Threads:1 Hosts:8 HostsPerProcess:8 DataSources:148 RRDsProcessed:0
12/09/2015 06:04:17 PM - SPINE: Poller[0] ERROR: Spine Timed Out While Processing Hosts Internal
12/09/2015 06:05:02 PM - POLLER: Poller[0] WARNING: Cron is out of sync with the Poller Interval! The Poller Interval is '60' seconds, with a maximum of a '300' second Cron, but 105 seconds have passed since the last poll!
12/09/2015 06:05:03 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_incoming','52194')'
12/09/2015 06:05:03 PM - SPINE: Poller[0] Host[1] ERROR: Empty result [127.0.0.1]: '/usr/bin/php -q /var/www/html/plugins/syslog/syslog_counter.php'
12/09/2015 06:05:28 PM - SPINE: Poller[0] Host[1] ERROR: The POPEN timed out
12/09/2015 06:06:01 PM - POLLER: Poller[0] Maximum runtime of 58 seconds exceeded. Exiting.
12/09/2015 06:06:01 PM - SYSTEM STATS: Time:59.3993 Method:spine Processes:1 Threads:1 Hosts:8 HostsPerProcess:8 DataSources:148 RRDsProcessed:0
12/09/2015 06:06:02 PM - SPINE: Poller[0] ERROR: Spine Timed Out While Processing Hosts Internal
12/09/2015 06:06:07 PM - POLLER: Poller[0] WARNING: Cron is out of sync with the Poller Interval! The Poller Interval is '60' seconds, with a maximum of a '300' second Cron, but 65 seconds have passed since the last poll!
12/09/2015 06:06:07 PM - POLLER: Poller[0] WARNING: Poller Output Table not Empty. Issues Found: 6, Data Sources: mem_buffers(DS[19]), mem_swap(DS[20]), (DS[21]), (DS[22]), (DS[23]), proc(DS[25])
12/09/2015 06:06:08 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_incoming','52211')'
12/09/2015 06:06:08 PM - SPINE: Poller[0] Host[1] ERROR: Empty result [127.0.0.1]: '/usr/bin/php -q /var/www/html/plugins/syslog/syslog_counter.php'
12/09/2015 06:06:33 PM - SPINE: Poller[0] Host[1] ERROR: The POPEN timed out
12/09/2015 06:07:07 PM - SPINE: Poller[0] ERROR: Spine Timed Out While Processing Hosts Internal
12/09/2015 06:07:12 PM - POLLER: Poller[0] Maximum runtime of 58 seconds exceeded. Exiting.
12/09/2015 06:07:12 PM - SYSTEM STATS: Time:64.3392 Method:spine Processes:1 Threads:1 Hosts:8 HostsPerProcess:8 DataSources:148 RRDsProcessed:0
12/09/2015 06:07:12 PM - POLLER: Poller[0] WARNING: Cron is out of sync with the Poller Interval! The Poller Interval is '60' seconds, with a maximum of a '300' second Cron, but 65 seconds have passed since the last poll!
12/09/2015 06:07:12 PM - POLLER: Poller[0] WARNING: Poller Output Table not Empty. Issues Found: 6, Data Sources: mem_buffers(DS[19]), mem_swap(DS[20]), (DS[21]), (DS[22]), (DS[23]), proc(DS[25])
12/09/2015 06:07:14 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_incoming','52228')'
12/09/2015 06:07:14 PM - SPINE: Poller[0] Host[1] ERROR: Empty result [127.0.0.1]: '/usr/bin/php -q /var/www/html/plugins/syslog/syslog_counter.php'
12/09/2015 06:07:39 PM - SPINE: Poller[0] Host[1] ERROR: The POPEN timed out
12/09/2015 06:08:11 PM - POLLER: Poller[0] Maximum runtime of 58 seconds exceeded. Exiting.
12/09/2015 06:08:12 PM - SYSTEM STATS: Time:59.4444 Method:spine Processes:1 Threads:1 Hosts:8 HostsPerProcess:8 DataSources:149 RRDsProcessed:0
12/09/2015 06:08:12 PM - SPINE: Poller[0] ERROR: Spine Timed Out While Processing Hosts Internal
12/09/2015 06:08:18 PM - POLLER: Poller[0] WARNING: Cron is out of sync with the Poller Interval! The Poller Interval is '60' seconds, with a maximum of a '300' second Cron, but 66 seconds have passed since the last poll!
12/09/2015 06:08:28 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_incoming','52246')'
12/09/2015 06:08:28 PM - SPINE: Poller[0] Host[1] ERROR: Empty result [127.0.0.1]: '/usr/bin/php -q /var/www/html/plugins/syslog/syslog_counter.php'
12/09/2015 06:08:53 PM - SPINE: Poller[0] Host[1] ERROR: The POPEN timed out
12/09/2015 06:09:17 PM - POLLER: Poller[0] Maximum runtime of 58 seconds exceeded. Exiting.
12/09/2015 06:09:27 PM - SPINE: Poller[0] ERROR: Spine Timed Out While Processing Hosts Internal
12/09/2015 06:09:31 PM - SYSTEM STATS: Time:73.6727 Method:spine Processes:1 Threads:1 Hosts:8 HostsPerProcess:8 DataSources:148 RRDsProcessed:0
12/09/2015 06:10:01 PM - POLLER: Poller[0] WARNING: Cron is out of sync with the Poller Interval! The Poller Interval is '60' seconds, with a maximum of a '300' second Cron, but 103 seconds have passed since the last poll!
12/09/2015 06:10:01 PM - POLLER: Poller[0] WARNING: Poller Output Table not Empty. Issues Found: 6, Data Sources: mem_buffers(DS[19]), mem_swap(DS[20]), (DS[21]), (DS[22]), (DS[23]), proc(DS[25])
12/09/2015 06:10:02 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_incoming','52267')'
12/09/2015 06:10:02 PM - SPINE: Poller[0] Host[1] ERROR: Empty result [127.0.0.1]: '/usr/bin/php -q /var/www/html/plugins/syslog/syslog_counter.php'
12/09/2015 06:10:27 PM - SPINE: Poller[0] Host[1] ERROR: The POPEN timed out
12/09/2015 06:11:01 PM - SPINE: Poller[0] ERROR: Spine Timed Out While Processing Hosts Internal
12/09/2015 06:11:00 PM - POLLER: Poller[0] Maximum runtime of 58 seconds exceeded. Exiting.
12/09/2015 06:11:08 PM - SYSTEM STATS: Time:67.1226 Method:spine Processes:1 Threads:1 Hosts:8 HostsPerProcess:8 DataSources:148 RRDsProcessed:0
12/09/2015 06:11:02 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_incoming','52281')'
12/09/2015 06:11:08 PM - SPINE: Poller[0] Host[1] ERROR: Empty result [127.0.0.1]: '/usr/bin/php -q /var/www/html/plugins/syslog/syslog_counter.php'
12/09/2015 06:11:33 PM - SPINE: Poller[0] Host[1] ERROR: The POPEN timed out
12/09/2015 06:12:01 PM - SPINE: Poller[0] ERROR: Spine Timed Out While Processing Hosts Internal

[cigamit]

Seems like one of your mysql tables crashed and needs repairs.

You might also check that none of the partitions is full.

[vodka]

I tried these two commands, but it didn't seem to fix anything..

mysqlcheck --auto-repair --databases syslog
mysqlcheck --auto-repair --databases cacti

The error message I was seeing (syslog related) dissapeared, but the graphs still not working.

I have to mention, that response from Cacti (web or ssh) is SUUUUPER slow...

[vodka]

I was getting an error [Duplicate entry 'xxxx' for key 1] and after searching I found the following: http://gregsowell.com/?p=3122

I followed the advice here there, and now Cacti is VERY responsive and quick, as before.

However, now none of the graphs are being updated not sure what I need to do...

Any help would be outstanding, there are no more errors..