receiving CMDPHP: Poller[0] ERROR: SQL Exec Failed

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

Moderators: Developers, Moderators

Post Reply
thewizards2k2
Posts: 4
Joined: Mon Sep 10, 2007 1:44 pm

receiving CMDPHP: Poller[0] ERROR: SQL Exec Failed

Post by thewizards2k2 »

i recently kept receiving the follow error messages in my log, can anyone help? this occurred after an apparent power outage.


09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (868, 'traffic_in', '2007-09-10 14:50:25', '960881440')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (868, 'traffic_out', '2007-09-10 14:50:25', '1821297962')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (867, 'traffic_in', '2007-09-10 14:50:25', '4258471080')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (867, 'traffic_out', '2007-09-10 14:50:25', '457881633')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (866, 'traffic_in', '2007-09-10 14:50:25', '1691206785')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (866, 'traffic_out', '2007-09-10 14:50:25', '360787751')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (865, 'traffic_in', '2007-09-10 14:50:25', '169127252')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (865, 'traffic_out', '2007-09-10 14:50:25', '1817423664')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (864, 'traffic_in', '2007-09-10 14:50:25', '3617299340')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (864, 'traffic_out', '2007-09-10 14:50:25', '3499942368')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (863, 'traffic_in', '2007-09-10 14:50:25', '3054999251')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (863, 'traffic_out', '2007-09-10 14:50:25', '4202252657')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (862, 'traffic_in', '2007-09-10 14:50:25', '3293467040')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (862, 'traffic_out', '2007-09-10 14:50:25', '3816435019')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (861, 'traffic_in', '2007-09-10 14:50:25', '3421387963')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (861, 'traffic_out', '2007-09-10 14:50:25', '873949762')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (848, 'traffic_out', '2007-09-10 14:50:25', '359227062')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (848, 'traffic_in', '2007-09-10 14:50:25', '300174557')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (847, 'traffic_out', '2007-09-10 14:50:25', '3294728700')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (847, 'traffic_in', '2007-09-10 14:50:25', '290785841')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (846, 'traffic_out', '2007-09-10 14:50:25', '3358908050')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (846, 'traffic_in', '2007-09-10 14:50:25', '2145618320')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (845, 'traffic_out', '2007-09-10 14:50:25', '563735241')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (845, 'traffic_in', '2007-09-10 14:50:25', '176371416')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (844, 'traffic_out', '2007-09-10 14:50:25', '2510893316')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (844, 'traffic_in', '2007-09-10 14:50:25', '1545289411')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (843, 'traffic_out', '2007-09-10 14:50:25', '3853657308')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (843, 'traffic_in', '2007-09-10 14:50:25', '1281561122')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (842, 'traffic_out', '2007-09-10 14:50:25', '3917703893')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (842, 'traffic_in', '2007-09-10 14:50:25', '3739045476')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (841, 'traffic_out', '2007-09-10 14:50:25', '2721616109')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (841, 'traffic_in', '2007-09-10 14:50:25', '555780305')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (840, 'traffic_out', '2007-09-10 14:50:25', '432879032')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (840, 'traffic_in', '2007-09-10 14:50:25', '2467788812')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (1351, 'nonunicast_in', '2007-09-10 14:50:24', '2297442')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (1351, 'nonunicast_out', '2007-09-10 14:50:24', '8460351')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (1350, 'nonunicast_in', '2007-09-10 14:50:24', '51171024')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (1350, 'nonunicast_out', '2007-09-10 14:50:24', '108897530')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (1349, 'nonunicast_in', '2007-09-10 14:50:24', '10875169')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (1349, 'nonunicast_out', '2007-09-10 14:50:24', '56657286')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (1348, 'nonunicast_in', '2007-09-10 14:50:24', '14436053')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (1348, 'nonunicast_out', '2007-09-10 14:50:24', '14799312')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (1347, 'nonunicast_in', '2007-09-10 14:50:24', '4781231')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (1347, 'nonunicast_out', '2007-09-10 14:50:24', '32662157')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (1346, 'nonunicast_in', '2007-09-10 14:50:24', '50532056')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (1346, 'nonunicast_out', '2007-09-10 14:50:24', '73538210')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (1345, 'nonunicast_in', '2007-09-10 14:50:24', '79050970')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (1345, 'nonunicast_out', '2007-09-10 14:50:24', '230938406')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (1344, 'nonunicast_in', '2007-09-10 14:50:24', '3924258')"
09/10/2007 02:50:25 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (1344, 'nonunicast_out', '2007-09-10 14:50:24', '267724538')"
Last edited by thewizards2k2 on Mon Sep 10, 2007 3:26 pm, edited 1 time in total.
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

