Critical Bug: Core migration initiated on V12 but resulted in 0-byte database truncation on UGOS Pro

[dnmc919]

Is there an existing issue for this?

• I have searched the existing issues

Current Behavior

During an automatic image update to the latest image upon a NAS reboot, the container initialized an upgrade path that resulted in catastrophic data loss. Instead of failing gracefully or throwing a standard SQLite schema migration error, the live database file (jellyfin.db) was flattened to 0 bytes on the host filesystem and no automatically generated pre-update backup was performed.

The SQLiteBacksups folder was empty, and an exhaustive search of all mnt paths resluted in no other names or potential backups.

root@DNNAS:/docker/appdata/jellyfin# sudo find / -name "jellyfin.db*" -exec ls -lh {} ; 2>/dev/null

-rw-r--r-- 1 media1 mediastack 0 Sep 10 09:47 /overlay/upper/docker/appdata/jellyfin/config/data/data/jellyfin.db
-rw-r--r-- 1 media1 mediastack 0 Sep 10 09:47 /docker/appdata/jellyfin/config/data/data/jellyfin.db

root@DNNAS:/docker/appdata/jellyfin# find /docker/appdata/jellyfin/ -name ".db" -ls
1198745 0 -rw-r--r-- 1 media1 mediastack 0 Sep 10 09:47 /docker/appdata/jellyfin/config/data/data/jellyfin.db
root@DNNAS:/docker/appdata/jellyfin# find /docker/ -name "jellyfin.db" -ls
1198745 0 -rw-r--r-- 1 media1 mediastack 0 Sep 10 09:47 /docker/appdata/jellyfin/config/data/data/jellyfin.db
root@DNNAS:/docker/appdata/jellyfin# find /docker/appdata/jellyfin/ -name ".bak*" -ls
root@DNNAS:/docker/appdata/jellyfin# find /docker/appdata/jellyfin/ -type f ( -name ".db" -o -name ".sqlite" -o -name ".sqlite3" ) -ls
1198745 0 -rw-r--r-- 1 media1 mediastack 0 Sep 10 09:47 /docker/appdata/jellyfin/config/data/data/jellyfin.db
root@DNNAS:/docker/appdata/jellyfin# find /volume /mnt* -type f ( -name "jellyfin.db" -o -name "library.db" ) -size +1k -ls 2>/dev/null
root@DNNAS:/docker/appdata/jellyfin# find / -type f ( -name "jellyfin.db" -o -name "library.db" ) -size +1k -ls 2>/dev/null

Expected Behavior

Well, a backup before any upgrade is an absolute prerequisite. If a backup fails, then the upgrade should NEVER proceed. Then, if a successful backup, the upgrade should work without errors, or revert with error log. It should not wipe out my whole database and still show running successfully in docker.

Steps To Reproduce

Cannot do so in this instance

Environment

- OS: UGREEN UGOS Pro (Latest stable release)
- How docker service was installed: Image: lscr.io/linuxserver/jellyfin:latest
- Hardware: Ugreen DXP4800 ProStorage Configuration: RAID 5 formatted as EXT4 Docker

CPU architecture

x86-64

Docker creation

services:
  jellyfin:
    image: lscr.io/linuxserver/jellyfin:latest
    container_name: jellyfin
    restart: unless-stopped
    environment:
      - PUID=1004
      - PGID=1003
      - TZ=America/Chicago
    ports:
      - 8096:8096
    volumes:
      - /docker/appdata/jellyfin/config:/config
      - /docker/appdata/jellyfin/cache:/cache
      - /volume1/media/movies:/media/movies

Container logs

[migrations] started
[migrations] no migrations found
───────────────────────────────────────

      ██╗     ███████╗██╗ ██████╗
      ██║     ██╔════╝██║██╔═══██╗
      ██║     ███████╗██║██║   ██║
      ██║     ╚════██║██║██║   ██║
      ███████╗███████║██║╚██████╔╝
      ╚══════╝╚══════╝╚═╝ ╚═════╝

   Brought to you by linuxserver.io
───────────────────────────────────────

To support the app dev(s) visit:
Jellyfin: https://opencollective.com/jellyfin

To support LSIO projects visit:
https://www.linuxserver.io/donate/

───────────────────────────────────────
GID/UID
───────────────────────────────────────

