"Trim Db Failed" alerts in Dashboard

[ursusltd 0]

Hi,

 

Last couple of days been seeing the above errors as alerts in the Dashboard. Seems to be coincidental with a disk upgrade I did (D: where I keep movie files, Emby is installed in C:). Using Teracopy, I copied data out from old D: drive to temporary drive and then back to new D: drive so I'm wondering if this is some kind of permissions issue. Found this in log file;

 

 

2019-06-24 00:00:00.122 Error TaskManager: Error

*** Error Report ***

Version: 4.1.1.0

Command line: C:\Users\Lou\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

Runtime: file:///C:/Users/Lou/AppData/Roaming/Emby-Server/system/System.Private.CoreLib.dll

Processor count: 8

Program data path: C:\Users\Lou\AppData\Roaming\Emby-Server

Application directory: C:\Users\Lou\AppData\Roaming\Emby-Server\system

SQLitePCL.pretty.SQLiteException: 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 SQLitePCL.pretty.DatabaseConnection.Execute(IDatabaseConnection This, String sql)

   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 playback_reporting.Data.ActivityRepository.DeleteOldData(Nullable`1 del_before)

   at playback_reporting.TaskCleanDb.<Execute>b__17_0()

   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)

--- End of stack trace from previous location where exception was thrown ---

   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)

--- End of stack trace from previous location where exception was thrown ---

   at playback_reporting.TaskCleanDb.Execute(CancellationToken cancellationToken, IProgress`1 progress)

   at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal(TaskOptions options)

Source: SQLitePCL.pretty

TargetSite: Void CheckOk(SQLitePCL.sqlite3, Int32)

 

2019-06-24 00:00:00.122 Info TaskManager: Trim Db Failed after 0 minute(s) and 0 seconds

[Happy2Play 8281]

@@TeamB

[RobWayBro 27]

I have been seeing these errors also.  Manually running the task so far is always successful.

[Q-Droid 642]

Same here. I just rescheluded the task to run 15 min later so it wouldn't coincide with log rotation and other stuff. It seems to have worked.

[ursusltd 0]

I have run the task manually without problem and changed the scheduled run time.

 

Many thanks for the help!

[Q-Droid 642]

New version (1.4.18.0) with some fixes for DB locking for the above issue.

 

Please update and report if it is still occurring.

 

I'll put the old schedule back and see what happens.

[Q-Droid 642]

No DB lock errors last night running on the original schedule.

[RobWayBro 27]

After I updated and restart, the errors stopped.

[ursusltd 0]

I have run the task manually without problem and changed the scheduled run time.

 

Many thanks for the help!

This has been working fine since change