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 to clean up temporary data files in Eon Mode. These files are no longer valid data files, and need to be removed. Pass 'true' to actually queue the files for deletion. CLEAN_COMMUNAL_STORAGE does not wait for the reaper queue to flush and the files to be actually deleted from the filesystem before returning.
You can cancel CLEAN_COMMUNAL_STORAGE during execution.
To verify that the files that were queued for deletion have actually been deleted, run FLUSH_REAPER_QUEUE.
Vertica supports this function only in Eon Mode.
Syntax
CLEAN_COMMUNAL_STORAGE ( 'actually_delete' )
Parameters
actually_delete |
BOOLEAN that indicates whether or not to delete temporary data files in the communal storage. |
Privileges
Superuser
Examples
Deletes:
=> SELECT CLEAN_COMMUNAL_STORAGE('true');
clean_communal_storage
------------------------
CLEAN COMMUNAL STORAGE
Total leaked files: 10
Total size: 2313
Files have not been queued for deletion.
Run clean_communal_storage(true) to queue files for deletion.
Check dc_communal_cleanup_records for more information.
(1 row)
