Devolutions ForumDevolutions Forum

Regular error SQLite Error 5

Regular error SQLite Error 5

avatar
jerome02

Hello,

II have just installed version 5 on a new server. When I try to run a script, for example, after making changes I regularly get the SQLite error Error 5: ‘database is locked’.

Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
   at PowerShellUniversal.Extensibility.EFTable`2.Insert(T item) in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.Extensibility\Persistence\EFTable.cs:line 149
   at UniversalDashboard.DashboardHub.OnConnectedAsync() in C:\actions-runner\_work\universal\universal\src\Universal.Server\Hubs\DashboardHub.cs:line 72
   at Microsoft.AspNetCore.SignalR.Internal.DefaultHubDispatcher`1.OnConnectedAsync(HubConnectionContext connection)
   at Microsoft.AspNetCore.SignalR.Internal.DefaultHubDispatcher`1.OnConnectedAsync(HubConnectionContext connection)
   at Microsoft.AspNetCore.SignalR.HubConnectionHandler`1.RunHubAsync(HubConnectionContext connection)


I’ve redone a clean install (appliance and same new server) but I still get the error.
the error isn’t blocking, you just have to wait a few tenths of a second and the error disappears, but it’s restrictive. has anyone ever had this problem?

avatar
Adam Driscoll

Recommended Answer

We have a fix coming for this in 5.0.2. I’m seeing it in my environment as well.

Adam Driscoll
PowerShell Expert and Developer at Devolutions

All Comments (2)

avatar
Adam Driscoll

We have a fix coming for this in 5.0.2. I’m seeing it in my environment as well.

Adam Driscoll
PowerShell Expert and Developer at Devolutions

avatar

I’ve the error on version 5.0.4 after upgarde from 4.3.4

2024-08-29 15:14:05.698 +02:00 [INF] Finished groom job.
2024-08-29 15:14:32.539 +02:00 [ERR] Failed to report progress
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
   at PowerShellUniversal.Extensibility.EFTable`2.Update(T item) in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.Extensibility\Persistence\EFTable.cs:line 282
   at UniversalAutomation.ExecutionCallback.ReportProgress(JobProgress request) in C:\actions-runner\_work\universal\universal\src\Universal.Server\Services\Automation\ExecutionService.cs:line 836
2024-08-29 15:14:32.977 +02:00 [ERR] Failed to report progress
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
   at PowerShellUniversal.Extensibility.EFTable`2.Update(T item) in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.Extensibility\Persistence\EFTable.cs:line 282
   at UniversalAutomation.ExecutionCallback.ReportProgress(JobProgress request) in C:\actions-runner\_work\universal\universal\src\Universal.Server\Services\Automation\ExecutionService.cs:line 836
2024-08-29 15:14:35.711 +02:00 [ERR] Failed to report progress
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
   at PowerShellUniversal.Extensibility.EFTable`2.Update(T item) in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.Extensibility\Persistence\EFTable.cs:line 282
   at UniversalAutomation.ExecutionCallback.ReportProgress(JobProgress request) in C:\actions-runner\_work\universal\universal\src\Universal.Server\Services\Automation\ExecutionService.cs:line 836
2024-08-29 15:14:39.732 +02:00 [ERR] Failed to report progress
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
   at PowerShellUniversal.Extensibility.EFTable`2.Update(T item) in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.Extensibility\Persistence\EFTable.cs:line 282
   at UniversalAutomation.ExecutionCallback.ReportProgress(JobProgress request) in C:\actions-runner\_work\universal\universal\src\Universal.Server\Services\Automation\ExecutionService.cs:line 836
2024-08-29 15:14:41.391 +02:00 [ERR] Failed to report progress
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
   at PowerShellUniversal.Extensibility.EFTable`2.Update(T item) in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.Extensibility\Persistence\EFTable.cs:line 282
   at UniversalAutomation.ExecutionCallback.ReportProgress(JobProgress request) in C:\actions-runner\_work\universal\universal\src\Universal.Server\Services\Automation\ExecutionService.cs:line 836
2024-08-29 15:14:43.140 +02:00 [ERR] Failed to report progress
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
   at PowerShellUniversal.Extensibility.EFTable`2.Update(T item) in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.Extensibility\Persistence\EFTable.cs:line 282
   at UniversalAutomation.ExecutionCallback.ReportProgress(JobProgress request) in C:\actions-runner\_work\universal\universal\src\Universal.Server\Services\Automation\ExecutionService.cs:line 836
