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?
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