Asset Deletion 3

Asset deletion 3 executes clean-up actions in asset versions that are no longer needed. It defines policies and constraints. The policies are set in the censhare Admin Client based on asset type and domains.

Concept & structure

Asset Deletion 3 is located in censhare Admin Client > Modules and has the following three configurations:

1. Delete Asset Versions (automatic)

As per configuration, this automatic action runs by setting a cron pattern that is normally set to run nightly (For more, see Configure execution time). A resource asset with the key censhare:query-deletion-ids gathers the "last marked" and "last deleted" asset IDs. The IDs are stored in the database (table: feature) under the following two features: (1) censhare:deletion.last-id.marked, (2) censhare:deletion.last-id.deleted. This allows the module to remember the last marked and deleted assets and continue from where it left off. Eventually, when there are no more asset versions to analyze from the "last-*" IDs, the features are set to 0 before the command starts to scan the database from the beginning.

• Mark asset versions: This action works in the following three steps:

  1. It queries and gathers possible candidates to be marked by applying the policies described in Asset Version Policies.
  2. It gathers all asset versions of each asset that is added to the candidate list and filters them out of the candidate list by applying a different asset type policy (for example: keep first/last versions).
  3. Finally, it proceeds to mark the asset versions by updating the deletion column of the asset table to the value 1 (marked).

• Delete asset versions: It queries assets from the database that are marked for deletion. It checks if there is any asset version policy that applies up to the asset type. It then applies the keepHoursBeforeDeletion policy to their asset versions. As soon as this duration is completed, it physically deletes the asset versions from the database.

• Delete Storage Items: It checks the entries in the storage_deletion_queue table and deletes any unreferenced files.

2. Asset Deletion 3 Report

The Asset Deletion 3 Report receives a maximum amount of rows to be displayed in the censhare Admin Client (50, 100, 500, or 1000). The action analyzes up to that amount of asset versions, regardless of whether the asset has more versions.

• Deletion Report: It shows for which asset type, domain, and 2nd domain the policy was applied. It also shows restrictions/constraints and policies of all asset versions of an asset, which could not be deleted. The report is visible both on the censhare Admin Client and censhare Web.

  censhare Admin Client:

  

  censhare Web:

  The report in censhare Web works with pagination, where a range of records is set at the bottom of the page as 'Maximum versions per page'. The arrows next to it, allow users to move within the pages.

  Note: The report action displays only the asset versions that contain at least one constraint. For example, from a list of 15 assets, that are queried and analyzed, only 10 of them have asset versions with some kind of constraints or policies. It is therefore expected that only these 10 of the 15 rows will be displayed.

  

3. Delete Asset Versions (individual)

The action allows you to run the complete asset deletion process (mark, delete and delete storage items). It works similar to the automatic asset deletion but runs for a single asset. Currently, the action is only available on the censhare Client and it can be executed by right-clicking on an asset Server Actions > Delete Asset Versions (individual).

Constraints

There are basically two groups of restrictions that we can see on the Asset Deletion 3 Report, which prevent asset versions from being deleted:

1. Asset Type Polices: Find more information, see Configure asset version policies.
2. Constraints:
   • asset_rel_fk8: This asset version has an associated variant.
   • asset_fk16: This asset version holds a content version that is still used in a later asset version.
   • asset_rel_fk3: This asset version is used in an actual placement.
   • asset_feature_fk7: This asset version is referenced by an asset feature.
   • Live-tag: Live-tags are used within the Online Channel. They indicate that a certain asset version is published on the website. If you do not use the Online Channel, you can deactivate the Live-tag check in the server actions for Asset Deletion 3.
   • Snapshot: This asset version has an associated snapshot. Snapshots are used in the Online Channel. Use this if you want to ensure that certain versions are kept even if an asset version policy applies.

Implementation

Code

Every action related to the asset deletion is implemented 'in batches' of 10000 assets, by following the process below:

1. Pull a batch from the database and work with it until it is fully processed
2. Clean all temporarily used objects to free the allocated memory
3. Pull the next batch

Committing to the database is performed in batches of 120 assets at a time. If one or more assets fail, a rollback exception is triggered. During the rollback exception we commit the mentioned batch of 120 assets but this time one by one. This allows us to commit the assets that have no exceptions and log those that could not be deleted.

Mark for deletion flow

The first query brings the best candidates that can be found in the database, to mark them for deletion. It excludes the following cases:

• Current version: It excludes the current version (0) or checked out (-2).
• Snapshot: Asset versions with snapshots are ignored for deletion (snapshot_name != null).
• Deletion Status: Statuses with 'marked for deletion' (deletion = 0), 'cannot delete' (deletion = 2) and 'proposed for deletion' (deletion = 4) are ignored.
• Polices: If the asset type has no policy, it is completely ignored. Otherwise, it checks if the policy is enabled and if a deletion mode is set to it.
• Variants: Any asset version with an associated variant is ignored.
• Actual placement: Versions that are used in actual placements are ignored.
• Content Version: If a version holds a content version that is still used in later asset versions, the content version is ignored.
• Feature Reference: If an asset version is referenced by an asset feature, it is ignored.

After getting the first batch of 10k assets of candidates, if that many exist, it queries all versions for each asset from the candidate bucket and filters them out again by applying the first asset type policies: 'keep first/last versions'. The remaining assets are compared with the first candidate list. If they are in the list, they are marked for deletion by updating the deletion column in the asset table to 1 (committing takes place for every 120 assets at a time. If any exceptions occur we re-commit one by one).

Deletion flow

At this stage, the module queries the batch of 10k assets which are marked for deletion and it is checking again if those assets continue to have at least one policy set. The next step applies the asset type policy to 'Keep hours before deletion'. The remaining asset versions are physically deleted. The Commit is executed for every 120 assets at a time. If there are any exceptions, we re-commit one by one.

Storage item deletion

For the storage item deletion, the module checks all entries in the storage_deletion_queue table and deletes all unreferenced files. It runs for the duration that is set in the command configuration in the censhare Admin Client.

Handlers

Server action

• Location: censhare-Server/app/modules/asset_deletion3/AssetDeletion3Handler.java

CommandHandler

• Location: censhare-Server/web-commands/com/censhare/api/admin/deletion/AssetDeletionReportHandler.java