[mythtv-users] Machine hung -- lists of recorded programs and upcoming recordings empty.

[Mark Perkins]

> On 23 Sep 2015, at 2:31 pm, Dick Steffens <dick at dicksteffens.com> wrote:
> 
>> On 09/22/2015 09:08 PM, Dick Steffens wrote:
>> On 09/22/2015 07:49 PM, Frank Phillips wrote:
>> <snip>
>>> Check in mythweb > settings > database and see if it needs to be repaired.
>> 
>> After several seconds I got a list with headers Name and Status. Most of the entries under Status are "OK" but two are not. They are:
>> 
>> oldprogram               Table is marked as crashed and last repair failed
>> record                        Table is marked as crashed and last repair failed
>> 
>> I ran Repair Tables from MythWeb. The page repopulated with all entries showing OK, and I can see the list of recorded programs, but the Upcoming Recordings page is still empty. I also ran Extended Check, but that had no effect on the Upcoming Recordings page. (I ran these after the stuff below.)
> 
> To verify that things are working again we successfully watched one program. Then I tried setting up a program for later this evening using MythWeb. The process of telling it to record worked, but it still shows nothing in the Upcoming Recordings screen.
> 
> What do I need to do to fix that?
> 
> -- 
> Regards,
> 
> Dick Steffens
> 
> _______________________________________________

I would recommend optimize_mythdb.pl next. Maybe in verbose mode and see what it says.

https://www.mythtv.org/wiki/User_Manual:Periodic_Maintenance