2024-08-29 15:14:45.333 +02:00 [ERR] Failed to report progress
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
   at PowerShellUniversal.Extensibility.EFTable`2.Update(T item) in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.Extensibility\Persistence\EFTable.cs:line 282
   at UniversalAutomation.ExecutionCallback.ReportProgress(JobProgress request) in C:\actions-runner\_work\universal\universal\src\Universal.Server\Services\Automation\ExecutionService.cs:line 836
2024-08-29 15:14:46.362 +02:00 [ERR] Failed to report progress
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
   at PowerShellUniversal.Extensibility.EFTable`2.Update(T item) in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.Extensibility\Persistence\EFTable.cs:line 282
   at UniversalAutomation.ExecutionCallback.ReportProgress(JobProgress request) in C:\actions-runner\_work\universal\universal\src\Universal.Server\Services\Automation\ExecutionService.cs:line 836
2024-08-29 15:14:47.531 +02:00 [ERR] Failed to report progress
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
   at PowerShellUniversal.Extensibility.EFTable`2.Update(T item) in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.Extensibility\Persistence\EFTable.cs:line 282
   at UniversalAutomation.ExecutionCallback.ReportProgress(JobProgress request) in C:\actions-runner\_work\universal\universal\src\Universal.Server\Services\Automation\ExecutionService.cs:line 836
2024-08-29 15:14:49.589 +02:00 [ERR] Failed to report progress
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
   at PowerShellUniversal.Extensibility.EFTable`2.Update(T item) in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.Extensibility\Persistence\EFTable.cs:line 282
   at UniversalAutomation.ExecutionCallback.ReportProgress(JobProgress request) in C:\actions-runner\_work\universal\universal\src\Universal.Server\Services\Automation\ExecutionService.cs:line 836
2024-08-29 15:14:51.676 +02:00 [ERR] Failed to report progress
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
   at PowerShellUniversal.Extensibility.EFTable`2.Update(T item) in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.Extensibility\Persistence\EFTable.cs:line 282
   at UniversalAutomation.ExecutionCallback.ReportProgress(JobProgress request) in C:\actions-runner\_work\universal\universal\src\Universal.Server\Services\Automation\ExecutionService.cs:line 836
2024-08-29 15:14:52.281 +02:00 [ERR] Failed to report progress
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
   at PowerShellUniversal.Extensibility.EFTable`2.Update(T item) in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.Extensibility\Persistence\EFTable.cs:line 282
   at UniversalAutomation.ExecutionCallback.ReportProgress(JobProgress request) in C:\actions-runner\_work\universal\universal\src\Universal.Server\Services\Automation\ExecutionService.cs:line 836
2024-08-29 15:14:53.471 +02:00 [ERR] Failed to report progress
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
   at PowerShellUniversal.Extensibility.EFTable`2.Update(T item) in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.Extensibility\Persistence\EFTable.cs:line 282
   at UniversalAutomation.ExecutionCallback.ReportProgress(JobProgress request) in C:\actions-runner\_work\universal\universal\src\Universal.Server\Services\Automation\ExecutionService.cs:line 836
2024-08-29 15:14:55.254 +02:00 [ERR] Failed to report progress
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
   at PowerShellUniversal.Extensibility.EFTable`2.Update(T item) in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.Extensibility\Persistence\EFTable.cs:line 282
   at UniversalAutomation.ExecutionCallback.ReportProgress(JobProgress request) in C:\actions-runner\_work\universal\universal\src\Universal.Server\Services\Automation\ExecutionService.cs:line 836
2024-08-29 15:14:57.057 +02:00 [ERR] Failed to report progress
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
   at PowerShellUniversal.Extensibility.EFTable`2.Update(T item) in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.Extensibility\Persistence\EFTable.cs:line 282
   at UniversalAutomation.ExecutionCallback.ReportProgress(JobProgress request) in C:\actions-runner\_work\universal\universal\src\Universal.Server\Services\Automation\ExecutionService.cs:line 836
2024-08-29 15:14:57.342 +02:00 [ERR] Failed to report progress
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
   at PowerShellUniversal.Extensibility.EFTable`2.Update(T item) in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.Extensibility\Persistence\EFTable.cs:line 282
   at UniversalAutomation.ExecutionCallback.ReportProgress(JobProgress request) in C:\actions-runner\_work\universal\universal\src\Universal.Server\Services\Automation\ExecutionService.cs:line 836
