RRDcached works fine with all graphs except for ports for which POE was recognized (asking myself sometimes also why). Syslog captures a "handle_request_update failure (cannot find the respective -ds3.rrd) and the consequent rrd creation also fails. I checked authorization etc, but all ok (for all other rrdβs it works anyhow). Since I donβt know the dependencies between port-id-poe.rrd and port-id*-dot3.rrd I am now stuck with my investigation.
I can cheat by creating the file port-id*-dot3.rrd manually. Then there is no error message. But the port-id*poe.rrd is also not updated anymore. Since this issue is with about 600 ports, I would be happy if I donβt have to cheat for all. Background explanation and / or a concrete fix would be highly appreciated.
Using one Server/VM as an example. Attached a syslog extract, poller extract and a list of the rrd files created.
----------------------------------------
LibreNMS | 1.37-71-g96a4a71
DB Schema | 240
PHP | 7.2.3-1+ubuntu16.04.1+deb.sury.org+1
MySQL | 5.7.21-0ubuntu0.16.04.1
RRDTool | 1.5.5
SNMP | NET-SNMP 5.7.3
----------------------------------------
Poller Extract:
Port eth0: Microsoft Corporation Device 0003 (2 / #247517) ifHCInOctets ifHCOutOctets ifHCInUcastPkts ifHCOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifHCInMulticastPkts ifOutMulticastPkts ifHighSpeed dot3Duplex VLAN == Using ifDescr as ifAliasMicrosoft Corporation Device 0003
ifInOctets (92435 B) 770.29166666667 Bps 120 secs
ifOutOctets (24830 B) 206.91666666667 Bps 120 secs
ifInErrors (0 B) 0 Bps 120 secs
ifOutErrors (0 B) 0 Bps 120 secs
ifInUcastPkts (111 B) 0.925 Bps 120 secs
ifOutUcastPkts (111 B) 0.925 Bps 120 secs
ifInNUcastPkts (0 B) 0 Bps 120 secs
ifOutNUcastPkts (0 B) 0 Bps 120 secs
ifInDiscards (0 B) 0 Bps 120 secs
ifOutDiscards (0 B) 0 Bps 120 secs
ifInUnknownProtos (0 B) 0 Bps 120 secs
ifInBroadcastPkts (0 B) 0 Bps 120 secs
ifOutBroadcastPkts (0 B) 0 Bps 120 secs
ifInMulticastPkts (807 B) 6.725 Bps 120 secs
ifOutMulticastPkts (0 B) 0 Bps 120 secs
bps(6.160kbps/1.660kbps)bytes(90.270kB/24.250kB)pkts(0.930pps/0.930pps)RRD[ [0;32mlast duisburg.dcn.local/port-id247517.rrd --daemon unix:/var/run/rrdcached.sock [0m]
RRD[ [0;32mupdate duisburg.dcn.local/port-id247517.rrd N:2044332583:290092718:0:0:1392430:1336106:U:U:0:0:U:0:0:17850475:0 --daemon unix:/var/run/rrdcached.sock [0m]
RRD[ [0;32mlast duisburg.dcn.local/port-id247517-dot3.rrd --daemon unix:/var/run/rrdcached.sock [0m]
RRD[ [0;32mcreate duisburg.dcn.local/port-id247517-dot3.rrd --step 300 RRA:AVERAGE:0.5:1:2016 RRA:AVERAGE:0.5:6:1440 RRA:AVERAGE:0.5:24:1440 RRA:AVERAGE:0.5:288:1440 RRA:MIN:0.5:1:720 RRA:MIN:0.5:6:1440 RRA:MIN:0.5:24:775 RRA:MIN:0.5:288:797 RRA:MAX:0.5:1:720 RRA:MAX:0.5:6:1440 RRA:MAX:0.5:24:775 RRA:MAX:0.5:288:797 RRA:LAST:0.5:1:1440 -O --daemon unix:/var/run/rrdcached.sock [0m]
RRD[ [0;32mupdate duisburg.dcn.local/port-id247517-dot3.rrd N --daemon unix:/var/run/rrdcached.sock [0m]
EtherLike RRD[ [0;32mlast duisburg.dcn.local/port-id247517-poe.rrd --daemon unix:/var/run/rrdcached.sock [0m]
RRD[ [0;32mupdate duisburg.dcn.local/port-id247517-poe.rrd N:U:U:U:U --daemon unix:/var/run/rrdcached.sock [0m]
PoE SQL[ [0;33mUPDATE ports
set poll_time
=β1520589162β,poll_prev
=β1520589042β,poll_period
=β120β,ifLastChange
=β0β,ifInOctets
=β2044332583β,ifInOctets_prev
=β2044240148β,ifInOctets_rate
=β770.29166666667β,ifInOctets_delta
=β92435β,ifOutOctets
=β290092718β,ifOutOctets_prev
=β290067888β,ifOutOctets_rate
=β206.91666666667β,ifOutOctets_delta
=β24830β,ifInErrors
=β0β,ifInErrors_prev
=β0β,ifInErrors_rate
=β0β,ifInErrors_delta
=β0β,ifOutErrors
=β0β,ifOutErrors_prev
=β0β,ifOutErrors_rate
=β0β,ifOutErrors_delta
=β0β,ifInUcastPkts
=β1392430β,ifInUcastPkts_prev
=β1392319β,ifInUcastPkts_rate
=β0.925β,ifInUcastPkts_delta
=β111β,ifOutUcastPkts
=β1336106β,ifOutUcastPkts_prev
=β1335995β,ifOutUcastPkts_rate
=β0.925β,ifOutUcastPkts_delta
=β111β WHERE port_id
= β247517β [0m]
SQL[ [0;33mUPDATE ports_statistics
set ifInNUcastPkts
=β0β,ifInNUcastPkts_prev
=β0β,ifInNUcastPkts_rate
=β0β,ifInNUcastPkts_delta
=β0β,ifOutNUcastPkts
=β0β,ifOutNUcastPkts_prev
=β0β,ifOutNUcastPkts_rate
=β0β,ifOutNUcastPkts_delta
=β0β,ifInDiscards
=β0β,ifInDiscards_prev
=β0β,ifInDiscards_rate
=β0β,ifInDiscards_delta
=β0β,ifOutDiscards
=β0β,ifOutDiscards_prev
=β0β,ifOutDiscards_rate
=β0β,ifOutDiscards_delta
=β0β,ifInUnknownProtos
=β0β,ifInUnknownProtos_prev
=β0β,ifInUnknownProtos_rate
=β0β,ifInUnknownProtos_delta
=β0β,ifInBroadcastPkts
=β0β,ifInBroadcastPkts_prev
=β0β,ifInBroadcastPkts_rate
=β0β,ifInBroadcastPkts_delta
=β0β,ifOutBroadcastPkts
=β0β,ifOutBroadcastPkts_prev
=β0β,ifOutBroadcastPkts_rate
=β0β,ifOutBroadcastPkts_delta
=β0β,ifInMulticastPkts
=β17850475β,ifInMulticastPkts_prev
=β17849668β,ifInMulticastPkts_rate
=β6.725β,ifInMulticastPkts_delta
=β807β,ifOutMulticastPkts
=β0β,ifOutMulticastPkts_prev
=β0β,ifOutMulticastPkts_rate
=β0β,ifOutMulticastPkts_delta
=β0β WHERE port_id
= β247517β [0m]
2 updated
Runtime for poller module βportsβ: 0.4247 seconds with 34168 bytes
SNMP: [17/0.38s] MySQL: [6/0.01s] RRD: [11/0.01s]