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

[John Pilkington]

On 04/09/13 15:20, Michael T. Dean wrote:
> 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.
>
That's certainly what I found.  But I guess this topic can rest and 
mature for a bit now; it's probably not mainstream.   Thanks for your help.

> Mike