spine 0.8.8d running error
Moderators: Developers, Moderators
spine 0.8.8d running error
I compile the spine 0.8.8d and change the poller type to spine,and when i view the log , I get the following error:
06/12/2015 02:30:00 PM - SPINE: Poller[0] FATAL: MySQL Error:'1054', Message:'Unknown column 'polling_time' in 'field list'' (Spine thread)
06/12/2015 02:30:00 PM - POLLER: Poller[0] WARNING: There are '1' detected as overrunning a polling process, please investigate
06/12/2015 02:30:00 PM - SYSTEM STATS: Time:298.9135 Method:spine Processes:1 Threads:1 Hosts:2 HostsPerProcess:2 DataSources:5 RRDsProcessed:0
06/12/2015 02:30:00 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
Does anyone have the same problem? And could someone help me?
Thanks!
06/12/2015 02:30:00 PM - SPINE: Poller[0] FATAL: MySQL Error:'1054', Message:'Unknown column 'polling_time' in 'field list'' (Spine thread)
06/12/2015 02:30:00 PM - POLLER: Poller[0] WARNING: There are '1' detected as overrunning a polling process, please investigate
06/12/2015 02:30:00 PM - SYSTEM STATS: Time:298.9135 Method:spine Processes:1 Threads:1 Hosts:2 HostsPerProcess:2 DataSources:5 RRDsProcessed:0
06/12/2015 02:30:00 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
Does anyone have the same problem? And could someone help me?
Thanks!
Re: spine 0.8.8d running error
Same here...
switched back to cmd.php untill I find a solution
switched back to cmd.php untill I find a solution
- Happiness0
- Cacti User
- Posts: 63
- Joined: Wed Oct 29, 2014 5:01 am
- Contact:
Re: spine 0.8.8d running error
Does the version of spine must be the same that the version of cacti?
- Happiness0
- Cacti User
- Posts: 63
- Joined: Wed Oct 29, 2014 5:01 am
- Contact:
Re: spine 0.8.8d running error
The thing I find strange is that if we look for the spine.c file, we have this line:
Or, there is no column "polling_time" in the table host , so it might be related to the problem.
Code: Select all
snprintf(query1, BUFSIZE, "UPDATE host SET polling_time='%g' WHERE id=%i", poll_time, host_id);
Re: spine 0.8.8d running error
Please submit a bug for this. And we will get it taken care of. It does appear that some code from a later revision made it into there.
http://bugs.cacti.net/
http://bugs.cacti.net/
Re: spine 0.8.8d running error
The downloadable version of spine 0.8.8d does not contain this line of code. Where did you download it from?
- Happiness0
- Cacti User
- Posts: 63
- Joined: Wed Oct 29, 2014 5:01 am
- Contact:
Re: spine 0.8.8d running error
Wrong file, sorry. The line is in poller.c, line 1289. Downloaded from the official website. http://www.cacti.net/downloads/spine/ca ... .8d.tar.gz
EDIT:issue reported here http://bugs.cacti.net/view.php?id=2576
EDIT:issue reported here http://bugs.cacti.net/view.php?id=2576
Re: spine 0.8.8d running error
Can you please add 0.8.8d to the list of product versions on bugs.cacti.net so that we can report against it?
- Happiness0
- Cacti User
- Posts: 63
- Joined: Wed Oct 29, 2014 5:01 am
- Contact:
Re: spine 0.8.8d running error
I'm certainly missing something obvious, but I do not see an edit buton on the issue, while being logged in.
Re: spine 0.8.8d running error
Get a similar FATAL error when using Spine 0.8.8d:
06/22/2015 05:15:01 PM - SPINE: Poller[0] FATAL: MySQL Error:'1054', Message:'Unknown column 'snmp_sysUptimeInstance' in 'field list'' (Spine thread)
and
06/22/2015 05:05:01 PM - SPINE: Poller[0] FATAL: MySQL Error:'1054', Message:'Unknown column 'polling_time' in 'field list'' (Spine thread)
06/22/2015 05:30:01 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
Downloaded from here:
http://www.cacti.net/downloads/spine/ca ... .8d.tar.gz
cmd.php works fine. Any ideas?
06/22/2015 05:15:01 PM - SPINE: Poller[0] FATAL: MySQL Error:'1054', Message:'Unknown column 'snmp_sysUptimeInstance' in 'field list'' (Spine thread)
and
06/22/2015 05:05:01 PM - SPINE: Poller[0] FATAL: MySQL Error:'1054', Message:'Unknown column 'polling_time' in 'field list'' (Spine thread)
06/22/2015 05:30:01 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
Downloaded from here:
http://www.cacti.net/downloads/spine/ca ... .8d.tar.gz
cmd.php works fine. Any ideas?
Re: spine 0.8.8d running error
Same Problem (SPINE 0.8.8d Copyright 2002-2015 by The Cacti Group).
Temporary workaround:
I switched back to "SPINE 0.8.8b Copyright 2002-2013 by The Cacti Group".
Cacti runs with version 0.8.8d
Code: Select all
SPINE: Poller[0] FATAL: MySQL Error:'1054', Message:'Unknown column 'snmp_sysUptimeInstance' in 'field list'' (Spine thread)
SPINE: Poller[0] FATAL: MySQL Error:'1054', Message:'Unknown column 'polling_time' in 'field list'' (Spine thread)
I switched back to "SPINE 0.8.8b Copyright 2002-2013 by The Cacti Group".
Cacti runs with version 0.8.8d
Cacti Version - 0.8.8h - Poller Type - SPINE 0.8.8h
MySQL - 5.0.54 - PHP - 5.1.6 -RRDTool - 1.2.23 - SNMP - 5.1.2
Plugins - Banner 0.32, Camm 1.6.7, Dashboard 1.2, Fix64bit 0.4, Monitor 1.3, Passwd 0.1, Settings 0.71, Tools 0.3, Realtime 0.5, Rrdclean 1.1, Spikekill 1.3, Syslog 1.22, Thold 0.6
MySQL - 5.0.54 - PHP - 5.1.6 -RRDTool - 1.2.23 - SNMP - 5.1.2
Plugins - Banner 0.32, Camm 1.6.7, Dashboard 1.2, Fix64bit 0.4, Monitor 1.3, Passwd 0.1, Settings 0.71, Tools 0.3, Realtime 0.5, Rrdclean 1.1, Spikekill 1.3, Syslog 1.22, Thold 0.6
Re: spine 0.8.8d running error
Same workaround for me. Even I go with Spine version 0.8.8c untill a fixed Spine version 0.8.8d is provided.Kreezer wrote: Temporary workaround:
I switched back to "SPINE 0.8.8b Copyright 2002-2013 by The Cacti Group".
Cacti runs with version 0.8.8d
- Happiness0
- Cacti User
- Posts: 63
- Joined: Wed Oct 29, 2014 5:01 am
- Contact:
Re: spine 0.8.8d running error
Yes, another workaround is proposed in the bug report http://bugs.cacti.net/view.php?id=2576 : adding the missing columns in the host table.
Re: spine 0.8.8d running error
can you please guide how can I check the details of below bug and workaround suggest of the same?
http://bugs.cacti.net/view.php?id=2576
this link is now redirected to a new site..where I can not find any information.
http://bugs.cacti.net/view.php?id=2576
this link is now redirected to a new site..where I can not find any information.
Who is online
Users browsing this forum: No registered users and 3 guests