CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062'

[luffywallis]

Hi everyone,
i recently installed Cacti on ubuntu 10.04 virtual machine, my problem is that the graphs are discontinued, i mean it's as if the poller doesn't work by moments. i also have two devices that are seen by Cacti as "up", but their graphs aren't plotted
in cacti.log, i have those messages:

Code: Select all

05/09/2011 03:35:08 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (35, 'traffic_in', '2011-05-09 15:35:02', '4022111834')'
05/09/2011 03:35:08 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (32, 'traffic_in', '2011-05-09 15:35:03', '1872725953')'
05/09/2011 03:35:09 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (34, 'traffic_in', '2011-05-09 15:35:02', '1795101830')'
05/09/2011 03:35:09 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (36, 'traffic_out', '2011-05-09 15:35:02', '2260988634')'
05/09/2011 03:40:01 PM - POLLER: Poller[0] WARNING: Poller Output Table not Empty.  Issues Found: 10, Data Sources: 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])
05/09/2011 03:40:01 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (7, 'proc', '2011-05-09 15:40:01', '193')'
05/09/2011 03:40:05 PM - SYSTEM STATS: Time:4.0303 Method:cmd.php Processes:20 Threads:N/A Hosts:13 HostsPerProcess:1 DataSources:62 RRDsProcessed:30
05/09/2011 03:40:07 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (34, 'traffic_out', '2011-05-09 15:40:02', '2261167425')'
05/09/2011 03:40:09 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (34, 'traffic_in', '2011-05-09 15:40:02', '1854135572')'
05/09/2011 03:40:12 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (32, 'traffic_out', '2011-05-09 15:40:03', '3241167968')'
05/09/2011 03:40:13 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (32, 'traffic_in', '2011-05-09 15:40:03', '1933750400')'

What can be the problem?

[noname]

- http://forums.cacti.net/viewtopic.php?f=21&t=35393
- http://forums.cacti.net/viewtopic.php?f=2&t=36288

It is said that the error is caused by running multiple pollers.

[luffywallis]

ok, now it works, thanks for your reply!
i still have another problem in the fact.
i have three devices that are seen as up but no graph is plotten. in cacti.log i have this message:

Code: Select all

05/06/2011 08:59:47 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'2006', SQL:"SELECT count(*) FROM poller_time WHERE poller_id=0 AND end_time>'0000-00-00 00:00:00'"
05/06/2011 08:59:47 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', 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"
05/06/2011 08:59:48 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'2006', SQL:"SELECT count(*) FROM poller_time WHERE poller_id=0 AND end_time>'0000-00-00 00:00:00'"
05/06/2011 08:59:48 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', 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"
05/06/2011 08:59:49 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'2006', SQL:"SELECT count(*) FROM poller_time WHERE poller_id=0 AND end_time>'0000-00-00 00:00:00'"

[noname]

- Error: 2006 = "MySQL server has gone away"

Check if your MySQL daemon is working properly.

More detailed: http://dev.mysql.com/doc/refman/5.5/en/gone-away.html