Problems with RRD-Clean - Post Here

tonyperez · Post by **tonyperez** » Wed Feb 25, 2009 12:31 pm

I have this errors after installing rrdclen V0.38 on a clean installation:

02/25/2009 11:20:05 AM - 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"

02/25/2009 11:12:37 AM - 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"
02/25/2009 11:12:37 AM - 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 '%%%%')"
02/25/2009 11:12:37 AM - 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 '%%%%')"

PIA 2.4

General Information
Date Wed, 25 Feb 2009 11:26:48 -0600
Cacti Version 0.8.7d
Cacti OS unix
SNMP Version NET-SNMP version: 5.4.1
RRDTool Version RRDTool 1.2.x
Hosts 1
Graphs 5
Data Sources Script/Command: 5
Script Query: 1
Total: 6

Poller Information
Interval 300
Type cmd.php
Items Action[1]: 7
Total: 7
Concurrent Processes 1
Max Threads 1
PHP Servers 1
Script Timeout 25
Max OID 10
Last Run Statistics Time:2.3952 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:7 RRDsProcessed:6

PHP Information
PHP Version 5.2.6-2ubuntu4.1
PHP OS Linux
PHP uname Linux mercurio 2.6.27-7-server #1 SMP Tue Nov 4 20:18:35 UTC 2008 i686
PHP SNMP Installed
max_execution_time 30
memory_limit 128M

Post by **TheWitness** » Wed Feb 25, 2009 1:01 pm

1146 is crashed table. Execute the repair table command.

TheWitness

tonyperez · Post by **tonyperez** » Wed Feb 25, 2009 1:40 pm

Thanks for your reply.

I have to apply repair command from MySQL front end ??? or there is a way to do it from cacti ???

tonyperez · Post by **tonyperez** » Wed Feb 25, 2009 1:54 pm

tonyperez wrote:Thanks for your reply.

I have to apply repair command from MySQL front end ??? or there is a way to do it from cacti ???

I allready apply the fix table command from MySQL front end and have the same error. I think that for some reazon the plugin did not install the tables for rrdclean after installed.

Name Rows Engine Collation Check Status
cdef 6 MyISAM latin1_swedish_ci OK
cdef_items 16 MyISAM latin1_swedish_ci OK
colors 103 MyISAM latin1_swedish_ci OK
data_input 15 MyISAM latin1_swedish_ci OK
data_input_data 2764 MyISAM latin1_swedish_ci OK
data_input_fields 66 MyISAM latin1_swedish_ci OK
data_local 196 MyISAM latin1_swedish_ci OK
data_template 71 MyISAM latin1_swedish_ci OK
data_template_data 267 MyISAM latin1_swedish_ci OK
data_template_data_rra 1357 MyISAM latin1_swedish_ci OK
data_template_rrd 566 MyISAM latin1_swedish_ci OK
graph_local 183 MyISAM latin1_swedish_ci OK
graph_template_input 123 MyISAM latin1_swedish_ci OK
graph_template_input_defs 467 MyISAM latin1_swedish_ci OK
graph_templates 57 MyISAM latin1_swedish_ci OK
graph_templates_gprint 3 MyISAM latin1_swedish_ci OK
graph_templates_graph 240 MyISAM latin1_swedish_ci OK
graph_templates_item 2742 MyISAM latin1_swedish_ci OK
graph_tree 1 MyISAM latin1_swedish_ci OK
graph_tree_items 31 MyISAM latin1_swedish_ci OK
host 18 MyISAM latin1_swedish_ci OK
host_graph 33 MyISAM latin1_swedish_ci OK
host_snmp_cache 688 MyISAM latin1_swedish_ci OK
host_snmp_query 29 MyISAM latin1_swedish_ci OK
host_template 10 MyISAM latin1_swedish_ci OK
host_template_graph 23 MyISAM latin1_swedish_ci OK
host_template_snmp_query 19 MyISAM latin1_swedish_ci OK
plugin_config 2 MyISAM latin1_swedish_ci OK
plugin_db_changes 22 MyISAM latin1_swedish_ci OK
plugin_hooks 30 MyISAM latin1_swedish_ci OK
plugin_realms 5 MyISAM latin1_swedish_ci OK
plugin_thold_contacts 1 MyISAM latin1_swedish_ci OK
plugin_thold_log 0 MyISAM latin1_swedish_ci OK
plugin_thold_template_contact 0 MyISAM latin1_swedish_ci OK
plugin_thold_threshold_contact 0 MyISAM latin1_swedish_ci OK
plugin_update_info 7 MyISAM latin1_swedish_ci OK
poller 0 MyISAM latin1_swedish_ci OK
poller_command 0 MyISAM latin1_swedish_ci OK
poller_item 464 MyISAM latin1_swedish_ci OK
poller_output 0 MyISAM latin1_swedish_ci OK
poller_reindex 23 MyISAM latin1_swedish_ci OK
poller_time 1 MyISAM latin1_swedish_ci OK
rra 5 MyISAM latin1_swedish_ci OK
rra_cf 10 MyISAM latin1_swedish_ci OK
settings 110 MyISAM latin1_swedish_ci OK
settings_graphs 245 MyISAM latin1_swedish_ci OK
settings_tree 0 MyISAM latin1_swedish_ci OK
snmp_query 12 MyISAM latin1_swedish_ci OK
snmp_query_graph 32 MyISAM latin1_swedish_ci OK
snmp_query_graph_rrd 61 MyISAM latin1_swedish_ci OK
snmp_query_graph_rrd_sv 69 MyISAM latin1_swedish_ci OK
snmp_query_graph_sv 48 MyISAM latin1_swedish_ci OK
thold_data 0 MyISAM latin1_swedish_ci OK
thold_template 0 MyISAM latin1_swedish_ci OK
user_auth 8 MyISAM latin1_swedish_ci OK
user_auth_perms 1 MyISAM latin1_swedish_ci OK
user_auth_realm 130 MyISAM latin1_swedish_ci OK
user_log 177 MyISAM latin1_swedish_ci OK
version 1 MyISAM latin1_swedish_ci OK