User UID:    1004
User GID:    1003
───────────────────────────────────────
[custom-init] No custom files found, skipping...
[09:00:24] [INF] [1] Emby.Server.Implementations.AppBase.BaseConfigurationManager: Setting cache path: /config/cache
[09:00:24] [INF] [7] Jellyfin.Server.ServerSetupApp.SetupServer: Kestrel is listening on all interfaces
[09:00:24] [INF] [7] Main: Jellyfin version: 10.11.11
[09:00:24] [INF] [7] Main: Environment Variables: ["[JELLYFIN_DATA_DIR, /config/data]", "[JELLYFIN_CACHE_DIR, /config/cache]", "[JELLYFIN_WEB_DIR, /usr/share/jellyfin/web]", "[JELLYFIN_LOG_DIR, /config/log]", "[JELLYFIN_CONFIG_DIR, /config]"]
[09:00:24] [INF] [7] Main: Arguments: ["/usr/lib/jellyfin/bin/jellyfin.dll", "--ffmpeg=/usr/lib/jellyfin-ffmpeg/ffmpeg"]
[09:00:24] [INF] [7] Main: Operating system: Ubuntu 24.04.4 LTS
[09:00:24] [INF] [7] Main: Architecture: X64
[09:00:24] [INF] [7] Main: 64-Bit Process: True
[09:00:24] [INF] [7] Main: User Interactive: True
[09:00:24] [INF] [7] Main: Processor count: 8
[09:00:24] [INF] [7] Main: Program data path: /config/data
[09:00:24] [INF] [7] Main: Log directory path: /config/log
[09:00:24] [INF] [7] Main: Config directory path: /config
[09:00:24] [INF] [7] Main: Cache path: /config/cache
[09:00:24] [INF] [7] Main: Temp directory path: /tmp/jellyfin
[09:00:24] [INF] [7] Main: Web resources path: /usr/share/jellyfin/web
[09:00:24] [INF] [7] Main: Application directory: /usr/lib/jellyfin/bin/
[09:00:24] [INF] [7] Jellyfin.Server.Startup: Storage path `/config/data/data` (Fixed) successfully checked with 6.3GiB free which is over the minimum of 2GiB.
[09:00:24] [INF] [7] Jellyfin.Server.Startup: Storage path `/config/cache` (Fixed) successfully checked with 6.3GiB free which is over the minimum of 2GiB.
[09:00:24] [INF] [7] Jellyfin.Server.Startup: Storage path `/config/data` (Fixed) successfully checked with 6.3GiB free which is over the minimum of 2GiB.
[09:00:24] [INF] [7] Emby.Server.Implementations.AppBase.BaseConfigurationManager: Setting cache path: /config/cache
[09:00:24] [INF] [7] Jellyfin.Database.Providers.Sqlite.SqliteDatabaseProvider: SQLite connection string: Data Source=/config/data/data/jellyfin.db;Cache=Default;Default Timeout=30;Pooling=True
[09:00:24] [INF] [7] Jellyfin.Database.Providers.Sqlite.SqliteDatabaseProvider: SQLITE connection pragma command set to:
PRAGMA locking_mode=NORMAL;
PRAGMA journal_size_limit=134217728;
PRAGMA synchronous=1;
PRAGMA temp_store=2;

[09:00:24] [INF] [7] Jellyfin.Database.Implementations.Locking.NoLockBehavior: The database locking mode has been set to: NoLock.
[09:00:24] [INF] [7] Jellyfin.Server.Migrations.JellyfinMigrationService: Initialise Migration service.
[09:00:24] [WRN] [10] Microsoft.Extensions.Diagnostics.HealthChecks.DefaultHealthCheckService: Health check StartupCheck with status Degraded completed after 0.7418ms with message 'Server is still starting up.'
[09:00:25] [INF] [7] Jellyfin.Server.Migrations.JellyfinMigrationService: There are 0 migrations for stage PreInitialisation.
[09:00:25] [INF] [7] Emby.Server.Implementations.AppBase.BaseConfigurationManager: Setting cache path: /config/cache
[09:00:25] [INF] [7] Emby.Server.Implementations.ApplicationHost: Loading assemblies
[09:00:25] [INF] [7] Emby.Server.Implementations.Plugins.PluginManager: Loaded assembly Jellyfin.Plugin.Opds, Version=7.0.0.0, Culture=neutral, PublicKeyToken=null from /config/data/plugins/OPDS_7.0.0.0/Jellyfin.Plugin.Opds.dll
[09:00:25] [INF] [7] Emby.Server.Implementations.Plugins.PluginManager: Loaded assembly Jellyfin.Plugin.OpenSubtitles, Version=24.0.0.0, Culture=neutral, PublicKeyToken=null from /config/data/plugins/Open Subtitles_24.0.0.0/Jellyfin.Plugin.OpenSubtitles.dll
[09:00:25] [INF] [7] Emby.Server.Implementations.Plugins.PluginManager: Loaded assembly Trakt, Version=30.0.0.0, Culture=neutral, PublicKeyToken=null from /config/data/plugins/Trakt_30.0.0.0/Trakt.dll
[09:00:25] [INF] [7] Jellyfin.Networking.Manager.NetworkManager: Defined LAN subnets: ["::1/128", "fe80::/10", "fc00::/7", "127.0.0.1/8", "10.0.0.0/8", "172.16.0.0/12", "192.168.0.0/16"]
[09:00:25] [INF] [7] Jellyfin.Networking.Manager.NetworkManager: Defined LAN exclusions: []
[09:00:25] [INF] [7] Jellyfin.Networking.Manager.NetworkManager: Used LAN subnets: ["::1/128", "fe80::/10", "fc00::/7", "127.0.0.1/8", "10.0.0.0/8", "172.16.0.0/12", "192.168.0.0/16"]
[09:00:25] [INF] [7] Jellyfin.Networking.Manager.NetworkManager: Filtered interface addresses: []
[09:00:25] [INF] [7] Jellyfin.Networking.Manager.NetworkManager: Bind Addresses ["::"]
[09:00:25] [INF] [7] Jellyfin.Networking.Manager.NetworkManager: Remote IP filter is Allowlist
[09:00:25] [INF] [7] Jellyfin.Networking.Manager.NetworkManager: Filtered subnets: []
[09:00:25] [INF] [7] Jellyfin.Database.Providers.Sqlite.SqliteDatabaseProvider: SQLite connection string: Data Source=/config/data/data/jellyfin.db;Cache=Default;Default Timeout=30;Pooling=True
[09:00:25] [INF] [7] Jellyfin.Database.Providers.Sqlite.SqliteDatabaseProvider: SQLITE connection pragma command set to:
PRAGMA locking_mode=NORMAL;
PRAGMA journal_size_limit=134217728;
PRAGMA synchronous=1;
PRAGMA temp_store=2;

