SQL Command Failed

Support for the Debian/Ubuntu package, created by JCFP.
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
bmanusenet
Newbie
Newbie
Posts: 31
Joined: April 17th, 2012, 12:13 am

SQL Command Failed

Post 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.
User avatar
sander
Release Testers
Release Testers
Posts: 8811
Joined: January 22nd, 2008, 2:22 pm

Re: SQL Command Failed

Post by sander »

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

My experience: harmless error message.
bmanusenet
Newbie
Newbie
Posts: 31
Joined: April 17th, 2012, 12:13 am

Re: SQL Command Failed

Post 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
User avatar
sander
Release Testers
Release Testers
Posts: 8811
Joined: January 22nd, 2008, 2:22 pm

Re: SQL Command Failed

Post 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.
User avatar
shypike
Administrator
Administrator
Posts: 19774
Joined: January 18th, 2008, 12:49 pm

Re: SQL Command Failed

Post by shypike »

Do you happen to have two instances of SABnzbd running?
bmanusenet
Newbie
Newbie
Posts: 31
Joined: April 17th, 2012, 12:13 am

Re: SQL Command Failed

Post 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.
Eejit
Sr. Member
Sr. Member
Posts: 267
Joined: September 10th, 2008, 5:46 pm

Re: SQL Command Failed

Post 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.
Eejit - The name say's it all !!
Image
RyNix420
Newbie
Newbie
Posts: 1
Joined: February 5th, 2017, 5:55 am

Re: SQL Command Failed

Post by 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 !!! :P ??? ??? :P ::) ;D
Post Reply