2024-08-29 15:15:12.817 +02:00 [INF] Starting heartbeat job.
2024-08-29 15:15:12.821 +02:00 [INF] Starting module discovery using Process.
2024-08-29 15:15:12.822 +02:00 [INF] Starting groom job.
2024-08-29 15:15:12.825 +02:00 [INF] Script BetterCollab-Status.ps1 has a max history of 100
2024-08-29 15:15:12.829 +02:00 [INF] Starting module discovery using Process.
2024-08-29 15:15:12.840 +02:00 [INF] Starting module discovery using Process.
2024-08-29 15:15:12.852 +02:00 [INF] Finished heartbeat job.
2024-08-29 15:15:12.869 +02:00 [INF] Script has 0 jobs to delete.
2024-08-29 15:15:12.869 +02:00 [INF] Script BetterCollab-Create.ps1 has a max history of 100
2024-08-29 15:15:12.873 +02:00 [INF] Script has 0 jobs to delete.
2024-08-29 15:15:12.873 +02:00 [INF] Script Register-Credentials.ps1 has a max history of 100
2024-08-29 15:15:12.875 +02:00 [INF] Script has 0 jobs to delete.
2024-08-29 15:15:12.875 +02:00 [INF] Script BetterCollab-Archiving.ps1 has a max history of 100
2024-08-29 15:15:12.877 +02:00 [INF] Script has 0 jobs to delete.
2024-08-29 15:15:12.877 +02:00 [INF] Script Postbox-Order-Automation.ps1 has a max history of 100
2024-08-29 15:15:12.887 +02:00 [INF] Script has 0 jobs to delete.


2024-08-29 15:05:25.409 +02:00 [INF] Quartz scheduler 'QuartzScheduler' initialized
2024-08-29 15:05:25.409 +02:00 [INF] Quartz scheduler version: 3.3.3.0
2024-08-29 15:05:25.413 +02:00 [INF] Scheduler QuartzScheduler_$_NON_CLUSTERED started.
2024-08-29 15:05:25.424 +02:00 [INF] Dashboard configuration complete.
2024-08-29 15:05:30.366 +02:00 [INF] PSModulePath (PowerShell 7) - C:\Program Files (x86)\Universal\Modules;C:\Program Files\PowerShell\Modules;C:\Program Files (x86)\Universal\Modules;C:\Program Files (x86)\Universal\Modules;C:\Program Files\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules;C:\Program Files (x86)\Universal\Modules;C:\ProgramData\UniversalAutomation\Repository\Modules;C:\Program Files (x86)\Universal\UniversalDashboard\Components;C:\ProgramData\UniversalAutomation\Repository\Components
2024-08-29 15:05:32.908 +02:00 [INF] PSModulePath (PowerShell 7) - C:\Program Files (x86)\Universal\Agents\5.1\Modules;C:\Program Files\PowerShell\Modules;C:\Program Files (x86)\Universal\Modules;C:\Program Files (x86)\Universal\Modules;C:\Program Files\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules;C:\Program Files (x86)\Universal\Modules;C:\ProgramData\UniversalAutomation\Repository\Modules;C:\Program Files (x86)\Universal\UniversalDashboard\Components;C:\ProgramData\UniversalAutomation\Repository\Components
2024-08-29 15:06:22.693 +02:00 [INF] ExecuteScript
2024-08-29 15:07:20.574 +02:00 [INF] Creating services.
2024-08-29 15:07:20.982 +02:00 [INF] Starting scheduler.
2024-08-29 15:07:21.003 +02:00 [INF] Scheduler QuartzScheduler_$_NON_CLUSTERED started.
2024-08-29 15:07:21.004 +02:00 [INF] Dashboard configuration complete.
2024-08-29 15:07:38.569 +02:00 [INF] ExecuteScript
2024-08-29 15:12:05.596 +02:00 [WRN] Failed to process the job 'c18f0cca-188a-43cb-8bca-72c5c02ac371': an exception occured. Job was automatically deleted because the retry attempt count exceeded 0.
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
   at PowerShellUniversal.Extensibility.EFTable`2.Update(T item) in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.Extensibility\Persistence\EFTable.cs:line 282
   at UniversalAutomation.HeartBeatService.Run() in C:\actions-runner\_work\universal\universal\src\Universal.Server\Services\HeartBeatService.cs:line 81
   at InvokeStub_HeartBeatService.Run(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
2024-08-29 15:14:05.647 +02:00 [WRN] Failed to process the job '7e282cd2-349f-4c22-90a0-8d9b444eb121': an exception occured. Job was automatically deleted because the retry attempt count exceeded 0.
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
   at PowerShellUniversal.Extensibility.EFTable`2.Update(T item) in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.Extensibility\Persistence\EFTable.cs:line 282
   at UniversalAutomation.HeartBeatService.Run() in C:\actions-runner\_work\universal\universal\src\Universal.Server\Services\HeartBeatService.cs:line 81
   at InvokeStub_HeartBeatService.Run(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
2024-08-29 15:15:17.875 +02:00 [INF] PSModulePath (PowerShell 7) - C:\Program Files (x86)\Universal\Modules;C:\Program Files\PowerShell\Modules;C:\Program Files (x86)\Universal\Modules;C:\Program Files (x86)\Universal\Modules;C:\Program Files\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules;C:\Program Files (x86)\Universal\Modules;C:\ProgramData\UniversalAutomation\Repository\Modules;C:\Program Files (x86)\Universal\UniversalDashboard\Components;C:\ProgramData\UniversalAutomation\Repository\Components


then the service crashed and stopped