mirror of
https://github.com/jellyfin/jellyfin.git
synced 2026-01-24 07:30:57 +01:00
SQLite Error 5: 'unable to delete/modify user-function due to active statements' #7233
Labels
No labels
area:database
awaiting-feedback
backend
blocked
breaking change: web api
bug
build
ci
confirmed
discussion needed
dotnet future
downstream
duplicate
EFjellyfin.db
enhancement
feature
future
github-actions
good first issue
hdr
help wanted
invalid
investigation
librarydb
live-tv
lyrics
media playback
music
needs testing
nuget
performance
platform
pull-request
question
regression
release critical
requires-web
roadmap
security
security
stale
support
syncplay
ui & ux
upstream
wontfix
No milestone
No project
No assignees
1 participant
Notifications
Due date
No due date set.
Dependencies
No dependencies set.
Reference: starred/jellyfin#7233
Loading…
Add table
Add a link
Reference in a new issue
No description provided.
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 @Hello-World-Traveler on GitHub (Aug 9, 2025).
Description of the bug
No effect that I notice. Logging issue before it becomes a problem.
This error occurs when there are active SQL statements running, preventing changes to user-defined functions in SQLite. To resolve it, ensure that no other operations are using the database connection when attempting to modify or delete functions.
"The error you are running into is caused by trying to access Sqlite from multiple threads. Concurrency is supported up to a point (when read-only operations are performed) but once you start inserting or updating records things get tricky." - Stack Overflow
Reproduction steps
N/A
What is the current bug behavior?
Unable to delete/modify inside db
What is the expected correct behavior?
No error
Jellyfin Server version
10.10.0+
Specify commit id
No response
Specify unstable release number
No response
Specify version number
No response
Specify the build version
10.10.7
Environment
Jellyfin logs
FFmpeg logs
Client / Browser logs
No response
Relevant screenshots or videos
No response
Additional information
No response
@CLepetitL commented on GitHub (Sep 29, 2025):
Up, same here
[06:55:04] [ERR] [66] Jellyfin.Api.Middleware.ExceptionMiddleware: Error processing request. URL GET /Shows/a0caf273fb611d4d641687059d6f2355/Seasons.
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'unable to delete/modify user-function due to active statements'.
[06:57:29] [ERR] [15] Jellyfin.Api.Middleware.ExceptionMiddleware: Error processing request. URL GET /Items/Latest.
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'not an error'.
[07:00:00] [ERR] [68] Microsoft.EntityFrameworkCore.Database.Connection: An error occurred using the connection to database 'main' on server '/config/data/data/jellyfin.db'.
[07:00:00] [ERR] [68] Microsoft.EntityFrameworkCore.Query: An exception occurred while iterating over the results of a query for context type 'Jellyfin.Server.Implementations.JellyfinDbContext'.
System.ObjectDisposedException: Cannot access a disposed object.
Object name: 'SQLitePCL.sqlite3'.
@ivanjx commented on GitHub (Nov 4, 2025):
still happening on 10.11.1
@theguymadmax commented on GitHub (Dec 2, 2025):
Closing as dupe of: #15149
@Hello-World-Traveler commented on GitHub (Dec 2, 2025):
@theguymadmax This issue came first.
@shaohme commented on GitHub (Dec 9, 2025):
Still happening on 10.11.4