<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<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 <jfabernathy@gmail.com><br>
<b>Sent:</b> Friday, 7 August 2020 7:52 pm<br>
<b>To:</b> mythtv-users@mythtv.org<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 <keemllib@gmail.com
</div>
<div class="nine-pg" dir="auto">>>> <mailto:keemllib@gmail.com>> 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">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">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">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">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>
</body>
</html>