SQLite Database Locking issue when running 5.6.10

SQLite Database Locking issue when running 5.6.10

Applicability
Users that are running PowerShell Universal 5.6.10 and using the default SQLite database may experience database locking issues that cause the platform to hang. 
Root Cause
The PowerShell Universal groom job implemented a database optimization feature in 5.6.10 to compress and defragment the database. This operation is running too frequently in this version and can cause the platform to hang while it is occurring. 
Workaround
To work around this issue, reduce the frequency of the groom job by clicking Settings \ General \ Data and reducing the groom interval to 12 or 24 hours rather than 1 minute. 

    • Related Articles

    • KB0051 - Viewing database contents

      Purpose The purpose of this document is to provide steps for viewing the PowerShell Universal database. Process PowerShell Universal v3 and v4 - LiteDB To view the LiteDB database for PowerShell Universal, you can use LiteDB Studio. PowerShell ...

    • KB0080 - Failed to Locate Secret in Database or Vault

      Scope Users running PowerShell Universal 5.0.16 attempting to run a script as another user based on a new secret PSCredential variable. Problem When attempting to run the script as the user stored in the PSCredential secret, the application reports ...

    • KB0078 - Service fails to start during PowerShell Universal v5 Upgrade when using SQLite and MSI

      Scope Users that are upgrading from PowerShell Universal v4 to PowerShell Universal v5 using the MSI and SQLite persistence database. Problem The service may not start in a timely manner and cause the MSI process to fail. Root Cause PowerShell ...

    • "Did not receive port from client process." when running jobs

      Version: Any Problem: When executing jobs, jobs can fail without starting the PowerShell script. Within the PowerShell Universal logs, you will see an error that states: Did not receive port from client process. Root Cause: When running in ...

    • KB0060 - Running Side-By-Side PowerShell Universal Instances

      Purpose The purpose of this document is to outline how to run side-by-side instances of PowerShell Universal on the same machine. These instances will have their own configuration settings and port. This can be useful for testing between versions. ...