[mythtv-users] Help, mythtv has stopped recording and I don't understand why!

Johan johan.vanderkolk at dommel.be
Wed Oct 6 05:09:04 UTC 2010


Op 06-10-10 05:00, Greg Oliver schreef:
> On Tue, Oct 5, 2010 at 9:54 PM, mythtv at blandford.net
> <mythtv at blandford.net>  wrote:
>    
>> Hello,
>>
>> I have a experiencing a strange issue.  I have been running mythtv since I
>> think 0.11.
>>
>> Tonight, when I go to look at the upcoming recordings, there are none. Just
>> a message that says 'You Haven't Scheduled Any Programs to Be Recorded".
>>
>>
>> In mythweb, the upcoming recordings page is just blank.
>>
>>
>> I have run optimize_mythdb.pl and it comes back clean.
>>      
>
> I had the exact thing on my recorded table the other day.  The
> optimize script just tells mysql to repair the tables, which in turn
> just truncates them if there are unrecoverable errors (may be distro
> related - I have not looked through my.cnf, etc..)
>
> It did piss me off though..  You would think that mysql by default
> does not do this kind of crap..  Now I'm interested again and will
> investigate further  :)
>
>    
>> /usr/share/doc/mythtv-docs-*/contrib/maintenance/optimize_mythdb.pl
>> Repaired/Optimized: `mythconverg`.`archiveitems`
>> Analyzed: `mythconverg`.`archiveitems`
>> Repaired/Optimized: `mythconverg`.`callsignnetworkmap`
>> Analyzed: `mythconverg`.`callsignnetworkmap`
>> Repaired/Optimized: `mythconverg`.`capturecard`
>> Analyzed: `mythconverg`.`capturecard`
>> Repaired/Optimized: `mythconverg`.`cardinput`
>> Analyzed: `mythconverg`.`cardinput`
>> Repaired/Optimized: `mythconverg`.`channel`
>> Analyzed: `mythconverg`.`channel`
>> Repaired/Optimized: `mythconverg`.`channel_copy`
>> Analyzed: `mythconverg`.`channel_copy`
>> Repaired/Optimized: `mythconverg`.`channelgroup`
>> Analyzed: `mythconverg`.`channelgroup`
>> Repaired/Optimized: `mythconverg`.`channelgroupnames`
>> Analyzed: `mythconverg`.`channelgroupnames`
>> Repaired/Optimized: `mythconverg`.`channelscan`
>> Analyzed: `mythconverg`.`channelscan`
>> Repaired/Optimized: `mythconverg`.`channelscan_channel`
>> Analyzed: `mythconverg`.`channelscan_channel`
>> Repaired/Optimized: `mythconverg`.`channelscan_dtv_multiplex`
>> Analyzed: `mythconverg`.`channelscan_dtv_multiplex`
>> Repaired/Optimized: `mythconverg`.`codecparams`
>> Analyzed: `mythconverg`.`codecparams`
>> Repaired/Optimized: `mythconverg`.`credits`
>> Analyzed: `mythconverg`.`credits`
>> Repaired/Optimized: `mythconverg`.`customexample`
>> Analyzed: `mythconverg`.`customexample`
>> Repaired/Optimized: `mythconverg`.`diseqc_config`
>> Analyzed: `mythconverg`.`diseqc_config`
>> Repaired/Optimized: `mythconverg`.`diseqc_tree`
>> Analyzed: `mythconverg`.`diseqc_tree`
>> Repaired/Optimized: `mythconverg`.`displayprofilegroups`
>> Analyzed: `mythconverg`.`displayprofilegroups`
>> Repaired/Optimized: `mythconverg`.`displayprofiles`
>> Analyzed: `mythconverg`.`displayprofiles`
>> Repaired/Optimized: `mythconverg`.`dtv_multiplex`
>> Analyzed: `mythconverg`.`dtv_multiplex`
>> Repaired/Optimized: `mythconverg`.`dtv_privatetypes`
>> Analyzed: `mythconverg`.`dtv_privatetypes`
>> Repaired/Optimized: `mythconverg`.`dvdbookmark`
>> Analyzed: `mythconverg`.`dvdbookmark`
>> Repaired/Optimized: `mythconverg`.`dvdinput`
>> Analyzed: `mythconverg`.`dvdinput`
>> Repaired/Optimized: `mythconverg`.`dvdtranscode`
>> Analyzed: `mythconverg`.`dvdtranscode`
>> Repaired/Optimized: `mythconverg`.`eit_cache`
>> Analyzed: `mythconverg`.`eit_cache`
>> Repaired/Optimized: `mythconverg`.`filemarkup`
>> Analyzed: `mythconverg`.`filemarkup`
>> Repaired/Optimized: `mythconverg`.`gallerymetadata`
>> Analyzed: `mythconverg`.`gallerymetadata`
>> Repaired/Optimized: `mythconverg`.`gamemetadata`
>> Analyzed: `mythconverg`.`gamemetadata`
>> Repaired/Optimized: `mythconverg`.`gameplayers`
>> Analyzed: `mythconverg`.`gameplayers`
>> Repaired/Optimized: `mythconverg`.`housekeeping`
>> Analyzed: `mythconverg`.`housekeeping`
>> Repaired/Optimized: `mythconverg`.`inputgroup`
>> Analyzed: `mythconverg`.`inputgroup`
>> Repaired/Optimized: `mythconverg`.`inuseprograms`
>> Analyzed: `mythconverg`.`inuseprograms`
>> Repaired/Optimized: `mythconverg`.`jobqueue`
>> Analyzed: `mythconverg`.`jobqueue`
>> Repaired/Optimized: `mythconverg`.`jumppoints`
>> Analyzed: `mythconverg`.`jumppoints`
>> Repaired/Optimized: `mythconverg`.`keybindings`
>> Analyzed: `mythconverg`.`keybindings`
>> Repaired/Optimized: `mythconverg`.`keyword`
>> Analyzed: `mythconverg`.`keyword`
>> Repaired/Optimized: `mythconverg`.`mamemetadata`
>> Analyzed: `mythconverg`.`mamemetadata`
>> Repaired/Optimized: `mythconverg`.`mamesettings`
>> Analyzed: `mythconverg`.`mamesettings`
>> Repaired/Optimized: `mythconverg`.`movies_movies`
>> Analyzed: `mythconverg`.`movies_movies`
>> Repaired/Optimized: `mythconverg`.`movies_showtimes`
>> Analyzed: `mythconverg`.`movies_showtimes`
>> Repaired/Optimized: `mythconverg`.`movies_theaters`
>> Analyzed: `mythconverg`.`movies_theaters`
>> Repaired/Optimized: `mythconverg`.`music_albumart`
>> Analyzed: `mythconverg`.`music_albumart`
>> Repaired/Optimized: `mythconverg`.`music_albums`
>> Analyzed: `mythconverg`.`music_albums`
>> Repaired/Optimized: `mythconverg`.`music_artists`
>> Analyzed: `mythconverg`.`music_artists`
>> Repaired/Optimized: `mythconverg`.`music_directories`
>> Analyzed: `mythconverg`.`music_directories`
>> Repaired/Optimized: `mythconverg`.`music_genres`
>> Analyzed: `mythconverg`.`music_genres`
>> Repaired/Optimized: `mythconverg`.`music_playlists`
>> Analyzed: `mythconverg`.`music_playlists`
>> Repaired/Optimized: `mythconverg`.`music_smartplaylist_categories`
>> Analyzed: `mythconverg`.`music_smartplaylist_categories`
>> Repaired/Optimized: `mythconverg`.`music_smartplaylist_items`
>> Analyzed: `mythconverg`.`music_smartplaylist_items`
>> Repaired/Optimized: `mythconverg`.`music_smartplaylists`
>> Analyzed: `mythconverg`.`music_smartplaylists`
>> Repaired/Optimized: `mythconverg`.`music_songs`
>> Analyzed: `mythconverg`.`music_songs`
>> Repaired/Optimized: `mythconverg`.`music_stats`
>> Analyzed: `mythconverg`.`music_stats`
>> Repaired/Optimized: `mythconverg`.`mythlog`
>> Analyzed: `mythconverg`.`mythlog`
>> Repaired/Optimized: `mythconverg`.`mythweb_sessions`
>> Analyzed: `mythconverg`.`mythweb_sessions`
>> Repaired/Optimized: `mythconverg`.`neskeyword`
>> Analyzed: `mythconverg`.`neskeyword`
>> Repaired/Optimized: `mythconverg`.`nestitle`
>> Analyzed: `mythconverg`.`nestitle`
>> Repaired/Optimized: `mythconverg`.`netflix`
>> Analyzed: `mythconverg`.`netflix`
>> Repaired/Optimized: `mythconverg`.`netvisionrssitems`
>> Analyzed: `mythconverg`.`netvisionrssitems`
>> Repaired/Optimized: `mythconverg`.`netvisionsearchgrabbers`
>> Analyzed: `mythconverg`.`netvisionsearchgrabbers`
>> Repaired/Optimized: `mythconverg`.`netvisionsites`
>> Analyzed: `mythconverg`.`netvisionsites`
>> Repaired/Optimized: `mythconverg`.`netvisiontreegrabbers`
>> Analyzed: `mythconverg`.`netvisiontreegrabbers`
>> Repaired/Optimized: `mythconverg`.`netvisiontreeitems`
>> Analyzed: `mythconverg`.`netvisiontreeitems`
>> Repaired/Optimized: `mythconverg`.`networkiconmap`
>> Analyzed: `mythconverg`.`networkiconmap`
>> Repaired/Optimized: `mythconverg`.`newssites`
>> Analyzed: `mythconverg`.`newssites`
>> Repaired/Optimized: `mythconverg`.`oldfind`
>> Analyzed: `mythconverg`.`oldfind`
>> Repaired/Optimized: `mythconverg`.`oldprogram`
>> Analyzed: `mythconverg`.`oldprogram`
>> Repaired/Optimized: `mythconverg`.`oldrecorded`
>> Analyzed: `mythconverg`.`oldrecorded`
>> Repaired/Optimized: `mythconverg`.`people`
>> Analyzed: `mythconverg`.`people`
>> Repaired/Optimized: `mythconverg`.`phonecallhistory`
>> Analyzed: `mythconverg`.`phonecallhistory`
>> Repaired/Optimized: `mythconverg`.`phonedirectory`
>> Analyzed: `mythconverg`.`phonedirectory`
>> Repaired/Optimized: `mythconverg`.`pidcache`
>> Analyzed: `mythconverg`.`pidcache`
>> Repaired/Optimized: `mythconverg`.`playgroup`
>> Analyzed: `mythconverg`.`playgroup`
>> Repaired/Optimized: `mythconverg`.`powerpriority`
>> Analyzed: `mythconverg`.`powerpriority`
>> Repaired/Optimized: `mythconverg`.`profilegroups`
>> Analyzed: `mythconverg`.`profilegroups`
>> Repaired/Optimized: `mythconverg`.`program`
>> Analyzed: `mythconverg`.`program`
>> Repaired/Optimized: `mythconverg`.`programgenres`
>> Analyzed: `mythconverg`.`programgenres`
>> Repaired/Optimized: `mythconverg`.`programrating`
>> Analyzed: `mythconverg`.`programrating`
>> Repaired/Optimized: `mythconverg`.`recgrouppassword`
>> Analyzed: `mythconverg`.`recgrouppassword`
>> Repaired/Optimized: `mythconverg`.`record`
>> Analyzed: `mythconverg`.`record`
>> Repaired/Optimized: `mythconverg`.`recorded`
>> Analyzed: `mythconverg`.`recorded`
>> Repaired/Optimized: `mythconverg`.`recordedcredits`
>> Analyzed: `mythconverg`.`recordedcredits`
>> Repaired/Optimized: `mythconverg`.`recordedfile`
>> Analyzed: `mythconverg`.`recordedfile`
>> Repaired/Optimized: `mythconverg`.`recordedmarkup`
>> Analyzed: `mythconverg`.`recordedmarkup`
>> Repaired/Optimized: `mythconverg`.`recordedprogram`
>> Analyzed: `mythconverg`.`recordedprogram`
>> Repaired/Optimized: `mythconverg`.`recordedrating`
>> Analyzed: `mythconverg`.`recordedrating`
>> Repaired/Optimized: `mythconverg`.`recordedseek`
>> Analyzed: `mythconverg`.`recordedseek`
>> Repaired/Optimized: `mythconverg`.`recordingprofiles`
>> Analyzed: `mythconverg`.`recordingprofiles`
>> Repaired/Optimized: `mythconverg`.`recordmatch`
>> Analyzed: `mythconverg`.`recordmatch`
>> Repaired/Optimized: `mythconverg`.`romdb`
>> Analyzed: `mythconverg`.`romdb`
>> Repaired/Optimized: `mythconverg`.`schemalock`
>> Analyzed: `mythconverg`.`schemalock`
>> Repaired/Optimized: `mythconverg`.`settings`
>> Analyzed: `mythconverg`.`settings`
>> Repaired/Optimized: `mythconverg`.`snessettings`
>> Analyzed: `mythconverg`.`snessettings`
>> Repaired/Optimized: `mythconverg`.`storagegroup`
>> Analyzed: `mythconverg`.`storagegroup`
>> Repaired/Optimized: `mythconverg`.`tvchain`
>> Analyzed: `mythconverg`.`tvchain`
>> Repaired/Optimized: `mythconverg`.`tvosdmenu`
>> Analyzed: `mythconverg`.`tvosdmenu`
>> Repaired/Optimized: `mythconverg`.`upnpmedia`
>> Analyzed: `mythconverg`.`upnpmedia`
>> Repaired/Optimized: `mythconverg`.`videocast`
>> Analyzed: `mythconverg`.`videocast`
>> Repaired/Optimized: `mythconverg`.`videocategory`
>> Analyzed: `mythconverg`.`videocategory`
>> Repaired/Optimized: `mythconverg`.`videocountry`
>> Analyzed: `mythconverg`.`videocountry`
>> Repaired/Optimized: `mythconverg`.`videogenre`
>> Analyzed: `mythconverg`.`videogenre`
>> Repaired/Optimized: `mythconverg`.`videometadata`
>> Analyzed: `mythconverg`.`videometadata`
>> Repaired/Optimized: `mythconverg`.`videometadatacast`
>> Analyzed: `mythconverg`.`videometadatacast`
>> Repaired/Optimized: `mythconverg`.`videometadatacountry`
>> Analyzed: `mythconverg`.`videometadatacountry`
>> Repaired/Optimized: `mythconverg`.`videometadatagenre`
>> Analyzed: `mythconverg`.`videometadatagenre`
>> Repaired/Optimized: `mythconverg`.`videosource`
>> Analyzed: `mythconverg`.`videosource`
>> Repaired/Optimized: `mythconverg`.`videotypes`
>> Analyzed: `mythconverg`.`videotypes`
>> Repaired/Optimized: `mythconverg`.`weatherdatalayout`
>> Analyzed: `mythconverg`.`weatherdatalayout`
>> Repaired/Optimized: `mythconverg`.`weatherscreens`
>> Analyzed: `mythconverg`.`weatherscreens`
>> Repaired/Optimized: `mythconverg`.`weathersourcesettings`
>> Analyzed: `mythconverg`.`weathersourcesettings`
>> Repaired/Optimized: `mythconverg`.`websites`
>> Analyzed: `mythconverg`.`websites`
>>
>> I have also run mysqlcheck against the mythtv tables and they all say they
>> are ok.
>>
>> I can see previously recorded shows and play them.  I can also watch live tv
>> via my PVR-500 and HDhomerun.
>>
>> Fedora did update mysql in the last few days and I ran mysql_upgrade just to
>> make sure and it comes back without errors as well.
>>
>> Running mythfilldatabase shows that I have data up through Oct 18th.
>>
>> Please help me figure out what is wrong!
>>
>> Michael
>>      
Had a similar issue. My tuner was not there anymore (not avail to myth 
when the BE started) , and all upcoming recordings were gone from the 
screen.
As soon as the tuner was back and the BE restarted, the upcoming 
recordings re-appeared.




More information about the mythtv-users mailing list