Short description of the following content

One part of our 3 steps deletion process is the "Delete Assets". This command deletes the asset versions in the Oracle database and writes the entries into the storage_deletion_queue.
This is a guide how to check whether the do-deletion job has finished successfully.

Important hints

This Article is only valid for AssetDeletion2.

The command configuration for do-deletion can be found in:
'censhare-Admin/Configuration/Modules/Asset Deletion/Delete Assets (automatic)'.
The do-deletion command by default is running daily at:
<cron pattern="30 3 * * *"/>

Step by Step guide

This check can only be done in the censhare server log.
Log on to the censhare Server via terminal.
Switch to the corpus user.
Change into the directory '~/work/logs'.
Now you can search the server logs for the "completed all" message of the do deletion command:

grep " completed all" server-0.*

The result of the grep-command should looks like that:

server-0.3.log:2011.11.21-14:34:12.151 INFO : T008: CommandExecutor: tr.20111121.143412.150[system]: completed all in 0ms 
server-0.65.log:2011.10.27-05:33:55.660 INFO : T034: CommandExecutor: tr.20111027.053354.000[system]: completed all in 19ms
server-0.4.log:2011.11.21-14:27:18.279 INFO : T036: CommandExecutor: tr.20111121.133421.516[system]: completed all in 3069766ms

The first entry shows a restart of the command during a refresh configuration (with censhare Admin Client).
The second entry shows the start of the command during the server startup.
The third one is the successful scheduled run. You can identify the scheduled run by the timestamp and duration time.
This third entry shows that the run has finished successfully.

Check deleted Assets in the database

For each deleted asset version with a storage item, an entry in the storage deletion queue will be created.
With this SQL statement, the current amount of entries can be checked:

select count(*) from storage_deletion_queue;