API tools faq
paste
Advertisement
JohnSPeach

poller.php -m storage -d -h 170

JohnSPeach
Jan 29th, 2019
143
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 25.74 KB | None | 0 0
raw download clone embed print report
  1. LibreNMS Poller
  2. SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.52ms]
  3.  
  4. SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.82ms]
  5.  
  6. SQL[SELECT version() [] 0.21ms]
  7.  
  8. ===================================
  9. Version info:
  10. Commit SHA: 60a39caa3518b474d3bc9c93de6a5fbaf1321dd6
  11. Commit Date: 1548696617
  12. DB Schema: 2019_01_16_195644_add_vrf_id_and_bgpLocalAs (131)
  13. PHP: 7.2.10-0ubuntu0.18.04.1
  14. MySQL: 10.1.34-MariaDB-0ubuntu0.18.04.1
  15. RRDTool: 1.7.0
  16. SNMP: NET-SNMP 5.7.3
  17. ==================================DEBUG!
  18. Updating os_def.cache...
  19. Done
  20. Override poller modules: storage
  21. Starting polling run:
  22.  
  23. SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `device_id` = 170 ORDER BY `device_id` ASC [] 1.03ms]
  24.  
  25. SQL[SELECT * FROM devices_attribs WHERE `device_id` = ? [170] 0.17ms]
  26.  
  27. Hostname: tmii01.mssm.edu
  28. Device ID: 170
  29. OS: linux (unix)
  30.  
  31. [FPING] /usr/bin/fping -e -q -c 3 -p 500 -t 500 tmii01.mssm.edu
  32. array (
  33. 'xmt' => '3',
  34. 'rcv' => '3',
  35. 'loss' => '0',
  36. 'min' => '0.24',
  37. 'max' => '0.27',
  38. 'avg' => '0.26',
  39. 'exitcode' => 0,
  40. )
  41. SQL[INSERT IGNORE INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`,`debug`) VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW(),:debug) {"xmt":"3","rcv":"3","loss":"0","min":"0.24","max":"0.27","avg":"0.26","device_id":170,"debug":"[]"} 1.36ms]
  42.  
  43. SNMP Check response code: 0
  44. Modules status: Global+
  45. OS
  46. Device
  47.  
  48. #### Load poller module core ####
  49. SNMP['/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' '' '-a' 'SHA' '-A' 'PASSWORD '-u' 'USER '-x' 'AES' '-X' 'PASSWORD '-OQnUt' '-m' 'SNMPv2-MIB' '-M' '/data/librenms/mibs:/data/librenms/mibs/supermicro:/data/librenms/mibs/dell' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysLocation.0' 'sysContact.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0']
  50. .*.*.0 = 6785214
  51. .*.*.0 = AB-58, 1425 DC, [40.788638,-73.952422]
  52. .*.*.0 = UNIX Eng <mssm-unix@mssm.edu>
  53. .*.*.0 = tmii01
  54. .*.*.0 = .*.4.1.8*
  55. .*.*.0 = Linux tmii01 3.5.0-23-generic #35~precise1-Ubuntu SMP Fri Jan 25 17:13:26 UTC 2013 x86_64
  56.  
  57. SNMP['/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' '' '-a' 'SHA' '-A' 'PASSWORD '-u' 'USER '-x' 'AES' '-X' 'PASSWORD '-OQnUst' '-m' 'HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB' '-M' '/data/librenms/mibs:/data/librenms/mibs/supermicro:/data/librenms/mibs/dell' 'udp:HOSTNAME:161' 'snmpEngineTime.0' 'hrSystemUptime.0']
  58. snmpEngineTime.0 = 67856
  59. hrSystemUptime.0 = 1632777790
  60.  
  61. Uptime seconds: 16327778
  62. RRD[update /data/librenms/rrd/tmii01.mssm.edu/uptime.rrd N:16327778]
  63. Uptime: 188 days, 23h 29m 38s
  64. SQL[select * from `locations` where (`location` = ?) limit 1 ["AB-58, 1425 DC, [40.788638,-73.952422]"] 0.35ms]
  65.  
  66.  
  67. >> Runtime for poller module 'core': 0.0959 seconds with 128408 bytes
  68. >> SNMP: [2/0.09s] MySQL: [0/0.00s] RRD: [1/0.00s]
  69. #### Unload poller module core ####
  70.  
  71. RRD[update /data/librenms/rrd/tmii01.mssm.edu/poller-perf-core.rrd N:0.095867872238159]
  72. Modules status: Global+
  73. OS
  74. Device
  75.  
  76. #### Load poller module storage ####
  77. SQL[SELECT * FROM storage WHERE device_id = ? [170] 0.64ms]
  78.  
  79. Storage /: hrstorage
  80.  
  81.  
  82.  
  83. SNMP['/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' '' '-a' 'SHA' '-A' 'PASSWORD '-u' 'USER '-x' 'AES' '-X' 'PASSWORD '-OQUs' '-m' 'HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES' '-M' '/data/librenms/mibs:/data/librenms/mibs/supermicro:/data/librenms/mibs/dell' 'udp:HOSTNAME:161' 'hrStorageEntry']
  84. hrStorageIndex.1 = 1
  85. hrStorageIndex.3 = 3
  86. hrStorageIndex.6 = 6
  87. hrStorageIndex.7 = 7
  88. hrStorageIndex.8 = 8
  89. hrStorageIndex.10 = 10
  90. hrStorageIndex.31 = 31
  91. hrStorageIndex.32 = 32
  92. hrStorageIndex.33 = 33
  93. hrStorageIndex.34 = 34
  94. hrStorageIndex.35 = 35
  95. hrStorageIndex.36 = 36
  96. hrStorageIndex.37 = 37
  97. hrStorageIndex.38 = 38
  98. hrStorageIndex.39 = 39
  99. hrStorageType.1 = hrStorageRam
  100. hrStorageType.3 = hrStorageVirtualMemory
  101. hrStorageType.6 = hrStorageOther
  102. hrStorageType.7 = hrStorageOther
  103. hrStorageType.8 = hrStorageOther
  104. hrStorageType.10 = hrStorageVirtualMemory
  105. hrStorageType.31 = hrStorageFixedDisk
  106. hrStorageType.32 = hrStorageFixedDisk
  107. hrStorageType.33 = hrStorageFixedDisk
  108. hrStorageType.34 = hrStorageFixedDisk
  109. hrStorageType.35 = hrStorageFixedDisk
  110. hrStorageType.36 = hrStorageFixedDisk
  111. hrStorageType.37 = hrStorageFixedDisk
  112. hrStorageType.38 = hrStorageFixedDisk
  113. hrStorageType.39 = hrStorageFixedDisk
  114. hrStorageDescr.1 = Physical memory
  115. hrStorageDescr.3 = Virtual memory
  116. hrStorageDescr.6 = Memory buffers
  117. hrStorageDescr.7 = Cached memory
  118. hrStorageDescr.8 = Shared memory
  119. hrStorageDescr.10 = Swap space
  120. hrStorageDescr.31 = /
  121. hrStorageDescr.32 = /sys/fs/fuse/connections
  122. hrStorageDescr.33 = /dev
  123. hrStorageDescr.34 = /boot
  124. hrStorageDescr.35 = /data
  125. hrStorageDescr.36 = /var
  126. hrStorageDescr.37 = /PROJECTS
  127. hrStorageDescr.38 = /tmp
  128. hrStorageDescr.39 = /opt
  129. hrStorageAllocationUnits.1 = 1024
  130. hrStorageAllocationUnits.3 = 1024
  131. hrStorageAllocationUnits.6 = 1024
  132. hrStorageAllocationUnits.7 = 1024
  133. hrStorageAllocationUnits.8 = 1024
  134. hrStorageAllocationUnits.10 = 1024
  135. hrStorageAllocationUnits.31 = 4096
  136. hrStorageAllocationUnits.32 = 4096
  137. hrStorageAllocationUnits.33 = 4096
  138. hrStorageAllocationUnits.34 = 1024
  139. hrStorageAllocationUnits.35 = 4096
  140. hrStorageAllocationUnits.36 = 4096
  141. hrStorageAllocationUnits.37 = 4096
  142. hrStorageAllocationUnits.38 = 4096
  143. hrStorageAllocationUnits.39 = 4096
  144. hrStorageSize.1 = 65969704
  145. hrStorageSize.3 = 75734564
  146. hrStorageSize.6 = 65969704
  147. hrStorageSize.7 = 41774424
  148. hrStorageSize.8 = 0
  149. hrStorageSize.10 = 9764860
  150. hrStorageSize.31 = 4805813
  151. hrStorageSize.32 = 0
  152. hrStorageSize.33 = 8243828
  153. hrStorageSize.34 = 234153
  154. hrStorageSize.35 = 3277845857
  155. hrStorageSize.36 = 1201440
  156. hrStorageSize.37 = 1331602538
  157. hrStorageSize.38 = 1331602538
  158. hrStorageSize.39 = 1331602538
  159. hrStorageUsed.1 = 65710284
  160. hrStorageUsed.3 = 67592224
  161. hrStorageUsed.6 = 13302564
  162. hrStorageUsed.7 = 41774424
  163. hrStorageUsed.10 = 1881940
  164. hrStorageUsed.31 = 1025706
  165. hrStorageUsed.32 = 0
  166. hrStorageUsed.33 = 1
  167. hrStorageUsed.34 = 29243
  168. hrStorageUsed.35 = 3871065409
  169. hrStorageUsed.36 = 255710
  170. hrStorageUsed.37 = 90804534
  171. hrStorageUsed.38 = 90804534
  172. hrStorageUsed.39 = 90804534
  173.  
  174. array (
  175. 'hrstorage' =>
  176. array (
  177. 1 =>
  178. array (
  179. 'hrStorageIndex' => '1',
  180. 'hrStorageType' => 'hrStorageRam',
  181. 'hrStorageDescr' => 'Physical memory',
  182. 'hrStorageAllocationUnits' => '1024',
  183. 'hrStorageSize' => '65969704',
  184. 'hrStorageUsed' => '65710284',
  185. ),
  186. 3 =>
  187. array (
  188. 'hrStorageIndex' => '3',
  189. 'hrStorageType' => 'hrStorageVirtualMemory',
  190. 'hrStorageDescr' => 'Virtual memory',
  191. 'hrStorageAllocationUnits' => '1024',
  192. 'hrStorageSize' => '75734564',
  193. 'hrStorageUsed' => '67592224',
  194. ),
  195. 6 =>
  196. array (
  197. 'hrStorageIndex' => '6',
  198. 'hrStorageType' => 'hrStorageOther',
  199. 'hrStorageDescr' => 'Memory buffers',
  200. 'hrStorageAllocationUnits' => '1024',
  201. 'hrStorageSize' => '65969704',
  202. 'hrStorageUsed' => '13302564',
  203. ),
  204. 7 =>
  205. array (
  206. 'hrStorageIndex' => '7',
  207. 'hrStorageType' => 'hrStorageOther',
  208. 'hrStorageDescr' => 'Cached memory',
  209. 'hrStorageAllocationUnits' => '1024',
  210. 'hrStorageSize' => '41774424',
  211. 'hrStorageUsed' => '41774424',
  212. ),
  213. 8 =>
  214. array (
  215. 'hrStorageIndex' => '8',
  216. 'hrStorageType' => 'hrStorageOther',
  217. 'hrStorageDescr' => 'Shared memory',
  218. 'hrStorageAllocationUnits' => '1024',
  219. 'hrStorageSize' => '0',
  220. ),
  221. 10 =>
  222. array (
  223. 'hrStorageIndex' => '10',
  224. 'hrStorageType' => 'hrStorageVirtualMemory',
  225. 'hrStorageDescr' => 'Swap space',
  226. 'hrStorageAllocationUnits' => '1024',
  227. 'hrStorageSize' => '9764860',
  228. 'hrStorageUsed' => '1881940',
  229. ),
  230. 31 =>
  231. array (
  232. 'hrStorageIndex' => '31',
  233. 'hrStorageType' => 'hrStorageFixedDisk',
  234. 'hrStorageDescr' => '/',
  235. 'hrStorageAllocationUnits' => '4096',
  236. 'hrStorageSize' => '4805813',
  237. 'hrStorageUsed' => '1025706',
  238. ),
  239. 32 =>
  240. array (
  241. 'hrStorageIndex' => '32',
  242. 'hrStorageType' => 'hrStorageFixedDisk',
  243. 'hrStorageDescr' => '/sys/fs/fuse/connections',
  244. 'hrStorageAllocationUnits' => '4096',
  245. 'hrStorageSize' => '0',
  246. 'hrStorageUsed' => '0',
  247. ),
  248. 33 =>
  249. array (
  250. 'hrStorageIndex' => '33',
  251. 'hrStorageType' => 'hrStorageFixedDisk',
  252. 'hrStorageDescr' => '/dev',
  253. 'hrStorageAllocationUnits' => '4096',
  254. 'hrStorageSize' => '8243828',
  255. 'hrStorageUsed' => '1',
  256. ),
  257. 34 =>
  258. array (
  259. 'hrStorageIndex' => '34',
  260. 'hrStorageType' => 'hrStorageFixedDisk',
  261. 'hrStorageDescr' => '/boot',
  262. 'hrStorageAllocationUnits' => '1024',
  263. 'hrStorageSize' => '234153',
  264. 'hrStorageUsed' => '29243',
  265. ),
  266. 35 =>
  267. array (
  268. 'hrStorageIndex' => '35',
  269. 'hrStorageType' => 'hrStorageFixedDisk',
  270. 'hrStorageDescr' => '/data',
  271. 'hrStorageAllocationUnits' => '4096',
  272. 'hrStorageSize' => '3277845857',
  273. 'hrStorageUsed' => '3871065409',
  274. ),
  275. 36 =>
  276. array (
  277. 'hrStorageIndex' => '36',
  278. 'hrStorageType' => 'hrStorageFixedDisk',
  279. 'hrStorageDescr' => '/var',
  280. 'hrStorageAllocationUnits' => '4096',
  281. 'hrStorageSize' => '1201440',
  282. 'hrStorageUsed' => '255710',
  283. ),
  284. 37 =>
  285. array (
  286. 'hrStorageIndex' => '37',
  287. 'hrStorageType' => 'hrStorageFixedDisk',
  288. 'hrStorageDescr' => '/PROJECTS',
  289. 'hrStorageAllocationUnits' => '4096',
  290. 'hrStorageSize' => '1331602538',
  291. 'hrStorageUsed' => '90804534',
  292. ),
  293. 38 =>
  294. array (
  295. 'hrStorageIndex' => '38',
  296. 'hrStorageType' => 'hrStorageFixedDisk',
  297. 'hrStorageDescr' => '/tmp',
  298. 'hrStorageAllocationUnits' => '4096',
  299. 'hrStorageSize' => '1331602538',
  300. 'hrStorageUsed' => '90804534',
  301. ),
  302. 39 =>
  303. array (
  304. 'hrStorageIndex' => '39',
  305. 'hrStorageType' => 'hrStorageFixedDisk',
  306. 'hrStorageDescr' => '/opt',
  307. 'hrStorageAllocationUnits' => '4096',
  308. 'hrStorageSize' => '1331602538',
  309. 'hrStorageUsed' => '90804534',
  310. ),
  311. ),
  312. )
  313. array (
  314. 'storage_id' => 1413,
  315. 'device_id' => 170,
  316. 'storage_mib' => 'hrstorage',
  317. 'storage_index' => '31',
  318. 'storage_type' => 'hrStorageFixedDisk',
  319. 'storage_descr' => '/',
  320. 'storage_size' => 19684610048,
  321. 'storage_units' => 4096,
  322. 'storage_used' => 4201291776,
  323. 'storage_free' => 15483318272,
  324. 'storage_perc' => 21,
  325. 'storage_perc_warn' => 60,
  326. 'storage_deleted' => 0,
  327. 'units' => '4096',
  328. 'used' => 4201291776,
  329. 'size' => 19684610048,
  330. 'free' => 15483318272,
  331. )
  332. 21% RRD[update /data/librenms/rrd/tmii01.mssm.edu/storage-hrstorage-_.rrd N:4201291776:15483318272]
  333. SQL[UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? ["4201291776","15483318272","19684610048","4096",21,1413] 1.22ms]
  334.  
  335.  
  336. Storage /boot: hrstorage
  337.  
  338.  
  339.  
  340. array (
  341. 'storage_id' => 1414,
  342. 'device_id' => 170,
  343. 'storage_mib' => 'hrstorage',
  344. 'storage_index' => '34',
  345. 'storage_type' => 'hrStorageFixedDisk',
  346. 'storage_descr' => '/boot',
  347. 'storage_size' => 239772672,
  348. 'storage_units' => 1024,
  349. 'storage_used' => 29944832,
  350. 'storage_free' => 209827840,
  351. 'storage_perc' => 12,
  352. 'storage_perc_warn' => 60,
  353. 'storage_deleted' => 0,
  354. 'units' => '1024',
  355. 'used' => 29944832,
  356. 'size' => 239772672,
  357. 'free' => 209827840,
  358. )
  359. 12% RRD[update /data/librenms/rrd/tmii01.mssm.edu/storage-hrstorage-_boot.rrd N:29944832:209827840]
  360. SQL[UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? ["29944832","209827840","239772672","1024",12,1414] 9.18ms]
  361.  
  362.  
  363. Storage /data: hrstorage
  364.  
  365.  
  366.  
  367. array (
  368. 'storage_id' => 1415,
  369. 'device_id' => 170,
  370. 'storage_mib' => 'hrstorage',
  371. 'storage_index' => '35',
  372. 'storage_type' => 'hrStorageFixedDisk',
  373. 'storage_descr' => '/data',
  374. 'storage_size' => 13426056630272,
  375. 'storage_units' => 4096,
  376. 'storage_used' => 15855883911168,
  377. 'storage_free' => -2429827280896,
  378. 'storage_perc' => 118,
  379. 'storage_perc_warn' => 60,
  380. 'storage_deleted' => 0,
  381. 'units' => '4096',
  382. 'used' => 15855883915264,
  383. 'size' => 13426056630272,
  384. 'free' => -2429827284992,
  385. )
  386. 118% RRD[update /data/librenms/rrd/tmii01.mssm.edu/storage-hrstorage-_data.rrd N:15855883915264:-2429827284992]
  387. SQL[UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? ["15855883915264","-2429827284992","13426056630272","4096",118,1415] 8.12ms]
  388.  
  389.  
  390. Storage /var: hrstorage
  391.  
  392.  
  393.  
  394. array (
  395. 'storage_id' => 1416,
  396. 'device_id' => 170,
  397. 'storage_mib' => 'hrstorage',
  398. 'storage_index' => '36',
  399. 'storage_type' => 'hrStorageFixedDisk',
  400. 'storage_descr' => '/var',
  401. 'storage_size' => 4921098240,
  402. 'storage_units' => 4096,
  403. 'storage_used' => 1047375872,
  404. 'storage_free' => 3873722368,
  405. 'storage_perc' => 21,
  406. 'storage_perc_warn' => 60,
  407. 'storage_deleted' => 0,
  408. 'units' => '4096',
  409. 'used' => 1047388160,
  410. 'size' => 4921098240,
  411. 'free' => 3873710080,
  412. )
  413. 21% RRD[update /data/librenms/rrd/tmii01.mssm.edu/storage-hrstorage-_var.rrd N:1047388160:3873710080]
  414. SQL[UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? ["1047388160","3873710080","4921098240","4096",21,1416] 7.98ms]
  415.  
  416.  
  417. Storage /PROJECTS: hrstorage
  418.  
  419.  
  420.  
  421. array (
  422. 'storage_id' => 1417,
  423. 'device_id' => 170,
  424. 'storage_mib' => 'hrstorage',
  425. 'storage_index' => '37',
  426. 'storage_type' => 'hrStorageFixedDisk',
  427. 'storage_descr' => '/PROJECTS',
  428. 'storage_size' => 5454243995648,
  429. 'storage_units' => 4096,
  430. 'storage_used' => 371934760960,
  431. 'storage_free' => 5082309234688,
  432. 'storage_perc' => 7,
  433. 'storage_perc_warn' => 60,
  434. 'storage_deleted' => 0,
  435. 'units' => '4096',
  436. 'used' => 371935371264,
  437. 'size' => 5454243995648,
  438. 'free' => 5082308624384,
  439. )
  440. 7% RRD[update /data/librenms/rrd/tmii01.mssm.edu/storage-hrstorage-_PROJECTS.rrd N:371935371264:5082308624384]
  441. SQL[UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? ["371935371264","5082308624384","5454243995648","4096",7,1417] 8.04ms]
  442.  
  443.  
  444. Storage /tmp: hrstorage
  445.  
  446.  
  447.  
  448. array (
  449. 'storage_id' => 1418,
  450. 'device_id' => 170,
  451. 'storage_mib' => 'hrstorage',
  452. 'storage_index' => '38',
  453. 'storage_type' => 'hrStorageFixedDisk',
  454. 'storage_descr' => '/tmp',
  455. 'storage_size' => 5454243995648,
  456. 'storage_units' => 4096,
  457. 'storage_used' => 371934760960,
  458. 'storage_free' => 5082309234688,
  459. 'storage_perc' => 7,
  460. 'storage_perc_warn' => 60,
  461. 'storage_deleted' => 0,
  462. 'units' => '4096',
  463. 'used' => 371935371264,
  464. 'size' => 5454243995648,
  465. 'free' => 5082308624384,
  466. )
  467. 7% RRD[update /data/librenms/rrd/tmii01.mssm.edu/storage-hrstorage-_tmp.rrd N:371935371264:5082308624384]
  468. SQL[UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? ["371935371264","5082308624384","5454243995648","4096",7,1418] 8.03ms]
  469.  
  470.  
  471. Storage /opt: hrstorage
  472.  
  473.  
  474.  
  475. array (
  476. 'storage_id' => 1419,
  477. 'device_id' => 170,
  478. 'storage_mib' => 'hrstorage',
  479. 'storage_index' => '39',
  480. 'storage_type' => 'hrStorageFixedDisk',
  481. 'storage_descr' => '/opt',
  482. 'storage_size' => 5454243995648,
  483. 'storage_units' => 4096,
  484. 'storage_used' => 371934760960,
  485. 'storage_free' => 5082309234688,
  486. 'storage_perc' => 7,
  487. 'storage_perc_warn' => 60,
  488. 'storage_deleted' => 0,
  489. 'units' => '4096',
  490. 'used' => 371935371264,
  491. 'size' => 5454243995648,
  492. 'free' => 5082308624384,
  493. )
  494. 7% RRD[update /data/librenms/rrd/tmii01.mssm.edu/storage-hrstorage-_opt.rrd N:371935371264:5082308624384]
  495. SQL[UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? ["371935371264","5082308624384","5454243995648","4096",7,1419] 7.97ms]
  496.  
  497. >> Runtime for poller module 'storage': 0.1123 seconds with 19968 bytes
  498. >> SNMP: [1/0.06s] MySQL: [8/0.05s] RRD: [8/0.00s]
  499. #### Unload poller module storage ####
  500.  
  501. RRD[update /data/librenms/rrd/tmii01.mssm.edu/poller-perf-storage.rrd N:0.11232805252075]
  502. ### Start Device Groups ###
  503. SQL[SELECT * FROM device_groups ORDER BY name [] 0.6ms]
  504.  
  505. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hostname REGEXP "^chief" || devices.hostname REGEXP "^base" ) LIMIT 1 [170] 0.42ms]
  506.  
  507. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hostname REGEXP "dmz-f5") LIMIT 1 [170] 0.31ms]
  508.  
  509. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.os REGEXP "F5") LIMIT 1 [170] 0.62ms]
  510.  
  511. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hardware REGEXP "IB") LIMIT 1 [170] 0.57ms]
  512.  
  513. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hostname REGEXP "^api-" || devices.hostname REGEXP "^msh-" ) LIMIT 1 [170] 0.31ms]
  514.  
  515. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hostname REGEXP "^splunk" || devices.hostname REGEXP "^cyber-syslog" ) LIMIT 1 [170] 0.6ms]
  516.  
  517. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hostname REGEXP "^eresources" || devices.hostname REGEXP "^web10" || devices.hostname REGEXP "^ccfl" || devices.hostname REGEXP "^ccmp" || devices.hostname REGEXP "^media" || devices.hostname REGEXP "^ccess" ) LIMIT 1 [170] 0.32ms]
  518.  
  519. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hostname REGEXP "^mshs-w4" || devices.hostname REGEXP "^blog" || devices.hostname = "smaaappp015002.mountsinai.org" || devices.hostname = "www.mountsinai.org" || devices.hostname REGEXP "^msmc-w4" ) LIMIT 1 [170] 0.32ms]
  520.  
  521. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hostname REGEXP "^mshs-w4" || devices.hostname REGEXP "^blog" || devices.hostname = "smaaappp015002.mountsinai.org" || devices.hostname = "www.mountsinai.org" || devices.hostname REGEXP "^msmc-w4" ) LIMIT 1 [170] 0.2ms]
  522.  
  523. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hostname REGEXP "smes") LIMIT 1 [170] 0.26ms]
  524.  
  525. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.os = "PanOS") LIMIT 1 [170] 0.27ms]
  526.  
  527. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hostname REGEXP "^smtp-" || devices.hostname REGEXP "^encmail" ) LIMIT 1 [170] 0.62ms]
  528.  
  529. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hostname REGEXP "^pred-mod") LIMIT 1 [170] 0.29ms]
  530.  
  531. SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME = ? ["devices_attribs","device_id"] 1.59ms]
  532.  
  533. SQL[SELECT DISTINCT(devices_attribs.device_id) FROM devices_attribs WHERE devices_attribs.device_id=? AND (devices_attribs.attrib_type = "override_sysContact_bool" && devices_attribs.attrib_value = 1 ) LIMIT 1 [170] 0.21ms]
  534.  
  535. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.status = 1) LIMIT 1 [170] 0.6ms]
  536.  
  537. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hostname REGEXP "^tmii") LIMIT 1 [170] 0.59ms]
  538.  
  539. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hostname REGEXP "^msdrop" || devices.hostname REGEXP "^d.s-cache" || devices.hostname REGEXP "^syslog" || devices.hostname REGEXP "^unix-" ) LIMIT 1 [170] 0.32ms]
  540.  
  541. SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`=? [170] 0.47ms]
  542.  
  543. Groups Added:
  544. Groups Removed:
  545. ### End Device Groups ###
  546. RRD[update /data/librenms/rrd/tmii01.mssm.edu/ping-perf.rrd N:0.26]
  547. RRD[update /data/librenms/rrd/tmii01.mssm.edu/poller-perf.rrd N:1.283]
  548. SQL[UPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=? WHERE `device_id` = ? [16327778,"0.26",170] 4.2ms]
  549.  
  550. Updating tmii01.mssm.edu
  551.  
  552. Polled in 1.283 seconds
  553. #### Start Alerts ####
  554. SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [170] 0.6ms]
  555.  
  556. 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` = ? [170] 0.29ms]
  557.  
  558. SQL[select exists(select * from `alert_schedule` inner join `alert_schedulables` on `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` where ((`recurring` = ? and `start` <= NOW() and `end` >= NOW()) or (`recurring` = ? and (`start_recurring_dt` <= date_format(NOW(), '--%d') and (`end_recurring_dt` >= date_format(NOW(), '--%d') or `end_recurring_dt` is null or `end_recurring_dt` = ? or `end_recurring_dt` = ?)) and `start_recurring_hr` <= date_format(NOW(), '%H:%i:%s') and `end_recurring_hr` >= date_format(NOW(), '%H:%i:%s') and (`recurring_day` like CONCAT('%', date_format(NOW(), ''), '%') or `recurring_day` is null or `recurring_day` = ?))) and ((`alert_schedulable_type` = ? and `alert_schedulable_id` = ?) or (`alert_schedulable_type` = ? and `alert_schedulable_id` in (?, ?)))) as `exists` [0,1,"0000-00-00","","","device",170,"device_group",1,23] 1.27ms]
  559.  
  560. SQL[SELECT DISTINCT a.* FROM alert_rules a
  561. LEFT JOIN alert_device_map d ON a.id=d.rule_id
  562. LEFT JOIN alert_group_map g ON a.id=g.rule_id
  563. LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id
  564. WHERE a.disabled = 0 AND ((d.device_id IS NULL AND g.group_id IS NULL) OR d.device_id=? OR dg.device_id=?) [170,170] 0.34ms]
  565.  
  566. Rule #1 (Devices up/down):
  567. SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [170] 0.52ms]
  568.  
  569. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [1,170] 0.19ms]
  570.  
  571. Status: NOCHG
  572. Rule #2 (Device rebooted):
  573. SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 AND (devices.disabled = 0 && devices.ignore = 0) = 1 [170] 0.47ms]
  574.  
  575. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [2,170] 0.18ms]
  576.  
  577. Status: NOCHG
  578. Rule #5 (Port status up/down):
  579. SQL[SELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND (ports.ifOperStatus = "down" && ports.ifAdminStatus != "down" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 [170] 1.28ms]
  580.  
  581. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [5,170] 0.19ms]
  582.  
  583. Status: NOCHG
  584. Rule #9 (Service up/down):
  585. SQL[SELECT * FROM devices,services WHERE (devices.device_id = ? AND devices.device_id = services.device_id) AND services.service_status != 0 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND (DAYOFWEEK(NOW()) BETWEEN 2 AND 6) = 1 AND (HOUR(NOW()) BETWEEN 8 AND 18) = 1 [170] 0.7ms]
  586.  
  587. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [9,170] 0.22ms]
  588.  
  589. Status: NOCHG
  590. Rule #23 (Weekday Regular Disk Space Critical):
  591. SQL[SELECT * FROM devices,storage WHERE (devices.device_id = ? AND devices.device_id = storage.device_id) AND storage.storage_perc > 95 AND devices.type = "server" AND storage.storage_descr NOT LIKE '/run%' AND storage.storage_descr != "/dev/shm" AND (DAYOFWEEK(NOW()) BETWEEN 2 AND 6) = 1 AND (HOUR(NOW()) BETWEEN 8 AND 18) = 1 AND storage.storage_descr NOT LIKE 'hroot%' AND storage.storage_descr NOT LIKE '/sys%' AND storage.storage_size < 1000000000000 [170] 1.32ms]
  592.  
  593. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [23,170] 0.17ms]
  594.  
  595. Status: NOCHG
  596. Rule #39 (Weekday regular disk space warning):
  597. SQL[SELECT * FROM devices,storage WHERE (devices.device_id = ? AND devices.device_id = storage.device_id) AND storage.storage_perc > 90 AND storage.storage_perc <= 95 AND storage.storage_descr != "/dev/shm" AND storage.storage_descr NOT LIKE 'hroot%' AND (DAYOFWEEK(NOW()) BETWEEN 2 AND 6) = 1 AND (HOUR(NOW()) BETWEEN 8 AND 18) = 1 AND storage.storage_descr NOT LIKE '/run%' AND storage.storage_descr NOT LIKE '/sys%' AND storage.storage_size < 1000000000000 [170] 0.58ms]
  598.  
  599. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [39,170] 0.16ms]
  600.  
  601. Status: NOCHG
  602. Rule #40 (weekday large disk space):
  603. SQL[SELECT * FROM devices,storage WHERE (devices.device_id = ? AND devices.device_id = storage.device_id) AND storage.storage_perc > 98 AND storage.storage_descr != "/dev/shm" AND storage.storage_descr NOT LIKE 'hroot%' AND storage.storage_descr NOT LIKE '/run%' AND storage.storage_descr NOT LIKE '/sys%' AND storage.storage_size >= 1000000000000 AND (DAYOFWEEK(NOW()) BETWEEN 2 AND 6) = 1 AND (HOUR(NOW()) BETWEEN 8 AND 18) = 1 AND storage.storage_free > 0 [170] 0.52ms]
  604.  
  605. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [40,170] 0.15ms]
  606.  
  607. Status: NOCHG
  608. #### End Alerts ####
  609. SQL[INSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES (:type,:doing,:start,:duration,:devices,:poller) {"type":"poll","doing":"170","start":1548768843.461784,"duration":"1.484","devices":1,"poller":"unix-mon02"} 0.85ms]
  610.  
  611. ./poller.php 170 2019-01-29 08:34:04 - 1 devices polled in 1.484 secs
  612. SNMP [4/0.19s]: Get[3/0.14s] Getnext[0/0.00s] Walk[1/0.06s]
  613. MySQL [22/0.07s]: Cell[26/0.01s] Row[-26/-0.01s] Rows[11/0.01s] Column[1/0.00s] Update[8/0.06s] Insert[2/0.00s] Delete[0/0.00s]
  614. RRD [12/0.00s]: Update[12/0.00s] Create [0/0.00s] Other[0/0.00s]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!