王学昌的笔记

        其实这个问题从11号这个神棍节就开始了。在11号的时候，直接重建采集器缓存就可以解决问题。完了这两天一直用这个方法也解决不了。查看日志，内容如下（意思是数据库坏了）：

2011年11月13日 11:05:23 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) LIMIT 10000"
11/13/2011 11:05:23 AM - SPINE: Poller[0] ERROR: SQL Failed! Error:'145', Message:'Table './cacti/poller_output' is marked as crashed and should be repaired', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (1646,'traffic_in','2011-11-13 11:05:22','5169176117'),(1646,'traffic_out','2011-11-13 11:05:22','9272209792'),(1647,'traffic_in','2011-11-13 11:05:22','9830550327'),(1647,'traffic_out','2011-11-13 11:05:22','13163317155'),(1648,'traffic_in','2011-11-13 11:05:22','5458535276'),(1648,'traffic_out','2011-11-13 11:05:22','7427309822'),(1649,'traffic_in','2011-11-13 11:05:22','3645202739'),(1649,'traffic_out','2011-11-13 11:05:22','6722996761'),(1650,'traffic_in','2011-11-13 11:05:22','9054301854'),(1650,'traffic_out','2011-11-13 11:05:22','12663499894'),(1651,'traffic_in','2011-11-13 11:05:22','0'),(1651,'traffic_out','2011-11-13 11:05:22','0'),(1652,'traffic_in','2011-11-13 11:05:22','256798948'),(1652,'traffic_out','2011-11-13 11:05:22','364356130'),(1653,'traffic_in','2011-11-13 11:05:22','2424811904'),(1653,'traffic_out','2011-11-13 11:05:22','3497951906'),(1654,'traffic_in','2011-11-13 11:05:22','0'),(1654,'traffic_out','2011-11-13 11'
2011年11月13日 11:05:22 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) LIMIT 10000"
11/13/2011 11:05:22 AM - SPINE: Poller[0] ERROR: SQL Failed! Error:'145', Message:'Table './cacti/poller_output' is marked as crashed and should be repaired', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (1621,'traffic_in','2011-11-13 11:05:22','7533214862'),(1621,'traffic_out','2011-11-13 11:05:22','5373963137'),(1622,'traffic_in','2011-11-13 11:05:22','1243697759'),(1622,'traffic_out','2011-11-13 11:05:22','1675633988'),(1623,'traffic_in','2011-11-13 11:05:22','4142367916'),(1623,'traffic_out','2011-11-13 11:05:22','3146613599'),(1624,'traffic_in','2011-11-13 11:05:22','2174897994'),(1624,'traffic_out','2011-11-13 11:05:22','4424584366'),(1625,'traffic_in','2011-11-13 11:05:22','1432625187'),(1625,'traffic_out','2011-11-13 11:05:22','3113602046'),(1626,'traffic_in','2011-11-13 11:05:22','9530585192'),(1626,'traffic_out','2011-11-13 11:05:22','11752058658'),(1627,'traffic_in','2011-11-13 11:05:22','3341979335'),(1627,'traffic_out','2011-11-13 11:05:22','5228639412'),(1628,'traffic_in','2011-11-13 11:05:22','3238587793'),(1628,'traffic_out','2011-11-13 11:05:22','4789426727'),(1629,'traffic_in','2011-11-13 11:05:22','5569253908'),(1629,'
11/13/2011 11:05:22 AM - SPINE: Poller[0] ERROR: SQL Failed! Error:'145', Message:'Table './cacti/poller_output' is marked as crashed and should be repaired', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (8926,'traffic_out','2011-11-13 11:05:21','0'),(8926,'traffic_in','2011-11-13 11:05:21','0'),(8927,'traffic_in','2011-11-13 11:05:21','0'),(8927,'traffic_out','2011-11-13 11:05:21','0'),(8928,'traffic_out','2011-11-13 11:05:21','715393753'),(8928,'traffic_in','2011-11-13 11:05:21','686957058'),(8929,'traffic_out','2011-11-13 11:05:21','5564434133'),(8929,'traffic_in','2011-11-13 11:05:21','3826662023'),(8930,'traffic_out','2011-11-13 11:05:21','8901386847'),(8930,'traffic_in','2011-11-13 11:05:21','6701335993'),(8931,'traffic_out','2011-11-13 11:05:21','5721355881'),(8931,'traffic_in','2011-11-13 11:05:21','7482918422'),(8932,'traffic_out','2011-11-13 11:05:21','10438129244'),(8932,'traffic_in','2011-11-13 11:05:21','7223723806'),(8933,'traffic_out','2011-11-13 11:05:21','5807971383'),(8933,'traffic_in','2011-11-13 11:05:21','8749420548'),(8934,'traffic_out','2011-11-13 11:05:21','5359298212'),(8934,'traffic_in','2011-11-13 11:05:21','3'

        看了下$cactipath/cli底下有个文件，repair_database.php。ok，修复它。解决问题。

        当然，在这之前

mysqlcheck --auto-repair --databases cacti

这个也用过。也有用

snmpwalk -c community -v 2c hostip if

查看过是不是其他问题。

        除了以上的数据库修复外，可以尝试另一条命令。当然，这个我没有试，因为没用上这两个就好了。
       

mysqlcheck --repair cacti