<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p><br>
</p>
<div class="moz-cite-prefix">On 8/7/20 6:34 AM, Mark Perkins wrote:<br>
</div>
<blockquote type="cite"
cite="mid:PS2P216MB07712BD3ACB2D7355A3DD2ABB7490@PS2P216MB0771.KORP216.PROD.OUTLOOK.COM">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<div style="font-family:Calibri, Arial, Helvetica, sans-serif;
font-size:12.0pt; line-height:1.3; color:#1F497D"
id="nine_body_n173c87-8ea1c" class="nine_body" dir="auto">
<div class="nine-pg" dir="auto"><br>
</div>
</div>
<div id="quoted_header_n173c87-8ea1c" class="quoted_header_editor
fold" dir="auto">
<hr style="border:none; height:1px; color:#E1E1E1;
background-color:#E1E1E1;" class="nine-pg">
<div style="border:none; padding:3.0pt 0cm 0cm 0cm"
class="nine-pg" dir="auto"><span
style="font-size:11.0pt;font-family:Calibri, Arial,
Helvetica, sans-serif"><b>From:</b> Jim Abernathy
<a class="moz-txt-link-rfc2396E" href="mailto:jfabernathy@gmail.com"><jfabernathy@gmail.com></a><br>
<b>Sent:</b> Friday, 7 August 2020 7:52 pm<br>
<b>To:</b> <a class="moz-txt-link-abbreviated" href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<b>Subject:</b> Re: [mythtv-users] find_orphans deleted
everything!<br>
</span></div>
</div>
<div id="quoted_body_n173c87-8ea1c" class="quoted_body_editor
mceEditable fold" dir="auto">
<div class="nine-pg" dir="auto"><br type="attribution">
</div>
<blockquote class="quote nine-pg" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="nine-pg" dir="auto">
<div class="nine-pg" dir="auto"><br>
</div>
<div class="nine-pg" dir="auto">On 8/7/20 1:41 AM, Bill Meek
wrote:</div>
<div class="nine-pg" dir="auto">> On 8/6/20 1:24 PM, Jim
Abernathy wrote:</div>
<div class="nine-pg" dir="auto">>></div>
<div class="nine-pg" dir="auto">>> On 8/4/20 11:38 AM,
James Abernathy wrote:</div>
<div class="nine-pg" dir="auto">>>></div>
<div class="nine-pg" dir="auto">>>></div>
<div class="nine-pg" dir="auto">>>> On Tue, Aug 4,
2020 at 11:18 AM Bill Meek <<a class="moz-txt-link-abbreviated" href="mailto:keemllib@gmail.com">keemllib@gmail.com</a>
</div>
<div class="nine-pg" dir="auto">>>>
<a class="moz-txt-link-rfc2396E" href="mailto:keemllib@gmail.com"><mailto:keemllib@gmail.com></a>> wrote:</div>
<div class="nine-pg" dir="auto">>>></div>
<div class="nine-pg" dir="auto">>>> On 8/4/20
7:20 AM, James Abernathy wrote:</div>
<div class="nine-pg" dir="auto">>>> > This
is strange. I've used the find_orphans script for years
to</div>
<div class="nine-pg" dir="auto">>>> find</div>
<div class="nine-pg" dir="auto">>>> >
problems and fix them; particularly after restoring a
database.</div>
<div class="nine-pg" dir="auto">>>> ></div>
<div class="nine-pg" dir="auto">>>> > So
after creating a new system with a new database but the
</div>
<div class="nine-pg" dir="auto">>>> same old</div>
<div class="nine-pg" dir="auto">>>> >
recordings hard drive, I ran it looking for issues. It
found</div>
<div class="nine-pg" dir="auto">>>> about 20
and</div>
<div class="nine-pg" dir="auto">>>> > I
chose to delete the problems. It deleted everything
including a</div>
<div class="nine-pg" dir="auto">>>> >
recording that was happening at the time. Many of these
were
</div>
<div class="nine-pg" dir="auto">>>> Live TV</div>
<div class="nine-pg" dir="auto">>>> >
partial recordings and nothing of significance was lost.</div>
<div class="nine-pg" dir="auto">>>> However, it
makes</div>
<div class="nine-pg" dir="auto">>>> > me
wonder about find_<a href="http://orphan.py"
moz-do-not-send="true">orphan.py</a>. I have the
version that is for</div>
<div class="nine-pg" dir="auto">>>> v31+.</div>
<div class="nine-pg" dir="auto">>>> ></div>
<div class="nine-pg" dir="auto">>>> >
Thoughts?</div>
<div class="nine-pg" dir="auto">>>> ></div>
<div class="nine-pg" dir="auto">>>> > JIm A</div>
<div class="nine-pg" dir="auto">>>></div>
<div class="nine-pg" dir="auto">>>> I'm
confused about the "nothing of significance was lost"</div>
<div class="nine-pg" dir="auto">>>> comment and
the Subject: line.</div>
<div class="nine-pg" dir="auto">>>></div>
<div class="nine-pg" dir="auto">>>> By
everything, do you mean it deleted all of the recordings</div>
<div class="nine-pg" dir="auto">>>> on the "old
recordings drive"?</div>
<div class="nine-pg" dir="auto">>>></div>
<div class="nine-pg" dir="auto">>>> Did the
initial output list the recordings that it planned</div>
<div class="nine-pg" dir="auto">>>> to delete?</div>
<div class="nine-pg" dir="auto">>>></div>
<div class="nine-pg" dir="auto">>>> -- Bill</div>
<div class="nine-pg" dir="auto">>>></div>
<div class="nine-pg" dir="auto">>>></div>
<div class="nine-pg" dir="auto">>>> Sorry I was not
clear. Since I rebuilt the system I have recorded
</div>
<div class="nine-pg" dir="auto">>>> nothing of
interest, just keeping everything working. So losing all
</div>
<div class="nine-pg" dir="auto">>>> the recordings
since the rebuild is not significant . So if I check
</div>
<div class="nine-pg" dir="auto">>>> my storage
groups directories "defaults" and "Livetv" I see only
</div>
<div class="nine-pg" dir="auto">>>> files recorded
since I did the destructed find_<a
href="http://orphans.py" moz-do-not-send="true">orphans.py</a>.</div>
<div class="nine-pg" dir="auto">>>> So now I should
have no orphans. Only 2 recordings and 1
</div>
<div class="nine-pg" dir="auto">>>> livetv file.
But if you look at the console below you'll see the
</div>
<div class="nine-pg" dir="auto">>>> problem.</div>
<div class="nine-pg" dir="auto">>>></div>
<div class="nine-pg" dir="auto">>>>
jim@mythbuntu:/mnt/md1$ ls recorded-tv2/</div>
<div class="nine-pg" dir="auto">>>>
10501_20200804123700.ts 11701_20200804122800.ts</div>
<div class="nine-pg" dir="auto">>>>
10501_20200804123700.ts.png 11701_20200804122800.ts.png</div>
<div class="nine-pg" dir="auto">>>>
jim@mythbuntu:/mnt/md1$ ls livetv2/</div>
<div class="nine-pg" dir="auto">>>>
11101_20200804123728.ts</div>
<div class="nine-pg" dir="auto">>>>
jim@mythbuntu:/mnt/md1$ cd</div>
<div class="nine-pg" dir="auto">>>>
jim@mythbuntu:~$ ./find_<a href="http://orphans.py"
moz-do-not-send="true">orphans.py</a></div>
<div class="nine-pg" dir="auto">>>> Recordings with
missing files</div>
<div class="nine-pg" dir="auto">>>> mythbuntu:
CBS This Morning 11701_20200804122800.ts</div>
<div class="nine-pg" dir="auto">>>> mythbuntu:
Good Morning America 11101_20200804123728.ts</div>
<div class="nine-pg" dir="auto">>>> mythbuntu:
Today 10501_20200804123700.ts</div>
<div class="nine-pg" dir="auto">>>>
Count: 3</div>
<div class="nine-pg" dir="auto">>>> Please select
from the following</div>
<div class="nine-pg" dir="auto">>>> 1. Delete
orphaned recording entries</div>
<div class="nine-pg" dir="auto">>>> 2. Refresh
list</div>
<div class="nine-pg" dir="auto">>>> ></div>
<div class="nine-pg" dir="auto">>></div>
<div class="nine-pg" dir="auto">>> Bill,</div>
<div class="nine-pg" dir="auto">>></div>
<div class="nine-pg" dir="auto">>> Did you see what I
was referring to?</div>
<div class="nine-pg" dir="auto">></div>
<div class="nine-pg" dir="auto">> Yes, and I don't have
an answer. May be the use of BackendServerIP
</div>
<div class="nine-pg" dir="auto">> that doesn't</div>
<div class="nine-pg" dir="auto">> exist on a fresh
install. Rather, MasterServerIP. Try changing both
</div>
<div class="nine-pg" dir="auto">> BackendServerIP</div>
<div class="nine-pg" dir="auto">> SQL to use the
MasterServerIP.</div>
<div class="nine-pg" dir="auto">></div>
<div class="nine-pg" dir="auto">> If so, the SQL may need
to be</div>
<div class="nine-pg" dir="auto">></div>
<div class="nine-pg" dir="auto">> WHERE hostname=%s AND
value IN (%s, %s)""",</div>
<div class="nine-pg" dir="auto">> (host,
'BackendServerIP', 'MasterServerIP')</div>
<div class="nine-pg" dir="auto">></div>
<div class="nine-pg" dir="auto">> or something like that.
Don't have time to work on it now.</div>
<div class="nine-pg" dir="auto">> Similar for the 2nd
query (the else case).</div>
<div class="nine-pg" dir="auto"><br>
</div>
<div class="nine-pg" dir="auto">I played with the script a
little but I have two handicaps, (1.) I don't
</div>
<div class="nine-pg" dir="auto">know mysql and (2.) I don't
know python3.</div>
<div class="nine-pg" dir="auto"><br>
</div>
<div class="nine-pg" dir="auto">So I'm not going to be any
help here. So basically, I'm making a note
</div>
<div class="nine-pg" dir="auto">on my system that find_<a
href="http://orphan.py" moz-do-not-send="true">orphan.py</a>
is not to be trusted.</div>
<div class="nine-pg" dir="auto"><br>
</div>
<div class="nine-pg" dir="auto">I don't imagine that I have
a problem now and I'll be careful moving
</div>
<div class="nine-pg" dir="auto">forward.</div>
<div class="nine-pg" dir="auto"><br>
</div>
<div class="nine-pg" dir="auto">Jim A</div>
<div class="nine-pg" dir="auto"><br>
</div>
<div class="nine-pg" dir="auto"><br>
</div>
<div class="nine-pg" dir="auto"><br>
</div>
<div class="nine-pg" dir="auto"><br>
</div>
</div>
</blockquote>
<div class="nine-pg" dir="auto">
<div class="nine-pg" dir="auto">Does the user running the
script have the same permissions as the user running the
backend (alternatively try running script as same user as
backend). Are you running script remotely from storage
groups / backend? </div>
</div>
</div>
<br>
</blockquote>
<p>As a test I replaced the find_orphan.py on both the backend and a
frontend with the v31 version from the wiki.<a
href="https://www.mythtv.org/wiki/Find_orphans.py">https://www.mythtv.org/wiki/Find_orphans.py</a></p>
<p>Then I ran it on the backend console as me, 'jim', and as
'mythtv'. No change; still listed all my current recordings as
"Recordings with missing files".</p>
<p>Then I ran it on a frontend that can run mythfrontend okay and
the results were the same. The recordings with missing files that
were listed were the only 3 on the system at the time and one was
being recording at that instant.</p>
<p>Jim A<br>
<br>
</p>
</body>
</html>