I think I screwed up my Interface-Traffic data template

[shaykes]

This is entirely my own fault. Now I'm trying to figure out how to fix it...

A few months ago, I imported a data template that was supposed to provide more statistics for interfaces. I believe it replaced the "Interface - Traffic" data template. Honestly, I forgot exactly what the template provided, or how I found it. I already had a bunch of devices set up & working fine before I imported the template. I imported the template, added a host, and started monitoring a few new hosts. Everything was working fine, so I thought I was golden.

Fast forward.... Today I discovered if I perform a "Reload Data Query" on a switch added before the import, Cacti will stop polling data sources that formerly used the traffic template. The only output in the debug logs is for data sources using non-traffic templates. I have tried a manual poll for the device, but the output is still only for the non-traffic templates. In data sources, the "Template Name" all appears as "None" (see below).

ss1.png (24.46 KiB) Viewed 701 times

Hosts added after the import continue to work fine&dandy.

I have tried:

• Setting Data Template for Interfaces

• Tried a poll with Re-Index method set to Verify All Fields, Index Count Changed, and None

• Manually changing all kinds of template fields in the database for the data source, then promptly restored from backup

• Re-Imported Interface-Traffic data template from fresh Cacti install

None of that worked, so I restored everything from backup to the prior day's state. Unfortunately, I don't have backups that go back to the days before I imported my the data template.

I'm really banging my head on the wall for this one... stupid move on my part. Any ideas/suggestions?

[gandalf]

Please goto Graph Management. Select a single of those graphs and try to "Change Graph Template" to provide the correct one. Just a shot, no guarantees ...
R.

[shaykes]

Reapplying template in Graph Management associated the correct template, but when I reloaded the SNMP - Interface Statistics data query, graphs stopped updating again -- all the switch's interfaces were removed from the poller cache.

If I run a verbose query, I see the interfaces listed as I would expect to see them. However, none of those interfaces are listed in the poller cache. Curious... any ideas on what would prevent the data query from inserting those interfaces into the poller cache? Seems to me that's where things are breaking down.

[gandalf]

No idea.
YOu may perform a rebuild_poller_cache for that specific host to try reloading stuff. But I fear that in case this does not help, a deep inspection of the db is required.
R.

[shaykes]

No idea.
YOu may perform a rebuild_poller_cache for that specific host to try reloading stuff. But I fear that in case this does not help, a deep inspection of the db is required.
R.

rebuilder_poller_cache unfortunately didn't work, and my previous endeavor into the db smacking at low-hanging fruit didn't fix anything. Thank goodness for backups.

At any rate, I decided to create a new host and scriptomatically copied all the old RRD files to the new paths. It was a simple matter since cacti can display all the IDs of a host's data sources on a single page! So far, things are working great for the new host, and I've maintained all my historical data.

Thanks for the assist!