From Small Guinea Pig, 5 Years ago, written in Plain Text.
Embed
  1. Starting Polling Session ...
  2.  
  3. SQL[select `version` from `dbSchema` order by `version` desc limit 1 [] 0.72ms]
  4. SQL[SELECT * FROM `bills` [] 0.71ms]
  5. Bill : Transit ONNET 10Gb - 5Gbps
  6. SQL[SELECT * FROM `bill_ports` as P, `ports` as I, `devices` as D WHERE P.bill_id=? AND I.port_id = P.port_id AND D.device_id = I.device_id ["1"] 1.76ms]
  7. SQL[SELECT NOW() [] 0.33ms]
  8.   Polling Te1/8 (TenGigabitEthernet1/8) on 4900m-core.tvt-datos.es
  9. SQL[SELECT * from `devices` WHERE `hostname` = '4900m-core.tvt-datos.es' LIMIT 1 [] 0.69ms]
  10. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -O qv -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 IF-MIB::ifHCInOctets.8]
  11. 3719443530787224
  12.  
  13. SQL[SELECT * from `devices` WHERE `hostname` = '4900m-core.tvt-datos.es' LIMIT 1 [] 0.94ms]
  14. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -O qv -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 IF-MIB::ifHCOutOctets.8]
  15. 518931173453678
  16.  
  17. SQL[SELECT timestamp, in_counter, in_delta, out_counter, out_delta FROM bill_port_counters WHERE `port_id` = ? AND `bill_id` = ? ["230","1"] 0.74ms]
  18. SQL[SELECT UNIX_TIMESTAMP(CURRENT_TIMESTAMP()) - UNIX_TIMESTAMP('2018-08-20 17:02:50') [] 0.37ms]
  19. SQL[UPDATE `bill_port_counters` set `timestamp`=?,`in_counter`=?,`out_counter`=?,`in_delta`=?,`out_delta`=? WHERE `port_id`='230' AND `bill_id`='1' ["2018-08-20 17:04:10","3719443530787224","518931173453678",31962373663,3337778936] 0.65ms]
  20.   Polling Ethernet47 (Ethernet47) on 7050s-interxion.tvt-datos.es
  21. SQL[SELECT * from `devices` WHERE `hostname` = '7050s-interxion.tvt-datos.es' LIMIT 1 [] 0.7ms]
  22. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -O qv -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 IF-MIB::ifHCInOctets.47]
  23. 3302627838835
  24.  
  25. SQL[SELECT * from `devices` WHERE `hostname` = '7050s-interxion.tvt-datos.es' LIMIT 1 [] 1.11ms]
  26. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -O qv -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 IF-MIB::ifHCOutOctets.47]
  27. 423915066866
  28.  
  29. SQL[SELECT timestamp, in_counter, in_delta, out_counter, out_delta FROM bill_port_counters WHERE `port_id` = ? AND `bill_id` = ? ["650","1"] 0.8ms]
  30. SQL[SELECT UNIX_TIMESTAMP(CURRENT_TIMESTAMP()) - UNIX_TIMESTAMP('2018-08-20 17:02:50') [] 0.35ms]
  31. SQL[UPDATE `bill_port_counters` set `timestamp`=?,`in_counter`=?,`out_counter`=?,`in_delta`=?,`out_delta`=? WHERE `port_id`='650' AND `bill_id`='1' ["2018-08-20 17:04:10","3302627838835","423915066866",235993,150604] 0.48ms]
  32. SQL[SELECT timestamp,delta,in_delta,out_delta FROM bill_data WHERE bill_id = ? ORDER BY timestamp DESC LIMIT 1 ["1"] 0.99ms]
  33. SQL[SELECT UNIX_TIMESTAMP(CURRENT_TIMESTAMP()) - UNIX_TIMESTAMP('2018-08-20 17:02:50') [] 0.33ms]
  34. SQL[INSERT IGNORE INTO `bill_data` (`bill_id`,`timestamp`,`period`,`delta`,`in_delta`,`out_delta`)  VALUES (:bill_id,:timestamp,:period,:delta,:in_delta,:out_delta) {"bill_id":"1","timestamp":"2018-08-20 17:04:10","period":"80","delta":35300539196,"in_delta":31962609656,"out_delta":3337929540} 0.48ms]
  35. SQL[SELECT * FROM `bill_ports` as P, `ports` as I, `devices` as D WHERE P.bill_id=? AND I.port_id = P.port_id AND D.device_id = I.device_id ["-D"] 1.2ms]
  36. SQL[SELECT NOW() [] 0.25ms]
  37. SQL[SELECT timestamp,delta,in_delta,out_delta FROM bill_data WHERE bill_id = ? ORDER BY timestamp DESC LIMIT 1 ["-D"] 0.49ms]
  38. SQL[SELECT UNIX_TIMESTAMP(CURRENT_TIMESTAMP()) - UNIX_TIMESTAMP('2018-08-20 17:02:50') [] 0.28ms]
  39. SQL[INSERT IGNORE INTO `bill_data` (`bill_id`,`timestamp`,`period`,`delta`,`in_delta`,`out_delta`)  VALUES (:bill_id,:timestamp,:period,:delta,:in_delta,:out_delta) {"bill_id":"-D","timestamp":"2018-08-20 17:04:10","period":"80","delta":0,"in_delta":0,"out_delta":0} 0.45ms]
  40. SQL[INSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES (:type,:doing,:start,:duration,:devices,:poller) {"type":"pollbill","doing":null,"start":1534777450.755182,"duration":"0.182","devices":0,"poller":"librenms.tvt-datos.es"} 0.48ms]
  41.  
  42. Completed in 0.182 sec
  43.