hard disk full

[powa-team]

hard disk full

[rjuju]

Hi,
Indeed a change in the retention most likely won't lead to immediate disk release. The reason for that is that the purge is only done once every powa_coalesce snapshot.

One way to force immediate purge is you have access to the database is to get the list of purge functions for that server (I used here $the_srv_id instead):

SELECT  function_name
FROM powa_functions
WHERE operation='purge'
AND enabled
AND srvid = $the_srv_id
ORDER BY module;
       function_name
---------------------------
 powa_qualstats_purge
 powa_stat_bgwriter_purge
 powa_statements_purge
 powa_databases_purge
 powa_all_relations_purge
 powa_user_functions_purge
(6 rows)

And call them one by one, in the order return by that query. For instance with the above resultset you would have to run:

SELECT powa_qualstats_purge($the_srv_id);
SELECT powa_stat_bgwriter_purge($the_srv_id);
SELECT powa_statements_purge($the_srv_id);
SELECT powa_databases_purge($the_srv_id);
SELECT powa_all_relations_purge($the_srv_id);
SELECT powa_user_functions_purge($the_srv_id);

Repeat that for all the servers you want to apply an immediate purge.

It might be a good idea to add a way to force that via the UI for similar cases.

[rjuju]

I'm assuming that this answered your question. Feel free to reopen this issue if that wasn't the case.