还是一个cacti错误日志的问题
时间:2011-01-20
来源:互联网
这个问题已经困扰我很久了,截取了部分日志如下,这些都是红色的错误日志,提示好像是mysql中不能插入重复的条目,我手动登陆到mysql上,在cacti库中,执行
INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (172,'mem_swap','2011-01-20 11:05:09','3785536'),(173,'users','2011-01-20 11:05:09','2'),(174,'proc','2011-01-20 11:05:09','302'),(177,'mem_buffers','2011-01-20 11:05:09','28296'),(178,'mem_swap','2011-01-20 11:05:09','3785536'),(179,'users','2011-01-20 11:05:09','2'),(180,'proc','2011-01-20 11:05:09','281'),(183,'mem_buffers','2011-01-20 11:05:09','27404'),(184,'mem_swap','2011-01-20 11:05:09','3785536'),(185,'users','2011-01-20 11:05:09','2'),(186,'proc','2011-01-20 11:05:09','279')
这个是可以成功执行的,但是接着执行下面的第二条的时候就不能执行了,就像日志中的一样,也是1062错误。我想也是,poller_output的表结构是这样的:,当然不能插入重复的记录,
mysql> desc poller_output;
+---------------+-----------------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-----------------------+------+-----+---------------------+-------+
| local_data_id | mediumint(
unsigned | NO | PRI | 0 | |
| rrd_name | varchar(19) | NO | PRI | | |
| time | datetime | NO | PRI | 0000-00-00 00:00:00 | |
| output | text | NO | | NULL | |
+---------------+-----------------------+------+-----+---------------------+-------+
4 rows in set (0.02 sec)
现在的问题是,为什么cacti会产生多条这样的插入记录呢?我仅仅是执行了一次Rebuild Poller Cache。而且不知道为什么,我加入的cacti插件都不生效了,界面上显示不出来,而之前是好的。
下面的是cacti产生的一些日志
01/20/2011 11:05:12 AM - SPINE: Poller[0] ERROR: SQL Failed! Error:'1062', Message:'Duplicate entry '172-mem_swap-2011-01-20 11:05:09' for key 1', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (172,'mem_swap','2011-01-20 11:05:09','3785536'),(173,'users','2011-01-20 11:05:09','2'),(174,'proc','2011-01-20 11:05:09','302'),(177,'mem_buffers','2011-01-20 11:05:09','28296'),(178,'mem_swap','2011-01-20 11:05:09','3785536'),(179,'users','2011-01-20 11:05:09','2'),(180,'proc','2011-01-20 11:05:09','281'),(183,'mem_buffers','2011-01-20 11:05:09','27404'),(184,'mem_swap','2011-01-20 11:05:09','3785536'),(185,'users','2011-01-20 11:05:09','2'),(186,'proc','2011-01-20 11:05:09','279')'
01/20/2011 11:05:12 AM - SPINE: Poller[0] ERROR: SQL Failed! Error:'1062', Message:'Duplicate entry '172-mem_swap-2011-01-20 11:05:09' for key 1', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (172,'mem_swap','2011-01-20 11:05:09','3785536'),(173,'users','2011-01-20 11:05:09','2'),(174,'proc','2011-01-20 11:05:09','302'),(177,'mem_buffers','2011-01-20 11:05:09','28708'),(178,'mem_swap','2011-01-20 11:05:09','3785536'),(179,'users','2011-01-20 11:05:09','2'),(180,'proc','2011-01-20 11:05:09','278'),(183,'mem_buffers','2011-01-20 11:05:09','27552'),(184,'mem_swap','2011-01-20 11:05:09','3785536'),(185,'users','2011-01-20 11:05:09','2'),(186,'proc','2011-01-20 11:05:09','280')'
INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (172,'mem_swap','2011-01-20 11:05:09','3785536'),(173,'users','2011-01-20 11:05:09','2'),(174,'proc','2011-01-20 11:05:09','302'),(177,'mem_buffers','2011-01-20 11:05:09','28296'),(178,'mem_swap','2011-01-20 11:05:09','3785536'),(179,'users','2011-01-20 11:05:09','2'),(180,'proc','2011-01-20 11:05:09','281'),(183,'mem_buffers','2011-01-20 11:05:09','27404'),(184,'mem_swap','2011-01-20 11:05:09','3785536'),(185,'users','2011-01-20 11:05:09','2'),(186,'proc','2011-01-20 11:05:09','279')
这个是可以成功执行的,但是接着执行下面的第二条的时候就不能执行了,就像日志中的一样,也是1062错误。我想也是,poller_output的表结构是这样的:,当然不能插入重复的记录,
mysql> desc poller_output;
+---------------+-----------------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-----------------------+------+-----+---------------------+-------+
| local_data_id | mediumint(

| rrd_name | varchar(19) | NO | PRI | | |
| time | datetime | NO | PRI | 0000-00-00 00:00:00 | |
| output | text | NO | | NULL | |
+---------------+-----------------------+------+-----+---------------------+-------+
4 rows in set (0.02 sec)
现在的问题是,为什么cacti会产生多条这样的插入记录呢?我仅仅是执行了一次Rebuild Poller Cache。而且不知道为什么,我加入的cacti插件都不生效了,界面上显示不出来,而之前是好的。
下面的是cacti产生的一些日志
01/20/2011 11:05:12 AM - SPINE: Poller[0] ERROR: SQL Failed! Error:'1062', Message:'Duplicate entry '172-mem_swap-2011-01-20 11:05:09' for key 1', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (172,'mem_swap','2011-01-20 11:05:09','3785536'),(173,'users','2011-01-20 11:05:09','2'),(174,'proc','2011-01-20 11:05:09','302'),(177,'mem_buffers','2011-01-20 11:05:09','28296'),(178,'mem_swap','2011-01-20 11:05:09','3785536'),(179,'users','2011-01-20 11:05:09','2'),(180,'proc','2011-01-20 11:05:09','281'),(183,'mem_buffers','2011-01-20 11:05:09','27404'),(184,'mem_swap','2011-01-20 11:05:09','3785536'),(185,'users','2011-01-20 11:05:09','2'),(186,'proc','2011-01-20 11:05:09','279')'
01/20/2011 11:05:12 AM - SPINE: Poller[0] ERROR: SQL Failed! Error:'1062', Message:'Duplicate entry '172-mem_swap-2011-01-20 11:05:09' for key 1', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (172,'mem_swap','2011-01-20 11:05:09','3785536'),(173,'users','2011-01-20 11:05:09','2'),(174,'proc','2011-01-20 11:05:09','302'),(177,'mem_buffers','2011-01-20 11:05:09','28708'),(178,'mem_swap','2011-01-20 11:05:09','3785536'),(179,'users','2011-01-20 11:05:09','2'),(180,'proc','2011-01-20 11:05:09','278'),(183,'mem_buffers','2011-01-20 11:05:09','27552'),(184,'mem_swap','2011-01-20 11:05:09','3785536'),(185,'users','2011-01-20 11:05:09','2'),(186,'proc','2011-01-20 11:05:09','280')'
作者: zing2046 发布时间: 2011-01-20
没去 cacti 论坛问问啊?
作者: taojie2000 发布时间: 2011-01-20
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28