CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1194'

[segruber]

Our Cacti Linux server had become unresponsive and as a result our colleague had to reboot the server.

I logged in this am and found that the mysqld and httpd was not set to start on bootup. I've since fixed that but Cacti is not graphing.

The error I get in the Cacti log is :

08/10/2012 09:30:01 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1194', SQL:"UPDATE poller_it_step = rrd_step - 300 WHERE (rrd_next_step < 0 AND host_id >= 0 AND host_id <= 12)'
08/10/2012 09:30:01 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1194', SQL:"UPDATE poller_it_step = rrd_step - 300 WHERE (rrd_next_step < 0 AND host_id >= 13 AND host_id <= 20)'
08/10/2012 09:30:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1194', SQL:"UPDATE poller_it_step = rrd_step - 300 WHERE (rrd_next_step < 0 AND host_id >= 21 AND host_id <= 28)'
08/10/2012 09:30:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'126', SQL:"UPDATE poller_itestep = rrd_next_step - 300 WHERE (host_id >= 29 AND host_id <= 44)'
08/10/2012 09:30:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1194', SQL:"UPDATE poller_it_step = rrd_step - 300 WHERE (rrd_next_step < 0 AND host_id >= 29 AND host_id <= 44)'


Where do I go from here ?

Thanks in advance,
Scott

[segruber]

I need to add some specifics :

Linux version : RHEL 6.1

mysql version : 5.1.52-1

Cacti version : 0.8.7g

Thanks again,
Scott

[segruber]

Anyone have any ideas ?

Thanks,
Scott

[paulgevers]

I am no expert on this at all, but maybe your tables got damaged and you need to get mysql to fix the tables.

[gandalf]

yep, see repair db script in cli directory, please
R.