Re-run failed queries from log file

[bntlinux]

Hello,

I have had an issue with the mysql database (problem with the poller_output table) that cost me 3 days worth of data on Cacti
I have found that all queries are in the var/log/cacti/cacti.log file and have been able to extract them

My question is what is the impact of running these queries in mysql knowing that the polling is working again and data, newer than the one in the logs, is now displayed in the charts

An example query that failed:

Code: Select all

insert into poller_output (local_data_id, rrd_name, time, output);values (387, 'traffic_in', '2014-06-10 12:15:04', '0');

Thanks in advance for your help,

Regards,

[Linegod]

It is not going to work.

RRDTool will not let you insert old data directly.

[Linegod]

For further info see: http://marc.info/?l=rrd-users&m=124533200009126

[bntlinux]

Ok Thanks for the reply