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
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
24 Prinsip MiliarderSatu lagi e-book buat kamu.... "24 Prinsip Miliarder" Disini dibahas 24 Prinsip Miliarder yang dicerahkan yang ditulis oleh Tung Desem Waringin. Kalau… Read More
How to change SMTP server IP (Exim IP) on WHM server 1) Login to WHM Click Exim Configuration Editor Check the box next to: “Send outgoing mail from the ip that matches the domain name in /etc/mailips … Read More
Graphing Router OS Simple Queue Using CactiI’ve searched the forum and the internet for tutorial on how to capture Router OS’s simple queue OID using cacti, and haven’t find any luck.. So I dec… Read More
0 comments:
Post a Comment