OperationalError: database is locked during postprocessing

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
zen0n
Newbie
Newbie
Posts: 3
Joined: May 11th, 2011, 7:21 pm

OperationalError: database is locked during postprocessing

Post by zen0n »

Hey guys, I'm having some weird sporadic issues with my sab setup. From time to time I will start getting these OperationalError messages popping up in the log as sab runs the sabtosickbeard script or autoProcessMovie. Im pretty sure most post processing is getting done, the files end up in the correct directories. But when I click on the log symbol in the plush uI I get some weird html output lot the proper log output.

Info on my setup, running debian jessie 3.10-3-amd64, with sabnzbd 0.7.16-1

Here's what it looks like in the sab logs

Code: Select all

2013-09-29 15:48:31,139::INFO::[postproc:342] unpack_magic finished on Breaking.Bad.S05E16.720p.HDTV.x264-IMMERSE
2013-09-29 15:48:31,140::INFO::[newsunpack:144] Running external script /var/stuff/sab/scripts/sabToSickBeard.py(/var/stuff/media/tv/Breaking.Bad.S05E16.720p.HDTV.x264-IM
MERSE, Breaking.Bad.S05E16.720p.HDTV.x264-IMMERSE.nzb, Breaking.Bad.S05E16.720p.HDTV.x264-IMMERSE, , tv, alt.binaries.teevee, 0)
2013-09-29 15:48:40,313::ERROR::[database:111] SQL Command Failed, see log
2013-09-29 15:48:40,313::INFO::[database:113] Traceback:
Traceback (most recent call last):
  File "/usr/share/sabnzbdplus/sabnzbd/database.py", line 104, in execute
    self.c.execute(command, args)
OperationalError: database is locked
2013-09-29 15:48:40,577::ERROR::[database:111] SQL Command Failed, see log
2013-09-29 15:48:40,584::INFO::[database:113] Traceback:
Traceback (most recent call last):
  File "/usr/share/sabnzbdplus/sabnzbd/database.py", line 104, in execute
    self.c.execute(command, args)
OperationalError: database is locked
2013-09-29 15:48:41,918::ERROR::[database:111] SQL Command Failed, see log
2013-09-29 15:48:41,919::INFO::[database:113] Traceback:
Traceback (most recent call last):
  File "/usr/share/sabnzbdplus/sabnzbd/database.py", line 104, in execute
    self.c.execute(command, args)
OperationalError: database is locked
2013-09-29 15:48:42,258::INFO::[postproc:521] Cleaning up Breaking.Bad.S05E16.720p.HDTV.x264-IMMERSE (keep_basic=False)
And the snippet that comes up in the plush ui when you click on log, different release from above, I had cleared the history.

Code: Select all

 Loading config from /var/stuff/sab/scripts/autoProcessTV.cfg
Opening URL: http://192.168.0.10:8081/home/postprocess/processEpisode?nzbName=Breaking.Bad.S05E16.720p.HDTV.x264-IMMERSE.nzb&quiet=1&dir=%2Fvar%2Fstuff%2Fmedia%2Ftv%2FBreaking.Bad.S05E16.720p.HDTV.x264-IMMERSE
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>

<head>

    <meta http-equiv="Content-Type" content="text/html; charset=utf-8"></meta>

    <title>500 Internal Server Error</title>

    <style type="text/css">

    #powered_by {

        margin-top: 20px;

        border-top: 2px solid black;

        font-style: italic;

    }



    #traceback {

        color: red;

    }

    </style>

</head>

    <body>

        <h2>500 Internal Server Error</h2>

        <p>The server encountered an unexpected condition which prevented it from fulfilling the request.</p>

        <pre id="traceback">Traceback (most recent call last):

  File "/opt/sickbeard/cherrypy/_cprequest.py", line 660, in respond

    response.body = self.handler()

  File "/opt/sickbeard/cherrypy/lib/encoding.py", line 193, in __call__

    self.body = self.oldhandler(*args, **kwargs)

  File "/opt/sickbeard/cherrypy/_cpdispatch.py", line 25, in __call__

    return self.callable(*self.args, **self.kwargs)

  File "/opt/sickbeard/sickbeard/webserve.py", line 1511, in processEpisode

    result = processTV.processDir(dir, nzbName)

  File "/opt/sickbeard/sickbeard/processTV.py", line 108, in processDir

    process_result = processor.process()

  File "/opt/sickbeard/sickbeard/postProcessor.py", line 858, in process

    notifiers.xbmc_notifier.update_library(ep_obj.show.name)

  File "/opt/sickbeard/sickbeard/notifiers/xbmc.py", line 496, in update_library

    if not self._update_library_json(curHost, showName) and sickbeard.XBMC_UPDATE_FULL:

  File "/opt/sickbeard/sickbeard/notifiers/xbmc.py", line 390, in _update_library_json

    shows = showsResponse["result"]["tvshows"]

KeyError: 'tvshows'

</pre>

    <div id="powered_by">

    <span>Powered by <a href="http://www.cherrypy.org">CherryPy 3.2.0rc1</a></span>

    </div>

    </body>

</html>
Top
User avatar
shypike
Administrator
Administrator
Posts: 19774
Joined: January 18th, 2008, 12:49 pm

Re: OperationalError: database is locked during postprocessi

Post by shypike »

Hmmm, sounds like some bug in the SQLite library.
The HTML part looks more like an error message from the SAB2sickbeard script.
Setup issue maybe?
Top
Post Reply

Return to “Debian/Ubuntu Package”