Cacti不显示流量,Mysql数据表修损坏修复
Cacti
中日志信息:
12/02/2010 04:50:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) "
12/02/2010 04:50:00 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'145', SQL:"UPDATE poller_item SET rrd_next_step = rrd_step - 300 WHERE (rrd_next_step < 0 AND host_id >= 0 AND host_id <= 9)'
12/02/2010 04:50:00 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'145', SQL:"UPDATE poller_item SET rrd_next_step = rrd_next_step - 300 WHERE (host_id >= 0 AND host_id <= 9)'
12/02/2010 04:50:00 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'145', SQL:"SELECT count(*) FROM poller_item WHERE (action=2 AND host_id >= 0 AND host_id <= 9 AND rrd_next_step <= 0)"
12/02/2010 04:50:00 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"SELECT * FROM poller_item WHERE (host_id >= 0 AND host_id <= 9 AND rrd_next_step <= 0) ORDER by host_id"
Windows
应用程序日志中的信息:
事件类型:
错误
事件来源:
MySQL
事件种类:
无
事件 ID:
100
日期:
2010-12-2
事件:
12:30:01
用户:
N/A
计算机:
EXCHANGEDOMAIN
描述:
C:\AppServ\MySQL\bin\mysqld-nt: Table '.\cacti\poller_item' is marked as crashed and should be repaired
For more information, see Help and Support Center at http://www.mysql.com.
Mysql
中数据表修复:
#用REPAIR TABLE方式修复,语法:REPAIR TABLE 表名 [选项]
#进入Mysql数据库:
C:\AppServ\MySQL\bin>mysql -u root -p
Enter password: **************
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 87
Server version: 5.0.45-community-nt-log MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
#
显示所有数据库:
mysql>
show databases;
+--------------------+
| Database
|
+--------------------+
| information_schema |
| cacti
|
| mysql
|
| phpmyadmin
|
| test
|
+--------------------+
5 rows in set (0.00 sec)
mysql>
#
连接损坏表所在的数据库:
mysql>
use cacti;
Database changed
#
查看当前连接的数据库:
mysql>
select database();
+------------+
| database() |
+------------+
| cacti
|
+------------+
1 row in set (0.00 sec)
# REPAIR TABLE
修复数据表
mysql>
REPAIR TABLE poller_item;
+-------------------+--------+----------+----------+
| Table
| Op | Msg_type | Msg_text |
+-------------------+--------+----------+----------+
| cacti.poller_item | repair | status
| OK |
+-------------------+--------+----------+----------+
1 row in set (0.02 sec)
mysql>
修复成功。
如果修复失败,可以尝试用USE_FRM选项,例:
mysql>
REPAIR TABLE poller_itemUSE_FRM;
其它参考:
http://wenku.baidu.com/view/8e784829647d27284b7351f7.html
http://blog.sina.com.cn/s/blog_4522f0b80100ew8i.html
信息技术交流中心 学习-交流-分享 共同提高自我