Problem with poller cache after OID change.

[asik]

Hi,

I have problem with my Cacti 0.8.7e.
How rebuild poller cache after OID number change in Data Template?
http://cacti/utilities.php?action=clear_poller_cache
and rebuild_poller_cache.php from <cacti>/cli directory doesn't work and poller still asking for old OID number.

TIA

[BSOD2600]

You sure the data template has the correct OID?
Where/what is asking for the old OID?
Does the poller cache reflect the correct OID?

[asik]

You sure the data template has the correct OID?
Where/what is asking for the old OID?
Does the poller cache reflect the correct OID?

Yes, I'm sure. When I delete graph and create it again, this work correctly.
Poller cache still have old OID. Even after rebuild cache.

Code: Select all

mysql> select * from poller_item where hostname='XXX' and rrd_name='swap_free'\G;
*************************** 1. row ***************************
       local_data_id: 1779
           poller_id: 0
             host_id: 53
              action: 0
            hostname: XXX
      snmp_community: XYZ
        snmp_version: 2
       snmp_username:
       snmp_password:
  snmp_auth_protocol:
snmp_priv_passphrase:
  snmp_priv_protocol:
        snmp_context:
           snmp_port: 161
        snmp_timeout: 1500
            rrd_name: swap_free
            rrd_path: /usr/local/www/virtual/XXX/cacti/rra/XXX_swap_free_1779.rrd
             rrd_num: 1
            rrd_step: 300
       rrd_next_step: 0
                arg1: .1.3.6.1.4.1.2021.8.21.101.1
                arg2:
                arg3:
1 row in set (0.00 sec)
mysql> delete from poller_item;
Query OK, 1308 rows affected (0.00 sec)

And after http://cacti/utilities.php?action=clear_poller_cache

Code: Select all

mysql> select * from poller_item where hostname='XXX' and rrd_name='swap_free'\G
*************************** 1. row ***************************
       local_data_id: 1779
           poller_id: 0
             host_id: 53
              action: 0
            hostname: XXX
      snmp_community: XYZ
        snmp_version: 2
       snmp_username:
       snmp_password:
  snmp_auth_protocol:
snmp_priv_passphrase:
  snmp_priv_protocol:
        snmp_context:
           snmp_port: 161
        snmp_timeout: 1500
            rrd_name: swap_free
            rrd_path: /usr/local/www/virtual/XXX/cacti/rra/XXX_swap_free_1779.rrd
             rrd_num: 1
            rrd_step: 300
       rrd_next_step: 0
                arg1: .1.3.6.1.4.1.2021.8.21.101.1
                arg2:
                arg3:
1 row in set (0.01 sec)

But if I delete this graph and create it again...:

Code: Select all

mysql> select * from poller_item where hostname='XXX' and rrd_name='swap_free'\G
*************************** 1. row ***************************
       local_data_id: 1806
           poller_id: 0
             host_id: 53
              action: 0
            hostname: XXX
      snmp_community: XYZ
        snmp_version: 2
       snmp_username:
       snmp_password:
  snmp_auth_protocol:
snmp_priv_passphrase:
  snmp_priv_protocol:
        snmp_context:
           snmp_port: 161
        snmp_timeout: 1500
            rrd_name: swap_free
            rrd_path: /usr/local/www/virtual/XXX/cacti/rra/XXX_swap_free_1806.rrd
             rrd_num: 1
            rrd_step: 300
       rrd_next_step: 0
                arg1: NET-SNMP-EXTEND-MIB::nsExtendOutput1Line."swapfree"
                arg2:
                arg3:
1 row in set (0.00 sec)

[/code]

[BSOD2600]

Cacti does not use the ASN.1 names for polling -- you really should switch them all back to the OID number. That's a possible source of problems too. A graph doesn't contain any data about what OID to poll, so I don't see how deleting and recreating will fix anything. It's the data source/template which contains that info.

[asik]

Thanks for replay
I updated "data template" to correct OID:

Code: Select all

[root@cacti /var/db/mysql]# snmpwalk -On -v2c -c ABC XXX NET-SNMP-EXTEND-MIB::nsExtendOutput1Line.\"swapfree\"
.1.3.6.1.4.1.8072.1.3.2.3.1.1.8.115.119.97.112.102.114.101.101 = STRING: 4194304000

Code: Select all

*************************** 1. row ***************************
  data_input_field_id: 6
data_template_data_id: 173
              t_value:
                value: .1.3.6.1.4.1.8072.1.3.2.3.1.1.8.115.119.97.112.102.114.101.101
1 row in set (0.01 sec)

and what I should do now, to update this OID on alredy existing hosts data sources?

<cacti>/cli/rebuild_poller_cache.php doesn't work.
http://cacti/utilities.php?action=clear_poller_cache doesn't work too

TIA

[BSOD2600]