You may want to repair your mysql tables
Reinhard
Top
thewizards2k2
Posts: 4
Joined: Mon Sep 10, 2007 1:44 pm

Post by thewizards2k2 »

i ran mysqlcheck -c cacti and everything checks out okay. i also ran

mysqlcheck -r cacti and everything replies with an "OK". i still get the same log error messages.


mysqlcheck -c cacti

cacti.cdef OK
cacti.cdef_items OK
cacti.colors OK
cacti.data_input OK
cacti.data_input_data OK
cacti.data_input_fields OK
cacti.data_local OK
cacti.data_template OK
cacti.data_template_data OK
cacti.data_template_data_rra OK
cacti.data_template_rrd OK
cacti.graph_local OK
cacti.graph_template_input OK
cacti.graph_template_input_defs OK
cacti.graph_templates OK
cacti.graph_templates_gprint OK
cacti.graph_templates_graph OK
cacti.graph_templates_item OK
cacti.graph_tree OK
cacti.graph_tree_items OK
cacti.host OK
cacti.host_graph OK
cacti.host_snmp_cache OK
cacti.host_snmp_query OK
cacti.host_template OK
cacti.host_template_graph OK
cacti.host_template_snmp_query OK
cacti.plugin_flowview_dnscache
note : The storage engine for the table doesn't support check
cacti.poller OK
cacti.poller_command OK
cacti.poller_item OK
cacti.poller_output OK
cacti.poller_reindex OK
cacti.poller_time OK
cacti.rra OK
cacti.rra_cf OK
cacti.settings OK
cacti.settings_graphs OK
cacti.settings_tree OK
cacti.snmp_query OK
cacti.snmp_query_graph OK
cacti.snmp_query_graph_rrd OK
cacti.snmp_query_graph_rrd_sv OK
cacti.snmp_query_graph_sv OK
cacti.user_auth OK
cacti.user_auth_perms OK
cacti.user_auth_realm OK
cacti.user_log OK
cacti.version OK
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

Please verify the "double poller issue" mentioned in the second link of my signature
Reinhard
Top
thewizards2k2
Posts: 4
Joined: Mon Sep 10, 2007 1:44 pm

Post by thewizards2k2 »

i dont see the second link in your signature, gandalf
Top
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:
Contact rony

Post by rony »

What is your Max Memory set to in PHP. If it's not at least 64M, change it.

Lower than needed memory settings can cause a condition where the poller_output table becomes to big.

Make sure that the poller_output table has no rows when the poller isn't running.
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
Top
thewizards2k2
Posts: 4
Joined: Mon Sep 10, 2007 1:44 pm

Post by thewizards2k2 »

the max memory set for php is at least 64 M.


how do i make sure that the poller_output table has no rows when the poller isn't running?
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

select count(*) from poller_ouput;
Run this from mysql cli
Reinhard
Top
johngillespie
Posts: 23
Joined: Thu Jun 15, 2006 7:03 am
Location: Paris, France

Post by johngillespie »

Hi,

I have the same problem and have checked my poller_output table... I have 5 entries even when the poller isn't running. What should I do ?

Regards,

John Gillespie
Top
johngillespie
Posts: 23
Joined: Thu Jun 15, 2006 7:03 am
Location: Paris, France

Post by johngillespie »

I have purged all entries in poller_output when the poller wasn't running but I still have the same error messages in my cacti log :(
Top
johngillespie
Posts: 23
Joined: Thu Jun 15, 2006 7:03 am
Location: Paris, France

Post by johngillespie »

