Weird issue with hostmib

[mrossTTX]

for what it's worth, i ran this query in mysql
select * from plugin_hmib_hrswrun_last_seen where host_id=1

and the last time it shows it to be running is over an hour ago, even though i know for a fact the service is running right now.. this table isnt getting updated in a timely fashion i suspect and that is maybe why I am having so many issues using HMIB for watching processes.
by way of comparision, i ran the same query against the other table
select * from plugin_hmib_hrswrun where host_id=1

and it does not see that software (process, service, etc) is running.

[mrossTTX]

finally caught HMIB in my log.. been waiting all day.

2023-01-11 13:52:15 - SYSTEM HMIB STATS: Time:5.9900 Processes:20 Hosts:9
2023-01-11 12:20:51 - SYSTEM HMIB STATS: Time:1434.7100 Processes:20 Hosts:9


nothing since.

[TheWitness]

No write to binlog? What other plugins are you using?

[TheWitness]

Let me rephrase that question, what version of MySQL/MariaDB?

[mrossTTX]

5.7, the version that came with the prebundled cacti for windows installer

[TheWitness]

This is the real problem. Are you sure you have access to all the devices, or are they all way out on the wan somewhere?

Some polls do extra things, but for that many hosts, it should not take that long.

2023-01-11 12:20:51 - SYSTEM HMIB STATS: Time:1434.7100 Processes:20 Hosts:9

[mrossTTX]

some are WAN, some ore local.. the one im trying to get HMIB to look at , is the cacti server itself.

[TheWitness]

Do a debug run for each host. If you run the "poller_hmib.php --help", you might be able to find the option to do one host at a time, then find the slow hosts and figure out what is going on.

[mrossTTX]

todays log
2023-01-17 13:16:24 - SYSTEM HMIB STATS: Time:1437.83 Processes:20 Hosts:8
2023-01-17 13:11:33 - SYSTEM HMIB STATS: Time:1433.9900 Processes:20 Hosts:8
I dont know why those times are varying.. sometimes its 6.x seconds , sometimes much longer. literally not doing anything to system but letting it sit and run.

yesterdays log:

2023-01-16 23:45:48 - SYSTEM HMIB STATS: Time:1430.0700 Processes:20 Hosts:9
2023-01-16 21:20:46 - SYSTEM HMIB STATS: Time:1429.9300 Processes:20 Hosts:9
2023-01-16 21:17:16 - SYSTEM HMIB STATS: Time:6.1300 Processes:20 Hosts:9
2023-01-16 12:07:19 - SYSTEM HMIB STATS: Time:6.1800 Processes:20 Hosts:9
2023-01-16 04:55:48 - SYSTEM HMIB STATS: Time:1429.8900 Processes:20 Hosts:9
2023-01-16 01:10:50 - SYSTEM HMIB STATS: Time:1426.0000 Processes:20 Hosts:9
2023-01-16 01:07:11 - SYSTEM HMIB STATS: Time:6.1200 Processes:20 Hosts:9

the 15th
2023-01-15 17:25:52 - SYSTEM HMIB STATS: Time:1434.0900 Processes:20 Hosts:9
2023-01-15 17:22:02 - SYSTEM HMIB STATS: Time:6.5500 Processes:20 Hosts:9
2023-01-15 17:21:23 - SYSTEM HMIB STATS: Time:1434.1600 Processes:20 Hosts:9
2023-01-15 17:16:56 - SYSTEM HMIB STATS: Time:7.0100 Processes:20 Hosts:9
2023-01-15 17:16:13 - SYSTEM HMIB STATS: Time:1430.6400 Processes:20 Hosts:9
2023-01-15 16:20:47 - SYSTEM HMIB STATS: Time:1426.3400 Processes:20 Hosts:9
2023-01-15 16:17:14 - SYSTEM HMIB STATS: Time:5.8900 Processes:20 Hosts:9
2023-01-15 08:36:00 - SYSTEM HMIB STATS: Time:1427.6500 Processes:20 Hosts:9
2023-01-15 05:00:58 - SYSTEM HMIB STATS: Time:1429.8400 Processes:20 Hosts:9
2023-01-15 02:50:44 - SYSTEM HMIB STATS: Time:1425.7300 Processes:20 Hosts:9
2023-01-15 02:00:51 - SYSTEM HMIB STATS: Time:1434.0600 Processes:20 Hosts:9
2023-01-15 00:46:04 - SYSTEM HMIB STATS: Time:1433.9300 Processes:20 Hosts:9
2023-01-15 00:42:07 - SYSTEM HMIB STATS: Time:6.1400 Processes:20 Hosts:9

the 14th
2023-01-14 20:12:04 - SYSTEM HMIB STATS: Time:6.0200 Processes:20 Hosts:9
2023-01-14 20:11:06 - SYSTEM HMIB STATS: Time:1438.1600 Processes:20 Hosts:9
2023-01-14 20:07:13 - SYSTEM HMIB STATS: Time:5.9300 Processes:20 Hosts:9
2023-01-14 18:00:46 - SYSTEM HMIB STATS: Time:1438.1500 Processes:20 Hosts:9
2023-01-14 17:56:59 - SYSTEM HMIB STATS: Time:6.2900 Processes:20 Hosts:9
2023-01-14 14:52:29 - SYSTEM HMIB STATS: Time:6.5000 Processes:20 Hosts:9
2023-01-14 14:51:33 - SYSTEM HMIB STATS: Time:1437.9700 Processes:20 Hosts:9
2023-01-14 13:30:45 - SYSTEM HMIB STATS: Time:1434.1100 Processes:20 Hosts:9
2023-01-14 12:37:15 - SYSTEM HMIB STATS: Time:6.0600 Processes:20 Hosts:9
2023-01-14 08:16:21 - SYSTEM HMIB STATS: Time:1440.4000 Processes:20 Hosts:9
2023-01-14 03:50:52 - SYSTEM HMIB STATS: Time:1442.1800 Processes:20 Hosts:9
2023-01-14 03:47:00 - SYSTEM HMIB STATS: Time:5.8800 Processes:20 Hosts:9
2023-01-14 03:46:27 - SYSTEM HMIB STATS: Time:1442.0500 Processes:20 Hosts:9
2023-01-14 01:05:33 - SYSTEM HMIB STATS: Time:1426.0400 Processes:20 Hosts:9
2023-01-14 01:00:49 - SYSTEM HMIB STATS: Time:1433.7900 Processes:20 Hosts:9
2023-01-14 00:57:03 - SYSTEM HMIB STATS: Time:6.0300 Processes:20 Hosts:9
2023-01-14 00:56:20 - SYSTEM HMIB STATS: Time:1421.5500 Processes:20 Hosts:9
2023-01-14 00:10:44 - SYSTEM HMIB STATS: Time:1430.1600 Processes:20 Hosts:9

[TheWitness]

It might be the software inventory taking all that time. This is why you run on the command line. Thinks like software inventory may take more time. When I used this plugin, I saved inventory once a day.

[TheWitness]

Also, make sure everything is SNMPv2 and not v1.

[mrossTTX]

>php -q poller_hmib.php --host-id=1 instantly updates the graphs for that host, but i had to reindex it first.
i did it a few times to ensure i was observing the behavior properly.

there were times i had to reindex and re run the command above a few times manually for it to kick off, but i could see instant feedback vs waiting an hour to 5 hours for hmib to finally pick up that the service was stopped or running.

[Osiris]

Hmm, that's odd.