"data query returned 0 rows" after upgrade to 087e

[RonaldPost]

I recently performed an upgrade from 0.8.6h to 0.8.7e. All seems to be fine (polling and graphing works fine), until I try to create graphs for a host.

After creating a new host or editing an existing one, I click on "Create graphs for this host". Instead of the interface list I now get the following error in the "Data Query" box:

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 to get more information.

When I click on "run this query in debug mode" I get:

Code: Select all

+ Running data query [1].
+ Found type = '3' [snmp query].
+ Found data query XML file at '/var/www/html/cacti-0.8.7e/resource/snmp_queries/interface.xml'
+ XML file parsed ok.
+ Executing SNMP walk for list of indexes @ '.1.3.6.1.2.1.2.2.1.1'
+ Index found at OID: '.1.3.6.1.2.1.2.2.1.1.1' value: '1'
+ Index found at OID: '.1.3.6.1.2.1.2.2.1.1.2' value: '2'
+ Index found at OID: '.1.3.6.1.2.1.2.2.1.1.3' value: '3'
.
.
.
+ Index found at OID: '.1.3.6.1.2.1.2.2.1.1.21' value: '21'
+ Located input field 'ifIndex' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.1'
+ Found item [ifIndex='1'] index: 1 [from value]
.
.
.
+ Found data query XML file at '/var/www/html/cacti-0.8.7e/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/var/www/html/cacti-0.8.7e/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/var/www/html/cacti-0.8.7e/resource/snmp_queries/interface.xml'

For me this shows that fetching the interface list works OK.

If I click on the green circle at the graph creation screen, I get:

Code: Select all

Warning: Invalid argument supplied for foreach() in /var/www/html/cacti-0.8.7e/lib/snmp.php on line 347
Warning: Invalid argument supplied for foreach() in /var/www/html/cacti-0.8.7e/lib/snmp.php on line 347
Warning: Invalid argument supplied for foreach() in /var/www/html/cacti-0.8.7e/lib/snmp.php on line 347
.
.
.
Warning: Invalid argument supplied for foreach() in /var/www/html/cacti-0.8.7e/lib/snmp.php on line 347
Warning: Invalid argument supplied for foreach() in /var/www/html/cacti-0.8.7e/lib/snmp.php on line 486
Warning: Invalid argument supplied for foreach() in /var/www/html/cacti-0.8.7e/lib/snmp.php on line 486
.
.
.
Warning: Invalid argument supplied for foreach() in /var/www/html/cacti-0.8.7e/lib/snmp.php on line 347
Warning: Invalid argument supplied for foreach() in /var/www/html/cacti-0.8.7e/lib/snmp.php on line 347
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/cacti-0.8.7e/lib/snmp.php:347) in /var/www/html/cacti-0.8.7e/graphs_new.php on line 45

Any tips/pointers on how to solve or debug this are highly appreciated.

Ronald

-----------------------------------------------------------
Some more info from the "Technical support" section:

Code: Select all

Technical Support
General Information
Date 	Thu, 16 Jul 2009 13:24:53 +0200
Cacti Version 	0.8.7e
Cacti OS 	unix
SNMP Version 	NET-SNMP version: 5.0.9
RRDTool Version 	RRDTool 1.2.x
Hosts 	942
Graphs 	8709
Data Sources 	Script/Command: 9
SNMP: 1170
SNMP Query: 7837
Script Query: 10
Script Query - Script Server: 72
Total: 9098
Poller Information
Interval 	300
Type 	cmd.php
Items 	Action[0]: 16680
Action[1]: 29
Action[2]: 144
Total: 16853
Concurrent Processes 	60
Max Threads 	150
PHP Servers 	1
Script Timeout 	25
Max OID 	10
Last Run Statistics 	Time:255.9261 Method:cmd.php Processes:60 Threads:N/A Hosts:938 HostsPerProcess:16 DataSources:16853 RRDsProcessed:8871
PHP Information
PHP Version 	4.3.2
PHP OS 	Linux
PHP uname 	Linux hostname 2.4.21-47.ELsmp #1 SMP Wed Jul 5 20:38:41 EDT 2006 i686
PHP SNMP 	Not Installed
max_execution_time 	1000
memory_limit 	400M

[RonaldPost]

Seems this is related to bug #1506:
http://bugs.cacti.net/view.php?id=1506

Also see:
http://forums.cacti.net/viewtopic.php?t=33316