2024-06-02, 09:32 PM
Hi TheDreadPirate,
first of all thank you for your answer/question and during my research I saw that you are an extremly helpful member of this forum.
Due to your question, XML files did exist and with this in mind, I had the Idea to just restore an one month old backup to solve the problem. Now I might made things worse. -.-
The backup seemed to actually work, because all shared paths were added, but now I get this error message and don't know why it comes up or how to fix it...
[23:08:51] [FTL] [1] Main: Error while starting server
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 11: 'malformed database schema (1)'.
The following process runs frequently round about every 10min again and again.
Do you have expirience with this error or can tell me how to I probably could fix it. Might there be a problem with the database because I was running Jellyfin 10.8.13 when I created the backup? Or could it be that there is a problem with overwriting still existing database when restoring? Jellyfin docker was stopped while running the backup. ´
I really need help here. Building up all data from scratch won't be a real option.![Confused-face Confused-face](https://static.jellyfin.org/forum/images/smilies/apple_emoji/confused-face.png)
PS: This is the second time when updating Jellyfin, that I had big problems afterwards. In the future I should stick with: "Never change a running system!"
first of all thank you for your answer/question and during my research I saw that you are an extremly helpful member of this forum.
Due to your question, XML files did exist and with this in mind, I had the Idea to just restore an one month old backup to solve the problem. Now I might made things worse. -.-
The backup seemed to actually work, because all shared paths were added, but now I get this error message and don't know why it comes up or how to fix it...
[23:08:51] [FTL] [1] Main: Error while starting server
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 11: 'malformed database schema (1)'.
The following process runs frequently round about every 10min again and again.
Code:
[23:03:38] [INF] [1] Main: Jellyfin version: 10.9.4
[23:03:38] [INF] [1] Main: Environment Variables: ["[JELLYFIN_CONFIG_DIR, /config]", "[JELLYFIN_DATA_DIR, /config/data]", "[JELLYFIN_CACHE_DIR, /config/cache]", "[JELLYFIN_LOG_DIR, /config/log]", "[JELLYFIN_WEB_DIR, /usr/share/jellyfin/web]"]
[23:03:38] [INF] [1] Main: Arguments: ["/usr/lib/jellyfin/bin/jellyfin.dll", "--ffmpeg=/usr/lib/jellyfin-ffmpeg/ffmpeg"]
[23:03:38] [INF] [1] Main: Operating system: Ubuntu 22.04.4 LTS
[23:03:38] [INF] [1] Main: Architecture: X64
[23:03:38] [INF] [1] Main: 64-Bit Process: True
[23:03:38] [INF] [1] Main: User Interactive: True
[23:03:38] [INF] [1] Main: Processor count: 4
[23:03:38] [INF] [1] Main: Program data path: /config/data
[23:03:38] [INF] [1] Main: Log directory path: /config/log
[23:03:38] [INF] [1] Main: Config directory path: /config
[23:03:38] [INF] [1] Main: Cache path: /config/cache
[23:03:38] [INF] [1] Main: Web resources path: /usr/share/jellyfin/web
[23:03:38] [INF] [1] Main: Application directory: /usr/lib/jellyfin/bin/
[23:03:39] [INF] [1] Emby.Server.Implementations.AppBase.BaseConfigurationManager: Setting cache path: /config/cache
[23:08:49] [INF] [1] Emby.Server.Implementations.ApplicationHost: Loading assemblies
[23:08:49] [INF] [1] Emby.Server.Implementations.Plugins.PluginManager: Skipping disabled plugin 6.0.0.0 of Kodi Sync Queue
[23:08:49] [INF] [1] Emby.Server.Implementations.Plugins.PluginManager: Skipping disabled plugin 8.0.0.0 of Kodi Sync Queue
[23:08:49] [INF] [1] Emby.Server.Implementations.Plugins.PluginManager: Skipping disabled plugin 9.0.0.0 of Kodi Sync Queue
[23:08:49] [INF] [1] Jellyfin.Networking.Manager.NetworkManager: Defined LAN subnets:
[23:08:49] [INF] [1] Jellyfin.Networking.Manager.NetworkManager: Defined LAN exclusions: []
[23:08:49] [INF] [1] Jellyfin.Networking.Manager.NetworkManager: Used LAN subnets:
[23:08:49] [INF] [1] Jellyfin.Networking.Manager.NetworkManager: Filtered interface addresses:
[23:08:49] [INF] [1] Jellyfin.Networking.Manager.NetworkManager: Bind Addresses
[23:08:49] [INF] [1] Jellyfin.Networking.Manager.NetworkManager: Remote IP filter is Allowlist
[23:08:49] [INF] [1] Jellyfin.Networking.Manager.NetworkManager: Filtered subnets: []
[23:08:51] [FTL] [1] Main: Error while starting server
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 11: 'malformed database schema (1)'.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements()+MoveNext()
at Microsoft.Data.Sqlite.SqliteCommand.GetStatements()+MoveNext()
at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at Emby.Server.Implementations.Data.SqliteExtensions.Execute(SqliteConnection sqliteConnection, String commandText)
at Emby.Server.Implementations.Data.BaseSqliteRepository.GetConnection()
at Emby.Server.Implementations.Data.BaseSqliteRepository.Initialize()
at Emby.Server.Implementations.Data.SqliteItemRepository.Initialize()
at Emby.Server.Implementations.ApplicationHost.InitializeServices()
at Jellyfin.Server.Program.StartServer(IServerApplicationPaths appPaths, StartupOptions options, IConfiguration startupConfig)
[23:08:51] [INF] [1] Main: Running query planner optimizations in the database... This might take a while
[23:08:51] [INF] [1] Emby.Server.Implementations.ApplicationHost: Disposing CoreAppHost
[23:08:51] [INF] [1] Emby.Server.Implementations.ApplicationHost: Disposing PluginManager
Do you have expirience with this error or can tell me how to I probably could fix it. Might there be a problem with the database because I was running Jellyfin 10.8.13 when I created the backup? Or could it be that there is a problem with overwriting still existing database when restoring? Jellyfin docker was stopped while running the backup. ´
I really need help here. Building up all data from scratch won't be a real option.
![Confused-face Confused-face](https://static.jellyfin.org/forum/images/smilies/apple_emoji/confused-face.png)
PS: This is the second time when updating Jellyfin, that I had big problems afterwards. In the future I should stick with: "Never change a running system!"