SQLite Error 5 on Startup

PowerShell Universal
1 
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:

image
image1310×429 258 KB

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:

image
image711×181 41.8 KB

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

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.

3

Apologies for the delay @adam - I have tested on 5.6.13 and the issue persists.