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:
Five best practices to improve your email delivery success rate In the modern day world of email delivery, recipient ISPs place great amount of emphasis on verifying the legitimacy of senders email to their cus… 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
How to Delete mailman archives from cPanel backend Go to “/usr/local/cpanel/3rdparty/mailman/archives/private” #cd /usr/local/cpanel/3rdparty/mailman/archives/private You can see lots o… 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
Postfix queue file corrupted Today, my Fedora based mail server crashed. It is has a small (160G) drive for the base file system and a RAID 5 (4x500G) for storage. Unfortunatel… Read More
0 comments:
Post a Comment