Page 1 of 1
SQL Command Failed
Posted: February 23rd, 2013, 10:11 am
by bmanusenet
I am on Ubuntu 12.04.1 with Sabnzbd 0.7.11 and the past couple weeks I have been getting quite a few of these errors.
2013-02-23 02:28:48,145 ERROR: SQL Command Failed, see log
I searched the forums, and couldn't really find anything. Something about the download history, not sure what to do or not to do...
Thanks.
Re: SQL Command Failed
Posted: February 23rd, 2013, 10:40 am
by sander
Re: SQL Command Failed
Posted: February 23rd, 2013, 11:37 am
by bmanusenet
Yea all from these forums. Nothing I read seems to say how to stop it.
I know it's harmless, but annoying lol
Re: SQL Command Failed
Posted: February 23rd, 2013, 12:36 pm
by sander
I believe Shypike said you could use "fuser ..." to see which (other) process is locking the file with the sql database ...
EDIT:
I tried fuser on some system running SAB:
Code: Select all
sander@R540:~/.sabnzbd/admin$ fuser -v history1.db
USER PID ACCESS COMMAND
/home/sander/.sabnzbd/admin/history1.db:
sander 27381 F.... sabnzbdplus
sander@R540:~/.sabnzbd/admin$ fuser -v queue9.sab
sander@R540:~/.sabnzbd/admin$
sander@R540:~/.sabnzbd/admin$ fuser -v totals9.sab
sander@R540:~/.sabnzbd/admin$
Looks useful.
Re: SQL Command Failed
Posted: February 23rd, 2013, 1:38 pm
by shypike
Do you happen to have two instances of SABnzbd running?
Re: SQL Command Failed
Posted: February 24th, 2013, 10:54 am
by bmanusenet
Sorry for the late reply. No there is only one instance.
And I have no idea what fuser is and how to use it.
Re: SQL Command Failed
Posted: February 24th, 2013, 3:40 pm
by Eejit
I've occasionally started to get this since installing Newznab on the same PC (windows). I just assumed it was that. Doesn't appear to be causing any trouble.
Re: SQL Command Failed
Posted: February 5th, 2017, 6:04 am
by RyNix420
