Problems with RRD-Clean - Post Here

[Howie]

RRDclean UI still shows up when the plugin is not enabled in Plugin Management.

I just spent a chunk of time trying to figure out why files weren't being archived, and nothing was appearing in the log. It turns out that the RRDClean UI will all show up, and apparently run, even when the plugin is disabled!

This is PIA2.4 or an older release?
Reinhard

It's all in my sig, but Cacti 0.8.7d and PIA 2.4 (it can't be any other version with 'd', can it?)

[jrwagz]

I have just installed RRD Clean v0.38 on my cacti v0.8.7e and when I search my rrd files it only returns a maximum of 600 files, when I know that there are well over 2000 RRDs being processed, let alone the old ones I want to clean out!

Is this a known limitation? Is there anyway I can increase it?

[gandalf]

RRDClean will search only for spare files. So in general, it will not return as many files as you have in your system.
R.

[jrwagz]

So does that mean any file that is found by the RRD Cleaner is not currently being updated by the poller?

[jbarbieri]

I just installed rrdclean, as I have somewhere along the lines of 3000 unused rrds.

When I scan, it comes back with 3,291 records. However, when sorted by date, I can see that 125 RRDs were marked as not in use, yet the last access time was within the past 5 minutes:

Last Accessed time: 2010-08-27 20:30:19
Last Scan: 2010-08-27 20:34:10

Other then that, this plugin seems like it will help me out.

Cacti Version 0.8.7e
PIA 2.5
rrdclean 0.40

[gandalf]

Is there anything special with those? Are those "externally updated"?
R.

[jbarbieri]

No, nothing special about them. The permissions are the same as all the other RRDs as well, and they are not externally updated.

[gandalf]

I've got no idea. To examine, I need a db dump of your database and a list of files that are erraneously flagged as "obsolete"
R.

[semakka]

Same problem here, rrdclean 0.41, PIA 3.0, cati&spine 0.8.7h. I know I have 5 rrds more:)
I have rrdclean 1.1 , PIA 2.5, cacti&spine 0,8,7e just peachy on an old system which I want to upgrade.



