graph issue

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
dkb
Posts: 24
Joined: Sun Dec 30, 2007 12:59 pm

graph issue

Post by dkb »

hi!

I'm using P4 1.6 with 512MB RAM. I encounter that the graph is not plotted when i added in more than 800++ of graphs. Is that because of a hardware limitation?

How do i troubleshoot if the graph is not plotting.?

Please advise. Thanks.
Top
jay
Cacti User
Posts: 390
Joined: Wed Aug 31, 2005 8:55 am
Location: Bristol, England

Post by jay »

Hi

It may be that your poller is not finishing within 5 minutes. Are you using Cactid/Spine or cmd.php?? Have a look at the logs to see how long the poller is taking.

Jay
Cacti Version 0.8.7e, Spine 0.8.7e, Apache 2.2.15, Mysql 5.0.88, PHP 5.2.13, RRDTool 1.2.30, NET-SNMP 5.5
Quad Core AMD Opteron Processor 2384, 2.70Ghz, 2GB RAM , 1 CPU used
Windows Server 2003 (X64), VMWARE ESX
Plugins: Aggregate 0.75

SYSTEM STATS: Time:12.5140 Method:spine Processes:2 Threads:15 Hosts:400 HostsPerProcess:200 DataSources:2909 RRDsProcessed:1384
Top
dkb
Posts: 24
Joined: Sun Dec 30, 2007 12:59 pm

graph

Post by dkb »

hi! I'm using spine. here's the some of the errors captured. How do i check the poller timmer? How to extend it? Pls advise...need the solution urgently. Thanks.

