rrd not updating, interface queury returns 0 rows

[cykes]

I have a problem that has come out of no where. I've been using cacti 0.86b for a while now with over 1000 graphs. Recently I've noticed a problem while trying to add additional devices. For whatever reason cacti gives the following error during data query.

"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."

The system also shows the following on the graph viewing page,

Viewing Area - Traffic - |query_ifName|'

This sytem is running Fedora Core 1, php 4.3.8, net-snmp 5.1-2.1, httpd 2.0.50 and mysql 3.23 and using cactid as the poller. Cacti is 0.86b + all patches.

I'm graphing equipment both with version 1 and 2c snmp. Graphs exist showing cpu processes, memory, disk usage as well as interface statistics. This has been working perfectly for the last 2 years .... well until I just tried to add a new device. So I don't know when this problem actually first manifested. The last device was added in January this year successfully.

As a result of not being able to retrieve interface information cacti is not creating rrd files for the new devices. Existing device graphs are however functioning without problems.

Following is a results from running a data query in debug mode for one of my personal VPN device. Note this device existed before the problem and graphs correctly however queries on the device from cacti show no interface information. What I find weird is the MAC address info.


Data Query Debug Information
+ Running data query [1].
+ Found type = '3' [snmp query].
+ Found data query XML file at '/var/www/html/cacti/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'
+ 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 item [ifIndex='2'] index: 2 [from value]
+ Found item [ifIndex='3'] index: 3 [from value]
+ Found item [ifIndex='4'] index: 4 [from value]
+ Located input field 'ifOperStatus' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.8'
+ Found item [ifOperStatus='Up'] index: 1 [from value]
+ Found item [ifOperStatus='Up'] index: 2 [from value]
+ Found item [ifOperStatus='Down'] index: 3 [from value]
+ Found item [ifOperStatus='Down'] index: 4 [from value]
+ Located input field 'ifDescr' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.2'
+ Found item [ifDescr='trust'] index: 1 [from value]
+ Found item [ifDescr='untrust'] index: 2 [from value]
+ Found item [ifDescr='serial'] index: 3 [from value]
+ Found item [ifDescr='vlan1'] index: 4 [from value]
+ Located input field 'ifName' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.31.1.1.1.1'
+ Found item [ifName=''] index: [from value]
+ Located input field 'ifAlias' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.31.1.1.1.18'
+ Found item [ifAlias=''] index: [from value]
+ Located input field 'ifType' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.3'
+ Found item [ifType='ethernetCsmacd(6)'] index: 1 [from value]
+ Found item [ifType='ethernetCsmacd(6)'] index: 2 [from value]
+ Found item [ifType='ethernetCsmacd(6)'] index: 3 [from value]
+ Found item [ifType='ethernetCsmacd(6)'] index: 4 [from value]
+ Located input field 'ifSpeed' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.5'
+ Found item [ifSpeed='100000000'] index: 1 [from value]
+ Found item [ifSpeed='100000000'] index: 2 [from value]
+ Found item [ifSpeed='0'] index: 3 [from value]
+ Found item [ifSpeed='0'] index: 4 [from value]
+ Located input field 'ifHwAddr' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.6'
+ Found item [ifHwAddr='00:00:10:DB:4B:7D:F2'] index: 1 [from value]
+ Found item [ifHwAddr='00:00:10:DB:4B:7D:F1'] index: 2 [from value]
+ Found item [ifHwAddr='00:00:10:DB:4B:7D:F6'] index: 3 [from value]
+ Found item [ifHwAddr='00:00:10:DB:4B:7D:FF'] index: 4 [from value]
+ Located input field 'ifIP' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.4.20.1.2'
+ Found item [ifIP='70.47.84.1'] index: 1 [from regexp oid parse]
+ Found item [ifIP='10.20.26.17'] index: 2 [from regexp oid parse]
+ Found data query XML file at '/var/www/html/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/snmp_queries/interface.xml'


Any help would be appreciated, as this is my primary graph server for the IT team. I have an additional server moreso for client access running later versions of cacti on Fedora Core 5. We have contemplated upgrading the server but have decided a resolution of the problem maybe more useful in the long run with respect to knowledge acquisition.

[pestilence]

You are running an old version of cacti, if my memory serves me well there used to be a bug as well with the limitation of graphs.
Try upgrading your cacti version, it should be done without any problems.

[cykes]

Well I was hoping there was more to this. Although I don't think it's a limitation issue as I've removed some old data and devices. But I do admit being an older version the best option is always to upgrade. I would have loved to find out why this problem occurred because I beleive it could ocurr wuth any version including the secondary server which is running 0.86h.

I'll consider this closed unless someone has seen and has resolved this problem.

[isabbel]

Hello...
I have the same problem to create new graphs on cacti. Did you find any solution ???
Regard's
Isabel

[gandalf]

Hello...
I have the same problem to create new graphs on cacti. Did you find any solution ???
Regard's
Isabel

Please provide more infos, or, better, open a new topic
Reinhard