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.
No graphs, SQL Cell errors in cacti.log
StandardRelated Posts:
Creating Graph for Mikrotik Queue Tree using CactiIt’s a long title, isn’t it ? Okay, first thing first, You have to download all these files : cacti_host_template_mikrotik_queue.xml cacti_data_templ… Read More
Mari Belajar BGP Apakah BGP? Border Gateway Protocol atau yang sering disingkat BGP merupakan salah satu jenis routing protocol yang ada di dunia komunikasi data. Se… Read More
Error: Passwords do not match, please retype. Lagi-lagi cacti bermasalah, kali ini errot nya “Error: Passwords do not match, please retype.” cenah,…. ketika mengupdate device atau menambah devi… Read More
/bin/rm: Argument list too long.Squid mati lagi gara-gara disk log full….. di hapus malah keluar error “/bin/rm: Argument list too long.” setelah googling katanya filenya terlalu bes… Read More
Export Graph ProblemLagi-lagi cacti bermasalah, fungsi export graphnya tidak jalan. Biasa… googlin, dan nemu url ini : http://forums.cacti.net/viewtopic.php?t=20612&h… Read More
0 comments:
Post a Comment