Cacti 硬盘空间满,无法运行解决方法

昨天CactiEZ服务器突然无法正常运行了，系统提示磁盘空间已满,MySQL服务不能启动。经检查发现虚拟机只分配了8G的空间容量，而Cacti每天会自动备份/var/www/html,因此空间很快被占满了。手动清除备份文件后，系统运行正常，但是Cacti无法抓取信息了，图片一直没有数据更新。查看Cactilog发现很错类似的错误提示：04/02/201001:17:56PM-CMDPHP:Poller[0]ERROR:SQLAssocFailed!,Error:'2006',SQL:"selectpoller_id,end_timefrompoller_timewherepoller_id=0"04/02/201001:17:55PM-CMDPHP:Poller[0]ERROR:SQLAssocFailed!,Error:'2006',SQL:"selectpoller_output.output,poller_output.time,poller_output.local_data_id,poller_item.rrd_path,poller_item.rrd_name,poller_item.rrd_numfrom(poller_output,poller_item)where(poller_output.local_data_id=poller_item.local_data_idandpoller_output.rrd_name=poller_item.rrd_name)LIMIT10000"登入系统，在MySQL下执行上述语句[root@localhost~]#mysql-urootWelcometotheMySQLmonitor.Commandsendwith;or\g.YourMySQLconnectionidis1220Serverversion:5.0.68SourcedistributionType'help;'or'\h'forhelp.Type'\c'toclearthebuffer.mysql>usecactiReadingtableinformationforcompletionoftableandcolumnnamesYoucanturnoffthisfeaturetogetaquickerstartupwith-ADatabasechangedmysql>selectpoller_output.output,poller_output.time,poller_output.local_data_id,poller_item.rrd_path,poller_item.rrd_name,poller_item.rrd_numfrom(poller_output,poller_item)where(poller_output.local_data_id=poller_item.local_data_idandpoller_output.rrd_name=poller_item.rrd_name);ERROR145(HY000):Table'./cacti/poller_output'ismarkedascrashedandshouldberepairedmysql>exitBye可以看到是/var/lib/mysql/cacti/poller_output这个文件有问题，我们需要修复一下。[root@localhost~]#myisamchk--safe-recover--force/var/lib/mysql/cacti/poller_outputWarning:option'key_buffer_size':unsignedvalue18446744073709551615adjustedto4294963200Warning:option'read_buffer_size':unsignedvalue18446744073709551615adjustedto4294967295Warning:option'write_buffer_size':unsignedvalue18446744073709551615adjustedto4294967295Warning:option'sort_buffer_size':unsignedvalue18446744073709551615adjustedto4294967295-recovering(withkeycache)MylSAM-table7var/lib/mysql/cacti/poller_output'Datarecords:81之后重启MySQL服务就可以啦。[root@localhost~]#servicemysqldrestartStoppingMySQL: [OK]StartingMySQL: [OK]Cacti不出图修复1、CACTI不画图类似报错Poller[0]ERROR:SQLAssocFailed!,Error:'1017'Ifyoucannotfixtheerrorwithpoller_outputtablenotshow:Justrunmysql,usedatabase"cacti"and+mySQL>selectcount(*)frompoller_output;Iftoomuchdata,runquery:+mysql>truncatetablepoller_output;Anditworkedformyissue.Goodluck,ManhDung具体命令[root@70yx_lan_monitor~]#mysqlWelcometotheMySQLmonitor.Commandsendwith;or\g.YourMySQLconnectionidis97Serverversion:5.1.52SourcedistributionCopyright(c)2000,2010,Oracleand/oritsaffiliates.Allrightsreserved.ThissoftwarecomeswithABSOLUTELYNOWARRANTY.Thisisfreesoftware,andyouarewelcometomodifyandredistributeitundertheGPLv2licenseType'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.mysql>use"cacti"ReadingtableinformationforcompletionoftableandcolumnnamesYoucanturnoffthisfeaturetogetaquickerstartupwith-ADatabasechangedmysql>selectcount(*)frompoller_output;ERROR145(HY000):Table'・/cacti/poller_output'ismarkedascrashedandshouldberepairedmysql>truncatetablepoller_output;QueryOK,0rowsaffected(0.02sec)mysql>selectcount(*)fro