[mythtv-users] clearing out old, non-existent videos

[Michael T. Dean]

On 09/04/2013 10:02 AM, John Pilkington wrote:
> On 04/09/13 14:13, Raymond Wagner wrote:
>> On Sep 4, 2013, at 9:04, "Michael T. Dean" wrote:
>>
>>> On 09/04/2013 05:30 AM, John Pilkington wrote:
>>>> Arising from this thread:
>>>>
>>>> http://www.gossamer-threads.com/lists/mythtv/dev/551029#551029
>>>>
>>>>>> On 30/08/13 13:34, Michael T. Dean wrote:
>>>>
>>>>> We don't really have a good way of clearing out old, non-existent 
>>>>> videos
>>>>> from old, non-existent hosts in Video Library at this point.
>>>>
>>>> Wouldn't a 'Clear all hashes from the Video List', with 'Are you 
>>>> sure?' protection, do this?  It would be much simpler.
>>>
>>> AIUI, in the case of a "missing" (no-longer-existent) host, any 
>>> Video Library videos in the database will always remain in the 
>>> database and the only way to remove them is to let that host say, "I 
>>> don't have any videos, anymore."
>>
>> If a video cannot be found during a scan, and the host it is thought 
>> to be on took part in the scan, it and all associated metadata will 
>> be wiped from the database.
>
>
> OK, so a new scan would restore only Videos with files that are 
> 'hashable' but their metadata would have been lost.  Not Good.

No metadata will be lost if the file was properly hashed on the old host 
and simply moved to a new host.  The only change would be a change to 
the host name associated with the video.

>
> Perhaps
>
> http://www.mythtv.org/wiki/Backend_migration#Retiring_an_old_backend
>
> ought to suggest scanning an empty Video folder on any host that's 
> about to be retired?

Yeah, I had considered adding something, but because we don't have a 
good way for the "no longer have access to the old host" side of it, I 
wanted to spend more time thinking before adding it (or, better, add a 
means for users to get rid of stuff interactively in the UI).

I'm not sure whether you could do so with the Video Manager (or whatever 
it's called) view, and if so, whether it would require individually 
finding and deleting videos.  I think I half remember someone saying 
that it refuses to delete the videos because the host can't be 
contacted/the video on that host can't be found.

Mike