(SOLVED) Does 10.11.2 fix the slow database?

[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