[0.7.20] database.pyo error

Report & discuss bugs found in SABnzbd
Forum rules
Help us help you:
  • Are you using the latest stable version of SABnzbd? Downloads page.
  • Tell us what system you run SABnzbd on.
  • Adhere to the forum rules.
  • Do you experience problems during downloading?
    Check your connection in Status and Interface settings window.
    Use Test Server in Config > Servers.
    We will probably ask you to do a test using only basic settings.
  • Do you experience problems during repair or unpacking?
    Enable +Debug logging in the Status and Interface settings window and share the relevant parts of the log here using [ code ] sections.
Post Reply
User avatar
xadox
Newbie
Newbie
Posts: 21
Joined: September 19th, 2012, 3:57 am

[0.7.20] database.pyo error

Post by xadox »

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?
Greets XadoX
User avatar
sander
Release Testers
Release Testers
Posts: 8829
Joined: January 22nd, 2008, 2:22 pm

Re: [0.7.20] database.pyo error

Post by sander »

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/... ?
User avatar
xadox
Newbie
Newbie
Posts: 21
Joined: September 19th, 2012, 3:57 am

Re: [0.7.20] database.pyo error

Post by xadox »

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)?
Greets XadoX
User avatar
sander
Release Testers
Release Testers
Posts: 8829
Joined: January 22nd, 2008, 2:22 pm

Re: [0.7.20] database.pyo error

Post by sander »

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.
User avatar
xadox
Newbie
Newbie
Posts: 21
Joined: September 19th, 2012, 3:57 am

Re: [0.7.20] database.pyo error

Post by xadox »

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