mirror of
https://github.com/jellyfin/jellyfin.git
synced 2026-07-16 05:43:54 +03:00
[Issue]: Solution to corrupt database during migration #4827
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @AnonymousWebHacker on GitHub (May 1, 2023).
Please describe your bug
It happens to many that during a server migration, upgrade or forced shutdown, the database is corrupted during a migration or optimization.
Example Logs
The line of error that interests us is the following
What happen ?
During migration, forced stop ..etc, sqlite creates an external database temporarily to organize the data, example
and
/var/lib/jellyfin/*.json<----- Data of the user that was being processed at that moment. you may run into multiple .json files in that path.Solution
Copy the database, to your personal PC, and install sqlitebrowser or any other sqlite database manager (maybe terminal as well)
You are interested in the
UserstableIf I manage to open the previous .json files, I will notice that it is from UserA, and it turns out that in the Users table, that user A, has abnormal values, to the others.
Simply edit, or delete said users .json
Jellyfin Version
10.8.z
if other:
No response
Environment
Jellyfin logs
FFmpeg logs
No response
Please attach any browser or client logs here
No response
Please attach any screenshots here
No response
Code of Conduct
@AnonymousWebHacker commented on GitHub (May 1, 2023):
Fix https://github.com/jellyfin/jellyfin/issues/7928