0.8.8h to 1.0.4 = graphs not updating

[phalek]

Ok, just realized that this seems to have gone ... odd. The older version provided the rrdtool command being used to update the rrd file.

You can try the debug on these files, but it may not show up ...

[Robvil]

No sign of the command.

Rebooted the server ... only error i see is:

2017-03-09 15:30:24 - DBCALL ERROR: SQL Assoc Failed!, Error: Unknown column 'a.hrStorageTotalCache' in 'where clause'
2017-03-09 15:30:24 - DBCALL ERROR: SQL Assoc Failed!, Error:1054, SQL:"SELECT * FROM (SELECT host_id, snmp_query_id, snmp_index, MAX(CASE WHEN field_name ='hrStorageIndex' THEN field_value ELSE NULL END) AS 'hrStorageIndex', MAX(CASE WHEN field_name ='hrStorageDescr' THEN field_value ELSE NULL END) AS 'hrStorageDescr', MAX(CASE WHEN field_name ='hrStorageAllocationUnits' THEN field_value ELSE NULL END) AS 'hrStorageAllocationUnits' FROM host_snmp_cache AS hsc WHERE snmp_query_id=1 AND host_id=1 GROUP BY snmp_query_id, snmp_index) as a WHERE a.hrStorageTotalCache > '1' AND a.hrStorageDescr NOT LIKE '%/dev/%'"

In what table should the column a.hrStorageTotalCache be?

Running /usr/local/spine/bin/spine --verbosity=5 shows no error at all - and OID values are returned - but never written to the rrd files.

[Robvil]

I managed to grab some of the data in sql table Poller_outout and i clearly see valid values in the colomns.
See attached file.

So question is why does these OID values not get updated in the rrd files - even as the time stamp on all rrd files has time of last update?

[Osiris]

No sign of the command.

Rebooted the server ... only error i see is:

2017-03-09 15:30:24 - DBCALL ERROR: SQL Assoc Failed!, Error: Unknown column 'a.hrStorageTotalCache' in 'where clause'
2017-03-09 15:30:24 - DBCALL ERROR: SQL Assoc Failed!, Error:1054, SQL:"SELECT * FROM (SELECT host_id, snmp_query_id, snmp_index, MAX(CASE WHEN field_name ='hrStorageIndex' THEN field_value ELSE NULL END) AS 'hrStorageIndex', MAX(CASE WHEN field_name ='hrStorageDescr' THEN field_value ELSE NULL END) AS 'hrStorageDescr', MAX(CASE WHEN field_name ='hrStorageAllocationUnits' THEN field_value ELSE NULL END) AS 'hrStorageAllocationUnits' FROM host_snmp_cache AS hsc WHERE snmp_query_id=1 AND host_id=1 GROUP BY snmp_query_id, snmp_index) as a WHERE a.hrStorageTotalCache > '1' AND a.hrStorageDescr NOT LIKE '%/dev/%'"

In what table should the column a.hrStorageTotalCache be?

Running /usr/local/spine/bin/spine --verbosity=5 shows no error at all - and OID values are returned - but never written to the rrd files.

That would appear plugin related. You should audit/grep your plugins and or scripts directory for that.

[Robvil]

I found the error.

All my rrd files expect .minimal_heartbeat = 120, but my poller interval was 5 minuttes, so i changed poller interval to 1 minutte.
Before the upgrade i was running with 5 minuttes poll interval - but due to old spine version, snmpget did not work before i upgraded spine. In between all these findings, i played around with all sorts of settings - set poll time to 1 minutte - and i had deleted all my rdd files and let the system create new ones. So in all of this a mismach between rrd heartbeat og poll interval was intruduced by me.

Which lead me to a question - is rrd heartbeat interval still set in templates - or only by the poller interval time in version 1.0.x?

[Chrysalis]

I have had the same issue and never got to the bottom of it, ran out of time in maintenance window so will play with this again on a spare server.

Sadly cacti 1.0 first meant I had to upgrade rrdtool since 1.3 is now the min version, I still like to use 1.2 as can pick good fonts.

The core issue was however that in the user area of cacti where can view graphs I just had empty image placeholders, yet in the admin console area if I viewed graphs from there they loaded fine. The clog was empty of errors (even in debug mode) and nothing in web server error log either, so I downgraded and will come back to this another time.

Also is a shame that thold never got merged.

[Robvil]

Regarding thold, you can download it from Github for version 1.x

I have it installed and working.