[mythtv-users] Need help debugging python bindings

Wed Jun 2 20:53:11 UTC 2010

Hi Doug,

On Wed, Jun 2, 2010 at 11:44 AM, Doug Vaughan <r.d.vaughan at rogers.com>wrote:

> Jack,
>   I am not sure what version of Jamu you are running. In your next post
> please include the information from:
> > /where ever Jamu is path/jamu.py -v
>

Title: (JAMU - Just.Another.Metadata.Utility); Version: (v0.7.3); Author:
(R.D.Vaughan)

This python script is intended to perform a variety of utility functions on
mythvideo metadata
and the associated video files.

The primary movie source for graphics and data is themoviedb.com wiki.
The primary TV Series source for graphics and data is thetvdb.com wiki.
Users of this script are encouraged to populate both themoviedb.com and
thetvdb.com with posters,
fan art and banners and meta data. The richer the source the more valuable
the script.

>
>   Do you know what type of database engine you are using in MySQL for the "
> mythconverg" data base. I only ask this as a long while ago a user had the
> "InnoDB" engine instead of the usual "MyISAM". Apparently "InnoDB" supported
> database roll-back so every jamu write to the data base was being rolled
> back.
>

You are correct, I'm using InnoDB.

>      Now this was fixed a long time ago in the Python bindings (since
> Mythtv 0.22+fixes) but I wonder if this is related as no other users do not
> seem to have this issue.
>

I'm betting you're right here too.  I put breakpoints in the bindings and
stopped just before the the execute for the update.  If I evaluate the
string the connect is about to execute (ie the "UPDATE ...") and try it in
the mysql client then it works ok.  The bindings don't work however.

>      As for debugging information output "-b, --debug Show debugging info"
> but you better be prepared for a lot of output. Assuming you will not be
> using an interactive option like "-I" and "-R" then you should pipe the
> output to a log file. Typically I only use the "-V" (verbose) option during
> problem analysis.
>   Example:
> > /where ever Jamu is path/jamu.py -MWV -d > issue1.log
>
> or
>
> > /where ever Jamu is path/jamu.py -MV -d > issue2.log
>
> I'm guessing in your examples you mean '-b' instead of '-d'.  Unfortunately
I AM using -R, but here's the output (with some inane parts trimmed):

perveil at cerebro:~$ /usr/share/mythtv/mythvideo/scripts/jamu.py -MRV -b -l en
-C "/home/mythtv/.mythtv/jamu.conf"
opts {'flags_options': False, 'version': False, 'mythtv_guess': False,
'examples': False, 'download': False, 'user_config':
'/home/mythtv/.mythtv/jamu.conf', 'overwrite': False, 'toprated': False,
'nokeys': False, 'usage': False, 'mythtv_ref_num': True, 'mythtv_watched':
False, 'update': False, 'mythtvdir': False, 'mythtvjanitor': False,
'language': 'en', 'mythtv_inetref': False, 'selected_data': None, 'maximum':
None, 'simulation': False, 'ret_filename': False, 'debug': True,
'mythtv_verbose': True, 'mythtvmeta': True, 'mythtvNFS': False,
'interactive': False}

args []
2010-06-02 16:36:06.309 Python Database Connection: Using connection
settings from /home/perveil/.mythtv/config.xml

<snip regular jamu messages about storage groups>

2010-06-02 16:36:06,340) DEBUG Checking for a valid video filename extension
2010-06-02 16:36:06,341) DEBUG Checking for a valid video filename extension
2010-06-02 16:36:06,341) DEBUG Checking for a valid video filename extension
2010-06-02 16:36:06,341) DEBUG Checking for a valid video filename extension
2010-06-02 16:36:06,341) DEBUG Checking for a valid video filename extension
2010-06-02 16:36:06,342) DEBUG Checking for a valid video filename extension
2010-06-02 16:36:06,342) DEBUG Checking for a valid video filename extension

! Warning: Skipping non-video file name:
(/myth/video/.movie_covers/Thumbs.db)
2010-06-02 16:36:06,342) DEBUG Checking for a valid video filename extension

! Warning: Skipping non-video file name: (/myth/video/Thumbs.db)
2010-06-02 16:36:06,343) DEBUG Checking for a valid video filename extension
2010-06-02 16:36:06,344) DEBUG Checking for a valid video filename extension

! Warning: Skipping non-video file name: (/myth/video/codecs.conf)
2010-06-02 16:36:06,344) DEBUG Checking for a valid video filename extension

! Warning: Skipping non-video file name: (/myth/video/xine-out.wav)
Mythtv video database maintenance start: 2010-06-02 16:36

Now processing video file (X-Men)(0)(0)

DEBUG: XML URL:
http://api.themoviedb.org/2.1/Movie.search/en/xml/c27cb71cff5bd76e1a7a009380562c62/x-men

2010-06-02 16:36:07,154) DEBUG Interactivily selecting movie using ConsoleUI
themoviedb.org Search Results:
2010-06-02 16:36:07,154) DEBUG Showing allElements[1] = <Movie: None>)
 1 -> X-Men: The Last Stand (2006)                       #
http://www.themoviedb.org/movie/36668
2010-06-02 16:36:07,155) DEBUG Showing allElements[2] = <Movie: None>)
 2 -> X-Men: Pryde of the X-Men (1989)                   #
http://www.themoviedb.org/movie/37713
2010-06-02 16:36:07,155) DEBUG Showing allElements[3] = <Movie: None>)
 3 -> Ten Dead Men (2008)                                #
http://www.themoviedb.org/movie/16259
2010-06-02 16:36:07,156) DEBUG Showing allElements[4] = <Movie: None>)
 4 -> X-Men Origins: Wolverine (2009)                    #
http://www.themoviedb.org/movie/2080
2010-06-02 16:36:07,156) DEBUG Showing allElements[5] = <Movie: None>)
 5 -> X-Men (2000)                                       #
http://www.themoviedb.org/movie/36657
2010-06-02 16:36:07,159) DEBUG Showing allElements[6] = <Movie: None>)
 6 -> X2 (2003)                                          #
http://www.themoviedb.org/movie/36658
2010-06-02 16:36:07,160) DEBUG Showing allElements[7] = {'id': '99999999',
'name': u'User choses to ignore video'})
 7 -> 99999999 # Set this video to be ignored by Jamu with a reference
number of '99999999'
Direct search of themoviedb.org # http://themoviedb.org/
Enter choice:
("Enter" key equals first selection (1)) or input a zero padded 5 digit
movie TMDB id number, ? for help):
5
2010-06-02 16:46:08,846) DEBUG Got choice of: 5
2010-06-02 16:46:08,847) DEBUG Trying to return ID: 4

Reference number (36657) added for (X-Men)

Mythtv video database maintenance ends at  : 2010-06-02 16:46

------------------Statistics---------------
Number of video files processed .....(    1)
Number of Fanart graphics downloaded (    0)
Number of Poster graphics downloaded (    0)
Number of Banner graphics downloaded (    0)
Number of 2nd source graphics downld (    0)
Number of metadata downloads.........(    0)
Number of 2nd source metadata found .(    0)
Number of symbolic links created.....(    0)
Number of Myth database updates......(    1)
Number of undersized posters ........(    0)
Number of Movies using IMDB numbers .(    0)

--------------Updated Video Files----------
X-Men

Nothing too interesting, really.  I think jamu is in the clear (it passes
the correct intid and inetref to the bindings), so my pretend money is on
the InnoDB angle.  Tonight I'll try and alter the table back to myisam and
see if that helps.

Thanks,

--Jack
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100602/48242945/attachment.htm>