(SOLVED) Does 10.11.2 fix the slow database?

[muddy]

As i had to wipe/reinstall due to insufficient backups during the migration from 10.10 to 10.11  this fresh install of 10.11 is so slow and causes everything to hang while a scan is going on, does the new patch help at all?

Thanks, 
Muddy

[34626]

To help you, we need some basic informations:
What OS?
Is it a docker-compose setup?
What hardware? (Just to know, if its slow due to hardware limitations?)

[muddy]

I don't use docker.
Dedicated Machine with base Arch Linux and Jellyfin.
10.10 and under were fast and awesome, once my install was corrupted by the 10.11 upgrade I had to wipe and do fresh install at 10.11.1 and it's working again but so slow and laggy, literally breaks the UI as in it will not load until a scan is done.
To Start over I moved
#/etc/jellyfin
#/var/cache/jellyfin
#/var/lib/jellyfin
#/var/log/jellyfin
#/usr/share/jellyfin
directories and restarted Jellyfin to create new config, db , etc

Added back in users and setup libraries etc and it works but just so slow man.
No changes made.

I love Jellyfin and not complaining as it is what it is, FOSS software with no warranty or guarantees

Just trying to find out before I fire off an upgrade if it breaks things further so I can avoid spending the time to restore everything.

Thanks

[jellykrabbypatty]

As i had to wipe/reinstall due to insufficient backups during the migration from 10.10 to 10.11  this fresh install of 10.11 is so slow and causes everything to hang while a scan is going on, does the new patch help at all?

Thanks, 
Muddy

It does not fix the slowness but it doesn't hurt anything from what I've seen if you are already using 10.11.

[34626]

Self hosting does require you to spend time, but why not use docker-compose? I do, and it works great. Currently i am in the process of diving into proxmox VE 9.0 to see if its will be even better :-) (Currently using Debian 13 headless + docker-compose) and also have other services.

[muddy]

Self hosting does require you to spend time, but why not use docker-compose? I do, and it works great. Currently i am in the process of diving into proxmox VE 9.0 to see if its will be even better :-) (Currently using Debian 13 headless + docker-compose) and also have other services.

I hear ya.
Docker is useful, I run many services on it but Jellyfin is not going there.

[muddy]

As i had to wipe/reinstall due to insufficient backups during the migration from 10.10 to 10.11  this fresh install of 10.11 is so slow and causes everything to hang while a scan is going on, does the new patch help at all?

Thanks, 
Muddy

It does not fix the slowness but it doesn't hurt anything from what I've seen if you are already using 10.11.

Thanks, doing a backup now then will give it a shot.
*update* Backup/Upgrade done, seems to work OK, it's still slower than before 10.11.

[T-10]

It might just be problems with arch (those who use Linux know arch is very difficult.) I'm not sure though.

[muddy]

I think I found the issue (or a symptom..)
When doing library scans the sqlite DB crashes out (or tosses constant errors)
I'll tinker with it and see if I can sort something out

