SQLite Lock Issue on Unraid 7 - Printable Version

SQLite Lock Issue on Unraid 7 - Printable Version

+- Jellyfin Forum (https://forum.jellyfin.org)
+-- Forum: Support (https://forum.jellyfin.org/f-support)
+--- Forum: Troubleshooting (https://forum.jellyfin.org/f-troubleshooting)
+--- Thread: SQLite Lock Issue on Unraid 7 (/t-sqlite-lock-issue-on-unraid-7)

Pages: 1 2

SQLite Lock Issue on Unraid 7 - thymon - 2025-02-04

Hello,

I have to restart my Jellyfin Docker at least three or four times a day due to this type of error:

Code:
[ERR] [132] Jellyfin.Api.Middleware.ExceptionMiddleware: Error processing request. URL POST /Sessions/Playing/Progress.

Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 6: 'database table is locked'.

I don’t know why the database gets locked like this.
I thought this was resolved in your 10.10.5 patch?
What should I do?

I’m running Unraid 7 with the official Jellyfin repository.

Thx in advance

RE: SQLite Lock Issue on Unraid 7 - TheDreadPirate - 2025-02-04

What plugins do you have installed?

RE: SQLite Lock Issue on Unraid 7 - thymon - 2025-02-04

RE: SQLite Lock Issue on Unraid 7 - TheDreadPirate - 2025-02-04

Can you share your full log via privatebin.net?

RE: SQLite Lock Issue on Unraid 7 - thymon - 2025-02-05

Okay, thank you.
I’ll send it to you via PM because it contains all the public IPs.

RE: SQLite Lock Issue on Unraid 7 - TheDreadPirate - 2025-02-05

How much disk space is available for transcodes? With as many users as you have that need transcoding, including live TV users, you would need a lot of space to ensure the transcodes don't fill up your disk.

I don't see anything else that could explain the database locking.

RE: SQLite Lock Issue on Unraid 7 - thymon - 2025-02-05

(2025-02-05, 06:21 PM)TheDreadPirate Wrote: How much disk space is available for transcodes? With as many users as you have that need transcoding, including live TV users, you would need a lot of space to ensure the transcodes don't fill up your disk.

I don't see anything else that could explain the database locking.

A 1TB SSD, and it’s never saturated at any point.

RE: SQLite Lock Issue on Unraid 7 - TheDreadPirate - 2025-02-06

Do you know what file system unRAID uses for the app volume that Jellyfin is writing to?

RE: SQLite Lock Issue on Unraid 7 - thymon - 2025-02-06

(2025-02-06, 01:38 PM)TheDreadPirate Wrote: Do you know what file system unRAID uses for the app volume that Jellyfin is writing to?

yes : XFS

RE: SQLite Lock Issue on Unraid 7 - TheDreadPirate - 2025-02-07

Well, there goes that idea. I was thinking maybe it was ZFS or BTRFS or something (not great choices for databases).