Error trying to process TV Shows

[Ray Milyard]

I just installed FreeNAS 11.1. I setup all my jails and plugins per Joshua's guide. Today I see I am getting these error when the nzb2media script runs on the file:

Code:

Bobs.Burgers.S08E08.HDTV.x264-KILLERS-postbot
						
								  
Traceback (most recent call last):
File "/usr/local/share/nzbToMedia/nzbToSickBeard.py", line 257, in <module>
import nzbToMedia
File "/usr/local/share/nzbToMedia/nzbToMedia.py", line 573, in <module>
import core
File "/usr/local/share/nzbToMedia/core/__init__.py", line 35, in <module>
from core.autoProcess.autoProcessComics import autoProcessComics
File "/usr/local/share/nzbToMedia/core/autoProcess/autoProcessComics.py", line 7, in <module>
from core.nzbToMediaUtil import convert_to_ascii, remoteDir, server_responding
File "/usr/local/share/nzbToMedia/core/nzbToMediaUtil.py", line 26, in <module>
from core import logger, nzbToMediaDB
File "/usr/local/share/nzbToMedia/core/nzbToMediaDB.py", line 6, in <module>
import sqlite3
File "/usr/local/lib/python2.7/sqlite3/__init__.py", line 24, in <module>
from dbapi2 import *
File "/usr/local/lib/python2.7/sqlite3/dbapi2.py", line 28, in <module>
from _sqlite3 import *
ImportError: /usr/local/lib/libsqlite3.so.0: Undefined symbol "fdatasync"

 

[Ray Milyard]

Been surfing around and can't seem find a fix for this.

 

[dlavigne]

Were you able to resolve this? If not, did upgrading to U1 fix it?

 

[Ray Milyard]

Were you able to resolve this? If not, did upgrading to U1 fix it?

Yes. Joshua helped me out.

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=221672
It looks like the bug is caused by packages built on FreeBSD 11.1 being installed on 11.0 (maybe your jail is version 11.0?).

I would try this...

Code:

pkg delete -f sqlite3
fetch "http://pkg.freebsd.org/freebsd:11:x86:64/release_0/All/sqlite3-3.13.0.txz"
pkg add sqlite3-*.txz

 

[William Edds]

I have recently done a fresh reinstall of FreeNAS and preformed the steps to install SABnzbd, Couchpotato, Sickrage and Transmission using the following instructions:

https://www.jruehlig.com/wordpress/installation-configuration-of-freenas-plugins/

However, when I would use Sickrage to find and download videos, SABnzbd download the files but would give me the following error when unpacking them:

ImportError: /usr/local/lib/libsqlite3.so.0: Undefined symbol "fdatasync"


Using Ray Milyard's advice from the post above, I am now back in business with all of my plugins working once again. Thank you Ray!

Reiterating and elaborating on Ray Milyard's steps to fix sqlite3 error:

1. SSH into FreeNAS
2. View your jails with jls
3. Login to the jail using jexec <jail number> csh
4. Delete sqlite3 with pkg delete -f sqlite3
5. Download correct package of sqlite3 with fetch "http://pkg.freebsd.org/freebsd:11:x86:64/release_0/All/sqlite3-3.13.0.txz"
6. Reinstall sqlite3 with pkg add sqlite3-*.txz
7. Verify everything now works by using your plugins

 

[flahiker76]

Thanks Ray for the great tip! I am using a Jail on my FreeNAS server and could not for the life of me figure out why sqlite3 was not loading correctly in Python. Your suggestion solved my problem. Thanks!

 

[TripitakaBC]

And solved my problem too when trying to install headphones without the plugin.

Many thanks!

 

[neto_hugo]

Guys, I have a warning that I can not figure out how to fix.

Sab and Sick are communicating ok, but at the time of the post-processing is giving this error:

Code:

