SABnzbd Forums

Posted: **September 30th, 2013, 9:52 pm**

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>

Posted: **October 2nd, 2013, 5:51 am**

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?

SABnzbd Forums

OperationalError: database is locked during postprocessing

OperationalError: database is locked during postprocessing

Re: OperationalError: database is locked during postprocessi