Everything is okay, until the accident last nignt, when the electric was blackout. The cacti server was no graph.
In checking the cacti.log file I see the following:
CMDPHP: Poller[0] ERROR; SQL Cell Failed!, Error:’145′, SQL:”select count(*) from poller_item where rrd_next_step<=0″
CMDPHP: Poller[0] ERROR; SQL Assoc Failed!, Error:’145′, SQL:”select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, 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) LIMIT 10000″
CMDPHP: Poller[0] ERROR; SQL Assoc Failed!, Error:’145′, SQL:”select * FROM poller_item WHERE (host_id >=0 AND host_id <= 49 AND rrd_next_step <= 0) ORDER by host_id”
CMDPHP: Poller[0] ERROR; SQL Cell Failed!, Error:’145′, SQL:”select count(*) FROM poller_item WHERE (action=2 AND host_id >= 0 AND host_id <= 49 AND rrd_next_step <=0)”
CMDPHP: DB Exec Failed!, Error:’145′, SQL:”UPDATE poller_item SET rrd_next_step = rrd_next_step – 300 WHERE (host_id >= 0 AND host_id <=49)’
CMDPHP: DB Exec Failed!, Error:’145′, SQL:”UPDATE poller_item SET rrd_next_step = rrd_step – 300 WHERE (host_id >= 0 AND host_id <=49
as always I googling, and find the resolve :
“mysqlcheck –auto-repair –databases cacti”
It works.
Friday, December 4, 2009
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment