Cacti SQL Failed！ Error:’1062′故障排除

cacti日志报错：05/25/2011 11:40:01 AM – SPINE: Poller[0] ERROR: SQL Failed！ Error:"1062", Message:"Duplicate entry "3-mem_buffers-2011-05-25 11:40:01" for key "PRIMARY"", SQL Fragment:"INSERT INTO poller_output （local_data_id, rrd_name, time, output） VALUES （3,"mem_buffers","2011-05-25 11:40:01","927912"）,（4,"mem_swap","2011-05-25 11:40:01","4192956"）,（5,"","2011-05-25 11:40:01","1min:0.10 5min:0.16 10min:0.23"）,（6,"users","2011-05-25 11:40:01","4"）,（7,"proc","2011-05-25 11:40:01","169"）,（8,"hdd_free","2011-05-25 11:40:01","47949780"）,（8,"hdd_used","2011-05-25 11:40:01","44424292"）"Check
- /etc/crontab
- /etc/cron.d/cacti
- crontab of root and cactiuser cat /etc/crontab
SHELL=/bin/bash
PATH=/sbin:/bin:/usr/sbin:/usr/bin
MAILTO=root
HOME=/
# run-parts
01 * * * * root run-parts /etc/cron.hourly
02 4 * * * root run-parts /etc/cron.daily
22 4 * * 0 root run-parts /etc/cron.weekly
42 4 1 * * root run-parts /etc/cron.monthlycrontab -l -u cactiuser
*/5 * * * * /usr/local/php/bin/php /opt/local/www/html/cacti/poller.php > /dev/null 2>&1cat /etc/cron.d/cacti
*/5 * * * * cacti php /var/www/cacti/poller.php &>/dev/null
注释以上语句故障排除。CentOS 4升级到4.9浅入分析和Linux内核相关的文件夹/proc和/sys相关资讯 CACTI

Cacti监控内网本机TCP连接状况（08月03日）
Cacti auth_login.php绕过访问限制（04月15日）
Cacti完全使用手册（让你快速个性（08/20/2015 19:49:24）

Cacti 安装spine以实现每分钟获取（04月27日）
Cacti host_new_graphs_save函数（12/16/2015 13:55:43）
Linux下搭建Cacti详述（08/12/2015 10:53:40）

本文评论查看全部评论（0）