Starting Polling Session ...

SQL[select `version` from `dbSchema` order by `version` desc limit 1 [] 0.72ms]
SQL[SELECT * FROM `bills` [] 0.71ms]
Bill : Transit ONNET 10Gb - 5Gbps
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]
SQL[SELECT NOW() [] 0.33ms]
  Polling Te1/8 (TenGigabitEthernet1/8) on 4900m-core.tvt-datos.es
SQL[SELECT * from `devices` WHERE `hostname` = '4900m-core.tvt-datos.es' LIMIT 1 [] 0.69ms]
SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -O qv -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 IF-MIB::ifHCInOctets.8]
3719443530787224

SQL[SELECT * from `devices` WHERE `hostname` = '4900m-core.tvt-datos.es' LIMIT 1 [] 0.94ms]
SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -O qv -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 IF-MIB::ifHCOutOctets.8]
518931173453678

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]
SQL[SELECT UNIX_TIMESTAMP(CURRENT_TIMESTAMP()) - UNIX_TIMESTAMP('2018-08-20 17:02:50') [] 0.37ms]
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]
  Polling Ethernet47 (Ethernet47) on 7050s-interxion.tvt-datos.es
SQL[SELECT * from `devices` WHERE `hostname` = '7050s-interxion.tvt-datos.es' LIMIT 1 [] 0.7ms]
SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -O qv -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 IF-MIB::ifHCInOctets.47]
3302627838835

SQL[SELECT * from `devices` WHERE `hostname` = '7050s-interxion.tvt-datos.es' LIMIT 1 [] 1.11ms]
SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -O qv -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 IF-MIB::ifHCOutOctets.47]
423915066866

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]
SQL[SELECT UNIX_TIMESTAMP(CURRENT_TIMESTAMP()) - UNIX_TIMESTAMP('2018-08-20 17:02:50') [] 0.35ms]
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]
SQL[SELECT timestamp,delta,in_delta,out_delta FROM bill_data WHERE bill_id = ? ORDER BY timestamp DESC LIMIT 1 ["1"] 0.99ms]
SQL[SELECT UNIX_TIMESTAMP(CURRENT_TIMESTAMP()) - UNIX_TIMESTAMP('2018-08-20 17:02:50') [] 0.33ms]
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]
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]
SQL[SELECT NOW() [] 0.25ms]
SQL[SELECT timestamp,delta,in_delta,out_delta FROM bill_data WHERE bill_id = ? ORDER BY timestamp DESC LIMIT 1 ["-D"] 0.49ms]
SQL[SELECT UNIX_TIMESTAMP(CURRENT_TIMESTAMP()) - UNIX_TIMESTAMP('2018-08-20 17:02:50') [] 0.28ms]
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]
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]

Completed in 0.182 sec