Technical Support
General Information
Date Sun, 27 Nov 2011 14:30:41 +0100
Cacti Version 0.8.7h
Cacti OS unix
SNMP Version NET-SNMP version: 5.4.2.1
RRDTool Version RRDTool 1.3.x
Hosts 3
Graphs 28
Data Sources Script/Command: 7
SNMP: 13
SNMP Query: 14
Total: 34
Poller Information
Interval 60
Type SPINE 0.8.7h Copyright 2002-2011 by The Cacti Group
Items Action[0]: 45
Action[1]: 7
Total: 52
Concurrent Processes 1
Max Threads 1
PHP Servers 1
Script Timeout 25
Max OID 10
Last Run Statistics Time:11.3532 Method:spine Processes:1 Threads:1 Hosts:5 HostsPerProcess:5 DataSources:57 RRDsProcessed:29
PHP Information
PHP Version 5.3.2-1ubuntu4.10
PHP OS Linux
PHP uname Linux testvm 2.6.32-35-generic #78-Ubuntu SMP Tue Oct 11 16:11:24 UTC 2011 x86_64
PHP SNMP Installed
max_execution_time 30
memory_limit 128M
MySQL Table Information
Name Rows Engine Collation
cdef 25 MyISAM latin1_swedish_ci
cdef_items 41 MyISAM latin1_swedish_ci
colors 106 MyISAM latin1_swedish_ci
data_input 13 MyISAM latin1_swedish_ci
data_input_data 747 MyISAM latin1_swedish_ci
data_input_fields 53 MyISAM latin1_swedish_ci
data_local 34 MyISAM latin1_swedish_ci
data_template 65 MyISAM latin1_swedish_ci
data_template_data 99 MyISAM latin1_swedish_ci
data_template_data_rra 503 MyISAM latin1_swedish_ci
data_template_rrd 147 MyISAM latin1_swedish_ci
graph_local 28 MyISAM latin1_swedish_ci
graph_template_input 108 MyISAM latin1_swedish_ci
graph_template_input_defs 435 MyISAM latin1_swedish_ci
graph_templates 52 MyISAM latin1_swedish_ci
graph_templates_gprint 5 MyISAM latin1_swedish_ci
graph_templates_graph 80 MyISAM latin1_swedish_ci
graph_templates_item 775 MyISAM latin1_swedish_ci
graph_tree 1 MyISAM latin1_swedish_ci
graph_tree_items 3 MyISAM latin1_swedish_ci
host 3 MyISAM latin1_swedish_ci
host_graph 14 MyISAM latin1_swedish_ci
host_snmp_cache 115 MyISAM latin1_swedish_ci
host_snmp_query 5 MyISAM latin1_swedish_ci
host_template 10 MyISAM latin1_swedish_ci
host_template_graph 32 MyISAM latin1_swedish_ci
host_template_snmp_query 19 MyISAM latin1_swedish_ci
plugin_aggregate_color_template_items 44 MyISAM latin1_swedish_ci
plugin_aggregate_color_templates 4 MyISAM latin1_swedish_ci
plugin_config 14 MyISAM latin1_swedish_ci
plugin_db_changes 18 MyISAM latin1_swedish_ci
plugin_discover_hosts 203 MyISAM latin1_swedish_ci
plugin_discover_template 0 MyISAM latin1_swedish_ci
plugin_hooks 87 MyISAM latin1_swedish_ci
plugin_mikrotik_processes 0 MEMORY latin1_swedish_ci
plugin_mikrotik_processor 0 MyISAM latin1_swedish_ci
plugin_mikrotik_storage 0 MyISAM latin1_swedish_ci
plugin_mikrotik_system 0 MyISAM latin1_swedish_ci
plugin_mikrotik_trees 0 MyISAM latin1_swedish_ci
plugin_mikrotik_users 0 MyISAM latin1_swedish_ci
plugin_realms 13 MyISAM latin1_swedish_ci
poller 0 MyISAM latin1_swedish_ci
poller_command 0 MyISAM latin1_swedish_ci
poller_item 52 MyISAM latin1_swedish_ci
poller_output 0 MyISAM latin1_swedish_ci
poller_output_boost 0 MEMORY latin1_swedish_ci
poller_output_boost_processes 0 MEMORY latin1_swedish_ci
poller_reindex 4 MyISAM latin1_swedish_ci
poller_time 1 MyISAM latin1_swedish_ci
rra 5 MyISAM latin1_swedish_ci
rra_cf 10 MyISAM latin1_swedish_ci
settings 148 MyISAM latin1_swedish_ci
settings_graphs 35 MyISAM latin1_swedish_ci
settings_tree 0 MyISAM latin1_swedish_ci
snmp_query 10 MyISAM latin1_swedish_ci
snmp_query_graph 27 MyISAM latin1_swedish_ci
snmp_query_graph_rrd 49 MyISAM latin1_swedish_ci
snmp_query_graph_rrd_sv 67 MyISAM latin1_swedish_ci
snmp_query_graph_sv 48 MyISAM latin1_swedish_ci
superlinks_auth 1 MyISAM latin1_swedish_ci
superlinks_pages 1 MyISAM latin1_swedish_ci
user_auth 2 MyISAM latin1_swedish_ci
user_auth_perms 0 MyISAM latin1_swedish_ci
user_auth_realm 34 MyISAM latin1_swedish_ci
user_log 9 MyISAM latin1_swedish_ci
version 1 MyISAM latin1_swedish_ci





11/27/2011 02:29:04 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,100"
11/27/2011 02:29:04 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 '%%%%')"
11/27/2011 02:29:04 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 '%%%%')"

[gandalf]

This error is thrown when there's no such table present.
Please do a "rescan" and retry. Do those errors still persist?
R.

[semakka]

yes, every time I scan I have the errors.

[gandalf]

Please deactivate and reactivate plugin and retry.
I tried to reproduce on 087i+PIA, but no error shows up
R.

[KevinNoall]

I am trying to use RRDClean for the first time, and when running a delete, nothing happens. The screen appears to show that it worked, but when i 'rescan' the number jumps back up to what it was.

Otherwise cacti is running great. rrd clean v 0.41Any thoughts?

[browniebraun]

I am trying to use RRDClean for the first time, and when running a delete, nothing happens. The screen appears to show that it worked, but when i 'rescan' the number jumps back up to what it was.

Otherwise cacti is running great. rrd clean v 0.41Any thoughts?

RRDCleaner puts all selected files into a queue which will be processed with the next poller run. This is necessary due to security issues.
(An Apache user should not have write permissions to application files). A click on "rescan" will drop the queue.

Regards
-Andi

[KevinNoall]

RRDCleaner puts all selected files into a queue which will be processed with the next poller run. This is necessary due to security issues.
(An Apache user should not have write permissions to application files). A click on "rescan" will drop the queue.

Sure enough! Sorry for the bonehead question. That could use a note on the page or something!

Thanks
Kevin