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

[Greg Oliver]

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
>
>
>
>
>
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>