CLEAN_COMMUNAL_STORAGE

Deletes files on communal (shared) storage that have leaked due to an event that led Vertica cleanup mechanisms to fail.

Invoke CLEAN_COMMUNAL_STORAGE after a node crash or after you restore objects from backup to clean up temporary data files in Eon Mode. These files are no longer valid data files and should be removed. If you pass 'true', CLEAN_COMMUNAL_STORAGE adds the files to the reaper queue and returns immediately. The files are removed when the reaper queue next runs, or you can call FLUSH_REAPER_QUEUE to delete them more quickly.

If you pass 'false', CLEAN_COMMUNAL_STORAGE reports information about extra files but does not queue them for deletion.

You can cancel CLEAN_COMMUNAL_STORAGE during execution.

This function is only available in Eon Mode.

Syntax

CLEAN_COMMUNAL_STORAGE ( 'actually‑delete' )

Parameters

actually‑delete

BOOLEAN that indicates whether to delete temporary data files in the communal storage.

Privileges

Superuser

Examples

Queue the files for deletion using the 'true' parmeter.

=> SELECT CLEAN_COMMUNAL_STORAGE('true')
CLEAN_COMMUNAL_STORAGE
------------------------------------------------------------------
CLEAN COMMUNAL STORAGE
Task was canceled.
Total leaked files: 9265
Total size: 4236501526
Files have been queued for deletion.
Check communal_cleanup_records for more information.
(1 row)