Nov 05 19:19:59 jellyfin jellyfin[3388]: [19:19:59] [ERR] Failed executing DbCommand (30,486ms) [Parameters=[@__item_Id_0='?' (DbType = Guid)], CommandType='Text', CommandTimeout='30']
Nov 05 19:19:59 jellyfin jellyfin[3388]: DELETE FROM "BaseItemImageInfos" AS "b"
Nov 05 19:19:59 jellyfin jellyfin[3388]: WHERE "b"."ItemId" = @__item_Id_0
Nov 05 19:19:59 jellyfin jellyfin[3388]: [19:19:59] [ERR] An exception occurred while executing an 'ExecuteDelete' operation for context type 'Jellyfin.Database.Implementations.JellyfinDbContext'.
Nov 05 19:19:59 jellyfin jellyfin[3388]: Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 6: 'database table is locked: BaseItemImageInfos'.
Nov 05 19:19:59 jellyfin jellyfin[3388]:    at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
Nov 05 19:19:59 jellyfin jellyfin[3388]:    at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
Nov 05 19:19:59 jellyfin jellyfin[3388]:    at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
Nov 05 19:19:59 jellyfin jellyfin[3388]:    at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQuery(RelationalCommandParameterObject parameterObject)
Nov 05 19:19:59 jellyfin jellyfin[3388]:    at Microsoft.EntityFrameworkCore.Query.RelationalShapedQueryCompilingExpressionVisitor.<>c.<NonQueryResult>b__31_0(DbContext _, ValueTuple3 state)
Nov 05 19:19:59 jellyfin jellyfin[3388]:    at Microsoft.EntityFrameworkCore.Query.RelationalShapedQueryCompilingExpressionVisitor.NonQueryResult(RelationalQueryContext relationalQueryContext, RelationalCommandResolver relationalCommandResolver, Type contextType, CommandSource commandSource, Boolean threadSafetyChecksEnabled)
Nov 05 19:19:59 jellyfin jellyfin[3388]: Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 6: 'database table is locked: BaseItemImageInfos'.
Nov 05 19:19:59 jellyfin jellyfin[3388]:    at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
Nov 05 19:19:59 jellyfin jellyfin[3388]:    at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
Nov 05 19:19:59 jellyfin jellyfin[3388]:    at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
Nov 05 19:19:59 jellyfin jellyfin[3388]:    at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQuery(RelationalCommandParameterObject parameterObject)
Nov 05 19:19:59 jellyfin jellyfin[3388]:    at Microsoft.EntityFrameworkCore.Query.RelationalShapedQueryCompilingExpressionVisitor.<>c.<NonQueryResult>b__31_0(DbContext _, ValueTuple3 state)
Nov 05 19:19:59 jellyfin jellyfin[3388]:    at Microsoft.EntityFrameworkCore.Query.RelationalShapedQueryCompilingExpressionVisitor.NonQueryResult(RelationalQueryContext relationalQueryContext, RelationalCommandResolver relationalCommandResolver, Type contextType, CommandSource commandSource, Boolean threadSafetyChecksEnabled)
Nov 05 19:19:59 jellyfin jellyfin[3388]: [19:19:59] [ERR] Error refreshing owned items for /storage/video/stuff/more-stuff
Nov 05 19:19:59 jellyfin jellyfin[3388]: Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 6: 'database table is locked: BaseItemImageInfos'.
Nov 05 19:19:59 jellyfin jellyfin[3388]:    at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
Nov 05 19:19:59 jellyfin jellyfin[3388]:    at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
Nov 05 19:19:59 jellyfin jellyfin[3388]:    at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
Nov 05 19:19:59 jellyfin jellyfin[3388]:    at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQuery(RelationalCommandParameterObject parameterObject)
Nov 05 19:19:59 jellyfin jellyfin[3388]:    at Microsoft.EntityFrameworkCore.Query.RelationalShapedQueryCompilingExpressionVisitor.<>c.<NonQueryResult>b__31_0(DbContext _, ValueTuple3 state)
Nov 05 19:19:59 jellyfin jellyfin[3388]:    at Microsoft.EntityFrameworkCore.Query.RelationalShapedQueryCompilingExpressionVisitor.NonQueryResult(RelationalQueryContext relationalQueryContext, RelationalCommandResolver relationalCommandResolver, Type contextType, CommandSource commandSource, Boolean threadSafetyChecksEnabled)
Nov 05 19:19:59 jellyfin jellyfin[3388]:    at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.ExecuteCore[TResult](Expression query, Boolean async, CancellationToken cancellationToken)
Nov 05 19:19:59 jellyfin jellyfin[3388]:    at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.Execute[TResult](Expression query)
Nov 05 19:19:59 jellyfin jellyfin[3388]:    at Jellyfin.Server.Implementations.Item.BaseItemRepository.SaveImages(BaseItem item)
Nov 05 19:19:59 jellyfin jellyfin[3388]:    at Emby.Server.Implementations.Library.LibraryManager.UpdateImagesAsync(BaseItem item, Boolean forceUpdate)
Nov 05 19:19:59 jellyfin jellyfin[3388]:    at MediaBrowser.Controller.Entities.BaseItem.RefreshMetadata(MetadataRefreshOptions options, CancellationToken cancellationToken)
`

I think it's fixed now after some digging found out about the option to adjust the DB setting :
/etc/jellyfin/database.xml

Changed NoLock to Optimistic and restarted Jellyfin, scanned the library that was having issues and it completed.

Thanks all

[Sea Monkey]

SQLite Error 6: 'database table is locked

If you wish to continue fighting with v10.11.x, set the locking mode to optimistic.

It still won't fix everything, but it will fix that.  After days of frustration, I gave up and did a fresh install of v10.10.7, as I unfortunately failed to create a backup prior to upgrading.