RRDCleaner Tool doesn't allow to delete more than ~500 files

[interduo]

'Delete All' button doesn't work on filter bar.

But You can delete it with selecting all with checkboxes and opening the list and choosing delete and it works.

[shavenne]

For me the way to select a file and choosing delete doesn't work either.
It seems to be deleted but it isn't. On rescan it appeares again.

Error messages in the logfile:

2016-12-29 22:14:13 - DBCALL ERROR: A DB Exec Failed!, Error:1366, SQL:"INSERT INTO data_source_purge_action VALUES('', ?, ?, ?) ON DUPLICATE KEY UPDATE local_data_id = VALUES(local_data_id)'
2016-12-29 22:14:13 - 5 ERROR: A DB Exec Failed!, Error: Incorrect integer value: '' for column 'id' at row 1
2016-12-29 22:14:13 - CMDPHP SQL Backtrace: (/rrdcleaner.php: 46 do_rrd)(/rrdcleaner.php: 446 db_execute_prepared)(/lib/database.php: 174 cacti_debug_backtrace)

[interduo]

You cannot with my method delete more than 500 files.

[interduo]

Khmm If You got more than 10k You cannot delete them with both metods.
You can delete them by selecting 500 and 500 and 500............

[dabeani]

i have that same problem on my productive system at work...
and, there were using an older version (not 1.0.0) -> 0.8.8f.
with that Verison you can also only select maximum 500, 500,...

[cigamit]

This is a php variable that you need to set. I think it's post_max_size=XXXM and max_input_vars (php 5.3.9), make them bigger than the default and then restart apache.

I think I'll put them in global.php.

[cigamit]

I just made a change to allow it to goto 5k. Let us know if it works.

[interduo]

I did delete these rrd by hand using find and bash so I cannot confirm now.

[cigamit]

That setting is static and only adjustable via hard modifications to the php.ini file. Besides, the GUI get's slow when it's set to high numbers.

[cigamit]

Resolved.