spine 0.8.8d running error

[shijiaqi]

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!

[norah10]

Same here...
switched back to cmd.php untill I find a solution

[Happiness0]

Does the version of spine must be the same that the version of cacti?

[Happiness0]

The thing I find strange is that if we look for the spine.c file, we have this line:

Code: Select all

 snprintf(query1, BUFSIZE, "UPDATE host SET polling_time='%g' WHERE id=%i", poll_time, host_id);

Or, there is no column "polling_time" in the table host , so it might be related to the problem.

[cigamit]

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/

[cigamit]

The downloadable version of spine 0.8.8d does not contain this line of code. Where did you download it from?

[Happiness0]

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

[jmb]

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]

I'm certainly missing something obvious, but I do not see an edit buton on the issue, while being logged in.

[neox01]

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?

[Kreezer]

Same Problem (SPINE 0.8.8d Copyright 2002-2015 by The Cacti Group).

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)

Temporary workaround:
I switched back to "SPINE 0.8.8b Copyright 2002-2013 by The Cacti Group".
Cacti runs with version 0.8.8d

[neox01]

Temporary workaround:
I switched back to "SPINE 0.8.8b Copyright 2002-2013 by The Cacti Group".
Cacti runs with version 0.8.8d

Same workaround for me. Even I go with Spine version 0.8.8c untill a fixed Spine version 0.8.8d is provided.

[Happiness0]

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.

[roxy]

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.