"Data Query [SNMP - Get Processor Information]" shows no CPUs but query works fine

[caduceus]

I use cacti for collecting data from Linux systems via SNMP that I then create custom graphs from, and I use the individual CPU graphs as part of the process.

I'm building a new cacti server fresh on CentOS 7.8. I tried migrating the database, etc. but that went very poorly so I decided to go fresh, with Cacti 1.2.11 from source.

I added the first couple hosts fine and was able to create the graphs. But all of them since, when I go to create the CPU graphs, report in the "Data Query [SNMP - Get Processor Information]" section of the Create Graphs page:

Code: Select all

This Data Query returned 0 rows, perhaps there was a problem executing this Data Query.You can run this Data Query in debug mode From there you can get more information.

However, the query runs seemingly just fine:

Code: Select all

Data Query Debug Information 
Total: 0.000000, Delta: 0.000000, Found data query XML file at '/var/www/html/cacti/resource/script_server/host_cpu.xml'
Total: 0.000000, Delta: 0.000000, Running Data Query [8].
Total: 0.000000, Delta: 0.000000, Found Type = '6' [Script Query - Script Server].
Total: 0.000000, Delta: 0.000000, XML file parsed ok.
Total: 0.120000, Delta: 0.120000, Executing script for num of indexes '"/opt/rh/rh-php73/root/usr/bin/php" -q /var/www/html/cacti/scripts/ss_host_cpu.php 'HOSTNAME' '11' '2:161:500:1:10:public::::::' 'num_indexes''
Total: 0.120000, Delta: 0.000000, Found number of indexes: 5
Total: 0.230000, Delta: 0.110000, Executing script for list of indexes '"/opt/rh/rh-php73/root/usr/bin/php" -q /var/www/html/cacti/scripts/ss_host_cpu.php 'HOSTNAME' '11' '2:161:500:1:10:public::::::' 'index'', Index Count: 5

Click to show Data Query output for field 'hrProcessorFrwID'
Total: 0.360000, Delta: 0.130000, Checking for Sort Field change. No changes detected.
Total: 0.360000, Delta: 0.000000, Update Data Query Sort Cache complete
Total: 0.360000, Delta: 0.000000, Index Association with Local Data complete
Total: 0.370000, Delta: 0.000000, No Index Changes Detected, Skipping Re-Index and Poller Cache Re-population
Total: 0.370000, Delta: 0.000000, Automation Executing for Data Query complete
Total: 0.370000, Delta: 0.000000, Plugin hooks complete

I've tried both with the PHP 7.3 CLI as above, as well as the default 5.4 CLI.

Any ideas why this is breaking?

[TheWitness]

I suspect a timeout.

[caduceus]

I suspect a timeout.

There isn't any delay in any responses, the query tests, etc. All SNMP queries to the systems work fine, but no system I've added since the first two will show me the list of CPUs on the Create Graphs screen, claiming there aren't any even though the query enumerates them.

[TheWitness]

You should see a call to the processor ID column. Like the attached. Are you seeing that?

[caduceus]

Yes, it is just collapsed.

Code: Select all

Executing script query '"/opt/rh/rh-php73/root/usr/bin/php" -q /var/www/html/cacti/scripts/ss_host_cpu.php HOSTNAME' '10' '2:161:500:1:10:public::::::' 'query' 'index''
Found item [hrProcessorFrwID='0'] index: 0
Found item [hrProcessorFrwID='1'] index: 1
Found item [hrProcessorFrwID='2'] index: 2
Found item [hrProcessorFrwID='3'] index: 3
Found item [hrProcessorFrwID='4'] index: 4
Found item [hrProcessorFrwID='5'] index: 5
Found item [hrProcessorFrwID='6'] index: 6
Found item [hrProcessorFrwID='7'] index: 7
Found item [hrProcessorFrwID='8'] index: 8
Found item [hrProcessorFrwID='9'] index: 9
Found item [hrProcessorFrwID='10'] index: 10
Found item [hrProcessorFrwID='11'] index: 11
Found item [hrProcessorFrwID='12'] index: 12
Found item [hrProcessorFrwID='13'] index: 13
Found item [hrProcessorFrwID='14'] index: 14
Found item [hrProcessorFrwID='15'] index: 15
Found item [hrProcessorFrwID='16'] index: 16
Found item [hrProcessorFrwID='17'] index: 17
Found item [hrProcessorFrwID='18'] index: 18
Found item [hrProcessorFrwID='19'] index: 19
Found item [hrProcessorFrwID='20'] index: 20
Found item [hrProcessorFrwID='21'] index: 21
Found item [hrProcessorFrwID='22'] index: 22
Found item [hrProcessorFrwID='23'] index: 23
Found item [hrProcessorFrwID='Total'] index: 4000

Now I notice that the problem now appears on the hosts I already added graphs for...sigh...

[caduceus]

Well, I'm not sure what went wrong. I tried upgrading to 1.2.12, but it was still broken, so I just started over. And since then everything is fine.

The only thing I remember changing was increasing the number of rows displayed, and changing that again hasn't been a problem.

Anyways, all set for now.