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:
No graphs, SQL Cell errors in cacti.logEverything 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… 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
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
How to change the unit for simple queue traffic from byte to bit goto Console -> Templates -> Graph Templates Tick Mikrotik – Queue – Simple Traffic (bytes/sec, Total Bandwidth) Mikrotik – Queue – Tree Traf… Read More
0 comments:
Post a Comment