Shulou(Shulou.com)06/01 Report--

Check one of the monitoring normally in the morning, and the cacti does not show the picture. There was a power outage yesterday. Troubleshooting:

1. Check that the service is normal

2. Check the connection of the service, normal

Check the log and report an error of 145.

An error is reported in the log as follows:

AM-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_name, 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"

MySQL view, collector cache stopped working.

Mysql > select count (*) from poller_output;+-+ | count (*) | +-+ | 0 | +-+ 1 row in set (0.00 sec) mysql >

Solution:

1. Rebuild the collector cache (more convenient)

2. Database cleanup (empty poller_output table)

Truncate table poller_output

Return to normal:

Because the problem occurs only once a year, the parameters are not optimized here.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.