[mythtv-users] Help: Upcoming recordings list suddenly blank!

[Bruce Markey]

mattjackets wrote:
> On Tue, 06 Mar 2007 23:12:34 -0800, "Bruce Markey" <bjm at lvcm.com> said:
>> matt wrote:
>> ...
>>> I've been having database table "crashes" lately, mostly in the
>>> 'program' table, but I just repaired the 'recordedseek' table today.
>> $ killall mythbackend
>> $ killall mythfrontend
>> $ mysqlcheck -c -u mythtv -pmythtv mythconverg
>> $ mysql -u mythtv -pmythtv mythconverg
>> mysql> truncate table program;
>> mysql> truncate table programrating;
>> mysql> truncate table programgenre;
>> mysql> truncate table credits;
>> mysql> quit
>> $ mythfilldatabase
>> $ mysqlcheck -c -u mythtv -pmythtv mythconverg
>> $ mysqlcheck -o -u mythtv -pmythtv mythconverg
>> $ mythbackend -v schedule
>>
>> --  bjm
> 
> Bruce,
> Thanks for the tips, I'll remember them in the future.  Unfortunately,
> they didn't help directly.  But running the backend at the console
> (instead of /etc/init.d/mythbackend start) allowed me to see that
> /dev/video0 went missing!  Once I got ivtv back up and running, all was
> well.  Thanks again for your tips!

I didn't expect that this was the sole solution to your problem.
However, you mentioned that you were concerned about program
table corruption. The intent was to fix corruption of the TV
listings then see what the scheduler was or wasn't doing.

Normally, nothing scheduled is because there are no inputs on
cards associated with a video source that has channels and TV
listings. Lots of things could be wrong. In your case it couldn't
find the card but it could have been any number of things.

> Also, I've noticed that mysqlcheck will report a table as 'OK' even when
> it's not.  If I check the table using the mysql client with 'check table
> program;' (for example) it shows it as not OK/corrupt.  Any idea as to
> why this is?  I thought both actions were identical.

www,mysql.com is where you can find first hand info. The
listings data is transient so truncating the bad table then
repopulating it would be the expedient thing to do. If it was
corrupt after that then I'd be concerned about a bad disk or
something.

--  bjm