Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!

Bug 457010

Summary: net-misc/flexget-1.0.3344: BUG: Unhandled error in plugin --series: Only '='/'!=' operators can be used with NULL
Product: Gentoo Linux Reporter: Craig Andrews <candrews>
Component: Current packagesAssignee: Mike Gilbert <floppym>
Status: RESOLVED FIXED    
Severity: normal CC: candrews
Priority: Normal    
Version: unspecified   
Hardware: All   
OS: Linux   
Whiteboard:
Package list:
Runtime testing required: ---

Description Craig Andrews gentoo-dev 2013-02-12 22:43:10 UTC
$ flexget --series
 Name                           Latest     Age        Downloaded
-------------------------------------------------------------------------------
2013-02-12 17:39 ERROR    task                          BUG: Unhandled error in plugin --series: Only '='/'!=' operators can be used with NULL
Traceback (most recent call last):
  File "/usr/lib64/python2.7/site-packages/flexget/task.py", line 386, in __run_plugin
    return method(*args, **kwargs)
  File "/usr/lib64/python2.7/site-packages/flexget/event.py", line 21, in __call__
    return self.func(*args, **kwargs)
  File "/usr/lib64/python2.7/site-packages/flexget/plugins/cli/series.py", line 24, in on_process_start
    self.display_summary()
  File "/usr/lib64/python2.7/site-packages/flexget/plugins/cli/series.py", line 140, in display_summary
    for series_name, data in sorted((self.get_series_summary()).iteritems()):
  File "/usr/lib64/python2.7/site-packages/flexget/plugins/cli/series.py", line 105, in get_series_summary
    'behind': self.new_eps_after(episode)}
  File "/usr/lib64/python2.7/site-packages/flexget/plugins/filter/series.py", line 406, in new_eps_after
    return series_eps.filter(or_(and_(Episode.season == since_ep.season, Episode.number > since_ep.number),
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/operators.py", line 234, in __gt__
    return self.operate(gt, other)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 123, in operate
    return op(self.comparator, *other, **kwargs)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/operators.py", line 234, in __gt__
    return self.operate(gt, other)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/properties.py", line 163, in operate
    return op(self.__clause_element__(), *other, **kwargs)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/operators.py", line 234, in __gt__
    return self.operate(gt, other)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/expression.py", line 1919, in operate
    return o[0](self, op, other[0], *o[1:], **kwargs)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/expression.py", line 1856, in __compare
    raise exc.ArgumentError("Only '='/'!=' operators can "
ArgumentError: Only '='/'!=' operators can be used with NULL
2013-02-12 17:39 INFO     task                          Aborting task (plugin: --series)

Reproducible: Always




# emerge --info
Portage 2.1.11.51 (default/linux/amd64/13.0, gcc-4.7.2, glibc-2.16.0, 3.7.4-gentoo x86_64)
=================================================================
System uname: Linux-3.7.4-gentoo-x86_64-Intel-R-_Core-TM-2_Quad_CPU_Q9550_@_2.83GHz-with-gentoo-2.2
KiB Mem:     3980372 total,    208904 free
KiB Swap:    3981288 total,   3229000 free
Timestamp of tree: Tue, 12 Feb 2013 19:45:01 +0000
ld GNU ld (GNU Binutils) 2.23.1
ccache version 3.1.9 [enabled]
app-shells/bash:          4.2_p42
dev-java/java-config:     2.1.12-r1
dev-lang/python:          2.7.3-r3, 3.2.3-r2
dev-util/ccache:          3.1.9
dev-util/cmake:           2.8.10.2-r1
dev-util/pkgconfig:       0.28
sys-apps/baselayout:      2.2
sys-apps/openrc:          0.11.8
sys-apps/sandbox:         2.6
sys-devel/autoconf:       2.13, 2.69
sys-devel/automake:       1.10.3, 1.11.6, 1.13.1
sys-devel/binutils:       2.23.1
sys-devel/gcc:            4.7.2
sys-devel/gcc-config:     1.8
sys-devel/libtool:        2.4.2
sys-devel/make:           3.82-r4
sys-kernel/linux-headers: 3.7 (virtual/os-headers)
sys-libs/glibc:           2.16.0
Repositories: gentoo openrc webapp-experimental sabayon sunrise mv x-portage
ACCEPT_KEYWORDS="amd64 ~amd64"
ACCEPT_LICENSE="* -@EULA Intel-SDP"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-O2 -march=native -pipe -fomit-frame-pointer -flto"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/share/gnupg/qualified.txt /usr/share/maven-bin-3.0/conf /var/spool/munin-async/.ssh"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/php/apache2-php5.4/ext-active/ /etc/php/cgi-php5.4/ext-active/ /etc/php/cli-php5.4/ext-active/ /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo"
CXXFLAGS="-O2 -march=native -pipe -fomit-frame-pointer -flto"
DISTDIR="/usr/portage/distfiles"
EMERGE_DEFAULT_OPTS="--jobs=4 --load-average=4.5"
FCFLAGS="-O2 -pipe"
FEATURES="assume-digests binpkg-logs ccache config-protect-if-modified distlocks ebuild-locks fixlafiles merge-sync news parallel-fetch parallel-install protect-owned sandbox sfperms strict unknown-features-warn unmerge-logs unmerge-orphans userfetch usersandbox webrsync-gpg xattr"
FFLAGS="-O2 -pipe"
GENTOO_MIRRORS="http://distfiles.gentoo.org"
LANG="en_US.UTF-8"
LDFLAGS="-Wl,-O1 -Wl,--as-needed -flto"
MAKEOPTS="-j5"
PKGDIR="/usr/portage/packages"
PORTAGE_CONFIGROOT="/"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --human-readable --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/var/lib/layman/openrc /var/lib/layman/webapps-experimental /var/lib/layman/sabayon /var/lib/layman/sunrise /var/lib/layman/mv /usr/local/portage"
SYNC="rsync://rsync.namerica.gentoo.org/gentoo-portage"
USE="X a52 aac aacs acl acpi aiglx alsa amd64 amr amrnb amrwb animation apache2 apng artworkextra asf aspnet2 asyncns authdaemond avahi avi bash-completion bcmath berkdb bitmap-fonts bluetooth bluray bmp bonjour bzip2 cairo caps ccache cdda cddb cdparanoia cdr chm cli consolekit cracklib crypt cryptsetup css cups curl cxx daap dbus device-mapper dga dhclient dirac divx4linux dlloader dovecot-sasl dpms dri dts dv dvb dvd dvdr dvdread egl enca encode exif faac fam fame fat fbcondecor fbsplash ffmpeg fftw firefox flac fontconfig foomaticdb fortran freetype ftp fuse gaim gd gdbm geoip gif gimpprint glamor gles glib glibc-omitfp glitz glut gphoto2 gpm gsm gstreamer gstreamer10 gtk gtk2 gudev hardenedphp hbci howl howl-compat https hwdb iconv idn imagemagick imap imlib innodb ipv6 java java5 jbig joystick jpeg jpeg2k junit kdehiddenvisibility kvm lapack lcms libfame libkms libnotify libsamplerate libusb lirc live lm_sensors lzma lzo mad maildir mdnsresponder-compat mjpeg mmap mms mmx mmxext mng modules mono motif mozilla mozsvg mp3 mpeg mpeg2 mplayer mudflap multilib musepack mysql mythtv ncurses nemesi network networkmanager nls nptl nptlonly ntfs offensive ofx ogg oggvorbis openal opencl openexr opengl openmp openvg pam pango pcre pdf pdflib perl phonon pic pie png pnp policykit ppd ppds pulseaudio python qt qt3 qt3support qt4 quicktime rar readline resolvconf rtc rtmp samba schroedinger screensaver sctp sdl session sftp sharedmem shout smp sna sni snmp sox speex spell sqlite sse sse2 sse3 ssh ssl ssse3 suspend2 svg tcpd theora threads tiff tls transcode truetype truetype-fonts type-fonts udev udisks unicode unzip upnp ups usb uxa v4l2 vaapi vcd vdpau videos vorbis vpx wayland webdav webkit webservices wifi wmf wv x264 xa xanim xattr xcb xcomposite xinerama xml xml2 xpm xprint xrandr xv xvid xvmc zeroconf zip zlib" ABI_X86="64" ALSA_CARDS="hda-intel" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache dav dav_fs dav_lock dconf deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias auth_digest proxy proxy_ajp proxy_connect proxy_http reqtimeout cgi" CALLIGRA_FEATURES="kexi words flow plan sheets stage tables krita karbon braindump" CAMERAS="ptp2" COLLECTD_PLUGINS="df interface irq load memory rrdtool swap syslog" CURL_SSL="nss" ELIBC="glibc" GPSD_PROTOCOLS="ashtech aivdm earthmate evermore fv18 garmin garmintxt gpsclock itrax mtk3301 nmea ntrip navcom oceanserver oldstyle oncore rtcm104v2 rtcm104v3 sirf superstar2 timing tsip tripmate tnt ubx" INPUT_DEVICES="evdev joystick keyboard mouse" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LIBREOFFICE_EXTENSIONS="presenter-console presenter-minimizer" LINGUAS="en" LIRC_DEVICES="userspace" PHP_TARGETS="php5-4" PYTHON_SINGLE_TARGET="python2_7" PYTHON_TARGETS="python2_7 python3_2" QEMU_SOFTMMU_TARGETS="arm i386 x86_64" QEMU_USER_TARGETS="arm i386 x86_64" RUBY_TARGETS="jruby ruby19" USERLAND="GNU" VIDEO_CARDS="intel" XTABLES_ADDONS="quota2 psd pknock lscan length2 ipv4options ipset ipp2p iface geoip fuzzy condition tee tarpit sysrq steal rawnat logmark ipmark dhcpmac delude chaos account"
USE_PYTHON="2.7 3.2"
Unset:  CPPFLAGS, CTARGET, INSTALL_MASK, LC_ALL, PORTAGE_BUNZIP2_COMMAND, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS
Comment 1 Craig Andrews gentoo-dev 2013-02-12 22:44:06 UTC
Running flexget (such as simply "flexget") seems to work alright. The only problematic command I've found so far is  "flexget --series"
Comment 2 Mike Gilbert gentoo-dev 2013-02-13 20:42:38 UTC
Hmm... that might be bad data in your series_episodes table.

Can you see if the following command returns any rows?

sqlite3 ~/.flexget/db-config.sqlite "select * from series_episodes where identified_by = 'ep' and number is NULL;"
Comment 3 Mike Gilbert gentoo-dev 2013-02-14 19:10:01 UTC
Please re-open if this is not fixed.

+*flexget-1.0.3352 (14 Feb 2013)
+
+  14 Feb 2013; Mike Gilbert <floppym@gentoo.org> +flexget-1.0.3352.ebuild:
+  Version bump, hopefully fixes bug 457010.
+
Comment 4 Craig Andrews gentoo-dev 2013-02-15 18:49:35 UTC
This problem still happens with net-misc/flexget-1.0.3352.

Also:
sqlite3 ~/.flexget/db-config.sqlite "select * from series_episodes where identified_by = 'ep' and number is NULL;"
Does not output anything.
Comment 5 Mike Gilbert gentoo-dev 2013-02-15 21:16:09 UTC
I'm going to have to send you upstream on this. Either create a ticket or ask in #flexget on Freenode.

http://flexget.com/newticket
Comment 6 Craig Andrews gentoo-dev 2013-02-17 18:32:40 UTC
(In reply to comment #5)
> I'm going to have to send you upstream on this. Either create a ticket or
> ask in #flexget on Freenode.
> 
> http://flexget.com/newticket

Issue created upstream at http://flexget.com/ticket/1952

Thanks!
Comment 7 Craig Andrews gentoo-dev 2013-03-19 02:06:12 UTC
(In reply to comment #6)
> (In reply to comment #5)
> > I'm going to have to send you upstream on this. Either create a ticket or
> > ask in #flexget on Freenode.
> > 
> > http://flexget.com/newticket
> 
> Issue created upstream at http://flexget.com/ticket/1952
> 
> Thanks!

This bug is resolved as of net-misc/flexget-1.0.3352