[mythtv-users] Database / storage housekeeping

[Jeff Simpson]

>
> > The thread runs when it finishes a recording and it tries to
> > autoexpire
> > a recording.  I don't have my db in front of my but you could dome
> > some
> > SQL to pull out all the file names the DB thinks exist and `ls` on the
> > storage drive then send them through diff and see what's in one but
> > not
> > the other.
> >


Yeah, that was the scripting I was trying to avoid. I guess it's not that
hard to do, but I didn't want to reinvent the wheel if there was already a
"myth-check-yourself-for-problems" command. I guess there is no magic
command, apart from the normal housekeeping thread.

So did the OP correct the problem ? Just "touch" the missing file and
> it will then have something to delete and can go ahead and delete the
> metadata.


I went the other way and just removed that recording from the dB using
phpmyadmin

I'm not sure if this behavior is a good thing or not, it alerts you
> to a problem, *if* you read the logs, which most people don't.


That was my problem, too. I don't often read the logs, so it has probably
been like that for awhile (at least a few months, since the missing
recordings were dated somewhere in 2005)

I suppose if you had a lot of files stored on an NFS filesystem and
> the network failed you wouldn't want the system to delete all of the
> metadata associated with those files.


Yeah, I wouldn't want automatic file deletion, but maybe a frontend alert of
some kind. TiVo has a menu item in their main menu that says some kind of
message, usually a "check out movie X" or "Showtime Free Preview this
weekend" "check out this new trailer", etc. Myth could do something similar
and say "Myth Found Some Errors" and have an option in there to view them
and optionally ignore them. Obviously not an important feature, but a neat
idea. It would be good to have some kind of framework for adding a menu item
on the fly dynamically.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20060331/17837956/attachment.htm