Cacti (home)ForumsRepositoryDocumentation
Cacti: offical forums and support
It is currently Sat Oct 25, 2014 9:36 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Nightly Build of Spine SNV-Checkout creats ERROR 1054
PostPosted: Tue Feb 02, 2010 8:27 am 
Offline
Cacti User

Joined: Tue Jul 07, 2009 8:03 am
Posts: 259
I Created a build from SVN checkout of Spine (main) last night.
Building the Code to executables works fine, but I get the following runtime errors:

, SPINE: Poller[0] FATAL: MySQL Error:'1054', Message:'Unknown column 'device_id' in 'where clause'' (Spine parent)
, SPINE: Poller[0] FATAL: MySQL Error:'1054', Message:'Unknown column 'device_id' in 'where clause'' (Spine parent)
, SPINE: Poller[0] FATAL: MySQL Error:'1054', Message:'Unknown column 'device_id' in 'where clause'' (Spine parent)
, SPINE: Poller[0] FATAL: MySQL Error:'1054', Message:'Unknown column 'device_id' in 'where clause'' (Spine parent)
, SPINE: Poller[0] FATAL: MySQL Error:'1054', Message:'Unknown column 'device_id' in 'where clause'' (Spine parent)
, SPINE: Poller[0] FATAL: MySQL Error:'1054', Message:'Unknown column 'device_id' in 'where clause'' (Spine parent)
, SPINE: Poller[0] FATAL: MySQL Error:'1054', Message:'Unknown column 'device_id' in 'where clause'' (Spine parent)
, SPINE: Poller[0] FATAL: MySQL Error:'1054', Message:'Unknown column 'device_id' in 'where clause'' (Spine parent)
, SPINE: Poller[0] FATAL: MySQL Error:'1054', Message:'Unknown column 'device_id' in 'where clause'' (Spine parent)
, SPINE: Poller[0] FATAL: MySQL Error:'1054', Message:'Unknown column 'device_id' in 'where clause'' (Spine parent)

Building spine from the 0.8.7.e Branch do not lead into this error.

But If I build from the 0.8.7 branch I get massive errors on deplucate entries.

02/02/2010 02:50:29 PM - SPINE: Poller[0] ERROR: SQL Failed! Error:'1062', Message:'Duplicate entry '54758-errors_in-2010-02-02 14:50:25' for key 1', SQL Fragment:'INSERT INTO poller_output_boost (local_data_id, rrd_name, time, output) VALUES (54758,'errors_in','2010-02-02 14:50:25','0'),(54758,'discards_in','2010-02-02 14:50:25','0'),(54758,'discards_out','2010-02-02 14:50:25','0'),(54758,'errors_out','2010-02-02 14:50:25','0'),(54759,'errors_in','2010-02-02 14:50:25','0'),(54759,'discards_in','2010-02-02 14:50:25','0'),(54759,'discards_out','2010-02-02 14:50:25','0'),(54759,'errors_out','2010-02-02 14:50:25','0'),(54760,'errors_in','2010-02-02 14:50:25','0'),(54760,'discards_in','2010-02-02 14:50:25','0'),(54760,'discards_out','2010-02-02 14:50:25','0'),(54760,'errors_out','2010-02-02 14:50:25','0'),(54761,'errors_in','2010-02-02 14:50:25','0'),(54761,'discards_in','2010-02-02 14:50:25','0'),(54761,'discards_out','2010-02-02 14:50:25','0'),(54761,'errors_out','2010-02-02 14:50:25','0'),(54762,'errors_in','2010-02-02 14:50:25','0'),(54762,'discards_in','2010-02-02 14:50:25','0'),(54762,'discards_out','2010-02-02 14:50:25','0'),(54762,'errors_out','2010-02-02 14:50:25''
02/02/2010 02:50:29 PM - SPINE: Poller[0] ERROR: SQL Failed! Error:'1062', Message:'Duplicate entry '54758-errors_in-2010-02-02 14:50:25' for key 1', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (54758,'errors_in','2010-02-02 14:50:25','0'),(54758,'discards_in','2010-02-02 14:50:25','0'),(54758,'discards_out','2010-02-02 14:50:25','0'),(54758,'errors_out','2010-02-02 14:50:25','0'),(54759,'errors_in','2010-02-02 14:50:25','0'),(54759,'discards_in','2010-02-02 14:50:25','0'),(54759,'discards_out','2010-02-02 14:50:25','0'),(54759,'errors_out','2010-02-02 14:50:25','0'),(54760,'errors_in','2010-02-02 14:50:25','0'),(54760,'discards_in','2010-02-02 14:50:25','0'),(54760,'discards_out','2010-02-02 14:50:25','0'),(54760,'errors_out','2010-02-02 14:50:25','0'),(54761,'errors_in','2010-02-02 14:50:25','0'),(54761,'discards_in','2010-02-02 14:50:25','0'),(54761,'discards_out','2010-02-02 14:50:25','0'),(54761,'errors_out','2010-02-02 14:50:25','0'),(54762,'errors_in','2010-02-02 14:50:25','0'),(54762,'discards_in','2010-02-02 14:50:25','0'),(54762,'discards_out','2010-02-02 14:50:25','0'),(54762,'errors_out','2010-02-02 14:50:25','0'),'


Last edited by Deviloper on Tue Feb 02, 2010 8:56 am, edited 1 time in total.

Top
 Profile  
 
 Post subject:
PostPosted: Tue Feb 02, 2010 8:46 am 
Offline
Cacti User

Joined: Tue Jul 07, 2009 8:03 am
Posts: 259
Another Problem depends on your system architectur (I am talking about your windows box):

gcc -DHAVE_CONFIG_H -I. -I. -I./config -I/usr/include/net-snmp -I/usr/include/net-snmp/.. -I/usr/include/mysql -g -O2 -c sql.c
: command not foundine 2:
: command not foundine 5:
: command not foundine 10:
: command not foundine 15:
: command not foundine 20:
: command not foundine 25:
: command not foundine 27:
'/config/depcomp: line 64: syntax error near unexpected token `in
'/config/depcomp: line 64: `case "$depmode" in
make: *** [sql.o] Error 2

root@km-lan-115v:/tmp/0.8.7 # dos2unix ./config/depcomp
dos2unix: converting file /config/depcomp to UNIX format ...


Top
 Profile  
 
 Post subject:
PostPosted: Tue Feb 02, 2010 1:07 pm 
Offline
Cacti User

Joined: Tue Jul 07, 2009 8:03 am
Posts: 259
For the guy who are interested in spine performance between spine 0.8.7e and 0.8.7f:

247K of DS
F:
SPINE: Time: 32.5552 s, Threads: 100, Hosts: 289

E:
SPINE: Time: 32.1308 s, Threads: 100, Hosts: 289

No change in performance when running ./spine -R


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 1 guest


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