Post by **TheWitness** » Wed Feb 25, 2009 3:38 pm

Looks like an issue with pia as you don't have the tables. Please provide details on you system. Is the pi enabled and active?

tonyperez · Post by **tonyperez** » Wed Feb 25, 2009 5:34 pm

Yes the PA is enable and active. I observe that when i downgrade to version 0.36 some tables was added successfully. Then, i upgrade it to version 0.38, and the error on the log seems to be corrected, but, i don`t have any data on the rrdclean screen and the last scan freezes at 2009-02-25 13:15:50. I attach some images and system details.

System Info:

Cacti 0.8.7d
PA 2.4
ubuntu Server 8.10
MySQL Server version: 5.0.67-0ubuntu6 (Ubuntu)
NET-SNMP version: 5.4.1
PHP 5.2.6-2ubuntu4.1 with Suhosin-Patch 0.9.6.2 (cli) (built: Feb 11 2009 20:38:24)
RRDTool 1.2.27
Plugins: thold 0.4, settings 0.5, loginmod 1.0, rrdclean 0.38

Tables:

Name Rows Engine Collation Check Status
cdef 23 MyISAM latin1_swedish_ci OK
cdef_items 33 MyISAM latin1_swedish_ci OK
colors 106 MyISAM latin1_swedish_ci OK
data_input 13 MyISAM latin1_swedish_ci OK
data_input_data 183 MyISAM latin1_swedish_ci OK
data_input_fields 55 MyISAM latin1_swedish_ci OK
data_local 1 MyISAM latin1_swedish_ci OK
data_template 42 MyISAM latin1_swedish_ci OK
data_template_data 43 MyISAM latin1_swedish_ci OK
data_template_data_rra 174 MyISAM latin1_swedish_ci OK
data_template_rrd 65 MyISAM latin1_swedish_ci OK
graph_local 1 MyISAM latin1_swedish_ci OK
graph_template_input 82 MyISAM latin1_swedish_ci OK
graph_template_input_defs 270 MyISAM latin1_swedish_ci OK
graph_templates 34 MyISAM latin1_swedish_ci OK
graph_templates_gprint 5 MyISAM latin1_swedish_ci OK
graph_templates_graph 35 MyISAM latin1_swedish_ci OK
graph_templates_item 329 MyISAM latin1_swedish_ci OK
graph_tree 1 MyISAM latin1_swedish_ci OK
graph_tree_items 1 MyISAM latin1_swedish_ci OK
host 1 MyISAM latin1_swedish_ci OK
host_graph 4 MyISAM latin1_swedish_ci OK
host_snmp_cache 2 MyISAM latin1_swedish_ci OK
host_snmp_query 1 MyISAM latin1_swedish_ci OK
host_template 7 MyISAM latin1_swedish_ci OK
host_template_graph 14 MyISAM latin1_swedish_ci OK
host_template_snmp_query 13 MyISAM latin1_swedish_ci OK
plugin_config 2 MyISAM latin1_swedish_ci OK
plugin_db_changes 22 MyISAM latin1_swedish_ci OK
plugin_hooks 30 MyISAM latin1_swedish_ci OK
plugin_realms 5 MyISAM latin1_swedish_ci OK
plugin_rrdclean 0 MyISAM latin1_swedish_ci OK
plugin_rrdclean_action 0 MyISAM latin1_swedish_ci OK
plugin_thold_contacts 1 MyISAM latin1_swedish_ci OK
plugin_thold_log 0 MyISAM latin1_swedish_ci OK
plugin_thold_template_contact 0 MyISAM latin1_swedish_ci OK
plugin_thold_threshold_contact 0 MyISAM latin1_swedish_ci OK
poller 0 MyISAM latin1_swedish_ci OK
poller_command 0 MyISAM latin1_swedish_ci OK
poller_item 1 MyISAM latin1_swedish_ci OK
poller_output 0 MyISAM latin1_swedish_ci OK
poller_reindex 0 MyISAM latin1_swedish_ci OK
poller_time 2 MyISAM latin1_swedish_ci OK
rra 5 MyISAM latin1_swedish_ci OK
rra_cf 10 MyISAM latin1_swedish_ci OK
settings 59 MyISAM latin1_swedish_ci OK
settings_graphs 35 MyISAM latin1_swedish_ci OK
settings_tree 0 MyISAM latin1_swedish_ci OK
snmp_query 8 MyISAM latin1_swedish_ci OK
snmp_query_graph 19 MyISAM latin1_swedish_ci OK
snmp_query_graph_rrd 39 MyISAM latin1_swedish_ci OK
snmp_query_graph_rrd_sv 59 MyISAM latin1_swedish_ci OK
snmp_query_graph_sv 40 MyISAM latin1_swedish_ci OK
thold_data 0 MyISAM latin1_swedish_ci OK
thold_template 0 MyISAM latin1_swedish_ci OK
user_auth 2 MyISAM latin1_swedish_ci OK
user_auth_perms 0 MyISAM latin1_swedish_ci OK
user_auth_realm 22 MyISAM latin1_swedish_ci OK
user_log 18 MyISAM latin1_swedish_ci OK
version 1 MyISAM latin1_swedish_ci OK

Logs:

02/25/2009 04:30:05 PM - SYSTEM THOLD STATS: Time:0.01 Tholds:0 Hosts:
02/25/2009 04:30:05 PM - SYSTEM STATS: Time:2.3569 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:1 RRDsProcessed:1
02/25/2009 04:25:05 PM - SYSTEM THOLD STATS: Time:0.02 Tholds:0 Hosts:
02/25/2009 04:25:05 PM - SYSTEM STATS: Time:3.3796 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:1 RRDsProcessed:1
02/25/2009 04:21:06 PM - AUTH LOGIN: User 'admin' Authenticated
02/25/2009 04:20:05 PM - SYSTEM THOLD STATS: Time:0 Tholds:0 Hosts:
02/25/2009 04:20:05 PM - SYSTEM STATS: Time:3.3672 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:1 RRDsProcessed:1
02/25/2009 04:15:04 PM - SYSTEM THOLD STATS: Time:0 Tholds:0 Hosts:
02/25/2009 04:15:04 PM - SYSTEM STATS: Time:2.3497 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:1 RRDsProcessed:1
02/25/2009 04:10:04 PM - SYSTEM THOLD STATS: Time:0 Tholds:0 Hosts:
02/25/2009 04:10:04 PM - SYSTEM STATS: Time:2.3269 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:1 RRDsProcessed:1
02/25/2009 04:05:04 PM - SYSTEM THOLD STATS: Time:0 Tholds:0 Hosts:

Jacket · Post by **Jacket** » Fri Feb 27, 2009 12:51 am

Same problem here. It seems i don't have plugin_rrdclean table in my cacti db. I don't know if it's supposed to be created after plugin is ebabled, but in my case it isn't.
Can you give me the structure so i can create it?
Cacti is 0.8.7d
PA is 2.4

Post by **TheWitness** » Fri Feb 27, 2009 6:59 am

Make sure rrdclean is NOT in global.php

Jacket · Post by **Jacket** » Fri Feb 27, 2009 8:36 am

I'm sure it's not (but checked anyways and it isn't there

).
I know this plugin uses the new architecture, so i installed and enabled it from the "Plugin Management" interface.

Edit:

I've checked rrdcleaner.php and found your queries for table creation. I don't know what's the problem with autocreating them, but i ran them manually and now all seems fine

Here are the queries for anyone that might be interested:

Code: Select all

CREATE TABLE IF NOT EXISTS `plugin_rrdclean` (
				`id` 					mediumint(8) unsigned NOT NULL auto_increment,
				`name` 		varchar(255) NOT NULL default '',
				`last_mod` 	datetime NOT NULL default '0000-00-00 00:00:00',
				`size`		varchar(255) NOT NULL default '',
				`name_cache`			varchar(255) NOT NULL default '',
				`local_data_id`			mediumint(8) unsigned NOT NULL default '0',
				`data_template_id`		mediumint(8) unsigned NOT NULL default '0',
				`data_template_name`	varchar(150) NOT NULL default '',
				PRIMARY KEY  (`id`)
				) ENGINE=MyISAM COMMENT='RRD Cleaner File Repository'

Code: Select all

CREATE TABLE IF NOT EXISTS `plugin_rrdclean_action` (
				`id` 					mediumint(8) 	unsigned NOT NULL auto_increment,
				`name`		varchar(255) 	NOT NULL default '',
				`local_data_id`			mediumint(8) 	unsigned NOT NULL default '0',
				`action`	tinyint(2)		NOT NULL default 0,
				PRIMARY KEY  (`id`)
				) ENGINE=MyISAM COMMENT='RRD Cleaner File Actions'

It seems i really needed that plugin

See the image

Great plugin

Post by **gandalf** » Sat Mar 07, 2009 6:49 am

Did you receive any mysql errors in cacti.log, previously?
Reinhard

Jacket · Post by **Jacket** » Sat Mar 07, 2009 9:04 am

I have many... Why are you asking?

Here are some random lines:
From reportit plugin, but it's working perfectly:

Code: Select all

03/07/2009 12:02:42 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL:"REPLACE reportit_results_11 SET id = 158178, `traffic_in__67` = 10000000, `traffic_in__68` = 581.711754808, `traffic_in__69` = 627.58988608, `traffic_in__70` = 414.455570992, `traffic_in__71` = 0, `traffic_out__67` = 10000000, `traffic_out__68` = 1064.71737782, `traffic_out__69` = 3896.74666664, `traffic_out__70` = 879.93442432, `traffic_out__71` = 0, `ifspeed__67` = 10000000, `ifspeed__68` = 0, `ifspeed__69` = 0, `ifspeed__70` = 0, `ifspeed__71` = 0'
03/07/2009 12:02:42 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL:"REPLACE reportit_results_11 SET id = 158172, `traffic_in__67` = 1000000000, `traffic_in__68` = 0, `traffic_in__69` = 0, `traffic_in__70` = 0, `traffic_in__71` = 0, `ifspeed__67` = 1000000000, `ifspeed__68` = 0, `ifspeed__69` = 0, `ifspeed__70` = 0, `ifspeed__71` = 0, `traffic_out__67` = 1000000000, `traffic_out__68` = 0, `traffic_out__69` = 0, `traffic_out__70` = 0, `traffic_out__71` = 0'

Something from boost, but it's not verry common.

Code: Select all

03/05/2009 01:37:11 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SHOW TABLES LIKE '%boost%'"
03/05/2009 01:05:15 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SHOW TABLES LIKE '%boost%'"
03/05/2009 07:28:09 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SHOW TABLES LIKE '%boost%'"
03/05/2009 07:11:13 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SHOW TABLES LIKE '%boost%'"
03/05/2009 06:03:05 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SHOW TABLES LIKE '%boost%'"

This is from mactrack, same thing happend there - database wasn't created automatically, so i imported the sql file and then ran upgrade_database.php, and now it seems to be ok.

Code: Select all

03/06/2009 11:23:58 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM mac_track_device_types ORDER BY description ASC LIMIT 0,30"
03/06/2009 11:23:58 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT DISTINCT vendor from mac_track_device_types ORDER BY vendor"
03/06/2009 11:23:58 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"REPLACE INTO mac_track_scanning_functions (scanning_function, type) VALUES ('get_standard_arp_table', '2')'
03/06/2009 11:23:58 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"REPLACE INTO mac_track_scanning_functions (scanning_function, type) VALUES ('Not Applicable - Hub/Switch', '2')'

tonyperez · Post by **tonyperez** » Mon Mar 09, 2009 1:57 pm

Hello Gandalf ...

I think i found the solution to the errors generated by the rrdclean V0.38. I just add the rrdclean_fill_table function to default case on rrdcleaner.php code:

Before:

Code: Select all

default :
	include_once ($config["include_path"] . "/top_header.php");
	/* fill files name table */
	list_rrd();
	include_once ($config["include_path"] . "/bottom_footer.php");

	break;
}

After:

Code: Select all

default :
        include_once ($config["include_path"] . "/top_header.php");
        /* fill files name table */
        rrdclean_fill_table(); <----------- I add this line
        list_rrd();
        include_once ($config["include_path"] . "/bottom_footer.php");

        break;
}

It looks is working fine. I have tables now on the cacti DB and the rrd's list screen without errors on the cacti log:

Cacti Log:

03/09/2009 01:40:06 PM - SYSTEM THOLD STATS: Time:0.0035 Tholds:0 Hosts:0
03/09/2009 01:40:05 PM - SYSTEM STATS: Time:3.3255 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:3 RRDsProcessed:3
03/09/2009 01:35:04 PM - SYSTEM THOLD STATS: Time:0.0075 Tholds:0 Hosts:0
03/09/2009 01:35:04 PM - SYSTEM STATS: Time:2.3498 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:3 RRDsProcessed:3
03/09/2009 01:30:07 PM - SYSTEM THOLD STATS: Time:0.0041 Tholds:0 Hosts:0
03/09/2009 01:30:07 PM - SYSTEM STATS: Time:3.3326 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:3 RRDsProcessed:3
03/09/2009 01:25:04 PM - SYSTEM THOLD STATS: Time:0.0041 Tholds:0 Hosts:0
03/09/2009 01:25:04 PM - SYSTEM STATS: Time:2.3576 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:3 RRDsProcessed:3
03/09/2009 01:20:49 PM - WEBUI: Cacti Log Cleared from Web Management Interface

Cacti Data Base:

Name Rows Engine Collation Check Status
cdef 6 MyISAM latin1_swedish_ci OK
cdef_items 16 MyISAM latin1_swedish_ci OK
colors 101 MyISAM latin1_swedish_ci OK
data_input 12 MyISAM latin1_swedish_ci OK
data_input_data 177 MyISAM latin1_swedish_ci OK
data_input_fields 46 MyISAM latin1_swedish_ci OK
data_local 3 MyISAM latin1_swedish_ci OK
data_template 41 MyISAM latin1_swedish_ci OK
data_template_data 44 MyISAM latin1_swedish_ci OK
data_template_data_rra 176 MyISAM latin1_swedish_ci OK
data_template_rrd 60 MyISAM latin1_swedish_ci OK
graph_local 2 MyISAM latin1_swedish_ci OK
graph_template_input 77 MyISAM latin1_swedish_ci OK
graph_template_input_defs 257 MyISAM latin1_swedish_ci OK
graph_templates 33 MyISAM latin1_swedish_ci OK
graph_templates_gprint 3 MyISAM latin1_swedish_ci OK
graph_templates_graph 35 MyISAM latin1_swedish_ci OK
graph_templates_item 272 MyISAM latin1_swedish_ci OK
graph_tree 1 MyISAM latin1_swedish_ci OK
graph_tree_items 1 MyISAM latin1_swedish_ci OK
host 1 MyISAM latin1_swedish_ci OK
host_graph 4 MyISAM latin1_swedish_ci OK
host_snmp_cache 2 MyISAM latin1_swedish_ci OK
host_snmp_query 1 MyISAM latin1_swedish_ci OK
host_template 7 MyISAM latin1_swedish_ci OK
host_template_graph 14 MyISAM latin1_swedish_ci OK
host_template_snmp_query 13 MyISAM latin1_swedish_ci OK
plugin_config 2 MyISAM latin1_swedish_ci OK
plugin_db_changes 12 MyISAM latin1_swedish_ci OK
plugin_hooks 30 MyISAM latin1_swedish_ci OK
plugin_realms 5 MyISAM latin1_swedish_ci OK
plugin_rrdclean 3 MyISAM latin1_swedish_ci OK <----------------- RRDClean tables
plugin_rrdclean_action 0 MyISAM latin1_swedish_ci OK <----------------- RRClean Tables
plugin_thold_contacts 2 MyISAM latin1_swedish_ci OK
plugin_thold_log 0 MyISAM latin1_swedish_ci OK
plugin_thold_template_contact 0 MyISAM latin1_swedish_ci OK
plugin_thold_threshold_contact 0 MyISAM latin1_swedish_ci OK
poller 0 MyISAM latin1_swedish_ci OK
poller_command 0 MyISAM latin1_swedish_ci OK
poller_item 3 MyISAM latin1_swedish_ci OK
poller_output 0 MyISAM latin1_swedish_ci OK
poller_reindex 0 MyISAM latin1_swedish_ci OK
poller_time 2 MyISAM latin1_swedish_ci OK
rra 5 MyISAM latin1_swedish_ci OK
rra_cf 10 MyISAM latin1_swedish_ci OK
settings 33 MyISAM latin1_swedish_ci OK
settings_graphs 70 MyISAM latin1_swedish_ci OK
settings_tree 0 MyISAM latin1_swedish_ci OK
snmp_query 8 MyISAM latin1_swedish_ci OK
snmp_query_graph 19 MyISAM latin1_swedish_ci OK
snmp_query_graph_rrd 39 MyISAM latin1_swedish_ci OK
snmp_query_graph_rrd_sv 59 MyISAM latin1_swedish_ci OK
snmp_query_graph_sv 40 MyISAM latin1_swedish_ci OK
thold_data 0 MyISAM latin1_swedish_ci OK
thold_template 0 MyISAM latin1_swedish_ci OK
user_auth 3 MyISAM latin1_swedish_ci OK
user_auth_perms 0 MyISAM latin1_swedish_ci OK
user_auth_realm 46 MyISAM latin1_swedish_ci OK
user_log 16 MyISAM latin1_swedish_ci OK
version 1 MyISAM latin1_swedish_ci OK

Thanks for this great plugin Gandalf !!!

Best regards ..

Tony Perez

Post by **gandalf** » Sun May 17, 2009 9:24 am

I just tried to reproduce on 087d with patches and PIA 2.4.
I'm unable to reproduce any SQL error, even in DEBUG mode.

The added line is IMHO a tweak to scan without pressing the Rescan button, that's all. So I need more facts to work on the problem.

Each of you may of course add the single line given above and tell me whether that solved to problem
Reinhard

Howie · Post by **Howie** » Thu May 28, 2009 4:46 am

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!

Post by **gandalf** » Sun May 31, 2009 3:13 pm

Howie wrote: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

Problems with RRD-Clean - Post Here

Who is online