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.