[mythtv-users] find_orphans deleted everything!
Bill Meek
keemllib at gmail.com
Fri Aug 7 05:41:30 UTC 2020
On 8/6/20 1:24 PM, Jim Abernathy wrote:
>
> On 8/4/20 11:38 AM, James Abernathy wrote:
>>
>>
>> On Tue, Aug 4, 2020 at 11:18 AM Bill Meek <keemllib at gmail.com <mailto:keemllib at gmail.com>> wrote:
>>
>> On 8/4/20 7:20 AM, James Abernathy wrote:
>> > This is strange. I've used the find_orphans script for years to
>> find
>> > problems and fix them; particularly after restoring a database.
>> >
>> > So after creating a new system with a new database but the same old
>> > recordings hard drive, I ran it looking for issues. It found
>> about 20 and
>> > I chose to delete the problems. It deleted everything including a
>> > recording that was happening at the time. Many of these were Live TV
>> > partial recordings and nothing of significance was lost.
>> However, it makes
>> > me wonder about find_orphan.py. I have the version that is for
>> v31+.
>> >
>> > Thoughts?
>> >
>> > JIm A
>>
>> I'm confused about the "nothing of significance was lost"
>> comment and the Subject: line.
>>
>> By everything, do you mean it deleted all of the recordings
>> on the "old recordings drive"?
>>
>> Did the initial output list the recordings that it planned
>> to delete?
>>
>> -- Bill
>>
>>
>> Sorry I was not clear. Since I rebuilt the system I have recorded nothing of interest, just keeping everything working. So losing all the
>> recordings since the rebuild is not significant . So if I check my storage groups directories "defaults" and "Livetv" I see only files
>> recorded since I did the destructed find_orphans.py.
>> So now I should have no orphans. Only 2 recordings and 1 livetv file. But if you look at the console below you'll see the problem.
>>
>> jim at mythbuntu:/mnt/md1$ ls recorded-tv2/
>> 10501_20200804123700.ts 11701_20200804122800.ts
>> 10501_20200804123700.ts.png 11701_20200804122800.ts.png
>> jim at mythbuntu:/mnt/md1$ ls livetv2/
>> 11101_20200804123728.ts
>> jim at mythbuntu:/mnt/md1$ cd
>> jim at mythbuntu:~$ ./find_orphans.py
>> Recordings with missing files
>> mythbuntu: CBS This Morning 11701_20200804122800.ts
>> mythbuntu: Good Morning America 11101_20200804123728.ts
>> mythbuntu: Today 10501_20200804123700.ts
>> Count: 3
>> Please select from the following
>> 1. Delete orphaned recording entries
>> 2. Refresh list
>> >
>
> Bill,
>
> Did you see what I was referring to?
Yes, and I don't have an answer. May be the use of BackendServerIP that doesn't
exist on a fresh install. Rather, MasterServerIP. Try changing both BackendServerIP
SQL to use the MasterServerIP.
If so, the SQL may need to be
WHERE hostname=%s AND value IN (%s, %s)""",
(host, 'BackendServerIP', 'MasterServerIP')
or something like that. Don't have time to work on it now.
Similar for the 2nd query (the else case).
> I ran the script again today, but exited and it showed the only 2 recordings on my system. Both made this morning and should not be orphans.
>
> -----------
>
> jim at mythbuntu:~$ ./find_orphans.py
> Recordings with missing files
> mythbuntu: Ask This Old House - Backsplash; Rainwater Feature 10404_20200806103000.ts
> mythbuntu: CBS This Morning 11701_20200806110000.ts
> Count: 2
> Please select from the following
> 1. Delete orphaned recording entries
> 2. Refresh list
--
Bill
More information about the mythtv-users
mailing list