[18:31:55] [INFO]::MAIN: Loading config from [/usr/local/share/nzbToMedia/autoProcessMedia.cfg]
[18:31:55] [INFO]::MAIN: Checking database structure...
[18:31:55] [INFO]::MAIN: Checking if git needs an update
[18:31:56] [INFO]::MAIN: No update needed
[18:31:56] [INFO]::MAIN: nzbToMedia Version:5d5d69ecdd5fe043be8a915ffa26e8427c9641c4 Branch:master (FreeBSD 11.0-RELEASE)
[18:31:56] [INFO]::MAIN: #########################################################
[18:31:56] [INFO]::MAIN: ## ..::[nzbToMedia.pyc]::.. ##
[18:31:56] [INFO]::MAIN: #########################################################
[18:31:56] [INFO]::MAIN: Script triggered from SABnzbd 0.7.17+
[18:31:56] [INFO]::MAIN: Auto-detected SECTION:SickBeard
[18:31:56] [INFO]::MAIN: Calling SickBeard:tv to post-process:American.Horror.Story.S01E10.Smoldering.Children.1080p.WEB-DL.DD5.1.AAC2.0.H.264-SA89.nzb
[18:31:56] [INFO]::MAIN: Attempting to auto-detect tv fork
Traceback (most recent call last):
File "/usr/local/share/nzbToMedia/nzbToSickBeard.py", line 260, in <module>
result = nzbToMedia.main(sys.argv, section)
File "/usr/local/share/nzbToMedia/nzbToMedia.py", line 847, in main
download_id='', failureLink=''.join(args[8:]))
File "/usr/local/share/nzbToMedia/nzbToMedia.py", line 717, in process
download_id, inputCategory, failureLink)
File "/usr/local/share/nzbToMedia/core/autoProcess/autoProcessTV.py", line 69, in processEpisode
fork, fork_params = autoFork(section, inputCategory)
File "/usr/local/share/nzbToMedia/core/nzbToMediaAutoFork.py", line 84, in autoFork
if param not in r.json()['data']['optionalParameters'].keys():
KeyError: 'optionalParameters'
Exception TypeError: "'NoneType' object is not callable" in <bound method PosixProcess.__del__ of <core.nzbToMediaUtil.PosixProcess object at 0x80077de10>> ignored

If I run the manual post-processing in sickrage then its works!

Is there any permission, user, issue?
Thank you!

 

[r3m0dul8]

Guys, I have a warning that I can not figure out how to fix.

Sab and Sick are communicating ok, but at the time of the post-processing is giving this error:

Code:

[18:31:55] [INFO]::MAIN: Loading config from [/usr/local/share/nzbToMedia/autoProcessMedia.cfg]
[18:31:55] [INFO]::MAIN: Checking database structure...
[18:31:55] [INFO]::MAIN: Checking if git needs an update
[18:31:56] [INFO]::MAIN: No update needed
[18:31:56] [INFO]::MAIN: nzbToMedia Version:5d5d69ecdd5fe043be8a915ffa26e8427c9641c4 Branch:master (FreeBSD 11.0-RELEASE)
[18:31:56] [INFO]::MAIN: #########################################################
[18:31:56] [INFO]::MAIN: ## ..::[nzbToMedia.pyc]::.. ##
[18:31:56] [INFO]::MAIN: #########################################################
[18:31:56] [INFO]::MAIN: Script triggered from SABnzbd 0.7.17+
[18:31:56] [INFO]::MAIN: Auto-detected SECTION:SickBeard
[18:31:56] [INFO]::MAIN: Calling SickBeard:tv to post-process:American.Horror.Story.S01E10.Smoldering.Children.1080p.WEB-DL.DD5.1.AAC2.0.H.264-SA89.nzb
[18:31:56] [INFO]::MAIN: Attempting to auto-detect tv fork
Traceback (most recent call last):
File "/usr/local/share/nzbToMedia/nzbToSickBeard.py", line 260, in <module>
result = nzbToMedia.main(sys.argv, section)
File "/usr/local/share/nzbToMedia/nzbToMedia.py", line 847, in main
download_id='', failureLink=''.join(args[8:]))
File "/usr/local/share/nzbToMedia/nzbToMedia.py", line 717, in process
download_id, inputCategory, failureLink)
File "/usr/local/share/nzbToMedia/core/autoProcess/autoProcessTV.py", line 69, in processEpisode
fork, fork_params = autoFork(section, inputCategory)
File "/usr/local/share/nzbToMedia/core/nzbToMediaAutoFork.py", line 84, in autoFork
if param not in r.json()['data']['optionalParameters'].keys():
KeyError: 'optionalParameters'
Exception TypeError: "'NoneType' object is not callable" in <bound method PosixProcess.__del__ of <core.nzbToMediaUtil.PosixProcess object at 0x80077de10>> ignored

If I run the manual post-processing in sickrage then its works!

Is there any permission, user, issue?
Thank you!

I don't suppose you got this working?

I'm struggling to get my SABnzbd to finish off the script and continues to kick out this same error

Thanks