Cacti

Bug reported: http://bugs.cacti.net/view.php?id=2484

My problem is that i have more than 2 000 000 records in data_input_data table. And i want to delete waste data. But i need confirmation is my solution correct. How to reproduce PROBLEM 1. Delete all graphs and data sources form cacti 2. check if no data SELECT COUNT(id) FROM cacti.data_template_dat...

Cacti version: 0.8.8c

Revision 7551

In the cli script there is a code to cleanup data_input_data table: /* remove invalid Data Input Data Rows from the Database in two passes */ $rows = db_fetch_cell("SELECT count(*) FROM data_input_data LEFT JOIN data_template_data ON data_template_data.data_input_id=data_input_data.data_templat...

The problem is solved.

Table Engine was changed back to MyISAM in MySQL.

May be it will more clear if i post some configuratons. First of all, when we used 0.8.7e MySQL engine was MyISAM, after upgragde i converted all tables to InnoDB. In update process there were error updating table 'data_template_rrd' table, so i changed 'cacti-0.8.7i-PIA-3.1/install/0_8_7g_to_0_8_7h...

Hi, sorry for my english.

We are using cacti to collect data from 1530 devices (83732 ds, 50792 graphs). It was version 0.8.7e. We updated it to 0.8.7i and after that on every graph there are holes. What data i must provide for the next step.

Poller starts every 1 minute.

As example one attachment.