Friday, December 4, 2009

No graphs, SQL Cell errors in cacti.log

Standard
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.

Related Posts:

  • 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
  • /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
  • 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
  • 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
  • Cacti Buat MikrotikTernyata sudah lengkap tool untuk monitoring Mikrotik dengan cacti. Jadi sekarang udah bisa menggrap : System HDD CPU Memory Uptime General Active PP… Read More

0 comments:

Post a Comment