Page 1 of 1

SQL Command Failed

Posted: August 14th, 2024, 5:47 pm
by paulcyberengel
I'm running version 4.3.2 [8a42abd] in a Docker swarm. I've noticed some odd behavior.

When an item is downloaded, after unpacking or during moving, I start getting SQL Command Failed errors. While this is happening the system stops downloading, the web interface keeps loosing connection to SABnzbd. Connection is restored, only to drop again a few seconds later. When I check the system logs I get repeated "database is locked" errors. If I navigate away from the home page and come back, the history panel is empty.

Once the move is complete, all errors stop and issues stop.

Re: SQL Command Failed

Posted: August 16th, 2024, 2:21 am
by safihre
Where is your database located? It seems your system is blocking access to the database file at the speed that's required, which isn't even that high..