CactiEZ异常关机重启后，主机鉴控的内存、cpu、硬盘空间等无数据显示，为主机添加的阈值全部消失。

  cactiezhd

查看日志

[root@CactiEZ ~]# tail -f /var/log/mysqld.log

130410 10:58:35 [ERROR] /usr/libexec/mysqld: Table './cacti/poller_item' is marked as crashed and should be repaired

130410 10:58:36 [ERROR] /usr/libexec/mysqld: Table './cacti/poller_item' is marked as crashed and should be repaired

130410 10:58:37 [ERROR] /usr/libexec/mysqld: Table './cacti/poller_item' is marked as crashed and should be repaired

修复出问题的表
 
[root@CactiEZ /]# myisamchk -c -r /var/lib/mysql/cacti/poller_item.MYI
- recovering (with sort) MyISAM-table '/var/lib/mysql/cacti/poller_item.MYI'
Data records: 707
- Fixing index 1
Wrong bytesec:   0-  0-  0 at     137228; Skipped
Wrong bytesec:   0-  0-  0 at     137228; Skipped
Wrong bytesec:   0-  0-  0 at     137228; Skipped
Wrong bytesec:   0-  0-  0 at     137228; Skipped
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
Data records: 691
 
修复完成后等待几分钟，查看图形的数据可以正常显示了，但阈值项目还是空的，再次查看日志。
 

cactiezhd2

[root@CactiEZ ~]# tail -f /var/log/mysqld.log
130410 13:05:48 [ERROR] /usr/libexec/mysqld: Table './cacti/thold_data' is marked as crashed and should be repaired
130410 13:05:50 [ERROR] /usr/libexec/mysqld: Table './cacti/thold_data' is marked as crashed and should be repaired
130410 13:05:59 [ERROR] /usr/libexec/mysqld: Table './cacti/thold_data' is marked as crashed and should be repaired
130410 13:06:02 [ERROR] /usr/libexec/mysqld: Table './cacti/thold_data' is marked as crashed and should be repaired
再次修复出问题的表
[root@CactiEZ ~]# myisamchk -c -r /var/lib/mysql/cacti/thold_data.MYI
- recovering (with sort) MyISAM-table '/var/lib/mysql/cacti/thold_data.MYI'
Data records: 111
- Fixing index 1
Wrong block with wrong total length starting at 580
Wrong block with wrong total length starting at 1776
Wrong block with wrong total length starting at 2740
Wrong block with wrong total length starting at 2936
Wrong block with wrong total length starting at 4032
Wrong block with wrong total length starting at 10072
Found block with too small length at 11544; Skipped
Found block with too small length at 14676; Skipped
Found block with too small length at 21632; Skipped
Found block with too small length at 21772; Skipped
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
- Fixing index 8
- Fixing index 9
Data records: 102
 
修改完成后，从系统里可以看到阈值的项目全部回来了。
 

yuzhi