Poller cache rebuild changes data source OIDs to old ones

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
espro
Posts: 12
Joined: Thu Jan 28, 2010 11:26 am

Poller cache rebuild changes data source OIDs to old ones

Post by espro »

I changed a custom OID a while back and updated my data template to reflect the new OID. I had existing graphs using the old one, but rebuilding the poller cache never changed anything. By going into the database I was able to update the arg1 entries in cacti.poller_item, but any time the poller cache is rebuilt they pick up the old ones.

Where is it getting the old OIDs from and how can I change those?
User avatar
Linegod
Developer
Posts: 1626
Joined: Thu Feb 20, 2003 10:16 am
Location: Canada
Contact:

Post by Linegod »

Run poller_reindex_hosts.php prior to rebuild_poller_cache.php
--
Live fast, die young
You're sucking up my bandwidth.

J.P. Pasnak,CD
CCNA, LPIC-1
http://www.warpedsystems.sk.ca
espro
Posts: 12
Joined: Thu Jan 28, 2010 11:26 am

Post by espro »

`php poller_reindex_hosts.php --id=All` did not solve the issue. Upon rebuilding the poller cache, the old OID came back.
espro
Posts: 12
Joined: Thu Jan 28, 2010 11:26 am

Post by espro »

I figured this out, though I still don't understand the cause

I did a mysqldump of the database and searched for the offending OID. I found it in the 'value' column of the 'data_input_data' table. Updating rows with the bad OID to the new OID, then rebuilding the poller cache resulted in the OIDs staying put to the new, correct OIDs.

What's the purpose of the data_input_data table, and how should its contents have been correctly set for an OID change on a data template for existing graphs?
Post Reply

Who is online

Users browsing this forum: No registered users and 6 guests