I can not get graphs to draw with spine

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Developers, Moderators

Post Reply
amoon
Posts: 3
Joined: Wed Jun 22, 2011 1:13 pm

I can not get graphs to draw with spine

Post by amoon »

It works fine with the cmd.php poller, just not with spine.

Here's some log outout which I think is the problem:

Code: Select all

06/22/2011 11:56:01 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "REPLACE INTO settings (name,value) VALUES ('stats_poller','Time:0.0078 Method:spine Processes:10 Threads:10 Hosts:0 HostsPerProcess:0 DataSources:668 RRDsProcessed:0')"
06/22/2011 11:56:01 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('stats_poller','Time:0.0078 Method:spine Processes:10 Threads:10 Hosts:0 HostsPerProcess:0 DataSources:668 RRDsProcessed:0')'
06/22/2011 11:56:01 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "SELECT COUNT(*) FROM poller_command"
06/22/2011 11:56:01 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'0', SQL:"SELECT COUNT(*) FROM poller_command"
06/22/2011 11:56:01 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "REPLACE INTO settings (name,value) VALUES ('stats_recache','RecacheTime:0.0 HostsRecached:0')"
06/22/2011 11:56:01 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('stats_recache','RecacheTime:0.0 HostsRecached:0')'
06/22/2011 11:57:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM host WHERE disabled = '' ORDER BY id"
06/22/2011 11:57:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'0', SQL:"SELECT id FROM host WHERE disabled = '' ORDER BY id"
06/22/2011 11:57:01 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "REPLACE INTO settings (name,value) VALUES ('path_webroot','/home/cacti/cacti')"
06/22/2011 11:57:01 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('path_webroot','/home/cacti/cacti')'
06/22/2011 11:57:01 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "SELECT count(*) FROM poller_time WHERE end_time='0000-00-00 00:00:00'"
06/22/2011 11:57:01 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'0', SQL:"SELECT count(*) FROM poller_time WHERE end_time='0000-00-00 00:00:00'"
06/22/2011 11:57:01 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "TRUNCATE TABLE poller_time"
06/22/2011 11:57:01 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"TRUNCATE TABLE poller_time'
06/22/2011 11:57:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT local_data_id, rrd_name FROM poller_output"
06/22/2011 11:57:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'0', SQL:"SELECT local_data_id, rrd_name FROM poller_output"
06/22/2011 11:57:01 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "REPLACE INTO settings (name,value) VALUES ('date',NOW())"
06/22/2011 11:57:01 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('date',NOW())'
06/22/2011 11:57:01 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "SELECT count(*) FROM poller_time WHERE poller_id=0 AND end_time>'0000-00-00 00:00:00'"
06/22/2011 11:57:01 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'0', SQL:"SELECT count(*) FROM poller_time WHERE poller_id=0 AND end_time>'0000-00-00 00:00:00'"
06/22/2011 11:57:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select  poller_output.output,  poller_output.time,  poller_output.local_data_id,  poller_item.rrd_path,  poller_item.rrd_name,  poller_item.rrd_num  from (poller_output,poller_item)  where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)  "
06/22/2011 11:57:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'0', SQL:"select  poller_output.output,  poller_output.time,  poller_output.local_data_id,  poller_item.rrd_path,  poller_item.rrd_name,  poller_item.rrd_num  from (poller_output,poller_item)  where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)  "
06/22/2011 11:57:01 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "REPLACE INTO settings (name,value) VALUES ('stats_poller','Time:0.0071 Method:spine Processes:10 Threads:10 Hosts:0 HostsPerProcess:0 DataSources:668 RRDsProcessed:0')"
06/22/2011 11:57:01 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('stats_poller','Time:0.0071 Method:spine Processes:10 Threads:10 Hosts:0 HostsPerProcess:0 DataSources:668 RRDsProcessed:0')'
06/22/2011 11:57:01 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "SELECT COUNT(*) FROM poller_command"
06/22/2011 11:57:01 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'0', SQL:"SELECT COUNT(*) FROM poller_command"
06/22/2011 11:57:01 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "REPLACE INTO settings (name,value) VALUES ('stats_recache','RecacheTime:0.0 HostsRecached:0')"
06/22/2011 11:57:01 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('stats_recache','RecacheTime:0.0 HostsRecached:0')'
06/22/2011 11:58:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM host WHERE disabled = '' ORDER BY id"
06/22/2011 11:58:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'0', SQL:"SELECT id FROM host WHERE disabled = '' ORDER BY id"
06/22/2011 11:58:01 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "REPLACE INTO settings (name,value) VALUES ('path_webroot','/home/cacti/cacti')"
06/22/2011 11:58:01 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('path_webroot','/home/cacti/cacti')'
06/22/2011 11:58:01 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "SELECT count(*) FROM poller_time WHERE end_time='0000-00-00 00:00:00'"
06/22/2011 11:58:01 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'0', SQL:"SELECT count(*) FROM poller_time WHERE end_time='0000-00-00 00:00:00'"
06/22/2011 11:58:01 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "TRUNCATE TABLE poller_time"
06/22/2011 11:58:01 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"TRUNCATE TABLE poller_time'
06/22/2011 11:58:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT local_data_id, rrd_name FROM poller_output"
06/22/2011 11:58:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'0', SQL:"SELECT local_data_id, rrd_name FROM poller_output"
06/22/2011 11:58:01 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "REPLACE INTO settings (name,value) VALUES ('date',NOW())"
06/22/2011 11:58:01 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('date',NOW())'
06/22/2011 11:58:01 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "SELECT count(*) FROM poller_time WHERE poller_id=0 AND end_time>'0000-00-00 00:00:00'"
06/22/2011 11:58:01 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'0', SQL:"SELECT count(*) FROM poller_time WHERE poller_id=0 AND end_time>'0000-00-00 00:00:00'"
06/22/2011 11:58:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select  poller_output.output,  poller_output.time,  poller_output.local_data_id,  poller_item.rrd_path,  poller_item.rrd_name,  poller_item.rrd_num  from (poller_output,poller_item)  where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)  "
06/22/2011 11:58:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'0', SQL:"select  poller_output.output,  poller_output.time,  poller_output.local_data_id,  poller_item.rrd_path,  poller_item.rrd_name,  poller_item.rrd_num  from (poller_output,poller_item)  where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)  "
06/22/2011 11:58:01 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "REPLACE INTO settings (name,value) VALUES ('stats_poller','Time:0.0073 Method:spine Processes:10 Threads:10 Hosts:0 HostsPerProcess:0 DataSources:668 RRDsProcessed:0')"
06/22/2011 11:58:01 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('stats_poller','Time:0.0073 Method:spine Processes:10 Threads:10 Hosts:0 HostsPerProcess:0 DataSources:668 RRDsProcessed:0')'
06/22/2011 11:58:01 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "SELECT COUNT(*) FROM poller_command"
06/22/2011 11:58:01 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'0', SQL:"SELECT COUNT(*) FROM poller_command"
06/22/2011 11:58:01 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "REPLACE INTO settings (name,value) VALUES ('stats_recache','RecacheTime:0.0 HostsRecached:0')"
06/22/2011 11:58:01 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('stats_recache','RecacheTime:0.0 HostsRecached:0')'
Top
amoon
Posts: 3
Joined: Wed Jun 22, 2011 1:13 pm

Re: I can not get graphs to draw with spine

Post by amoon »

./bumpd
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Re: I can not get graphs to draw with spine

Post by gandalf »

amoon wrote:./bumpd
Oh, I didn't know that there was a "bump daemon" :lol: :lol: :lol:
Did you apply all official patches?
R.
Top
amoon
Posts: 3
Joined: Wed Jun 22, 2011 1:13 pm

Re: I can not get graphs to draw with spine

Post by amoon »

Patches? I wasn't aware that we had to apply them, I'll try it out though.

Which patches do I need to apply exactly?

I'm using the latest version of cacti..

Thanks btw.
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Re: I can not get graphs to draw with spine

Post by gandalf »

amoon wrote:Which patches do I need to apply exactly?
All 087g related. In given sequence, please. See hints at
http://www.cacti.net/download_patches.php
R.
Top
Post Reply

Return to “Help: Linux/Unix Specific”

Who is online

Users browsing this forum: No registered users and 1 guest