[mythtv-users] Database / storage housekeeping

[Jeff Simpson]

I recently happened to come across this error in my database logs:

ERROR when trying to autoexpire file:
/mnt/store//1311_20060213220000_20060213220000.nuv. File doesn't exist.
Database metadata will not be removed.

Turns out that file didn't exist, but the entry was still in the logs. Does
this housekeeping task run all the time, and does it list ALL the errors it
finds, or just the first one? Reason I ask is because I found a similar
error yesterday (different file). I wonder if I have a whole slew of missing
files that I will find out about 1 day at a time.

Is there a utility for checking the sanity of the database? Something that
compares the file list to the database and vice versa, tells you about files
that aren't in the database and database entries with no files attached. I'm
especially interested to see if there are any unattached files, as they are
effectively wasting space on the mythbox.

(yes, I know I can go through them one at a time or write a script to do it,
I'm just wondering if one already exists before I spend time on it)

 - Jeff
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20060330/e9fa600d/attachment.htm