Database locked after latest Update (3.5.2.0)

[fruhnow 0]

Hi there,

 

Yesterday I updated my Emby-Server to Version 3.5.2.0. Before that, everything was running nice and stable.

Right now, after the update, (I guess) nothing regarding the Database works anymore! Before the Update, everything worked just like this.

 

I can test & reproduce this with at least 3 Tasks from the AdminUI (Refresh People, SCAN MEDIA LIBRARY and Refresh TV guide from xmltv source)

 

It looks like this right now: 

(see attachment)

 

 

There is a corresponding Log-Entry, too:

 

 

 

2018-08-02 08:01:49.978 Error TaskManager: Error
    *** Error Report ***
    Version: 3.5.2.0
    Command line: C:\Users\Admin\AppData\Roaming\Emby-Server\system\EmbyServer.dll
    Operating system: Microsoft Windows NT 6.2.9200.0
    64-Bit OS: True
    64-Bit Process: True
    User Interactive: True
    Processor count: 4
    Program data path: C:\Users\Admin\AppData\Roaming\Emby-Server\programdata
    Application directory: C:\Users\Admin\AppData\Roaming\Emby-Server\system
    Busy: database is locked
    SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
     at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
     at SQLitePCL.pretty.StatementImpl.MoveNext()
     at Emby.Server.Implementations.Data.SqliteItemRepository.ExecuteWithSingleParam(IDatabaseConnection db, String query, Byte[] value)
     at Emby.Server.Implementations.Data.SqliteItemRepository.<>c__DisplayClass89_0.<DeleteItem>b__0(IDatabaseConnection db)
     at SQLitePCL.pretty.DatabaseConnection.<>c__DisplayClass20_0.<RunInTransaction>b__0(IDatabaseConnection db)
     at SQLitePCL.pretty.DatabaseConnection.RunInTransaction[T](IDatabaseConnection This, Func`2 f, TransactionMode mode)
     at SQLitePCL.pretty.DatabaseConnection.RunInTransaction(IDatabaseConnection This, Action`1 action, TransactionMode mode)
     at Emby.Server.Implementations.Data.SqliteItemRepository.DeleteItem(Guid id, CancellationToken cancellationToken)
     at Emby.Server.Implementations.Library.LibraryManager.DeleteItem(BaseItem item, DeleteOptions options, BaseItem parent, Boolean notifyParentItem)
     at Emby.Server.Implementations.Library.LibraryManager.DeleteItem(BaseItem item, DeleteOptions options, Boolean notifyParentItem)
     at Emby.Server.Implementations.LiveTv.LiveTvManager.CleanDatabaseInternal(Guid[] currentIdList, String[] validTypes, IProgress`1 progress, CancellationToken cancellationToken)
     at Emby.Server.Implementations.LiveTv.LiveTvManager.RefreshChannelsInternal(IProgress`1 progress, CancellationToken cancellationToken)
     at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal(TaskOptions options)
    SQLitePCL.pretty.SQLiteException
     at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
     at SQLitePCL.pretty.StatementImpl.MoveNext()
     at Emby.Server.Implementations.Data.SqliteItemRepository.ExecuteWithSingleParam(IDatabaseConnection db, String query, Byte[] value)
     at Emby.Server.Implementations.Data.SqliteItemRepository.<>c__DisplayClass89_0.<DeleteItem>b__0(IDatabaseConnection db)
     at SQLitePCL.pretty.DatabaseConnection.<>c__DisplayClass20_0.<RunInTransaction>b__0(IDatabaseConnection db)
     at SQLitePCL.pretty.DatabaseConnection.RunInTransaction[T](IDatabaseConnection This, Func`2 f, TransactionMode mode)
     at SQLitePCL.pretty.DatabaseConnection.RunInTransaction(IDatabaseConnection This, Action`1 action, TransactionMode mode)
     at Emby.Server.Implementations.Data.SqliteItemRepository.DeleteItem(Guid id, CancellationToken cancellationToken)
     at Emby.Server.Implementations.Library.LibraryManager.DeleteItem(BaseItem item, DeleteOptions options, BaseItem parent, Boolean notifyParentItem)
     at Emby.Server.Implementations.Library.LibraryManager.DeleteItem(BaseItem item, DeleteOptions options, Boolean notifyParentItem)
     at Emby.Server.Implementations.LiveTv.LiveTvManager.CleanDatabaseInternal(Guid[] currentIdList, String[] validTypes, IProgress`1 progress, CancellationToken cancellationToken)
     at Emby.Server.Implementations.LiveTv.LiveTvManager.RefreshChannelsInternal(IProgress`1 progress, CancellationToken cancellationToken)
     at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal(TaskOptions options)
    
2018-08-02 08:01:49.978 Info TaskManager: Refresh Guide Failed after 0 minute(s) and 18 seconds

 

 

Looking forward to your response!

fruhnow

[Luke 42080]

Hi, it's not locked after the update. This usually suggests you somehow have two instances of the server running.

 

If you've configured a windows service for emby try disabling and reboot your machine. You may also just have the server process running under two different windows user accounts.