hi, since this morning i get the following error
OperationalError: database is locked
2013-02-15 10:46:16,767::ERROR::[database:90] SQL Command Failed, see log
2013-02-15 10:46:16,767::DEBUG::[database:91] SQL: SELECT * FROM history WHERE name LIKE ? ORDER BY completed desc LIMIT ?, ?
2013-02-15 10:46:16,767::INFO::[database:92] Traceback:
Traceback (most recent call last):
File "/usr/share/sabnzbdplus/sabnzbd/database.py", line 83, in execute
self.c.execute(command, args)
OperationalError: database is locked
i checked in the forums but couldn't find something.
i restarted sab still the same result; everything works fine. d/l ; queue all is good besides this error i cannot reboot the machine atm.
SQL error database locked
Forum rules
Help us help you:
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.
Re: SQL error database locked
FWIW:
I sometimes see the same thing on my Ubuntu. It doesn't seem to be a real problem (exactly as you say), so I ignore it.
I sometimes see the same thing on my Ubuntu. It doesn't seem to be a real problem (exactly as you say), so I ignore it.
Re: SQL error database locked
This is an inherent thing from the sqlite library.
Their docs and forums claim that the only way an sqlite database file is locked, is when a program has it open.
I've also seen claims by users that a reboot doesn't remedy this, making the previous line doubtful.
Maybe this will help: http://stackoverflow.com/questions/1510 ... e-database
More extensive discussion on the sqlite forum: http://sqlite.1065341.n5.nabble.com/Unl ... 21053.html
We haven't really looked into that, because the issue is so rare.
As a last resort you can try to delete the file admin/history1.db
Their docs and forums claim that the only way an sqlite database file is locked, is when a program has it open.
I've also seen claims by users that a reboot doesn't remedy this, making the previous line doubtful.
Maybe this will help: http://stackoverflow.com/questions/1510 ... e-database
More extensive discussion on the sqlite forum: http://sqlite.1065341.n5.nabble.com/Unl ... 21053.html
We haven't really looked into that, because the issue is so rare.
As a last resort you can try to delete the file admin/history1.db