11:31:13 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"select poller_output.output, poller_output.time, UNIX_TIMESTAMP(poller_output.time) as unix_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資料庫Table有問題,輸入mysqlcheck --auto-repair --databases cacti -p SQL密碼
利用此修復指令Mysql的資料庫後,便可重新產生rra檔與看到對應的流量圖
沒有留言:
張貼留言