2024-06-14, 01:47 PM
(This post was last modified: 2024-06-14, 02:20 PM by LordElber. Edited 3 times in total.)
Hey everyone,
so now I got time to take a deeper look into the problem and was able to solve it.
First of all I checked my database file which was located here ( I use UnRaid + Jellyfin docker):
Database location:
/mnt/user/appdata/jellyfin/data/data/library.db
First I opened the database:
Then I checked its integrity:
It came out, that the database was borked.
Luckily there were 2 other library databases (backups obviously automatically generated by jellyfin during the last docker updates) in that folder:
library.db.bak1
library.db.bak2
So I did the PRAGMA integrity_check also on those two databases. It came out, that library.db.bak2 was borked, but library.db.bak1 was ok.
So I deleted the following borked databases.
library.db
library.db-wab
library.de-shm
library.db.bak2
Then I moved library.db.bak1 to library.db and started Jellyfin Docker again and it worked.
Jellyfin automatically recreated the databases library.db-wab and library.de-shm new.
PS: You in case need to make sure that the database file has the right owner. Just check your other jellyfin files and change that in case. E.g.: When I copied the database, it create the new database with owner root:root. To change this into another owner just:
In this example the new owner would be jellyfin:jellyfin, but in my case it was users:?.
And: Once again thanks to TheDreadPirate for his frequent supply here!
so now I got time to take a deeper look into the problem and was able to solve it.
First of all I checked my database file which was located here ( I use UnRaid + Jellyfin docker):
Database location:
/mnt/user/appdata/jellyfin/data/data/library.db
First I opened the database:
Code:
sqlite3 library.db
Then I checked its integrity:
Code:
PRAGMA integrity_check;
It came out, that the database was borked.
Luckily there were 2 other library databases (backups obviously automatically generated by jellyfin during the last docker updates) in that folder:
library.db.bak1
library.db.bak2
So I did the PRAGMA integrity_check also on those two databases. It came out, that library.db.bak2 was borked, but library.db.bak1 was ok.
So I deleted the following borked databases.
library.db
library.db-wab
library.de-shm
library.db.bak2
Then I moved library.db.bak1 to library.db and started Jellyfin Docker again and it worked.
Code:
mv library.db.bak1 library.db
Jellyfin automatically recreated the databases library.db-wab and library.de-shm new.
PS: You in case need to make sure that the database file has the right owner. Just check your other jellyfin files and change that in case. E.g.: When I copied the database, it create the new database with owner root:root. To change this into another owner just:
Code:
sudo chown jellyfin:jellyfin /mnt/user/appdata/jellyfin/data/data/library.db
And: Once again thanks to TheDreadPirate for his frequent supply here!