Strange thing is ... my charts have wholes in them ... I have the 1 min patch and it fails ("ERROR: SQL Exec Failed" message) once every 3 minutes.
Top
johngillespie
Posts: 23
Joined: Thu Jun 15, 2006 7:03 am
Location: Paris, France

Post by johngillespie »

Here is some info from my cacti log :

Code: Select all

 09/26/2007 11:47:04 AM - SYSTEM STATS: Time:22.1819 Method:cmd.php Processes:3 Threads:N/A Hosts:8 HostsPerProcess:3 DataSources:10 RRDsProcessed:3
09/26/2007 11:47:04 AM - SYSTEM STATS: Time:3.0887 Method:cmd.php Processes:3 Threads:N/A Hosts:8 HostsPerProcess:3 DataSources:10 RRDsProcessed:3
09/26/2007 11:46:45 AM - SYSTEM STATS: Time:103.2650 Method:cmd.php Processes:3 Threads:N/A Hosts:8 HostsPerProcess:3 DataSources:10 RRDsProcessed:6
09/26/2007 11:46:45 AM - POLLER: Poller[0] Maximum runtime of 52 seconds exceeded. Exiting.
09/26/2007 11:46:44 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (52, 'traffic_in', '2007-09-26 11:46:44', '2978743427')"
09/26/2007 11:46:44 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (52, 'traffic_out', '2007-09-26 11:46:44', '1630301769')"
09/26/2007 11:46:44 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (53, 'snmp_oid', '2007-09-26 11:46:44', '14')"
09/26/2007 11:46:44 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (42, 'traffic_out', '2007-09-26 11:46:44', '945036899')"
09/26/2007 11:46:44 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (42, 'traffic_in', '2007-09-26 11:46:44', '320074325')"
09/26/2007 11:46:43 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (48, 'traffic_out', '2007-09-26 11:46:43', '560690712')"
09/26/2007 11:46:43 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (48, 'traffic_in', '2007-09-26 11:46:43', '1618842496')"
09/26/2007 11:46:43 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (21, 'traffic_out', '2007-09-26 11:46:43', '3247775584')"
09/26/2007 11:46:43 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (21, 'traffic_in', '2007-09-26 11:46:43', '3229501088')"
09/26/2007 11:46:42 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/26/2007 11:45:01 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/26/2007 11:44:04 AM - SYSTEM STATS: Time:3.0882 Method:cmd.php Processes:3 Threads:N/A Hosts:8 HostsPerProcess:3 DataSources:10 RRDsProcessed:6
09/26/2007 11:43:04 AM - SYSTEM STATS: Time:3.0968 Method:cmd.php Processes:3 Threads:N/A Hosts:8 HostsPerProcess:3 DataSources:9 RRDsProcessed:5
09/26/2007 11:43:01 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/26/2007 11:42:05 AM - SYSTEM STATS: Time:22.4198 Method:cmd.php Processes:3 Threads:N/A Hosts:8 HostsPerProcess:3 DataSources:10 RRDsProcessed:4
09/26/2007 11:42:04 AM - SYSTEM STATS: Time:3.1337 Method:cmd.php Processes:3 Threads:N/A Hosts:8 HostsPerProcess:3 DataSources:10 RRDsProcessed:2
09/26/2007 11:41:45 AM - SYSTEM STATS: Time:103.7529 Method:cmd.php Processes:3 Threads:N/A Hosts:8 HostsPerProcess:3 DataSources:10 RRDsProcessed:11
09/26/2007 11:41:45 AM - POLLER: Poller[0] Maximum runtime of 52 seconds exceeded. Exiting.
09/26/2007 11:41:42 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/26/2007 11:40:02 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/26/2007 11:39:04 AM - SYSTEM STATS: Time:3.1059 Method:cmd.php Processes:3 Threads:N/A Hosts:8 HostsPerProcess:3 DataSources:10 RRDsProcessed:6
09/26/2007 11:38:04 AM - SYSTEM STATS: Time:3.1403 Method:cmd.php Processes:3 Threads:N/A Hosts:8 HostsPerProcess:3 DataSources:9 RRDsProcessed:5
09/26/2007 11:38:01 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/26/2007 11:37:04 AM - SYSTEM STATS: Time:3.0901 Method:cmd.php Processes:3 Threads:N/A Hosts:8 HostsPerProcess:3 DataSources:10 RRDsProcessed:0
09/26/2007 11:37:04 AM - SYSTEM STATS: Time:22.2210 Method:cmd.php Processes:3 Threads:N/A Hosts:8 HostsPerProcess:3 DataSources:10 RRDsProcessed:6
09/26/2007 11:36:45 AM - SYSTEM STATS: Time:103.8547 Method:cmd.php Processes:3 Threads:N/A Hosts:8 HostsPerProcess:3 DataSources:10 RRDsProcessed:8
09/26/2007 11:36:45 AM - POLLER: Poller[0] Maximum runtime of 52 seconds exceeded. Exiting.
09/26/2007 11:36:44 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (52, 'traffic_in', '2007-09-26 11:36:44', '2977084243')"
09/26/2007 11:36:44 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (52, 'traffic_out', '2007-09-26 11:36:44', '1628429094')"
09/26/2007 11:36:44 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (53, 'snmp_oid', '2007-09-26 11:36:44', '15')"
09/26/2007 11:36:43 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (48, 'traffic_out', '2007-09-26 11:36:43', '348066150')"
09/26/2007 11:36:43 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (48, 'traffic_in', '2007-09-26 11:36:43', '1535956927')"
09/26/2007 11:36:42 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/26/2007 11:35:01 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/26/2007 11:34:05 AM - SYSTEM STATS: Time:3.1096 Method:cmd.php Processes:3 Threads:N/A Hosts:8 HostsPerProcess:3 DataSources:10 RRDsProcessed:6
09/26/2007 11:33:04 AM - SYSTEM STATS: Time:3.0932 Method:cmd.php Processes:3 Threads:N/A Hosts:8 HostsPerProcess:3 DataSources:9 RRDsProcessed:5
09/26/2007 11:33:01 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/26/2007 11:32:04 AM - SYSTEM STATS: Time:23.2537 Method:cmd.php Processes:3 Threads:N/A Hosts:8 HostsPerProcess:3 DataSources:10 RRDsProcessed:3
09/26/2007 11:32:04 AM - SYSTEM STATS: Time:3.1315 Method:cmd.php Processes:3 Threads:N/A Hosts:8 HostsPerProcess:3 DataSources:10 RRDsProcessed:3
09/26/2007 11:31:44 AM - SYSTEM STATS: Time:103.1595 Method:cmd.php Processes:3 Threads:N/A Hosts:8 HostsPerProcess:3 DataSources:10 RRDsProcessed:6
09/26/2007 11:31:44 AM - POLLER: Poller[0] Maximum runtime of 52 seconds exceeded. Exiting.
09/26/2007 11:31:44 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (52, 'traffic_in', '2007-09-26 11:31:43', '2975294869')"
09/26/2007 11:31:44 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (52, 'traffic_out', '2007-09-26 11:31:43', '1626717621')"
09/26/2007 11:31:44 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (53, 'snmp_oid', '2007-09-26 11:31:43', '14')"
09/26/2007 11:31:43 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (42, 'traffic_out', '2007-09-26 11:31:43', '924869406')"
09/26/2007 11:31:43 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (42, 'traffic_in', '2007-09-26 11:31:43', '301265031')"
Top
johngillespie
Posts: 23
Joined: Thu Jun 15, 2006 7:03 am
Location: Paris, France

Post by johngillespie »

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

Post by gandalf »

johngillespie wrote:fixed :)
Please help us: how did you perform that bit of magic?
Reinhard
Top
johngillespie
Posts: 23
Joined: Thu Jun 15, 2006 7:03 am
Location: Paris, France

Post by johngillespie »

I'm not actually exactly certain what it was that I did that fixed it... I did a couple of things such as running a repair on the entire database but that didn't seem to do much.... The thing I think fixed it was rebuilding the poller cache.
Top
Post Reply

Return to “Help: Linux/Unix Specific”

Who is online

Users browsing this forum: No registered users and 1 guest