问个cacti监控网卡流量的问题

zing2046

轮询工具已经换成spine，每分钟取值一次，计划任务也改成1分钟执行了，其他的数据都是正常完整的，除了网卡流量取值不正常，是网卡的取值方式是Associated Data Queries，这就没法在数据模板里面更改取值间隔时间了                                                        


那我想解决这个中间有间断怎么处理呢？

laohuanggua

cacti日志是什么？？？


网卡的取值方式是Associated Data Queries，====肯定是这么取值了。

zing2046

回复 2# laohuanggua

日志里面有这样的信息，用红色的也有黄色的：能说明什么信息啊？

    11/30/2010 05:46:20 PM - SPINE: Poller[0] Host[90] TH[1] DS[548] WARNING: SNMP timeout detected [500 ms], ignoring host '192.168.0.104'
11/30/2010 05:46:20 PM - SPINE: Poller[0] Host[90] TH[1] DS[549] WARNING: SNMP timeout detected [500 ms], ignoring host '192.168.0.104'
11/30/2010 05:46:20 PM - SPINE: Poller[0] Host[90] TH[1] DS[549] WARNING: SNMP timeout detected [500 ms], 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[0] 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[0] 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')'

laohuanggua

红的是错误。
黄德是warning


SPINE: Poller[0] Host[90] TH[1] DS[548] WARNING: SNMP timeout detected [500 ms]
把snmp timeout时间调成1500ms。

zing2046

回复 4# laohuanggua


   多谢，snmp超时时间我已经改成1500MS了，等会看看还有没有黄色提示，，那这个红色的说的又是什么呢？vps-disk是我放在目标机上的一个脚本。用来输出磁盘的占用率，是不是也是超时啊？


12/01/2010 02:15:04 PM - SPINE: Poller[0] 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')'

laohuanggua

红色就是error。貌似需要用一个database upgrade.php程序。

vps-disk脚本你是怎么执行的？
ssh到远程上执行？
放在snmpd.conf中用exec执行？

别让我猜谜语哦。

zing2046

回复 6# laohuanggua


    通过snmp执行的，这个没有问题，snmpwalk可以正确查询到执行的结果，而且cacti里面可以正确绘图的没有图像中断。还是有下面的出错提示~~~~

12/02/2010 01:45:07 PM - SPINE: Poller[0] 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[0] 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')'

laohuanggua

Duplicate entry

重复的条目？？？？

你一个查询是查询四个值？？？不知道你部署的是什么？把过程中的要点给说说？