[09:00:25] [INF] [7] Jellyfin.Database.Implementations.Locking.NoLockBehavior: The database locking mode has been set to: NoLock.
[09:00:25] [INF] [7] Main: Prepare system for possible migrations
[09:00:25] [INF] [7] Jellyfin.Server.Migrations.JellyfinMigrationService: There are 0 migrations for stage CoreInitialisation.
[09:00:25] [WRN] [16] Microsoft.Extensions.Diagnostics.HealthChecks.DefaultHealthCheckService: Health check StartupCheck with status Degraded completed after 0.0245ms with message 'Server is still starting up.'
[09:00:26] [INF] [7] Emby.Server.Implementations.Plugins.PluginManager: Loaded plugin: OPDS Feed 7.0.0.0
[09:00:26] [INF] [7] Emby.Server.Implementations.Plugins.PluginManager: Loaded plugin: Open Subtitles 24.0.0.0
[09:00:26] [INF] [7] Emby.Server.Implementations.Plugins.PluginManager: Loaded plugin: Trakt 30.0.0.0
[09:00:26] [INF] [7] Emby.Server.Implementations.Plugins.PluginManager: Loaded plugin: TMDb 10.11.11.0
[09:00:26] [INF] [7] Emby.Server.Implementations.Plugins.PluginManager: Loaded plugin: Studio Images 10.11.11.0
[09:00:26] [INF] [7] Emby.Server.Implementations.Plugins.PluginManager: Loaded plugin: OMDb 10.11.11.0
[09:00:26] [INF] [7] Emby.Server.Implementations.Plugins.PluginManager: Loaded plugin: MusicBrainz 10.11.11.0
[09:00:26] [INF] [7] Emby.Server.Implementations.Plugins.PluginManager: Loaded plugin: AudioDB 10.11.11.0
[09:00:26] [INF] [7] Jellyfin.Server.Migrations.JellyfinMigrationService: There are 0 migrations for stage AppInitialisation.
[09:00:26] [INF] [16] Main: Kestrel is listening on all interfaces
[09:00:26] [WRN] [16] Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware: The WebRootPath was not found: /run/s6-rc:s6-rc-init:FdlMNN/servicedirs/svc-jellyfin/wwwroot. Static files may be unavailable.
[09:00:26] [INF] [16] Emby.Server.Implementations.ApplicationHost: Running startup tasks
[09:00:26] [INF] [13] Emby.Server.Implementations.IO.LibraryMonitor: Watching directory /media/movies/Cary Grant
[09:00:26] [INF] [7] Emby.Server.Implementations.IO.LibraryMonitor: Watching directory /media/movies/Animated
[09:00:26] [INF] [15] Emby.Server.Implementations.IO.LibraryMonitor: Watching directory /media/movies/Clark Gable
[09:00:26] [INF] [20] Emby.Server.Implementations.IO.LibraryMonitor: Watching directory /media/movies/Humphrey Bogart
[09:00:26] [INF] [10] Emby.Server.Implementations.IO.LibraryMonitor: Watching directory /media/movies/Archive
[09:00:26] [INF] [21] Emby.Server.Implementations.IO.LibraryMonitor: Watching directory /media/movies/Glenn Ford
[09:00:26] [INF] [16] Emby.Server.Implementations.ScheduledTasks.TaskManager: Daily trigger for Generate Trickplay Images set to fire at 2026-08-12 03:00:00.000 -05:00, which is 17:59:33.3096258 from now.
[09:00:26] [INF] [16] Emby.Server.Implementations.ScheduledTasks.TaskManager: Daily trigger for Extract Chapter Images set to fire at 2026-08-12 02:00:00.000 -05:00, which is 16:59:33.3071453 from now.
[09:00:26] [INF] [9] Emby.Server.Implementations.IO.LibraryMonitor: Watching directory /media/movies/Errol Flynn
[09:00:26] [INF] [10] Emby.Server.Implementations.IO.LibraryMonitor: Watching directory /media/tvmini
[09:00:26] [INF] [7] Emby.Server.Implementations.IO.LibraryMonitor: Watching directory /media/movies/New
[09:00:26] [INF] [13] Emby.Server.Implementations.IO.LibraryMonitor: Watching directory /media/movies/John Wayne
[09:00:26] [INF] [13] Emby.Server.Implementations.IO.LibraryMonitor: Watching directory /media/tvspecial
[09:00:26] [INF] [20] Emby.Server.Implementations.IO.LibraryMonitor: Watching directory /media/movies/To Own
[09:00:26] [INF] [16] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Found ffmpeg version 7.1.4
[09:00:26] [INF] [13] Emby.Server.Implementations.IO.LibraryMonitor: Watching directory /media/tvtemp
[09:00:26] [INF] [15] Emby.Server.Implementations.IO.LibraryMonitor: Watching directory /media/movies/Released
[09:00:26] [INF] [24] Emby.Server.Implementations.IO.LibraryMonitor: Watching directory /media/movies/Owned
[09:00:26] [INF] [16] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Available decoders: ["libdav1d", "av1", "av1_cuvid", "av1_qsv", "h264", "h264_qsv", "h264_cuvid", "hevc", "hevc_qsv", "hevc_cuvid", "mpeg2video", "mpeg2_qsv", "mpeg2_cuvid", "mpeg4", "mpeg4_cuvid", "msmpeg4", "vc1_qsv", "vc1_cuvid", "vp8", "libvpx", "vp8_cuvid", "vp8_qsv", "vp9", "libvpx-vp9", "vp9_cuvid", "vp9_qsv", "aac", "ac3", "ac4", "dca", "flac", "mp3", "truehd"]
[09:00:26] [INF] [7] Emby.Server.Implementations.IO.LibraryMonitor: Watching directory /media/tvshows3
[09:00:26] [INF] [16] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Available encoders: ["libsvtav1", "av1_nvenc", "av1_qsv", "av1_amf", "av1_vaapi", "libx264", "h264_amf", "h264_nvenc", "h264_qsv", "h264_v4l2m2m", "h264_vaapi", "libx265", "hevc_amf", "hevc_nvenc", "hevc_qsv", "hevc_vaapi", "mjpeg_qsv", "mjpeg_vaapi", "aac", "libfdk_aac", "ac3", "alac", "dca", "flac", "libmp3lame", "libopus", "truehd", "libvorbis", "srt"]
[09:00:26] [INF] [21] Emby.Server.Implementations.IO.LibraryMonitor: Watching directory /media/tvshows
[09:00:26] [INF] [16] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Available filters: ["bwdif_cuda", "bwdif_opencl", "deinterlace_qsv", "deinterlace_vaapi", "flip_vulkan", "hwupload_cuda", "hwupload_vaapi", "libplacebo", "overlay_opencl", "overlay_qsv", "overlay_vaapi", "overlay_vulkan", "overlay_cuda", "procamp_vaapi", "scale_cuda", "scale_opencl", "scale_qsv", "scale_vaapi", "scale_vulkan", "tonemapx", "tonemap_cuda", "tonemap_opencl", "tonemap_vaapi", "transpose_cuda", "transpose_opencl", "transpose_vaapi", "transpose_vulkan", "vpp_qsv", "yadif_cuda", "yadif_opencl", "zscale", "alphasrc"]
[09:00:26] [INF] [9] Emby.Server.Implementations.IO.LibraryMonitor: Watching directory /media/tvshows1
[09:00:26] [INF] [10] Emby.Server.Implementations.IO.LibraryMonitor: Watching directory /media/tvshows2
[09:00:26] [INF] [16] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Available hwaccel types: ["cuda", "vaapi", "qsv", "drm", "opencl", "vulkan"]
[09:00:28] [INF] [16] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: FFmpeg: /usr/lib/jellyfin-ffmpeg/ffmpeg
[09:00:28] [INF] [16] Emby.Server.Implementations.ApplicationHost: ServerId: 5147b26d6e424bb4a81c444594d1e1a5
[09:00:28] [INF] [16] Emby.Server.Implementations.ApplicationHost: Core startup complete
[09:00:28] [INF] [16] Main: Startup complete 0:00:08.2611027
[ls.io-init] done.
[09:00:29] [INF] [21] Emby.Server.Implementations.ScheduledTasks.TaskManager: Clean Transcode Directory Completed after 0 minute(s) and 0 seconds
[09:00:29] [INF] [24] Emby.Server.Implementations.ScheduledTasks.TaskManager: Clean up collections and playlists Completed after 0 minute(s) and 0 seconds
[09:00:54] [INF] [24] Emby.Server.Implementations.ScheduledTasks.TaskManager: Update Plugins Completed after 0 minute(s) and 24 seconds
[09:38:15] [INF] [46] Emby.Server.Implementations.IO.LibraryMonitor: The Ark (/media/tvshows/The Ark) will be refreshed.
[09:38:15] [INF] [46] Emby.Server.Implementations.IO.LibraryMonitor: Season 1 (/media/tvshows/The Ark/The Ark Season 01) will be refreshed.
[09:38:15] [INF] [46] Emby.Server.Implementations.IO.LibraryMonitor: We Weren't Supposed to Be Awake (/media/tvshows/The Ark/The Ark Season 01/The Ark.S01E04.We Weren't Supposed to Be Awake.mkv) will be refreshed.
[09:38:15] [INF] [46] Emby.Server.Implementations.IO.LibraryMonitor: Like It Touched the Sun (/media/tvshows/The Ark/The Ark Season 01/The Ark.S01E02.Like It Touched the Sun.mkv) will be refreshed.
[09:38:15] [INF] [46] Emby.Server.Implementations.IO.LibraryMonitor: Everyone Wanted to Be on This Ship (/media/tvshows/The Ark/The Ark Season 01/The Ark.S01E01.Everyone Wanted to Be on This Ship.mkv) will be refreshed.
[09:38:15] [INF] [46] Emby.Server.Implementations.IO.LibraryMonitor: Get Out and Push (/media/tvshows/The Ark/The Ark Season 01/The Ark.S01E03.Get Out and Push.mkv) will be refreshed.
[09:38:15] [INF] [46] Emby.Server.Implementations.IO.LibraryMonitor: One Step Forward, Two Steps Back (/media/tvshows/The Ark/The Ark Season 01/The Ark.S01E05.One Step Forward, Two Steps Back.mkv) will be refreshed.
[09:38:15] [INF] [46] Emby.Server.Implementations.IO.LibraryMonitor: Two By Two (/media/tvshows/The Ark/The Ark Season 01/The Ark.S01E06.Two by Two.mkv) will be refreshed.
[09:38:15] [INF] [46] Emby.Server.Implementations.IO.LibraryMonitor: A Slow Death Is Worse (/media/tvshows/The Ark/The Ark Season 01/The Ark.S01E07.A Slow Death is Worse.mkv) will be refreshed.
[09:38:15] [INF] [46] Emby.Server.Implementations.IO.LibraryMonitor: Every Single Person Matters (/media/tvshows/The Ark/The Ark Season 01/The Ark.S01E08.Every Single Person Matters.mkv) will be refreshed.
[09:38:15] [INF] [46] Emby.Server.Implementations.IO.LibraryMonitor: The Painful Way (/media/tvshows/The Ark/The Ark Season 01/The Ark.S01E09.The Painful Way.mkv) will be refreshed.
[09:38:15] [INF] [46] Emby.Server.Implementations.IO.LibraryMonitor: Hoping for Forever (/media/tvshows/The Ark/The Ark Season 01/The Ark.S01E10.Hoping for Forever.mkv) will be refreshed.
[09:38:15] [INF] [46] Emby.Server.Implementations.IO.LibraryMonitor: Everybody Wins (/media/tvshows/The Ark/The Ark Season 01/The Ark.S01E12.Everybody Wins.mkv) will be refreshed.
[09:38:15] [INF] [46] Emby.Server.Implementations.IO.LibraryMonitor: The Last Thing You Ever Do (/media/tvshows/The Ark/The Ark Season 01/The Ark.S01E11.The Last Thing You Ever Do.mkv) will be refreshed.
[09:38:15] [INF] [46] Emby.Server.Implementations.IO.LibraryMonitor: tvshows (/media/tvshows) will be refreshed.
[09:38:15] [INF] [46] Emby.Server.Implementations.IO.LibraryMonitor: The Lord of the Rings: The Rings of Power (/media/tvshows/The Lord of the Rings - The Rings of Power) will be refreshed.
[09:38:15] [INF] [46] Emby.Server.Implementations.IO.LibraryMonitor: Season 2 (/media/tvshows/The Lord of the Rings - The Rings of Power/The Lord of the Rings - The Rings of Power Season 02) will be refreshed.
[09:38:15] [INF] [46] Emby.Server.Implementations.IO.LibraryMonitor: Elven Kings Under the Sky (/media/tvshows/The Lord of the Rings - The Rings of Power/The Lord of the Rings - The Rings of Power Season 02/The Lord of the Rings - The Rings of Power.S02E01.Elven Kings Under the Sky.WEBDL-720p Proper.mkv) will be refreshed.
[09:38:15] [INF] [46] Emby.Server.Implementations.IO.LibraryMonitor: Where the Stars Are Strange (/media/tvshows/The Lord of the Rings - The Rings of Power/The Lord of the Rings - The Rings of Power Season 02/The Lord of the Rings - The Rings of Power.S02E02.Where the Stars are Strange.WEBDL-720p Proper.mkv) will be refreshed.
[09:38:15] [INF] [46] Emby.Server.Implementations.IO.LibraryMonitor: Eldest (/media/tvshows/The Lord of the Rings - The Rings of Power/The Lord of the Rings - The Rings of Power Season 02/The Lord of the Rings - The Rings of Power.S02E04.Eldest.WEBDL-720p.mkv) will be refreshed.
[09:38:15] [INF] [46] Emby.Server.Implementations.IO.LibraryMonitor: The Eagle and the Sceptre (/media/tvshows/The Lord of the Rings - The Rings of Power/The Lord of the Rings - The Rings of Power Season 02/The Lord of the Rings - The Rings of Power.S02E03.The Eagle and the Sceptre.WEBDL-720p Proper.mkv) will be refreshed.
[09:38:15] [INF] [46] Emby.Server.Implementations.IO.LibraryMonitor: Halls of Stone (/media/tvshows/The Lord of the Rings - The Rings of Power/The Lord of the Rings - The Rings of Power Season 02/The Lord of the Rings - The Rings of Power.S02E05.Halls of Stone.WEBDL-720p.mkv) will be refreshed.
[09:38:15] [INF] [46] Emby.Server.Implementations.IO.LibraryMonitor: Where Is He? (/media/tvshows/The Lord of the Rings - The Rings of Power/The Lord of the Rings - The Rings of Power Season 02/The Lord of the Rings - The Rings of Power.S02E06.Where Is He.WEBDL-720p.mkv) will be refreshed.
[09:38:15] [INF] [46] Emby.Server.Implementations.IO.LibraryMonitor: Doomed to Die (/media/tvshows/The Lord of the Rings - The Rings of Power/The Lord of the Rings - The Rings of Power Season 02/The Lord of the Rings - The Rings of Power.S02E07.Doomed to Die.WEBDL-720p.mkv) will be refreshed.
[09:38:15] [INF] [46] Emby.Server.Implementations.IO.LibraryMonitor: Shadow and Flame (/media/tvshows/The Lord of the Rings - The Rings of Power/The Lord of the Rings - The Rings of Power Season 02/The Lord of the Rings - The Rings of Power.S02E08.Shadow and Flame.WEBDL-720p.mkv) will be refreshed.
[09:38:15] [ERR] [43] MediaBrowser.Providers.Manager.ProviderManager: Error refreshing item
System.ArgumentException: Guid can't be empty (Parameter 'id')
   at Emby.Server.Implementations.Library.LibraryManager.GetItemById(Guid id)
   at MediaBrowser.Providers.Manager.ProviderManager.StartProcessingRefreshQueue()
