rrdcleaner don't see my RRA file (error in cacti log)

General discussion about Plugins for Cacti

Moderators: Developers, Moderators

Post Reply
Rno
Cacti Pro User
Posts: 709
Joined: Wed Dec 07, 2011 9:19 am

rrdcleaner don't see my RRA file (error in cacti log)

Post by Rno »

Hello,
I just install rrdcleaner, but in my case it won't find any old rra file.
Under RRD Cleaner thit told me there is no unused RRD files, but If I look into my derctory I have file a month older or even more.

I think it's because the rra directory is a link to /var/lib/cacti/rra (from /usr/share/cacti/rra)
Don't ask why I get this server like that !

So I can I tell rrdcleaner to follow the link ?

Or if that's not the case what is the problem ?

Oups: many error in the cacti log file:
08/05/2016 04:33:08 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT plugin_rrdclean_action.id, plugin_rrdclean_action.name, plugin_rrdclean_action.local_data_id, plugin_rrdclean_action.action FROM plugin_rrdclean_action"
.
.
.
08/05/2016 04:29:10 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT plugin_rrdclean.id, plugin_rrdclean.name, plugin_rrdclean.last_mod, plugin_rrdclean.size, plugin_rrdclean.name_cache, plugin_rrdclean.local_data_id, plugin_rrdclean.data_template_id, plugin_rrdclean.data_template_name FROM (plugin_rrdclean) WHERE (plugin_rrdclean.name like '%%%%') OR (plugin_rrdclean.name_cache like '%%%%') OR (plugin_rrdclean.data_template_name like '%%%%') ORDER BY name ASC LIMIT 0,30"
08/05/2016 04:29:10 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT ROUND(SUM(plugin_rrdclean.size),2) FROM plugin_rrdclean WHERE (plugin_rrdclean.name like '%%%%') OR (plugin_rrdclean.name_cache like '%%%%') OR (plugin_rrdclean.data_template_name like '%%%%')"
08/05/2016 04:29:10 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(plugin_rrdclean.name) FROM plugin_rrdclean WHERE (plugin_rrdclean.name like '%%%%') OR (plugin_rrdclean.name_cache like '%%%%') OR (plugin_rrdclean.data_template_name like '%%%%')"
08/05/2016 04:29:08 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT plugin_rrdclean_action.id, plugin_rrdclean_action.name, plugin_rrdclean_action.local_data_id, plugin_rrdclean_action.action FROM plugin_rrdclean_action"
Test
Almalinux
php 8.2.14
mariadb 10.6.16
Cacti 1.2.27
Spine 1.2.27
RRD 1.7.2
thold 1.8
monitor 2.5
syslog 3.2
flowview: 3.3
weathermap 1.0 Beta
Rno
Cacti Pro User
Posts: 709
Joined: Wed Dec 07, 2011 9:19 am

Re: rrdcleaner don't see my RRA file (error in cacti log)

Post by Rno »

Test
Almalinux
php 8.2.14
mariadb 10.6.16
Cacti 1.2.27
Spine 1.2.27
RRD 1.7.2
thold 1.8
monitor 2.5
syslog 3.2
flowview: 3.3
weathermap 1.0 Beta
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest