[SOLVED] Can't clear poller cache

[lester]

Hi,

Yesterday i have a problem with disk full (
since cacti doesn't graph.
when i click view poller cache i see 6254 row
and when i click clear poller cache, the poller are not clear

Do you have an idea ?

[lester]

Ok i have found problem and solution.
Pb is : poller seem doesn't work
but the in the Db Mysql the table poller_output have problem
when i try to repair the table on sql :

Code: Select all

REPAIR TABLE poller_output
Can't find file: 'poller_output' (errno: 2)

i make :

Code: Select all

DROP TABLE IF EXISTS `poller_output`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `poller_output` (
  `local_data_id` mediumint(8) unsigned NOT NULL default '0',
  `rrd_name` varchar(19) NOT NULL default '',
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `output` text NOT NULL,
  PRIMARY KEY  (`local_data_id`,`rrd_name`,`time`)
) TYPE=MyISAM;
SET character_set_client = @saved_cs_client;
LOCK TABLES `poller_output` WRITE;
/*!40000 ALTER TABLE `poller_output` DISABLE KEYS */;
/*!40000 ALTER TABLE `poller_output` ENABLE KEYS */;
UNLOCK TABLES;

and now the poller work fine

++

[BSOD2600]

Try using \cacti\cli\repair_database.php next time.