[09:38:17] [ERR] [47] MediaBrowser.Providers.Subtitles.SubtitleManager: Error downloading subtitles from Open Subtitles
System.Security.Authentication.AuthenticationException: Account username and/or password are not set up
   at Jellyfin.Plugin.OpenSubtitles.OpenSubtitleDownloader.Login(CancellationToken cancellationToken)
   at Jellyfin.Plugin.OpenSubtitles.OpenSubtitleDownloader.Search(SubtitleSearchRequest request, CancellationToken cancellationToken)
   at MediaBrowser.Providers.Subtitles.SubtitleManager.SearchSubtitles(SubtitleSearchRequest request, CancellationToken cancellationToken)
[09:38:27] [INF] [44] Trakt.Helpers.LibraryManagerEventsHelper: Timer elapsed - processing queued items
[09:38:27] [INF] [44] Trakt.Helpers.LibraryManagerEventsHelper: No movies with event type Remove to process
[09:38:27] [INF] [44] Trakt.Helpers.LibraryManagerEventsHelper: No movies with event type Add to process
[09:38:27] [INF] [44] Trakt.Helpers.LibraryManagerEventsHelper: No movies with event type Update to process
[09:38:27] [INF] [44] Trakt.Helpers.LibraryManagerEventsHelper: No episodes with event type Remove to process
[09:38:27] [INF] [44] Trakt.Helpers.LibraryManagerEventsHelper: No episodes with event type Add to process
[09:38:27] [INF] [44] Trakt.Helpers.LibraryManagerEventsHelper: Processing 1 episodes with event type Update
[09:38:30] [ERR] [49] MediaBrowser.Providers.TV.EpisodeMetadataService: Error in The Open Movie Database
System.Text.Json.JsonException: 'i' is invalid after a value. Expected either ',', '}', or ']'. Path: $.Episodes[1] | LineNumber: 0 | BytePositionInLine: 1066.
 ---> System.Text.Json.JsonReaderException: 'i' is invalid after a value. Expected either ',', '}', or ']'. LineNumber: 0 | BytePositionInLine: 1066.
   at System.Text.Json.ThrowHelper.ThrowJsonReaderException(Utf8JsonReader& json, ExceptionResource resource, Byte nextByte, ReadOnlySpan`1 bytes)
   at System.Text.Json.Utf8JsonReader.ConsumeNextToken(Byte marker)
   at System.Text.Json.Utf8JsonReader.ReadSingleSegment()
   at System.Text.Json.Utf8JsonReader.Read()
   at System.Text.Json.Serialization.Converters.ObjectDefaultConverter`1.OnTryRead(Utf8JsonReader& reader, Type typeToConvert, JsonSerializerOptions options, ReadStack& state, T& value)
   at System.Text.Json.Serialization.JsonConverter`1.TryRead(Utf8JsonReader& reader, Type typeToConvert, JsonSerializerOptions options, ReadStack& state, T& value, Boolean& isPopulatedValue)
   at System.Text.Json.Serialization.JsonCollectionConverter`2.OnTryRead(Utf8JsonReader& reader, Type typeToConvert, JsonSerializerOptions options, ReadStack& state, TCollection& value)
   at System.Text.Json.Serialization.JsonConverter`1.TryRead(Utf8JsonReader& reader, Type typeToConvert, JsonSerializerOptions options, ReadStack& state, T& value, Boolean& isPopulatedValue)
   at System.Text.Json.Serialization.Metadata.JsonPropertyInfo`1.ReadJsonAndSetMember(Object obj, ReadStack& state, Utf8JsonReader& reader)
   at System.Text.Json.Serialization.Converters.ObjectDefaultConverter`1.OnTryRead(Utf8JsonReader& reader, Type typeToConvert, JsonSerializerOptions options, ReadStack& state, T& value)
   at System.Text.Json.Serialization.JsonConverter`1.TryRead(Utf8JsonReader& reader, Type typeToConvert, JsonSerializerOptions options, ReadStack& state, T& value, Boolean& isPopulatedValue)
   at System.Text.Json.Serialization.JsonConverter`1.ReadCore(Utf8JsonReader& reader, T& value, JsonSerializerOptions options, ReadStack& state)
   --- End of inner exception stack trace ---
   at System.Text.Json.ThrowHelper.ReThrowWithPath(ReadStack& state, JsonReaderException ex)
   at System.Text.Json.Serialization.JsonConverter`1.ReadCore(Utf8JsonReader& reader, T& value, JsonSerializerOptions options, ReadStack& state)
   at System.Text.Json.Serialization.Metadata.JsonTypeInfo`1.ContinueDeserialize(ReadBufferState& bufferState, JsonReaderState& jsonReaderState, ReadStack& readStack, T& value)
   at System.Text.Json.Serialization.Metadata.JsonTypeInfo`1.DeserializeAsync(Stream utf8Json, CancellationToken cancellationToken)
   at System.Net.Http.Json.HttpClientJsonExtensions.<FromJsonAsyncCore>g__Core|12_0[TValue,TJsonOptions](HttpClient client, Task`1 responseTask, Boolean usingResponseHeadersRead, CancellationTokenSource linkedCTS, Func`4 deserializeMethod, TJsonOptions jsonOptions, CancellationToken cancellationToken)
   at MediaBrowser.Providers.Plugins.Omdb.OmdbProvider.EnsureSeasonInfo(String seriesImdbId, Int32 seasonId, CancellationToken cancellationToken)
   at MediaBrowser.Providers.Plugins.Omdb.OmdbProvider.GetSeasonRootObject(String imdbId, Int32 seasonId, CancellationToken cancellationToken)
   at MediaBrowser.Providers.Plugins.Omdb.OmdbProvider.FetchEpisodeData[T](MetadataResult`1 itemResult, Int32 episodeNumber, Int32 seasonNumber, String episodeImdbId, String seriesImdbId, String language, String country, CancellationToken cancellationToken)
   at MediaBrowser.Providers.Plugins.Omdb.OmdbEpisodeProvider.GetMetadata(EpisodeInfo info, CancellationToken cancellationToken)
   at MediaBrowser.Providers.Manager.MetadataService`2.ExecuteRemoteProviders(MetadataResult`1 temp, String logName, Boolean replaceData, TIdType id, IEnumerable`1 providers, CancellationToken cancellationToken)
[09:38:30] [ERR] [44] MediaBrowser.Providers.Subtitles.SubtitleManager: Error downloading subtitles from Open Subtitles
System.Security.Authentication.AuthenticationException: Account username and/or password are not set up
   at Jellyfin.Plugin.OpenSubtitles.OpenSubtitleDownloader.Login(CancellationToken cancellationToken)
   at Jellyfin.Plugin.OpenSubtitles.OpenSubtitleDownloader.Search(SubtitleSearchRequest request, CancellationToken cancellationToken)

[j0nnymoe]

It's not our responsibility to backup your data. If you're willing to risk your setup with automatic backups, you're playing with fire. Jellyfin themselves tell you to backup your data before you perform the backup.

This is ultimately why we don't support/recommend automatic updates.

[vellfire]

As seen in the changelog: https://jellyfin.org/posts/jellyfin-release-12.0/

IT IS VERY IMPORTANT THAT YOU READ THIS SECTION BEFORE UPGRADING TO JELLYFIN 12.0! Failure to do so may cause issues! Always feel free to ask for help in our chat if you are unclear or run into trouble.

This release changes the database schema and actively rewrites data on first boot, so a backup is the only way back to your previous version.

1. As always for major upgrades, ensure you STOP Jellyfin and take a FULL MANUAL BACKUP OF YOUR DATA AND CONFIG DIRECTORIES before upgrading!

The bug you are referring to is commonly known as "problem exists between keyboard and chair".

[dnmc919]

It's not our responsibility to backup your data. If you're willing to risk your setup with automatic backups, you're playing with fire. Jellyfin themselves tell you to backup your data before you perform the backup.

This is ultimately why we don't support/recommend automatic updates.

To start, my apologies for messing up my title as I was trying to post here and with the NAS manufacturer at the same time and was trying to copy and paste a lot of the same info to both. So, I got my titles jacked up, but I was focused on the content, which you should have been as well. For those that fancy themselves comedians or just enjoy deflective commentary while dodging the actual issue, this is a bug report of a critical failure on the upgrade. This happened. It is broke. It wiped out the .db. Having worked IT for 30 years, truncating a db to 0 bytes on upgrade = bad.

I am incredibly surprised by the poor quality of responses at this point. Whether a backup was made or not wasn't, or at least shouldn't have been, the focus in this setting. I actually do have a Jellyfin backup that runs weekly. Yes, I know to do this, and I make it a habit to do in-app backups, or manual when not provided, prior to upgrades. But again, this was not the actual issue. It was a recommendation for "what I would like to see", and I still would like to see development move towards a beneficial and precautionary .db copy with certain .db reliant applications like this one. That title was more for the NAS vendor because of what went wrong on their side.

At the same time though, your assumption that automatic backups were the culprit is false. The time spent making uninformed comments was wasted for both of us. Not every environment is going to match what you may use, as all things seek to improve or we wouldn't have Docker versus all the years deploying these apps on virtual linux servers, and before that dedicated hardware. This didn't happen because automatic updates were set. They were not. In my system, Update Detection is on, which I use so I can see in the GUI when new images are available without relying on a ton of notifications from various repositories, and this requires it to see :latest to note a change. For me, this is a great feature. I can click the upgrade button on my test stack, and if good, then go do the same in my production stack. Since automatic updates are not on, it should not have tried to do an update. This only happened because of a power failure that exceeded the UPS, causing the NAS to lose power without the graceful shutdown. When it came on, it seems to have treated everything coming up as a recovery, looked at the :latest flag for the image, which because of the recovery state pulled a new image. As noted, I also have an issue report with the NAS vendor on this, but it is not why the upgrade failed and no one here was being ask to address that. But again, none of this matters to what this bug report was about. None of the previous paragraphs should have been necessary except to clarify far more info than should have been needed.

This is about the upgrade failure that wiped out the database, which should never happen no matter how many backups a person has, or if they manually pulled the new image. Come on guys. You can be better than this with the community. I was trying to help in letting you know. For me, the fix is restoring my database, but I do not want that to be a problem again. The recommendation was to report it with the image repository provider first, which I did. The images here are slightly different, and generally I prefer being standard on LinuxServer images with my environment. If it isn't your concern from the database perspective, let me know that and I will hope over to the official and post there instead.

[j0nnymoe]

If you're willing to risk your setup with automatic backups
First of all, I was supposed to say automatic updates, not backups. I was writing my response while cooking dinner.

For those that fancy themselves comedians or just enjoy deflective commentary while dodging the actual issue, this is a bug report of a critical failure on the upgrade. This happened. It is broke. It wiped out the .db. Having worked IT for 30 years, truncating a db to 0 bytes on upgrade = bad.
We package what jellyfin release, They recommended doing a full backup before the major upgrade because while generally things like this can happen, they don't happen all the time. The new update has been downloaded so far.... 215,890 times and you're the first person I've seen report the issue of a the database getting corrupted. Like with any major upgrade, it's not likely to happen but there is always a risk.

And just a note on how many years you've worked in IT, I've also got a long time in the game and yes having a database nuke itself isn't fun but this is why we always take backups before any major upgrades.

I still would like to see development move towards a beneficial and precautionary .db copy with certain .db reliant applications like this one.
We don't add anything additional to our containers outside of what makes sense/good companions for said applications. Major of applications we provide images for have their own builtin backup solutions or depend on external databases such as mariadb or postgres which you then handle your backups accordingly.

Adding in additional backup functionality would likely be pointless because most users would ask to disable it so it doesn't affect their current backup strategy.

As far as I'm concerned, this isn't a wide spread issue, Jellyfin were aware there might be issues with upgrades hence their recommendation for the backups as there was large changes. Unfortunately I think you just got unlucky with this upgrade, could potentially because by the your NAS running the upgrade as it booted and myself your host filesystem was ready thus wiping it out. Just speculation, I'm not familiar with the ugreen nas platform.

[aptalca]

I'd like to make clear that we are not the developers of jellyfin. We had nothing to do with the upgrade path that resulted in catastrophic data loss.

We are a downstream publisher where we package the upstream app in a docker image. We do not touch jellyfin's database.