[mythtv-users] Database / storage housekeeping

[Bryan Halter]

Jeff Simpson wrote:

> 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
>
>
>  
>
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.

--Bryan