Alfred Database Locked #2
Description
Describe the bug
- Database lock issues
- symlinks being deleted (perhaps) despite --dry-run option on command-line
- Feature Request: No progress indicator on web front-end (might be nice to get updates for every 100 odd symlinks given the large size of some realdebrid/all folders?
To Reproduce
Steps to reproduce the behavior:
- Start container
- Click on '.Manual Scan'
- Go to docker container logs (no output on front-end)
- See errors below
Environment:
- OS: Ubuntu 24.04
- Docker version: 27.2.1, build 9e34c9b
- Alfred version: 0.0.24
Additional context
.env file used to build container:
SYMLINK_DIR=/mnt/plex,/mnt/symlinks
TORRENTS_DIR=/mnt/remote/realdebrid/all,/mnt/remote/realdebrid/torrents,/mnt/remote/realdebrid/movies,/mnt/remote/realdebrid/movies4k,/mnt/remote/realdebrid/shows,/mnt/remote/realdebrid/shows4k
DELETE_BEHAVIOR=files
SCAN_INTERVAL=720
Multiple database is locked issues during scan of 21,219 torrents (304Tb), for example:
2025-04-22 12:20:02 | INFO | File /mnt/remote/realdebrid/all/Caddo.Lake.2024.1080p.WEB.H264-omgfr[TGx]/caddo.lake.2024.1080p.web.h264-omgfr.mkv is not used!
2025-04-22 12:20:02 | ERROR | Error updating symlink /mnt/plex/movies4k/Suncoast (2024) {tmdb-1014209}/Suncoast (2024) [2160p, HEVC, EAC3].mkv: database is locked
2025-04-22 12:20:02 | DEBUG | Traceback (most recent call last):
File "/app/alfred.py", line 167, in upsert_symlink
execute_with_retry(cursor, 'INSERT INTO symlinks (symlink, target, ref_count) VALUES (?, ?, ?)', (file_path, target, ref_count))
File "/app/alfred.py", line 58, in execute_with_retry
return cursor.execute(query, params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
sqlite3.OperationalError: database is locked
Container started with the following CMD
/app/start.sh --dry-run
however, app indicates deletions are happening. Anxiety inducing, even if the INFO log is misleading?
2025-04-22 12:20:02 | INFO | File /mnt/remote/realdebrid/all/Locke.And.Key.S03.2160p.NF.WEBRip.DDP.5.1.Atmos.HDR.DoVi.Hybrid.P8.by.DVT/Locke.And.Key.S03E01.2160p.NF.WEBRip.DDP.5.1.Atmos.HDR.DoVi.Hybrid.P8.by.DVT.mkv is not used!
2025-04-22 12:20:02 | INFO | File /mnt/remote/realdebrid/all/Locke.And.Key.S03.2160p.NF.WEBRip.DDP.5.1.Atmos.HDR.DoVi.Hybrid.P8.by.DVT/Locke.And.Key.S03E01.2160p.NF.WEBRip.DDP.5.1.Atmos.HDR.DoVi.Hybrid.P8.by.DVT.mkv deleted!
2025-04-22 12:20:02 | INFO | File /mnt/remote/realdebrid/torrents/Medium.seasons.01-07.AMZN.1080p.5.1.HEVC.x265.10bit-Bearfish/Medium S06E10AMZN.1080p.5.1.HEVC.x265.10bit-Bearfish.mkv is not used!
2025-04-22 12:20:02 | INFO | File /mnt/remote/realdebrid/torrents/Medium.seasons.01-07.AMZN.1080p.5.1.HEVC.x265.10bit-Bearfish/Medium S06E10AMZN.1080p.5.1.HEVC.x265.10bit-Bearfish.mkv deleted!
2025-04-22 12:20:02 | INFO | File /mnt/remote/realdebrid/all/American.Monster.S07.1080p.WEBRip.AAC2.0.x264-KOMPOST[rartv]/American.Monster.S07E03.With.Honors.1080p.WEB.h264-KOMPOST.mkv is not used!
2025-04-22 12:20:02 | INFO | File /mnt/remote/realdebrid/all/American.Monster.S07.1080p.WEBRip.AAC2.0.x264-KOMPOST[rartv]/American.Monster.S07E03.With.Honors.1080p.WEB.h264-KOMPOST.mkv deleted!