cactiEZ不显示图像的问题
今天一上监控看数据,忽然发现所有服务器都没数据了,先登录到cacti用系统工具中的“重建采集器缓存”也没能恢复。然后赶紧ssh到服务器查看,在mysql数据库的log文件中,看到了报错提示:出现了好几次这样的情况,解决办法如下:1. 登录mysql数据库root@shangwubu-jiankong.51mox.com:mysql -u rootWelcome to the MySQL monitor.Commands end with ; or g.Your MySQL connection id is 34Server version: 5.1.47 Source distribution
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.This software comes with ABSOLUTELY NO WARRANTY. This is free software,and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
2. 进入数据库mysql> use cacti;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -A3. 修复办法:mysql> select count(*) from poller_output;ERROR 145 (HY000): Table './cacti/poller_output' is marked as crashed and should be repairedmysql> truncate table poller_output;Query OK, 0 rows affected (0.00 sec)mysql> select count(*) from poller_output;+----------+| count(*) |+----------+| 0 |+----------+1 row in set (0.00 sec)mysql> quitBye4. 登录cacti查看实时数据:
生活***好玩,因为生活老***玩我! 人生自古谁无死,啊个拉屎不用纸! 过来看看的 站的更高,尿的更远。 此地禁止大小便,违者没收工具。 昨天,系花对我笑了一下,乐得我晚上直数羊,一只羊,两只羊,三只羊……
页:
[1]