SQLite Error 5 on Startup
Product: PowerShell Universal Version: 5.6.9
Hosting via IIS 10
v5.6.9
I’m having an issue where the database is locked within 10 minutes of server startup:
I can confirm that no other scripts are scheduled between 8:13 and 8:20 AM and no API logs were generated during that time. Thus, it seems that upon the first run of anything the database was already locked. After this, it stays locked.
Associated handles only show PSU IIS process:
Has anyone else had this issue, specifically on 5.6.9? I saw in 5.6.11 the groom job fix was rolled back, but also reports that it continued to occur.
@Adam Driscoll
6c79d13fdea59d1a38690ebb48cafcb7d1fb0b7a.png
1d7b717473bc47e0e39342122140411b2f92348a.jpeg
All Comments (2)
Others have reported this but we haven’t identified why. It behaves very much like you are seeing, where it almost immediately is locked but you aren’t really doing anything.
I’ve tested in numerous environments and I cannot reproduce this. I’m curious if you can try with 5.6.13, because we did identify a object pinning issue related to the database. That said, it wasn’t fixed because of the locking and only because of memory growth in really busy servers.
Adam Driscoll
PowerShell Expert and Developer at Devolutions
Apologies for the delay @Adam Driscoll - I have tested on 5.6.13 and the issue persists.