[Issue]: Failure to refresh libraries after update. Readonly database.

[thoja21]

Please describe your bug

Since upgrading to 10.9.5 I see the following exception being thrown in the Jellyfin logs when I refresh a library that has had new videos added.

I'm not familiar with the Jellyfin codebase at all and may be jumping ahead but assume this could be related to the readonly database changes made in the PR: #11969

Reproduction Steps

With 10.9.5 server installed:

1. Add additional files (e.g. videos)
2. Request a library refresh
3. Video/music etc is not added to library and a 'readonly database' exception is thrown.

Jellyfin Version

10.9.0

if other:

No response

Environment

- OS: Ubuntu 23.10
- Linux Kernel: GNU/Linux 6.5.0-35-generic x86_64
- Virtualization: Docker
- Clients: N/A
- Browser: N/A
- FFmpeg Version:
- Playback Method:
- Hardware Acceleration:
- GPU Model:
- Plugins:
- Reverse Proxy:
- Base URL:
- Networking:
- Storage: Local SSD

Jellyfin logs

jellyfin  | [00:07:27] [INF] [1] Main: Startup complete 0:00:43.3183502
jellyfin  | [00:07:28] [INF] [10] Emby.Server.Implementations.ScheduledTasks.TaskManager: Update Plugins Completed after 0 minute(s) and 5 seconds
jellyfin  | [00:07:32] [INF] [16] Emby.Server.Implementations.HttpServer.WebSocketManager: WS 192.168.0.229 request
jellyfin  | [00:07:58] [INF] [23] MediaBrowser.Providers.TV.SeriesMetadataService: Creating Season Season Unknown entry for MyVideo
jellyfin  | [00:08:10] [ERR] [10] MediaBrowser.Providers.Manager.ProviderManager: Error refreshing item
jellyfin  | Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 8: 'attempt to write a readonly database'.
jellyfin  |    at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
jellyfin  |    at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
jellyfin  |    at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
jellyfin  |    at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader()
jellyfin  |    at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
jellyfin  |    at Emby.Server.Implementations.Data.SqliteItemRepository.UpdatePeople(Guid itemId, List`1 people)
jellyfin  |    at Emby.Server.Implementations.Library.LibraryManager.UpdatePeopleAsync(BaseItem item, List`1 people, CancellationToken cancellationToken)
jellyfin  |    at MediaBrowser.Providers.Manager.MetadataService`2.SaveItemAsync(MetadataResult`1 result, ItemUpdateType reason, CancellationToken cancellationToken)
jellyfin  |    at MediaBrowser.Providers.Manager.MetadataService`2.RefreshMetadata(BaseItem item, MetadataRefreshOptions refreshOptions, CancellationToken cancellationToken)
jellyfin  |    at MediaBrowser.Controller.Entities.BaseItem.RefreshMetadata(MetadataRefreshOptions options, CancellationToken cancellationToken)
jellyfin  |    at MediaBrowser.Controller.Entities.TV.Series.RefreshAllMetadata(MetadataRefreshOptions refreshOptions, IProgress`1 progress, CancellationToken cancellationToken)
jellyfin  |    at MediaBrowser.Controller.Entities.Folder.RefreshAllMetadataForContainer(IMetadataContainer container, MetadataRefreshOptions refreshOptions, IProgress`1 progress, CancellationToken cancellationToken)
jellyfin  |    at MediaBrowser.Controller.Entities.Folder.RefreshChildMetadata(BaseItem child, MetadataRefreshOptions refreshOptions, Boolean recursive, IProgress`1 progress, CancellationToken cancellationToken)
jellyfin  |    at MediaBrowser.Controller.Entities.Folder.<>c__DisplayClass69_0`1.<<RunTasks>b__1>d.MoveNext()
jellyfin  | --- End of stack trace from previous location ---
jellyfin  |    at MediaBrowser.Controller.Entities.Folder.RunTasks[T](Func`3 task, IList`1 children, IProgress`1 progress, CancellationToken cancellationToken)
jellyfin  |    at MediaBrowser.Controller.Entities.Folder.ValidateChildrenInternal2(IProgress`1 progress, Boolean recursive, Boolean refreshChildMetadata, Boolean allowRemoveRoot, MetadataRefreshOptions refreshOptions, IDirectoryService directoryService, CancellationToken cancellationToken)
jellyfin  |    at MediaBrowser.Controller.Entities.Folder.ValidateChildrenInternal(IProgress`1 progress, Boolean recursive, Boolean refreshChildMetadata, Boolean allowRemoveRoot, MetadataRefreshOptions refreshOptions, IDirectoryService directoryService, CancellationToken cancellationToken)
jellyfin  |    at MediaBrowser.Providers.Manager.ProviderManager.RefreshCollectionFolderChildren(MetadataRefreshOptions options, CollectionFolder collectionFolder, CancellationToken cancellationToken)
jellyfin  |    at MediaBrowser.Providers.Manager.ProviderManager.RefreshItem(BaseItem item, MetadataRefreshOptions options, CancellationToken cancellationToken)
jellyfin  |    at MediaBrowser.Providers.Manager.ProviderManager.StartProcessingRefreshQueue()

FFmpeg logs

No response

Please attach any browser or client logs here

No response

Please attach any screenshots here

No response

Code of Conduct

• I agree to follow this project's Code of Conduct

[jellyfin-bot]

Hi, it seems like your issue report has the following item(s) that need to be addressed:

• You have not filled in the environment completely.

This is an automated message, currently under testing. Please file an issue here if you encounter any problems.

[thoja21]

Also, to add to this I'm also seeing readonly database exceptions when doing pretty much anything that requires Jellyfin to make updates. E.g. removing favourites:

log.log

[Eldarock]

Same here, can't add new shows or movies : readonly database exceptions
Reverted back to 10.9.4 : issue is not present, and database looks good. Small victory here :)

[oddstr13]

I've been unable to reproduce, but we have been getting multiple reports of this issue from different sources.

[MylesAU]

I've generated debug logs from an occurrence of this issue. Logs start from clicking "Scan All Libraries" in the WebUI Dashboard to the error occurring: https://gist.github.com/MylesAU/bed6360a9f2eff451ac176444acf8ec0

[piratefin]

Have also been seeing exactly the same issue. Only with version 10.9.5 (the issue lists v10.9.0 which i assume is a typo).

[xd003]

I can confirm facing the very same issue on v10.9.5. Hope a hotfix gets released for this one since its kinda critical affecting quite many tasks

[oddstr13]

the issue lists v10.9.0 which i assume is a typo.

issue template default apparently, and the only 10.9 option currently available

[Vucko130]

Same here. Windows 11 64-bit. Reverted back to 10.9.4

[sjorge]

I can consistently trigger it with a 'scan all media', as long as there is some new content to be detected.