ironmansoftware / issues

Public Issue tracker for Ironman Software products.
https://ironmansoftware.com
31 stars 2 forks source link

Remove temporary SQLite files (*.shl, *.wal) on service startup #3427

Open DataTraveler1 opened 1 week ago

DataTraveler1 commented 1 week ago

Summary of the new feature / enhancement

It can be helpful if the SQLite temporary files would be deleted (or renamed) upon service startup. The reason is that corrupted .shl/.wal file may prevent the startup of the PowerShell Universal service. The error message from MSI install in this scenario will be:

Error 1920. Service 'PowerShell Universal' (PowerShellUniversal) failed to start. Verify that you have sufficient privileges to start system services.

The workaround is to remove the .shl/.wal files and then the service should start normally (#3423 is indirectly related to this feature request). A SQLite database with corrupted temp files is attached 📎 database.zip

Proposed technical implementation details (optional)

An option in the appsettings.json to opt-in or out for this feature could be ideal. It could also possibly be added as a custom action to the MSI installer.