DELETE /api/v2/assets/{id} removes DB row but leaves the binary file on disk #2908

Description

Deleting an asset from the web UI (or via DELETE /api/v2/assets/{id}) removes the row from the assets table but leaves the corresponding file untouched in /data/anthias_assets/.

Related to but distinct from #860, which is about orphans from failed uploads. Here the upload succeeded, the asset played fine, and was deleted normally from the UI.

Steps to Reproduce

1. Upload a video asset via the web UI
2. Delete it from the UI
3. Inspect /data/anthias_assets/ inside the server container and compare with the assets table in /data/.anthias/anthias.db.

Environment

• Anthias v2026.5.1 (Docker, ghcr.io/screenly/anthias-server:latest-pi4-64, image digest sha256:db5ebebf3b53…)
• Raspberry Pi 4 (aarch64)
• Raspberry Pi OS Lite, Debian 13 (trixie), kernel 6.18.29

Actual behavior

The DB row is gone. The file remains on disk indefinitely. The containing directory's mtime is unchanged, indicating no deletion attempt was made on the filesystem at all.

Expected Behavior

Both the DB row and the file in /data/anthias_assets/ are removed.

Thanks for Anthias — the project is great!
py