[SOLVED] Can't clear poller cache

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Moderators, Developers

Post Reply
Author
Message
lester
Posts: 9
Joined: Sat Dec 06, 2008 9:27 am

[SOLVED] Can't clear poller cache

#1 Post by lester » Wed May 13, 2009 5:25 am

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 ?
Last edited by lester on Wed May 13, 2009 7:14 am, edited 1 time in total.

lester
Posts: 9
Joined: Sat Dec 06, 2008 9:27 am

#2 Post by lester » Wed May 13, 2009 7:13 am

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 :)

++

User avatar
BSOD2600
Cacti Moderator
Posts: 12160
Joined: Sat May 08, 2004 12:44 pm
Location: USA

#3 Post by BSOD2600 » Wed May 13, 2009 1:33 pm

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

Post Reply