关于Cacti很郁闷的问题

7looki

自从这个月月初把 Cacti 搭建好以后,直到今天中午以前,没有出任何问题.

中午出完午饭以后,一看Cacti,获取不到数据了.

重启MySQL
结果: 报错:

1. 
   
2. # /etc/init.d/mysqld restart
   
3. ERROR! MySQL manager or server PID file could not be found!
   
4. Starting MySQL. ERROR! Manager of pid-file quit without updating file.
   

复制代码

Google了一圈,在MySQL的配置文件中加入了datadir,MySQL启动起来了;

(之前MySQL一直运行正常,自从安装好以后,再没有改动过)

但是,依旧才不到图像,而且所有的都显示的是 -nan ,然后各种排错:

(1) system utilities --> Rebuild poller cache  (还是采集不到数据)

(2) 重新设置时间 (还是采集不到数据)

(3) 修改权限 #chmod 777 -R /home/data/webapps/cacti/rra (还是采集不到数据)

(4) 修复数据库表 #mysqlcheck -ao cacti --auto-repair -uroot -p (还是采集不到数据)

(5) 重启snmpd服务 #service snmpd restart  (还是采集不到数据)

(6)

# /usr/bin/php /home/data/webapps/cacti/poller.php --force
ERROR: /home/data/webapps/cacti/rra/192_168_6_1_traffic_in_95.rrd: illegal attempt to update using time 1325145337 when last update time is 1325192108 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_1_traffic_in_96.rrd: illegal attempt to update using time 1325145337 when last update time is 1325192108 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_1_5min_cpu_97.rrd: illegal attempt to update using time 1325145337 when last update time is 1325192108 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_1_loss_98.rrd: illegal attempt to update using time 1325145337 when last update time is 1325192108 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_15_users_99.rrd: illegal attempt to update using time 1325145337 when last update time is 1325192108 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_15_proc_100.rrd: illegal attempt to update using time 1325145337 when last update time is 1325192108 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_15_mem_buffers_101.rrd: illegal attempt to update using time 1325145337 when last update time is 1325192108 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_15_mem_swap_102.rrd: illegal attempt to update using time 1325145337 when last update time is 1325192108 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_15_hdd_used_106.rrd: illegal attempt to update using time 1325145337 when last update time is 1325192108 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_15_hdd_used_107.rrd: illegal attempt to update using time 1325145337 when last update time is 1325192108 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_15_load_1min_152.rrd: illegal attempt to update using time 1325145337 when last update time is 1325192108 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_15_hdd_used_108.rrd: illegal attempt to update using time 1325145337 when last update time is 1325192108 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_15_hdd_used_109.rrd: illegal attempt to update using time 1325145337 when last update time is 1325192108 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_15_hdd_used_110.rrd: illegal attempt to update using time 1325145337 when last update time is 1325192108 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_15_traffic_in_111.rrd: illegal attempt to update using time 1325145337 when last update time is 1325192108 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_16_users_112.rrd: illegal attempt to update using time 1325145337 when last update time is 1325192090 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_16_proc_113.rrd: illegal attempt to update using time 1325145337 when last update time is 1325192090 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_16_mem_buffers_114.rrd: illegal attempt to update using time 1325145337 when last update time is 1325192090 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_16_load_1min_116.rrd: illegal attempt to update using time 1325145337 when last update time is 1325192090 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_16_mem_swap_115.rrd: illegal attempt to update using time 1325145337 when last update time is 1325192090 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_16_hdd_used_119.rrd: illegal attempt to update using time 1325145337 when last update time is 1325192090 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_16_traffic_in_123.rrd: illegal attempt to update using time 1325145337 when last update time is 1325192090 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_16_hdd_used_122.rrd: illegal attempt to update using time 1325145337 when last update time is 1325192090 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_16_hdd_used_121.rrd: illegal attempt to update using time 1325145337 when last update time is 1325192090 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_16_hdd_used_120.rrd: illegal attempt to update using time 1325145337 when last update time is 1325192090 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_232_proc_138.rrd: illegal attempt to update using time 1325145338 when last update time is 1325192090 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_232_mem_swap_140.rrd: illegal attempt to update using time 1325145338 when last update time is 1325192090 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_232_mem_buffers_139.rrd: illegal attempt to update using time 1325145338 when last update time is 1325192090 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_232_load_1min_141.rrd: illegal attempt to update using time 1325145338 when last update time is 1325192090 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_232_hdd_used_144.rrd: illegal attempt to update using time 1325145338 when last update time is 1325192090 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_232_hdd_used_145.rrd: illegal attempt to update using time 1325145338 when last update time is 1325192090 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_232_hdd_used_146.rrd: illegal attempt to update using time 1325145338 when last update time is 1325192090 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_232_hdd_used_147.rrd: illegal attempt to update using time 1325145338 when last update time is 1325192090 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_232_hdd_used_148.rrd: illegal attempt to update using time 1325145338 when last update time is 1325192090 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_232_traffic_in_151.rrd: illegal attempt to update using time 1325145338 when last update time is 1325192090 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_232_hdd_used_149.rrd: illegal attempt to update using time 1325145338 when last update time is 1325192090 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_232_users_137.rrd: illegal attempt to update using time 1325145338 when last update time is 1325192090 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_9_hdd_used_159.rrd: illegal attempt to update using time 1325145338 when last update time is 1325192091 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_9_hdd_used_160.rrd: illegal attempt to update using time 1325145338 when last update time is 1325192091 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_9_hdd_used_158.rrd: illegal attempt to update using time 1325145338 when last update time is 1325192091 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_9_mem_buffers_155.rrd: illegal attempt to update using time 1325145338 when last update time is 1325192091 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_9_users_153.rrd: illegal attempt to update using time 1325145338 when last update time is 1325192091 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_9_proc_154.rrd: illegal attempt to update using time 1325145338 when last update time is 1325192091 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_9_mem_swap_156.rrd: illegal attempt to update using time 1325145338 when last update time is 1325192091 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_9_hdd_used_162.rrd: illegal attempt to update using time 1325145338 when last update time is 1325192091 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_9_hdd_used_161.rrd: illegal attempt to update using time 1325145338 when last update time is 1325192091 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_9_traffic_in_163.rrd: illegal attempt to update using time 1325145338 when last update time is 1325192091 (minimum one second step)
ERROR: /home/data/webapps/cacti/rra/192_168_6_9_load_1min_157.rrd: illegal attempt to update using time 1325145338 when last update time is 1325192091 (minimum one second step)
12/29/2011 03:55:39 PM - SYSTEM STATS: Time:2.6691 Method:spine Processes:1 Threads:1 Hosts:6 HostsPerProcess:6 DataSources:74 RRDsProcessed:48

好吧,删除rra下面的所有文件,数分钟后,出图了.


这是什么情况?最郁闷的是MySQL怎么会出这个错误?


这一个月的数据,就这样没了嘛?

mrs99098

除了你的mysql问题外，从你排错的第六步看应该是系统时间变了，更新数据的时间比历史数据记录的时间更早导致无法更新rrd文件。