SABnzbd Forums

Posted: **June 12th, 2015, 1:55 am**

I am using SABnzbd 0.7.20 on a Windows 2012 R2 Server.
I am starting SABnzbd with the Parameter F, so a different location of the INI ist used.

Somethimes there is the following error occuring:

Code: Select all

2015-06-12 08:46:17,210::ERROR::[database:111] SQL Command Failed, see log
2015-06-12 08:46:17,210::DEBUG::[database:112] SQL: select count(*) from History WHERE name LIKE ?
2015-06-12 08:46:17,210::INFO::[database:113] Traceback: 
Traceback (most recent call last):
  File "sabnzbd\database.pyo", line 104, in execute
OperationalError: database is locked
2015-06-12 08:46:17,256::ERROR::[database:111] SQL Command Failed, see log
2015-06-12 08:46:17,256::DEBUG::[database:112] SQL: SELECT * FROM history WHERE name LIKE ? ORDER BY completed desc LIMIT ?, ?
2015-06-12 08:46:17,256::INFO::[database:113] Traceback: 
Traceback (most recent call last):
  File "sabnzbd\database.pyo", line 104, in execute
OperationalError: database is locked

Somehow I can not find a file called database.pyo?

Posted: **June 12th, 2015, 6:42 am**

No, no problem with database.pyo.

The problem is this: "database is locked".

So:
- is another SABnzbd running?
- if not: has the account under which you're running SAB full (write) rights to the files in .sabnzbd/admin/... ?

Posted: **June 12th, 2015, 7:18 am**

is another SABnzbd running?

No.

has the account under which you're running SAB full (write) rights to the files in .sabnzbd/admin/... ?

Yes. Already readded rights to the folder.
Do I have to start SABnzbd with UAE Admin rights (right click, start as admin)?

Posted: **June 12th, 2015, 7:37 am**

Yes, try that. Or run CMD.EXE as admin, and then run sabnzbd-console.exe from that

Formal answer: I believe on Windows even Admin not always has all rights to all files and directories. In such cases, an Admin can explicitly take ownership, but that is not done implicitly. The good thing about this: an Admin can not silently look into other users' files. After explicity taking ownership, it is clear to a user that this has been done by Admin.
However, this is knowledge from 1996 or so. Please ignore! ;-)

So, first step: just try to run as Admin.

Posted: **June 15th, 2015, 2:41 am**

I have installed sabnzbd as service now. While running as service the error was not occuring anymore.

SABnzbd Forums

[0.7.20] database.pyo error

[0.7.20] database.pyo error

Re: [0.7.20] database.pyo error

Re: [0.7.20] database.pyo error

Re: [0.7.20] database.pyo error

Re: [0.7.20] database.pyo error