問個cacti監控網卡流量的問題
http://www.51cacti.cn/attachment.php?aid=Mjc2fGEwMzhlZWNmfDEyOTEwODkxNzJ8M2I0OXJLR1djb01uWWdqK2ZZV1orYjRmT2xVVURGaFVmL3FGMjVCbjJna05Hdnc%3D&noupdate=yes
輪詢工具已經換成spine，每分鐘取值一次，計劃任務也改成1分鐘執行了，其他的數據都是正常完整的，除了網卡流量取值不正常，是網卡的取值方式是Associated Data Queries，這就沒法在數據模板裡面更改取值間隔時間了
那我想解決這個中間有間斷怎麼處理呢？
《解決方案》
cacti日誌是什麼？？？
網卡的取值方式是Associated Data Queries，====肯定是這麼取值了。
《解決方案》
回復 2# laohuanggua
日誌裡面有這樣的信息，用紅色的也有黃色的：能說明什麼信息啊？
11/30/2010 05:46:20 PM - SPINE: Poller Host TH DS WARNING: SNMP timeout detected , ignoring host '192.168.0.104'
11/30/2010 05:46:20 PM - SPINE: Poller Host TH DS WARNING: SNMP timeout detected , ignoring host '192.168.0.104'
11/30/2010 05:46:20 PM - SPINE: Poller Host TH DS WARNING: SNMP timeout detected , ignoring host '192.168.0.104'
11/30/2010 05:45:22 PM - SYSTEM STATS: Time:21.4243 Method:spine Processes:1 Threads:1 Hosts:59 HostsPerProcess:59 DataSources:307 RRDsProcessed:478
11/30/2010 05:45:22 PM - SPINE: Poller ERROR: SQL Failed! Error:'1062', Message:'Duplicate entry '553--2010-11-30 17:45:22' for key 1', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (553,'','2010-11-30 17:45:22','1min:0.63 5min:0.54 10min:0.86'),(552,'mem_swap','2010-11-30 17:45:22','3873352'),(551,'mem_buffers','2010-11-30 17:45:22','20992'),(554,'users','2010-11-30 17:45:22','5'),(555,'proc','2010-11-30 17:45:22','369'),(556,'vps_disk','2010-11-30 17:45:22','83')'
11/30/2010 05:45:22 PM - SPINE: Poller ERROR: SQL Failed! Error:'1062', Message:'Duplicate entry '547-proc-2010-11-30 17:45:22' for key 1', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (547,'proc','2010-11-30 17:45:22','369'),(550,'traffic_out','2010-11-30 17:45:22','320974679'),(550,'traffic_in','2010-11-30 17:45:22','2692585700'),(548,'vps_disk','2010-11-30 17:45:22','13'),(545,'','2010-11-30 17:45:22','1min:0.63 5min:0.54 10min:0.86'),(546,'users','2010-11-30 17:45:22','5'),(544,'mem_swap','2010-11-30 17:45:22','3873352'),(543,'mem_buffers','2010-11-30 17:45:22','21240')'
《解決方案》
紅的是錯誤。
黃德是warning
SPINE: Poller Host TH DS WARNING: SNMP timeout detected
把snmp timeout時間調成1500ms。
《解決方案》
回復 4# laohuanggua
多謝，snmp超時時間我已經改成1500MS了，等會看看還有沒有黃色提示，，那這個紅色的說的又是什麼呢？vps-disk是我放在目標機上的一個腳本。用來輸出磁碟的佔用率，是不是也是超時啊？
12/01/2010 02:15:04 PM - SPINE: Poller ERROR: SQL Failed! Error:'1062', Message:'Duplicate entry '189-mem_buffers-2010-12-01 14:15:03' for key 1', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (189,'mem_buffers','2010-12-01 14:15:03','18384'),(190,'mem_swap','2010-12-01 14:15:03','3880448'),(191,'users','2010-12-01 14:15:03','5'),(192,'proc','2010-12-01 14:15:03','371'),(193,'vps_disk','2010-12-01 14:15:03','U')'
《解決方案》
紅色就是error。貌似需要用一個database upgrade.php程序。
vps-disk腳本你是怎麼執行的？
ssh到遠程上執行？
放在snmpd.conf中用exec執行？
別讓我猜謎語哦。:emn28:
《解決方案》
回復 6# laohuanggua
通過snmp執行的，這個沒有問題，snmpwalk可以正確查詢到執行的結果，而且cacti裡面可以正確繪圖的沒有圖像中斷。還是有下面的出錯提示~~~~
12/02/2010 01:45:07 PM - SPINE: Poller ERROR: SQL Failed! Error:'1062', Message:'Duplicate entry '535-mem_buffers-2010-12-02 13:45:04' for key 1', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (535,'mem_buffers','2010-12-02 13:45:04','43356'),(536,'mem_swap','2010-12-02 13:45:04','3750964'),(537,'','2010-12-02 13:45:04','1min:6.76 5min:4.24 10min:4.23'),(538,'users','2010-12-02 13:45:04','4'),(539,'proc','2010-12-02 13:45:04','382'),(540,'vps_disk','2010-12-02 13:45:04','8')'
12/02/2010 01:45:06 PM - SPINE: Poller ERROR: SQL Failed! Error:'1062', Message:'Duplicate entry '527-mem_buffers-2010-12-02 13:45:04' for key 1', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (527,'mem_buffers','2010-12-02 13:45:04','34940'),(528,'mem_swap','2010-12-02 13:45:04','3750964'),(532,'vps_disk','2010-12-02 13:45:04','1'),(531,'proc','2010-12-02 13:45:04','388'),(530,'users','2010-12-02 13:45:04','4'),(529,'','2010-12-02 13:45:04','1min:6.76 5min:4.24 10min:4.23')'
《解決方案》
Duplicate entry
重複的條目？？？？
你一個查詢是查詢四個值？？？不知道你部署的是什麼？把過程中的要點給說說？