Once the data template has been corrected, a poller cache flush should be all thats required for cacti to use the correct data. It's still wrong when you view the poller cache?

[jeconcour]

it seems i have the same problem

i change a data template (5mn bytes/s pooling) used by a data source to use an another data template (1mn bytes/s pooling). after doing this nothing is pooling or in the pooler cache, even if i rebuild it. When i active debugger mode to the data or graph source all is ok. the debugger log mod say "nothing to pool" in teh logs and the host is active.

If i delete completely the data source and configure a new one to use the data template (1mn bytes/s pooling) , all is working fine so this is not a problem of configuration of ma data template

i don't want to have to delete all my hundreds of data source and recreate new one, new graph, reconfigure all graph name, data source name and weathermaps graph, i will spend it days.... please help

[zed22]

I also have this problem. Running 0.8.7e here as well. I have a data template associated to a bunch of data sources. It is using the "total all values" script Gandalf wrote (http://forums.cacti.net/viewtopic.php?t=30182). I went into the data template and changed the "snmpwalk base OID" because I wanted to walk a different OID than what I originally used. I rebuilt the poller cache, but all of the data sources are still using the old OID. Is there any way to push or update the new OID to the existing data sources? I also am just trying to avoid starting from scratch and recreating them all.

I tried duplicating the data template and changing the data source to the new template. This did change the OID in the poller cache, but lost all of the other information and variables for the script. I changed it back to the original data template and it was still gone. Rebuilding the poller cache did not help. The values being entered in this rrd file now are all 0 as well.

New:

CENTCMTB01 - Total Modem Count
Script Server: /var/www/cacti/scripts/ss_total_snmpwalk.php ss_total_snmpwalk .1.3.6.1.4.1.4981.1.10.1.6
RRD: /var/www/cacti/rra/centcmtb01_reg_24742.rrd

Old:

CENTCMTB01 - Total Modem Count
Script Server: /var/www/cacti/scripts/ss_total_snmpwalk.php ss_total_snmpwalk <ip address> .1.3.6.1.4.1.4981.2.1.2.1.7 <community> 2 161 1000 MD5 DES
RRD: /var/www/cacti/rra/centcmtb01_reg_24742.rrd

Long story short, the problem I am hoping to work around is that all of the data sources still have the old OID in the poller cache even though I changed it in the data template. Thanks.

Edit: I deleted a data source, recreated a new graph and data source, and it has all of the correct info in the poller cache. I went into the data source and changed it to the old rrd file to preserve the history and now it is working. I just wanted to avoid doing this 76 times, but so be it.

[tecman]

I had the same issue with 0.8.7e and after few hours spent on trying to work out things in mysql I came up with same idea to duplicate data template and replace templates in data sources on each host. I did find the problem with missing variables for my script. The solution for that was to go to each host definition and click SAVE again and rebuild poller cache.

It looks like this feature is bit buggy and maybe needs cacti dev attention?

Regards,
Pawel

[gandalf]

If things have changed outside the control of cacti, it is indeed a good idea to rebuild the poller cache. Until now, no specific problem in this area is known. If you don't agree, please post a bug report
R.

[tecman]

If things have changed outside the control of cacti, it is indeed a good idea to rebuild the poller cache. Until now, no specific problem in this area is known. If you don't agree, please post a bug report
R.

Hi Gandalf,

I think I can call it a bug and I'll raise it shortly.

[jauer]

Did anything ever come of this?

I think I'm hitting the same issue on 0.8.7g.

I changed the OID on a Data Template and rebuilt the poller cache.
In the poller log I saw that it was still using the old OID.

I manually changed the OID in arg1 in the poller_item table to get polling working.
When I rebuilt the poller cache arg1 was changed back.

I then changed the data template to use per data source OID.
The old OID then appeared in the each data source.

I changed the OID in each datasource, rebuilt the poller cache, and turned off per data source OID in the data template.

Now everything appears normal but I don't know if that's because the poller is using per-data-source OID even though I have that turned off.

[gandalf]

Again, if you feel the nedd to have us fix that, please report a bug as given by http://www.cacti.net/bugs.php
Please attach the findings. They are quite precise, so chance is to get us reproducing that issue
R.

[TheWitness]

This is a known defect. I have a revised lib/template.php that should resolve the issue if you want to test.

HOWEVER: Please please please please, backup your Cacti database before you test this. If there are issues, you can simply restore the original lib/template.php and try again.

So, the process is as follows:

1) backup original lib/template.php
2) backup database 'mysqldump cacti > cacti_backup.sql
3) apply the attached lib/template.php
4) edit the data template and change the oid.
5) repopulate poller cache
6) see if the graphs poller cache has the correct values.
7) watch your log and graphs for issues.
8) backoff as required.

TheWitness

[TheWitness]

Feedback anyone?