1.2.9 bad SNMP Indexes

[voytek]

I have a 1.2.9 installed on Centos, originally was 1.2.6, just noticed I have some 'bad indexes':

2020/03/23 13:00:05 - POLLER: Poller[Main Poller] WARNING: You have 2 Devices with bad SNMP Indexes. Devices: Device[WAG54G], Device[WAG54G cacti] totalling 6 Data Sources. Please Either Re-Index, Delete or Disable these Data Sources.

looking in prior log entries, I think it started with:

2020/03/23 12:50:04 - POLLER: Poller[Main Poller] Device[WAG54G cacti] DQ[SNMP - Interface Statistics] RECACHE ASSERT FAILED '13305600<2837
2020/03/23 12:50:04 - POLLER: Poller[Main Poller] Device[WAG54G cacti] DQ[Cacti Stats - Data Collector Stats] RECACHE ASSERT FAILED '13305599<2835

how can I fix this ?

/later/

oops, sorry, just tried "*Re-Index Device" option - I think it reindex and fixed this, sorry not checking this better

some more log entries:

2020/03/23 13:00:05 - POLLER: Poller[Main Poller] WARNING: You have 2 Devices with bad SNMP Indexes. Devices: Device[WAG54G], Device[WAG54G cacti] totalling 6 Data Sources. Please Either Re-Index, Delete or Disable these Data Sources.
2020/03/23 12:55:06 - POLLER: Poller[Main Poller] WARNING: You have 2 Devices with bad SNMP Indexes. Devices: Device[WAG54G], Device[WAG54G cacti] totalling 6 Data Sources. Please Either Re-Index, Delete or Disable these Data Sources.
2020/03/23 12:55:06 - SNMPAGENT WARNING: No notification receivers configured for event: cactiNotifyDeviceFailedPoll (CACTI-MIB), severity: medium
2020/03/23 12:55:05 - SYSTEM STATS: Time:4.4207 Method:cmd.php Processes:1 Threads:0 Hosts:14 HostsPerProcess:14 DataSources:196 RRDsProcessed:139
2020/03/23 12:50:35 - AUTOM8 WARNING: Automation Rule[Traffic 64 bit Server] for Device[WAG54G] - DQ[SNMP - Interface Statistics] includes a SQL column ifOperStatus that is not found for the Device. Can not continue.
2020/03/23 12:50:35 - REINDEX WARNING: Sort Field has Changed for Device[WAG54G] and DQ[SNMP - Interface Statistics]. Old Sort:ifDescr, New Sort:ifIndex. Re-mapping issues may occur!
2020/03/23 12:50:17 - PCOMMAND Device[WAG54G] WARNING: Recache Event Detected for Device
2020/03/23 12:50:17 - REINDEX WARNING: Sort Field has Changed for Device[WAG54G cacti] and DQ[SNMP - Interface Statistics]. Old Sort:ifDescr, New Sort:ifIndex. Re-mapping issues may occur!
2020/03/23 12:50:05 - PCOMMAND Device[WAG54G cacti] WARNING: Recache Event Detected for Device
2020/03/23 12:50:05 - SYSTEM STATS: Time:3.4448 Method:cmd.php Processes:1 Threads:0 Hosts:14 HostsPerProcess:14 DataSources:208 RRDsProcessed:181
2020/03/23 12:50:04 - POLLER: Poller[Main Poller] WARNING: Invalid Response(s), Errors[3] Device[WAG54G] Thread[1] DS[WAG54G - Traffic - |query_ifIP|/|query_ifDescr|, WAG54G - Traffic - |query_ifIP|/|query_ifDescr|, WAG54G - Traffic - |query_ifIP|/|query_ifDescr|] Graphs[WAG54G - Traffic - 192.168.1.254 (br0), WAG54G - Traffic - 192.168.1.254 (br0), WAG54G - Traffic - 0.0.0.0 (eth0), WAG54G - Traffic - 0.0.0.0 (eth0), WAG54G - Traffic - 111.222.333.444 (ppp0)]
2020/03/23 12:50:04 - POLLER: Poller[Main Poller] Device[WAG54G] DQ[SNMP - Interface Statistics] RECACHE ASSERT FAILED '13305640<2876
2020/03/23 12:50:04 - POLLER: Poller[Main Poller] Device[WAG54G] DQ[Cacti Stats - Data Collector Stats] RECACHE ASSERT FAILED '13305639<2874
2020/03/23 12:50:04 - POLLER: Poller[Main Poller] WARNING: Invalid Response(s), Errors[3] Device[WAG54G cacti] Thread[1] DS[WAG54G cacti - Traffic - 192.168.1.254/br0, WAG54G cacti - Traffic - 0.0.0.0/eth0, WAG54G cacti - Traffic - |query_ifIP|/|query_ifDescr|] Graphs[WAG54G cacti - Traffic - 192.168.1.254 (br0), WAG54G cacti - Traffic - 192.168.1.254 (br0), WAG54G cacti - Traffic - 0.0.0.0 (eth0), WAG54G cacti - Traffic - 0.0.0.0 (eth0), WAG54G cacti - Traffic - 111.222.333.444 (ppp0)]
2020/03/23 12:50:04 - POLLER: Poller[Main Poller] Device[WAG54G cacti] DQ[SNMP - Interface Statistics] RECACHE ASSERT FAILED '13305600<2837
2020/03/23 12:50:04 - POLLER: Poller[Main Poller] Device[WAG54G cacti] DQ[Cacti Stats - Data Collector Stats] RECACHE ASSERT FAILED '13305599<2835

[Osiris]

There is a fix to lib/data_query.php in githubs 1.2.x branch, you should install it. Also, increase the timeouts for you snmp devices, or lower the max kids.

[voytek]

thanks, I'll try the github version
original - 82184 Mar 2 10:53 data_query.php
github - 82683 Mar 30 17:34 data_query.php

[misterbux]

There is a fix to lib/data_query.php in githubs 1.2.x branch, you should install it. Also, increase the timeouts for you snmp devices, or lower the max kids.

Could you share the link please? Thanks.