SQL Command Failed

[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.

[sander]

75 hits via https://www.google.com/search?source=ig ... abnzbd.org

My experience: harmless error message.

[bmanusenet]

Yea all from these forums. Nothing I read seems to say how to stop it.

I know it's harmless, but annoying lol

[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.

[shypike]

Do you happen to have two instances of SABnzbd running?

[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.

[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.

[RyNix420]

its caused by two SAB's running at the same time , just go to your task manager and get rid of one of them !!!