Hi Doug,<br><br><div class="gmail_quote">On Wed, Jun 2, 2010 at 11:44 AM, Doug Vaughan <span dir="ltr"><<a href="mailto:r.d.vaughan@rogers.com">r.d.vaughan@rogers.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Jack,<br>
I am not sure what version of Jamu you are running. In your next post please include the information from:<br>
> /where ever Jamu is path/jamu.py -v<br></blockquote><div> </div><div>Title: (JAMU - Just.Another.Metadata.Utility); Version: (v0.7.3); Author: (R.D.Vaughan)<br><br>This python script is intended to perform a variety of utility functions on mythvideo metadata<br>
and the associated video files.<br><br>The primary movie source for graphics and data is <a href="http://themoviedb.com">themoviedb.com</a> wiki.<br>The primary TV Series source for graphics and data is <a href="http://thetvdb.com">thetvdb.com</a> wiki.<br>
Users of this script are encouraged to populate both <a href="http://themoviedb.com">themoviedb.com</a> and <a href="http://thetvdb.com">thetvdb.com</a> with posters,<br>fan art and banners and meta data. The richer the source the more valuable the script.<br>
<br> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
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.<br>
</blockquote><div><br>You are correct, I'm using InnoDB.<br> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
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.<br></blockquote><div><br>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.<br>
<br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
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.<br>
Example:<br>
> /where ever Jamu is path/jamu.py -MWV -d > issue1.log<br>
<br>
or<br>
<br>
> /where ever Jamu is path/jamu.py -MV -d > issue2.log<br>
<br></blockquote><div>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):<br><br>perveil@cerebro:~$ /usr/share/mythtv/mythvideo/scripts/jamu.py -MRV -b -l en -C "/home/mythtv/.mythtv/jamu.conf"<br>
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}<br>
<br>args []<br>2010-06-02 16:36:06.309 Python Database Connection: Using connection settings from /home/perveil/.mythtv/config.xml<br><br><snip regular jamu messages about storage groups><br><br>2010-06-02 16:36:06,340) DEBUG Checking for a valid video filename extension<br>
2010-06-02 16:36:06,341) DEBUG Checking for a valid video filename extension<br>2010-06-02 16:36:06,341) DEBUG Checking for a valid video filename extension<br>2010-06-02 16:36:06,341) DEBUG Checking for a valid video filename extension<br>
2010-06-02 16:36:06,341) DEBUG Checking for a valid video filename extension<br>2010-06-02 16:36:06,342) DEBUG Checking for a valid video filename extension<br>2010-06-02 16:36:06,342) DEBUG Checking for a valid video filename extension<br>
<br>! Warning: Skipping non-video file name: (/myth/video/.movie_covers/Thumbs.db)<br>2010-06-02 16:36:06,342) DEBUG Checking for a valid video filename extension<br><br>! Warning: Skipping non-video file name: (/myth/video/Thumbs.db)<br>
2010-06-02 16:36:06,343) DEBUG Checking for a valid video filename extension<br>2010-06-02 16:36:06,344) DEBUG Checking for a valid video filename extension<br><br>! Warning: Skipping non-video file name: (/myth/video/codecs.conf)<br>
2010-06-02 16:36:06,344) DEBUG Checking for a valid video filename extension<br><br>! Warning: Skipping non-video file name: (/myth/video/xine-out.wav)<br>Mythtv video database maintenance start: 2010-06-02 16:36<br><br>Now processing video file (X-Men)(0)(0)<br>
<br>DEBUG: XML URL:<a href="http://api.themoviedb.org/2.1/Movie.search/en/xml/c27cb71cff5bd76e1a7a009380562c62/x-men">http://api.themoviedb.org/2.1/Movie.search/en/xml/c27cb71cff5bd76e1a7a009380562c62/x-men</a><br><br>2010-06-02 16:36:07,154) DEBUG Interactivily selecting movie using ConsoleUI<br>
<a href="http://themoviedb.org">themoviedb.org</a> Search Results:<br>2010-06-02 16:36:07,154) DEBUG Showing allElements[1] = <Movie: None>)<br> 1 -> X-Men: The Last Stand (2006) # <a href="http://www.themoviedb.org/movie/36668">http://www.themoviedb.org/movie/36668</a><br>
2010-06-02 16:36:07,155) DEBUG Showing allElements[2] = <Movie: None>)<br> 2 -> X-Men: Pryde of the X-Men (1989) # <a href="http://www.themoviedb.org/movie/37713">http://www.themoviedb.org/movie/37713</a><br>
2010-06-02 16:36:07,155) DEBUG Showing allElements[3] = <Movie: None>)<br> 3 -> Ten Dead Men (2008) # <a href="http://www.themoviedb.org/movie/16259">http://www.themoviedb.org/movie/16259</a><br>
2010-06-02 16:36:07,156) DEBUG Showing allElements[4] = <Movie: None>)<br> 4 -> X-Men Origins: Wolverine (2009) # <a href="http://www.themoviedb.org/movie/2080">http://www.themoviedb.org/movie/2080</a><br>
2010-06-02 16:36:07,156) DEBUG Showing allElements[5] = <Movie: None>)<br> 5 -> X-Men (2000) # <a href="http://www.themoviedb.org/movie/36657">http://www.themoviedb.org/movie/36657</a><br>
2010-06-02 16:36:07,159) DEBUG Showing allElements[6] = <Movie: None>)<br> 6 -> X2 (2003) # <a href="http://www.themoviedb.org/movie/36658">http://www.themoviedb.org/movie/36658</a><br>
2010-06-02 16:36:07,160) DEBUG Showing allElements[7] = {'id': '99999999', 'name': u'User choses to ignore video'})<br> 7 -> 99999999 # Set this video to be ignored by Jamu with a reference number of '99999999'<br>
Direct search of <a href="http://themoviedb.org">themoviedb.org</a> # <a href="http://themoviedb.org/">http://themoviedb.org/</a><br>Enter choice:<br>("Enter" key equals first selection (1)) or input a zero padded 5 digit movie TMDB id number, ? for help):<br>
5 <br>2010-06-02 16:46:08,846) DEBUG Got choice of: 5<br>2010-06-02 16:46:08,847) DEBUG Trying to return ID: 4<br><br>Reference number (36657) added for (X-Men) <br><br>Mythtv video database maintenance ends at : 2010-06-02 16:46<br>
<br>------------------Statistics---------------<br>Number of video files processed .....( 1)<br>Number of Fanart graphics downloaded ( 0)<br>Number of Poster graphics downloaded ( 0)<br>Number of Banner graphics downloaded ( 0)<br>
Number of 2nd source graphics downld ( 0)<br>Number of metadata downloads.........( 0)<br>Number of 2nd source metadata found .( 0)<br>Number of symbolic links created.....( 0)<br>Number of Myth database updates......( 1)<br>
Number of undersized posters ........( 0)<br>Number of Movies using IMDB numbers .( 0)<br><br>--------------Updated Video Files----------<br>X-Men<br><br><br>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.<br>
<br>Thanks,<br><br>--Jack<br></div></div>