Cacti 硬盤(pán)空間滿(mǎn),無(wú)法運(yùn)行解決方法

昨天CactiEZ服務(wù)器突然無(wú)法正常運(yùn)行了，系統(tǒng)提示磁盤(pán)空間已滿(mǎn),MySQL服務(wù)不能啟動(dòng)。經(jīng)檢查發(fā)現(xiàn)虛擬機(jī)只分配了8G的空間容量，而Cacti每天會(huì)自動(dòng)備份/var/www/html,因此空間很快被占滿(mǎn)了。手動(dòng)清除備份文件后，系統(tǒng)運(yùn)行正常，但是Cacti無(wú)法抓取信息了，圖片一直沒(méi)有數(shù)據(jù)更新。查看Cactilog發(fā)現(xiàn)很錯(cuò)類(lèi)似的錯(cuò)誤提示：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"登入系統(tǒng)，在MySQL下執(zhí)行上述語(yǔ)句[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這個(gè)文件有問(wèn)題，我們需要修復(fù)一下。[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服務(wù)就可以啦。[root@localhost~]#servicemysqldrestartStoppingMySQL: [OK]StartingMySQL: [OK]Cacti不出圖修復(fù)1、CACTI不畫(huà)圖類(lèi)似報(bào)錯(cuò)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