Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Thu Aug 17, 2017 6:47 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 22 posts ]  Go to page Previous  1, 2
Author Message
 Post subject: Re: 0.8.8h to 1.0.4 = graphs not updating
PostPosted: Thu Mar 09, 2017 8:21 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Jan 31, 2008 6:39 am
Posts: 2598
Location: Kressbronn, Germany
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 ... :-(

_________________
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code:
CereusServer Master:  SYSTEM STATS: Time:2.5621 Method:spine Processes:1 Threads:16 Hosts:446 HostsPerProcess:446 DataSources:14683 RRDsProcessed:7573
CereusServer Agent:   SYSTEM STATS: Time:27.4840 Method:spine Processes:1 Threads:8 Hosts:16 HostsPerProcess:16 DataSources:114576 RRDsProcessed:48061


Top
 Profile  
 
 Post subject: Re: 0.8.8h to 1.0.4 = graphs not updating
PostPosted: Thu Mar 09, 2017 9:38 am 
Offline

Joined: Tue Oct 25, 2016 4:32 am
Posts: 27
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.


Top
 Profile  
 
 Post subject: Re: 0.8.8h to 1.0.4 = graphs not updating
PostPosted: Sat Mar 11, 2017 1:16 pm 
Offline

Joined: Tue Oct 25, 2016 4:32 am
Posts: 27
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?


Attachments:
Poller_output.txt [4.63 KiB]
Downloaded 15 times
Top
 Profile  
 
 Post subject: Re: 0.8.8h to 1.0.4 = graphs not updating
PostPosted: Mon Mar 13, 2017 7:49 pm 
Offline
Cacti User
User avatar

Joined: Mon Jan 05, 2015 10:10 am
Posts: 464
Robvil wrote:
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.

_________________
Before history, there was a paradise, now dust.


Top
 Profile  
 
 Post subject: Re: 0.8.8h to 1.0.4 = graphs not updating
PostPosted: Tue Mar 14, 2017 4:23 am 
Offline

Joined: Tue Oct 25, 2016 4:32 am
Posts: 27
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?


Top
 Profile  
 
 Post subject: Re: 0.8.8h to 1.0.4 = graphs not updating
PostPosted: Sun Apr 02, 2017 1:08 pm 
Offline
Cacti User

Joined: Fri Sep 19, 2008 10:14 am
Posts: 57
Location: UK
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.


Top
 Profile  
 
 Post subject: Re: 0.8.8h to 1.0.4 = graphs not updating
PostPosted: Mon Apr 03, 2017 12:49 am 
Offline

Joined: Tue Oct 25, 2016 4:32 am
Posts: 27
Regarding thold, you can download it from Github for version 1.x

I have it installed and working.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 22 posts ]  Go to page Previous  1, 2

All times are UTC - 5 hours


Who is online

Users browsing this forum: Bing [Bot] and 15 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group