Jellyfin

• Fix Jellyfin Database (upgrade from 10.11.11 to 12.1)

Fix Jellyfin Database (upgrade from 10.11.11 to 12.1)

I had a corrupted Database, I took these steps to fix it. Make backups:

systemctl stop jellyfin

apt install sqlite3
cd /var/lib/jellyfin/data
cp jellyfin.db jellyfin.db.bak
sqlite3 jellyfin.db ".recover" | sqlite3 jellyfin.db.recovered
sqlite3 jellyfin.db.recovered "PRAGMA integrity_check;"

The check should return OK. If it outputs rows, you have to delete them: (Make sure to delete your own rows and not just copy pasting mine)

DELETE FROM BaseItemProviders WHERE rowid = 45789;

DELETE FROM BaseItemProviders
WHERE ItemId NOT IN (SELECT Id FROM BaseItems)
   OR ItemId GLOB '*[!0-9A-Fa-f-]*';

run the check again

PRAGMA integrity_check;

it should return OK, if it does type .quit

Then I removed the encoding.xml

mv /etc/jellyfin/encoding.xml /etc/jellyfin/encoding.xml.old`

Then I upgraded jellyfin

apt update && apt dist-upgrade -y

Now the upgrade goes as intended but takes a while