01/17/2008 11:16:04 PM - SPINE: Poller[0] ERROR: A database insert failed! Error:'1062', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (78,'traffic_out','2008-01-17 23:16:04','547840275'),(78,'traffic_in','2008-01-17 23:16:04','2359867680'),(77,'traffic_in','2008-01-17 23:16:04','2992410072'),(77,'traffic_out','2008-01-17 23:16:04','922818037'),(76,'traffic_out','2008-01-17 23:16:04','3546490162'),(76,'traffic_in','2008-01-17 23:16:04','2981088879')'
01/17/2008 11:16:04 PM - SPINE: Poller[0] ERROR: A database insert failed! Error:'1062', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (41,'traffic_in','2008-01-17 23:16:04','3139243560'),(41,'traffic_out','2008-01-17 23:16:04','3052989772'),(81,'traffic_in','2008-01-17 23:16:04','134661002'),(43,'traffic_out','2008-01-17 23:16:04','217947939'),(44,'traffic_out','2008-01-17 23:16:04','527071298'),(44,'traffic_in','2008-01-17 23:16:04','2502110175'),(45,'traffic_in','2008-01-17 23:16:04','2688807622'),(45,'traffic_out','2008-01-17 23:16:04','298159891'),(46,'traffic_out','2008-01-17 23:16:04','607983671'),(47,'traffic_in','2008-01-17 23:16:04','3587483589'),(47,'traffic_out','2008-01-17 23:16:04','563568217'),(48,'traffic_in','2008-01-17 23:16:04','2652518213'),(48,'traffic_out','2008-01-17 23:16:04','617940561'),(49,'traffic_out','2008-01-17 23:16:04','600931827'),(49,'traffic_in','2008-01-17 23:16:04','1387439156'),(50,'traffic_in','2008-01-17 23:16:04','922865550'),(50,'traffic_out','2008-01-17 23:16:04','610874240'),(51,'traffic_out','2008-01-17 23:16:04','760267270'
01/17/2008 11:16:04 PM - SPINE: Poller[0] ERROR: A database insert failed! Error:'1062', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (26,'traffic_out','2008-01-17 23:16:04','3546488878'),(26,'traffic_in','2008-01-17 23:16:04','2981088066'),(27,'traffic_out','2008-01-17 23:16:04','642784517'),(28,'traffic_out','2008-01-17 23:16:04','701702593'),(29,'traffic_out','2008-01-17 23:16:04','803118086'),(30,'traffic_out','2008-01-17 23:16:04','922818037'),(30,'traffic_in','2008-01-17 23:16:04','2992410072'),(31,'traffic_out','2008-01-17 23:16:04','547840275'),(32,'traffic_out','2008-01-17 23:16:04','1410739332'),(33,'traffic_out','2008-01-17 23:16:04','600185747'),(33,'traffic_in','2008-01-17 23:16:04','3997459513'),(34,'traffic_out','2008-01-17 23:16:04','477564609'),(34,'traffic_in','2008-01-17 23:16:04','2475739010'),(35,'traffic_out','2008-01-17 23:16:04','494307807'),(35,'traffic_in','2008-01-17 23:16:04','2729807825'),(36,'traffic_in','2008-01-17 23:16:04','494084017'),(36,'traffic_out','2008-01-17 23:16:04','911966665'),(37,'traffic_in','2008-01-17 23:16:04','81430484'
01/17/2008 11:16:04 PM - SPINE: Poller[0] ERROR: A database insert failed! Error:'1062', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (25,'proc','2008-01-17 23:16:03','70'),(23,'','2008-01-17 23:16:03','1min:0.05 5min:0.10 10min:0.09'),(22,'','2008-01-17 23:16:03','total:0 incoming:0'),(21,'','2008-01-17 23:16:03','Time:2.1425 Method:spine Processes:1 Threads:1 Hosts:8 HostsPerProcess:8 DataSources:78 RRDsProcessed:41'),(20,'mem_swap','2008-01-17 23:16:03','779144'),(19,'mem_buffers','2008-01-17 23:16:03','99340')'
01/17/2008 11:15:04 PM - SYSTEM STATS: Time:2.1425 Method:spine Processes:1 Threads:1 Hosts:8 HostsPerProcess:8 DataSources:78 RRDsProcessed:41
01/17/2008 11:14:04 PM - SYSTEM STATS: Time:2.1438 Method:spine Processes:1 Threads:1 Hosts:8 HostsPerProcess:8 DataSources:78 RRDsProcessed:41
01/17/2008 11:13:04 PM - SYSTEM STATS: Time:2.1407 Method:spine Processes:1 Threads:1 Hosts:8 HostsPerProcess:8 DataSources:78 RRDsProcessed:42
01/17/2008 11:12:04 PM - SYSTEM STATS: Time:3.1179 Method:spine Processes:1 Threads:1 Hosts:8 HostsPerProcess:8 DataSources:78 RRDsProcessed:3
01/17/2008 11:12:04 PM - SYSTEM STATS: Time:2.1985 Method:spine Processes:1 Threads:1 Hosts:8 HostsPerProcess:8 DataSources:78 RRDsProcessed:81
01/17/2008 11:11:03 PM - SYSTEM STATS: Time:2.1416 Method:spine Processes:1 Threads:1 Hosts:8 HostsPerProcess:8 DataSources:78 RRDsProcessed:41
01/17/2008 11:10:37 PM - AUTH LOGIN: User 'admin' Authenticated
01/17/2008 11:10:03 PM - SYSTEM STATS: Time:2.1446 Method:spine Processes:1 Threads:1 Hosts:8 HostsPerProcess:8 DataSources:78 RRDsProcessed:41
01/17/2008 11:09:03 PM - SYSTEM STATS: Time:2.1442 Method:spine Processes:1 Threads:1 Hosts:8 HostsPerProcess:8 DataSources:78 RRDsProcessed:42
01/17/2008 11:08:04 PM - SYSTEM STATS: Time:2.1432 Method:spine Processes:1 Threads:1 Hosts:8 HostsPerProcess:8 DataSources:76 RRDsProcessed:41
01/17/2008 11:08:03 PM - SYSTEM STATS: Time:2.1522 Method:spine Processes:1 Threads:1 Hosts:8 HostsPerProcess:8 DataSources:78 RRDsProcessed:43
01/17/2008 11:07:04 PM - SYSTEM STATS: Time:2.1426 Method:spine Processes:1 Threads:1 Hosts:8 HostsPerProcess:8 DataSources:76 RRDsProcessed:41
01/17/2008 11:06:04 PM - SYSTEM STATS: Time:2.1478 Method:spine Processes:1 Threads:1 Hosts:8 HostsPerProcess:8 DataSources:76 RRDsProcessed:41
01/17/2008 11:05:04 PM - SYSTEM STATS: Time:2.1408 Method:spine Processes:1 Threads:1 Hosts:8 HostsPerProcess:8 DataSources:76 RRDsProcessed:42
01/17/2008 11:04:04 PM - SYSTEM STATS: Time:2.1510 Method:spine Processes:1 Threads:1 Hosts:8 HostsPerProcess:8 DataSources:76 RRDsProcessed:41
01/17/2008 11:02:04 PM - SYSTEM STATS: Time:2.1427 Method:spine Processes:1 Threads:1 Hosts:8 HostsPerProcess:8 DataSources:76 RRDsProcessed:43
01/17/2008 11:02:02 PM - POLLER: Poller[0] WARNING: Poller Output Table not Empty. Potential Data Source Issues for Data Sources: mem_buffers(DS[19]), mem_swap(DS[20]), (DS[21]), (DS[22]), (DS[23]), proc(DS[25]), traffic_in(DS[26]), traffic_out(DS[26]), traffic_in(DS[27]), traffic_out(DS[27]), traffic_in(DS[28]), traffic_out(DS[28]), traffic_in(DS[29]), traffic_out(DS[29]), traffic_in(DS[30]), traffic_out(DS[30]), traffic_in(DS[31]), traffic_out(DS[31]), traffic_in(DS[32]), traffic_out(DS[32]), traffic_in(DS[33]), traffic_out(DS[33]), traffic_in(DS[34]), traffic_out(DS[34]), traffic_in(DS[35]), traffic_out(DS[35]), traffic_in(DS[36]), traffic_out(DS[36]), traffic_in(DS[37]), traffic_out(DS[37]), traffic_in(DS[38]), traffic_out(DS[38]), traffic_in(DS[39]), traffic_out(DS[39]), traffic_in(DS[40]), traffic_out(DS[40]), traffic_in(DS[41]), traffic_out(DS[41]), traffic_in(DS[42]), traffic_out(DS[42]), traffic_in(DS[43]), traffic_out(DS[43]), traffic_in(DS[44]), traffic_out(DS[44]), traffic_in(DS[45]), traffic_out(DS[45]), traffic_in(DS[46]), traffic_out(DS[46]), traffic_in(DS[47]), traffic_out(DS[47]), traffic_in(DS[48]), traffic_out(DS[48]), traffic_in(DS[49]), traffic_out(DS[49]), traffic_in(DS[50]), traffic_out(DS[50]), traffic_in(DS[51]), traffic_out(DS[51]), traffic_in(DS[52]), traffic_out(DS[52]), traffic_in(DS[53]), traffic_out(DS[53]), traffic_in(DS[54]), traffic_out(DS[54]), traffic_in(DS[55]), traffic_out(DS[55]), traffic_in(DS[76]), traffic_out(DS[76]), traffic_in(DS[77]), traffic_out(DS[77]), traffic_in(DS[78]), traffic_out(DS[78]), traffic_in(DS[81]), traffic_out(DS[81]), traffic_in(DS[82]), traffic_out(DS[82])
01/17/2008 11:01:03 PM - SYSTEM STATS: Time:2.1152 Method:spine Processes:1 Threads:1 Hosts:8 HostsPerProcess:8 DataSources:76 RRDsProcessed:0
01/17/2008 11:01:03 PM - SYSTEM STATS: Time:1.1430 Method:spine Processes:1 Threads:1 Hosts:8 HostsPerProcess:8 DataSources:76 RRDsProcessed:41
[52]), traffic_in(DS[53]), traffic_out(DS[53]), traffic_in(DS[54]), traffic_out(DS[54]), traffic_in(DS[55]), traffic_out(DS[55]), traffic_in(DS[76]), traffic_out(DS[76]), traffic_in(DS[77]), traffic_out(DS[77]), traffic_in(DS[78]), traffic_out(DS[78]), 5min_cpu(DS[80]), traffic_in(DS[81]), traffic_out(DS[81]), traffic_in(DS[82]), traffic_out(DS[82])
Top
User avatar
fmangeant
Cacti Guru User
Posts: 2345
Joined: Fri Sep 19, 2003 8:36 am
Location: Sophia-Antipolis, France
Contact:
Contact fmangeant

Post by fmangeant »

Hi

which poller interval do you use ?
[size=84]
[color=green]HOWTOs[/color] :
[list][*][url=http://forums.cacti.net/viewtopic.php?t=15353]Install and configure the Net-SNMP agent for Unix[/url]
[*][url=http://forums.cacti.net/viewtopic.php?t=26151]Install and configure the Net-SNMP agent for Windows[/url]
[*][url=http://forums.cacti.net/viewtopic.php?t=28175]Graph multiple servers using an SNMP proxy[/url][/list]
[color=green]Templates[/color] :
[list][*][url=http://forums.cacti.net/viewtopic.php?t=15412]Multiple CPU usage for Linux[/url]
[*][url=http://forums.cacti.net/viewtopic.php?p=125152]Memory & swap usage for Unix[/url][/list][/size]
Top
dkb
Posts: 24
Joined: Sun Dec 30, 2007 12:59 pm

Post by dkb »

hi! There is a spine poller timed out error. How do i fix this? Please advise...thanks.

01/17/2008 11:49:56 PM - SPINE: Poller[0] ERROR: Spine Timed Out While Processing Hosts Internal
01/17/2008 11:49:56 PM - SYSTEM STATS: Time:54.5678 Method:spine Processes:1 Threads:1 Hosts:31 HostsPerProcess:31 DataSources:548 RRDsProcessed:0
01/17/2008 11:49:55 PM - SYSTEM STATS: Time:53.4010 Method:spine Processes:1 Threads:1 Hosts:31 HostsPerProcess:31 DataSources:548 RRDsProcessed:0
01/17/2008 11:49:55 PM - SPINE: Poller[0] ERROR: Spine Timed Out While Processing Hosts Internal
01/17/2008 11:48:56 PM - SYSTEM STATS: Time:54.5890 Method:spine Processes:1 Threads:1 Hosts:31 HostsPerProcess:31 DataSources:548 RRDsProcessed:0
01/17/2008 11:48:56 PM - SPINE: Poller[0] ERROR: Spine Timed Out While Processing Hosts Internal
01/17/2008 11:47:56 PM - SYSTEM STATS: Time:54.1871 Method:spine Processes:1 Threads:1 Hosts:31 HostsPerProcess:31 DataSources:555 RRDsProcessed:1
01/17/2008 11:47:56 PM - SPINE: Poller[0] ERROR: Spine Timed Out While Processing Hosts Internal
01/17/2008 11:46:56 PM - SYSTEM STATS: Time:54.2776 Method:spine Processes:1 Threads:1 Hosts:31 HostsPerProcess:31 DataSources
Top
dkb
Posts: 24
Joined: Sun Dec 30, 2007 12:59 pm

Post by dkb »

fmangeant wrote:Hi

which poller interval do you use ?

I'm using "every minute". What configuration that i need to change to fix this? Thanks.
Top
dkb
Posts: 24
Joined: Sun Dec 30, 2007 12:59 pm

Post by dkb »

fmangeant wrote:Hi

which poller interval do you use ?
hi! I've tried 5mins as well. It doesn't solve the issue.
Top
dkb
Posts: 24
Joined: Sun Dec 30, 2007 12:59 pm

Post by dkb »

hi! Any help will be very much appreciated. Thanks.
Top
dkb
Posts: 24
Joined: Sun Dec 30, 2007 12:59 pm

additional info

Post by dkb »

Additional info.....here's the log file captured after i restarted cacti. Please advise thanks.

01/18/2008 12:38:50 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:49 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:48 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:47 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:46 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:45 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:44 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:43 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:42 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:41 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:40 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:39 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:38 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:37 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:36 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:35 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:34 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:33 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:32 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:31 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:30 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:29 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:28 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:27 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:26 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:25 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:24 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:23 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:22 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:21 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:20 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:19 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
01/18/2008 12:38:18 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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) LIMIT 10000"
ata_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"
Top
jay
Cacti User
Posts: 390
Joined: Wed Aug 31, 2005 8:55 am
Location: Bristol, England

Post by jay »

I'm not entirely sure what the problem is. You could try repairing your poller output table within mysql

repair table cacti.poller_output

or take a look at
http://docs.cacti.net/node/283
Cacti Version 0.8.7e, Spine 0.8.7e, Apache 2.2.15, Mysql 5.0.88, PHP 5.2.13, RRDTool 1.2.30, NET-SNMP 5.5
Quad Core AMD Opteron Processor 2384, 2.70Ghz, 2GB RAM , 1 CPU used
Windows Server 2003 (X64), VMWARE ESX
Plugins: Aggregate 0.75

SYSTEM STATS: Time:12.5140 Method:spine Processes:2 Threads:15 Hosts:400 HostsPerProcess:200 DataSources:2909 RRDsProcessed:1384
Top
dkb
Posts: 24
Joined: Sun Dec 30, 2007 12:59 pm

Post by dkb »

jay wrote:I'm not entirely sure what the problem is. You could try repairing your poller output table within mysql

repair table cacti.poller_output

or take a look at
http://docs.cacti.net/node/283
hi i'm new to unix and mysql....how do i repair the table cacti.poller output? Thanks for the reply
Top
User avatar
fmangeant
Cacti Guru User
Posts: 2345
Joined: Fri Sep 19, 2003 8:36 am
Location: Sophia-Antipolis, France
Contact:
Contact fmangeant

Post by fmangeant »

You can even use "truncate poller_output", using PhpMyadmin.
[size=84]
[color=green]HOWTOs[/color] :
[list][*][url=http://forums.cacti.net/viewtopic.php?t=15353]Install and configure the Net-SNMP agent for Unix[/url]
[*][url=http://forums.cacti.net/viewtopic.php?t=26151]Install and configure the Net-SNMP agent for Windows[/url]
[*][url=http://forums.cacti.net/viewtopic.php?t=28175]Graph multiple servers using an SNMP proxy[/url][/list]
[color=green]Templates[/color] :
[list][*][url=http://forums.cacti.net/viewtopic.php?t=15412]Multiple CPU usage for Linux[/url]
[*][url=http://forums.cacti.net/viewtopic.php?p=125152]Memory & swap usage for Unix[/url][/list][/size]
Top
dkb
Posts: 24
Joined: Sun Dec 30, 2007 12:59 pm

Post by dkb »

can provide me the steps to do that?

Will there be any problem if i change the template for the exisitng graph? eg. cisco router to generic snmp host.

Is there a limit on the number of host cacti can support?

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

Post by gandalf »

dkb wrote:can provide me the steps to do that?

Code: Select all

mysql --user=cactiuser -p cacti
> enter password
truncate table poller_output;
quit
Is there a limit on the number of host cacti can support?
Sure. Depending on hw sizing and type of polling (SNMP is fast, script is slow). Known installations run up to 2000-3000 hosts and more. Limiting factor is the number of data sources, though.
Reinhard
Top
Post Reply

Return to “Help: General”

Who is online

Users browsing this forum: No registered users and 1 guest