librenms@librenms:~$ ./poller.php -r -f -p -d -h -m storage LibreNMS Poller SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.4ms] SQL[select count(*) as aggregate from `migrations` [] 0.2ms] SQL[select version() [] 0.16ms] =========================================== Component | Version --------- | ------- LibreNMS | 23.2.0-3-gc0fd1e15e (2023-02-24T12:10:10+00:00) DB Schema | 2022_08_15_084507_add_rrd_type_to_wireless_sensors_table (248) PHP | 8.2.3 Python | 3.10.6 Database | MariaDB 10.11.2-MariaDB RRDTool | 1.7.2 SNMP | 5.9.1 =========================================== DEBUG! Updating os_def.cache Override poller modules: storage Starting polling run: SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '' ORDER BY `device_id` ASC [] 0.64ms] SQL[select * from `devices` where `device_id` = ? limit 1 [41] 0.25ms] SQL[select * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [41] 0.18ms] Attempting to initialize OS: truenas OS initialized as Generic Hostname: Device ID: 41 OS: truenas Resolved IP: 10.0.20.7 [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' '' response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 2.28/4.92/10.1 SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ixsystems' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'] SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.50536.3.1 SQL[insert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `debug`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?, ?) [2.28,10.1,4.92,3,3,0,"{\"poller_name\":\"librenms\"}",41,"2023-02-28 14:29:27"] 1.02ms] SQL[update `devices` set `last_ping_timetaken` = ? where `device_id` = ? [4.92,41] 0.32ms] SQL[select * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` is null order by `going_down` desc limit 1 [41] 0.35ms] Modules status: Global+ OS Device #### Load poller module core #### SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ixsystems' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-On' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysUpTime.0'] .*.*.0 = 10630219 SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ixsystems' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'] SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = 106302 HOST-RESOURCES-MIB::hrSystemUptime.0 = 26400890 Uptime seconds: 264009 Uptime: 3 days 1 hour 20 minutes 9 seconds SQL[update `devices` set `uptime` = ? where `device_id` = ? [264009,41] 0.42ms] >> Runtime for poller module 'core': 0.0663 seconds with 107168 bytes >> SNMP: [2/0.06s] MySQL: [1/0.00s] #### Unload poller module core #### Modules status: Global+ OS Device #### Load poller module storage #### SQL[SELECT * FROM storage WHERE device_id = ? [41] 0.35ms] Storage tank/.system/cores: freenas-dataset SNMP['/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'FREENAS-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ixsystems' 'udp:HOSTNAME:161' 'datasetTable'] datasetIndex.1 = 1 datasetIndex.2 = 2 datasetIndex.3 = 3 datasetIndex.4 = 4 datasetIndex.5 = 5 datasetIndex.6 = 6 datasetIndex.7 = 7 datasetIndex.8 = 8 datasetIndex.9 = 9 datasetIndex.10 = 10 datasetIndex.11 = 11 datasetIndex.12 = 12 datasetIndex.13 = 13 datasetIndex.14 = 14 datasetIndex.15 = 15 datasetIndex.16 = 16 datasetIndex.17 = 17 datasetDescr.1 = tank/.system/cores datasetDescr.2 = tank/.system/samba4 datasetDescr.3 = tank/.system/services datasetDescr.4 = tank/.system/configs-8f179c8648fc4419af075a5cf26c19f8 datasetDescr.5 = tank/ datasetDescr.6 = tank datasetDescr.7 = tank/homes datasetDescr.8 = tank/.system/ctdb_shared_vol datasetDescr.9 = tank/.system/rrd-8f179c8648fc4419af075a5cf26c19f8 datasetDescr.10 = tank/ datasetDescr.11 = tank/ datasetDescr.12 = boot-pool/grub datasetDescr.13 = tank/.system/glusterd datasetDescr.14 = boot-pool/ROOT/22.12.1 datasetDescr.15 = tank/.system/webui datasetDescr.16 = tank/.system datasetDescr.17 = tank/.system/syslog-8f179c8648fc4419af075a5cf26c19f8 datasetAllocationUnits.1 = 261888 datasetAllocationUnits.2 = 797568 datasetAllocationUnits.3 = 261888 datasetAllocationUnits.4 = 773760 datasetAllocationUnits.5 = 654983012928 datasetAllocationUnits.6 = 3562475308416 datasetAllocationUnits.7 = 583296 datasetAllocationUnits.8 = 261888 datasetAllocationUnits.9 = 32093184 datasetAllocationUnits.10 = 2907384516672 datasetAllocationUnits.11 = 261888 datasetAllocationUnits.12 = 8585216 datasetAllocationUnits.13 = 279744 datasetAllocationUnits.14 = 2833498112 datasetAllocationUnits.15 = 261888 datasetAllocationUnits.16 = 49824192 datasetAllocationUnits.17 = 14344320 datasetSize.1 = 1073479936 datasetSize.2 = 19542032824960 datasetSize.3 = 19542032824960 datasetSize.4 = 19542032824960 datasetSize.5 = 19542032824960 datasetSize.6 = 19542032824960 datasetSize.7 = 19542032824960 datasetSize.8 = 19542032824960 datasetSize.9 = 19542032824960 datasetSize.10 = 19542032824960 datasetSize.11 = 19542032824960 datasetSize.12 = 95988752384 datasetSize.13 = 19542032824960 datasetSize.14 = 95988752384 datasetSize.15 = 19542032824960 datasetSize.16 = 19542032824960 datasetSize.17 = 19542032824960 datasetUsed.1 = 261888 datasetUsed.2 = 797568 datasetUsed.3 = 261888 datasetUsed.4 = 773760 datasetUsed.5 = 654983012928 datasetUsed.6 = 380928 datasetUsed.7 = 583296 datasetUsed.8 = 261888 datasetUsed.9 = 32093184 datasetUsed.10 = 2907384516672 datasetUsed.11 = 261888 datasetUsed.12 = 8585216 datasetUsed.13 = 279744 datasetUsed.14 = 2821681152 datasetUsed.15 = 261888 datasetUsed.16 = 488064 datasetUsed.17 = 14344320 array ( 'dataset' => array ( 1 => array ( 'datasetIndex' => '1', 'datasetDescr' => 'tank/.system/cores', 'datasetAllocationUnits' => '261888', 'datasetSize' => '1073479936', 'datasetUsed' => '261888', ), 2 => array ( 'datasetIndex' => '2', 'datasetDescr' => 'tank/.system/samba4', 'datasetAllocationUnits' => '797568', 'datasetSize' => '19542032824960', 'datasetUsed' => '797568', ), 3 => array ( 'datasetIndex' => '3', 'datasetDescr' => 'tank/.system/services', 'datasetAllocationUnits' => '261888', 'datasetSize' => '19542032824960', 'datasetUsed' => '261888', ), 4 => array ( 'datasetIndex' => '4', 'datasetDescr' => 'tank/.system/configs-8f179c8648fc4419af075a5cf26c19f8', 'datasetAllocationUnits' => '773760', 'datasetSize' => '19542032824960', 'datasetUsed' => '773760', ), 5 => array ( 'datasetIndex' => '5', 'datasetDescr' => 'tank/', 'datasetAllocationUnits' => '654983012928', 'datasetSize' => '19542032824960', 'datasetUsed' => '654983012928', ), 6 => array ( 'datasetIndex' => '6', 'datasetDescr' => 'tank', 'datasetAllocationUnits' => '3562475308416', 'datasetSize' => '19542032824960', 'datasetUsed' => '380928', ), 7 => array ( 'datasetIndex' => '7', 'datasetDescr' => 'tank/homes', 'datasetAllocationUnits' => '583296', 'datasetSize' => '19542032824960', 'datasetUsed' => '583296', ), 8 => array ( 'datasetIndex' => '8', 'datasetDescr' => 'tank/.system/ctdb_shared_vol', 'datasetAllocationUnits' => '261888', 'datasetSize' => '19542032824960', 'datasetUsed' => '261888', ), 9 => array ( 'datasetIndex' => '9', 'datasetDescr' => 'tank/.system/rrd-8f179c8648fc4419af075a5cf26c19f8', 'datasetAllocationUnits' => '32093184', 'datasetSize' => '19542032824960', 'datasetUsed' => '32093184', ), 10 => array ( 'datasetIndex' => '10', 'datasetDescr' => 'tank/', 'datasetAllocationUnits' => '2907384516672', 'datasetSize' => '19542032824960', 'datasetUsed' => '2907384516672', ), 11 => array ( 'datasetIndex' => '11', 'datasetDescr' => 'tank/', 'datasetAllocationUnits' => '261888', 'datasetSize' => '19542032824960', 'datasetUsed' => '261888', ), 12 => array ( 'datasetIndex' => '12', 'datasetDescr' => 'boot-pool/grub', 'datasetAllocationUnits' => '8585216', 'datasetSize' => '95988752384', 'datasetUsed' => '8585216', ), 13 => array ( 'datasetIndex' => '13', 'datasetDescr' => 'tank/.system/glusterd', 'datasetAllocationUnits' => '279744', 'datasetSize' => '19542032824960', 'datasetUsed' => '279744', ), 14 => array ( 'datasetIndex' => '14', 'datasetDescr' => 'boot-pool/ROOT/22.12.1', 'datasetAllocationUnits' => '2833498112', 'datasetSize' => '95988752384', 'datasetUsed' => '2821681152', ), 15 => array ( 'datasetIndex' => '15', 'datasetDescr' => 'tank/.system/webui', 'datasetAllocationUnits' => '261888', 'datasetSize' => '19542032824960', 'datasetUsed' => '261888', ), 16 => array ( 'datasetIndex' => '16', 'datasetDescr' => 'tank/.system', 'datasetAllocationUnits' => '49824192', 'datasetSize' => '19542032824960', 'datasetUsed' => '488064', ), 17 => array ( 'datasetIndex' => '17', 'datasetDescr' => 'tank/.system/syslog-8f179c8648fc4419af075a5cf26c19f8', 'datasetAllocationUnits' => '14344320', 'datasetSize' => '19542032824960', 'datasetUsed' => '14344320', ), ), ) Reporting disabled by user setting array ( 'storage_id' => 670, 'device_id' => 41, 'storage_mib' => 'freenas-dataset', 'storage_index' => '1', 'storage_type' => 'dataset', 'storage_descr' => 'tank/.system/cores', 'storage_size' => 281131513479168, 'storage_units' => 261888, 'storage_used' => 281131513479168, 'storage_free' => 0, 'storage_perc' => 100, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '261888', 'size' => 281131513479168, 'free' => 0, 'used' => 281131513479168, ) 100% SQL[UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? ["281131513479168","0","281131513479168",261888,100,670] 0.36ms] Storage tank/.system/samba4: freenas-dataset array ( 'storage_id' => 671, 'device_id' => 41, 'storage_mib' => 'freenas-dataset', 'storage_index' => '2', 'storage_type' => 'dataset', 'storage_descr' => 'tank/.system/samba4', 'storage_size' => 9223372036854775807, 'storage_units' => 797568, 'storage_used' => 9223372036854775807, 'storage_free' => 0, 'storage_perc' => 100, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '797568', 'size' => 1.5586100036137697E+19, 'free' => 0, 'used' => 1.5586100036137697E+19, ) 100% SQL[UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? ["1.5586100036138E+19","0","1.5586100036138E+19",797568,100,671] 0.19ms] Storage tank/.system/services: freenas-dataset array ( 'storage_id' => 672, 'device_id' => 41, 'storage_mib' => 'freenas-dataset', 'storage_index' => '3', 'storage_type' => 'dataset', 'storage_descr' => 'tank/.system/services', 'storage_size' => 5118101114344931328, 'storage_units' => 261888, 'storage_used' => 5118101114344931328, 'storage_free' => 0, 'storage_perc' => 100, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '261888', 'size' => 5117823892463124480, 'free' => 0, 'used' => 5117823892463124480, ) 100% SQL[UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? ["5117823892463124480","0","5117823892463124480",261888,100,672] 0.37ms] Storage tank/.system/configs-8f179c8648fc4419af075a5cf26c19f8: freenas-dataset array ( 'storage_id' => 673, 'device_id' => 41, 'storage_mib' => 'freenas-dataset', 'storage_index' => '4', 'storage_type' => 'dataset', 'storage_descr' => 'tank/.system/configs-8f179c8648fc4419af075a5cf26c19f8', 'storage_size' => 9223372036854775807, 'storage_units' => 773760, 'storage_used' => 9223372036854775807, 'storage_free' => 0, 'storage_perc' => 100, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '773760', 'size' => 1.512084331864105E+19, 'free' => 0, 'used' => 1.512084331864105E+19, ) 100% SQL[UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? ["1.5120843318641E+19","0","1.5120843318641E+19",773760,100,673] 0.16ms] Storage tank/: freenas-dataset array ( 'storage_id' => 674, 'device_id' => 41, 'storage_mib' => 'freenas-dataset', 'storage_index' => '5', 'storage_type' => 'dataset', 'storage_descr' => 'tank/', 'storage_size' => 9223372036854775807, 'storage_units' => 2147483647, 'storage_used' => 9223372036854775807, 'storage_free' => 0, 'storage_perc' => 100, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '654983012928', 'size' => 1.2799699538430177E+25, 'free' => 0, 'used' => 1.2799699538430177E+25, ) 100% SQL[UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? ["1.279969953843E+25","0","1.279969953843E+25",654983012928,100,674] 0.17ms] Storage tank: freenas-dataset array ( 'storage_id' => 675, 'device_id' => 41, 'storage_mib' => 'freenas-dataset', 'storage_index' => '6', 'storage_type' => 'dataset', 'storage_descr' => 'tank', 'storage_size' => 9223372036854775807, 'storage_units' => 2147483647, 'storage_used' => 9223372036854775807, 'storage_free' => 0, 'storage_perc' => 100, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '3562475308416', 'size' => 6.961800941517497E+25, 'free' => 0, 'used' => 6.961800941517497E+25, ) 100% SQL[UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? ["6.9618009415175E+25","0","6.9618009415175E+25",3562475308416,100,675] 0.16ms] Storage tank/homes: freenas-dataset array ( 'storage_id' => 676, 'device_id' => 41, 'storage_mib' => 'freenas-dataset', 'storage_index' => '7', 'storage_type' => 'dataset', 'storage_descr' => 'tank/homes', 'storage_size' => 9223372036854775807, 'storage_units' => 583296, 'storage_used' => 9223372036854775807, 'storage_free' => 0, 'storage_perc' => 100, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '583296', 'size' => 1.1398789578667868E+19, 'free' => 0, 'used' => 1.1398789578667868E+19, ) 100% SQL[UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? ["1.1398789578668E+19","0","1.1398789578668E+19",583296,100,676] 0.15ms] Storage tank/.system/ctdb_shared_vol: freenas-dataset array ( 'storage_id' => 677, 'device_id' => 41, 'storage_mib' => 'freenas-dataset', 'storage_index' => '8', 'storage_type' => 'dataset', 'storage_descr' => 'tank/.system/ctdb_shared_vol', 'storage_size' => 5118101114344931328, 'storage_units' => 261888, 'storage_used' => 5118101114344931328, 'storage_free' => 0, 'storage_perc' => 100, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '261888', 'size' => 5117823892463124480, 'free' => 0, 'used' => 5117823892463124480, ) 100% SQL[UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? ["5117823892463124480","0","5117823892463124480",261888,100,677] 0.25ms] Storage tank/.system/rrd-8f179c8648fc4419af075a5cf26c19f8: freenas-dataset array ( 'storage_id' => 678, 'device_id' => 41, 'storage_mib' => 'freenas-dataset', 'storage_index' => '9', 'storage_type' => 'dataset', 'storage_descr' => 'tank/.system/rrd-8f179c8648fc4419af075a5cf26c19f8', 'storage_size' => 9223372036854775807, 'storage_units' => 32021760, 'storage_used' => 9223372036854775807, 'storage_free' => 0, 'storage_perc' => 100, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '32093184', 'size' => 6.271660551854811E+20, 'free' => 0, 'used' => 6.271660551854811E+20, ) 100% SQL[UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? ["6.2716605518548E+20","0","6.2716605518548E+20",32093184,100,678] 0.23ms] Storage tank/: freenas-dataset array ( 'storage_id' => 679, 'device_id' => 41, 'storage_mib' => 'freenas-dataset', 'storage_index' => '10', 'storage_type' => 'dataset', 'storage_descr' => 'tank/', 'storage_size' => 9223372036854775807, 'storage_units' => 2147483647, 'storage_used' => 9223372036854775807, 'storage_free' => 0, 'storage_perc' => 100, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '2907384516672', 'size' => 5.681620365958469E+25, 'free' => 0, 'used' => 5.681620365958469E+25, ) 100% SQL[UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? ["5.6816203659585E+25","0","5.6816203659585E+25",2907384516672,100,679] 0.14ms] Storage tank/: freenas-dataset array ( 'storage_id' => 680, 'device_id' => 41, 'storage_mib' => 'freenas-dataset', 'storage_index' => '11', 'storage_type' => 'dataset', 'storage_descr' => 'tank/', 'storage_size' => 5118101114344931328, 'storage_units' => 261888, 'storage_used' => 5118101114344931328, 'storage_free' => 0, 'storage_perc' => 100, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '261888', 'size' => 5117823892463124480, 'free' => 0, 'used' => 5117823892463124480, ) 100% SQL[UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? ["5117823892463124480","0","5117823892463124480",261888,100,680] 0.2ms] Storage boot-pool/grub: freenas-dataset array ( 'storage_id' => 681, 'device_id' => 41, 'storage_mib' => 'freenas-dataset', 'storage_index' => '12', 'storage_type' => 'dataset', 'storage_descr' => 'boot-pool/grub', 'storage_size' => 824084489272557568, 'storage_units' => 8585216, 'storage_used' => 824084489272557568, 'storage_free' => 0, 'storage_perc' => 100, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '8585216', 'size' => 824084172787154944, 'free' => 0, 'used' => 824084172787154944, ) 100% SQL[UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? ["824084172787154944","0","824084172787154944",8585216,100,681] 0.19ms] Storage tank/.system/glusterd: freenas-dataset array ( 'storage_id' => 682, 'device_id' => 41, 'storage_mib' => 'freenas-dataset', 'storage_index' => '13', 'storage_type' => 'dataset', 'storage_descr' => 'tank/.system/glusterd', 'storage_size' => 5467062553959358464, 'storage_units' => 279744, 'storage_used' => 5467062553959358464, 'storage_free' => 0, 'storage_perc' => 100, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '279744', 'size' => 5466766430585610240, 'free' => 0, 'used' => 5466766430585610240, ) 100% SQL[UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? ["5466766430585610240","0","5466766430585610240",279744,100,682] 0.19ms] Storage boot-pool/ROOT/22.12.1: freenas-dataset array ( 'storage_id' => 683, 'device_id' => 41, 'storage_mib' => 'freenas-dataset', 'storage_index' => '14', 'storage_type' => 'dataset', 'storage_descr' => 'boot-pool/ROOT/22.12.1', 'storage_size' => 9223372036854775807, 'storage_units' => 2147483647, 'storage_used' => 9223372036854775807, 'storage_free' => 0, 'storage_perc' => 100, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '2833498112', 'size' => 2.719839486532995E+20, 'free' => 0, 'used' => 2.719839486532995E+20, ) 100% SQL[UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? ["2.719839486533E+20","0","2.719839486533E+20",2833498112,100,683] 0.15ms] Storage tank/.system/webui: freenas-dataset array ( 'storage_id' => 684, 'device_id' => 41, 'storage_mib' => 'freenas-dataset', 'storage_index' => '15', 'storage_type' => 'dataset', 'storage_descr' => 'tank/.system/webui', 'storage_size' => 5118101114344931328, 'storage_units' => 261888, 'storage_used' => 5118101114344931328, 'storage_free' => 0, 'storage_perc' => 100, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '261888', 'size' => 5117823892463124480, 'free' => 0, 'used' => 5117823892463124480, ) 100% SQL[UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? ["5117823892463124480","0","5117823892463124480",261888,100,684] 0.19ms] Storage tank/.system: freenas-dataset array ( 'storage_id' => 686, 'device_id' => 41, 'storage_mib' => 'freenas-dataset', 'storage_index' => '16', 'storage_type' => 'dataset', 'storage_descr' => 'tank/.system', 'storage_size' => 9223372036854775807, 'storage_units' => 49752768, 'storage_used' => 9223372036854775807, 'storage_free' => 0, 'storage_perc' => 100, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '49824192', 'size' => 9.736659955411094E+20, 'free' => 0, 'used' => 9.736659955411094E+20, ) 100% SQL[UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? ["9.7366599554111E+20","0","9.7366599554111E+20",49824192,100,686] 0.2ms] Storage tank/.system/syslog-8f179c8648fc4419af075a5cf26c19f8: freenas-dataset array ( 'storage_id' => 701, 'device_id' => 41, 'storage_mib' => 'freenas-dataset', 'storage_index' => '17', 'storage_type' => 'dataset', 'storage_descr' => 'tank/.system/syslog-8f179c8648fc4419af075a5cf26c19f8', 'storage_size' => 9223372036854775807, 'storage_units' => 14344320, 'storage_used' => 9223372036854775807, 'storage_free' => 0, 'storage_perc' => 100, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '14344320', 'size' => 2.803171722917302E+20, 'free' => 0, 'used' => 2.803171722917302E+20, ) 100% SQL[UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? ["2.8031717229173E+20","0","2.8031717229173E+20",14344320,100,701] 0.15ms] >> Runtime for poller module 'storage': 0.2281 seconds with 15240 bytes >> SNMP: [1/0.22s] MySQL: [18/0.04s] #### Unload poller module storage #### Polled in 1.356 seconds ### Start Device Groups ### SQL[select * from `device_groups` [] 0.2ms] SQL[select * from `device_group_device` where `device_group_device`.`device_id` = ? [41] 0.21ms] Groups Added: Groups Removed: ### End Device Groups, runtime: 0.0023s ### #### Start Alerts #### SQL[select `device_groups`.*, `device_group_device`.`device_id` as `pivot_device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id` from `device_groups` inner join `device_group_device` on `device_groups`.`id` = `device_group_device`.`device_group_id` where `device_group_device`.`device_id` = ? [41] 0.23ms] SQL[select * from `locations` where `locations`.`id` = ? limit 1 [13] 0.19ms] SQL[select exists(select * from `alert_schedule` where (`start` <= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) or (time(`start`) > time(`end`) and (time(`start`) <= ? or time(`end`) > ?))) and (`recurring_day` like ? or `recurring_day` is null)))) and (exists (select * from `devices` inner join `alert_schedulables` on `devices`.`device_id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?) or exists (select * from `locations` inner join `alert_schedulables` on `locations`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?))) as `exists` ["2023-02-28T14:29:27.635927Z","2023-02-28T14:29:27.635927Z",0,1,"14:29:27","14:29:27","14:29:27","14:29:27","%","device",41,"location",13] 0.42ms] SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [41] 0.28ms] SQL[SELECT DISTINCT a.* FROM alert_rules a LEFT JOIN alert_device_map d ON a.id=d.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND d.device_id = ?) LEFT JOIN alert_group_map g ON a.id=g.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND g.group_id IN (SELECT DISTINCT device_group_id FROM device_group_device WHERE device_id = ?)) LEFT JOIN alert_location_map l ON a.id=l.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND l.location_id IN (SELECT DISTINCT location_id FROM devices WHERE device_id = ?)) LEFT JOIN devices ld ON l.location_id=ld.location_id AND ld.device_id = ? LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ? WHERE a.disabled = 0 AND ( (d.device_id IS NULL AND g.group_id IS NULL AND l.location_id IS NULL) OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=? OR ld.device_id=?)) OR (a.invert_map = 1 AND (d.device_id != ? OR d.device_id IS NULL) AND (dg.device_id != ? OR dg.device_id IS NULL) AND (ld.device_id != ? OR ld.device_id IS NULL)) ) [41,41,41,41,41,41,41,41,41,41,41] 0.63ms] Rule #1 (Devices up/down): SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [41] 0.26ms] SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [1,41] 0.16ms] Status: NOCHG Rule #5 (Processor usage over 85%): SQL[SELECT * FROM devices,processors WHERE (devices.device_id = ? AND devices.device_id = processors.device_id) AND processors.processor_usage > 85 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [41] 0.27ms] SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [5,41] 0.15ms] Status: NOCHG #### End Alerts #### ./poller.php 2023-02-28 14:29:27 - 1 devices polled in 1.471 secs SNMP [4/0.32s]: Snmpget[3/0.10s] Snmpwalk[1/0.22s] SQL [40/0.11s]: Select[20/0.06s] Insert[1/0.01s] Update[19/0.04s]