[mythtv-users] find_orphans.py not working as expected

[Gary Raposo]

On 2020-05-15 1:51 p.m., Roland Ernst wrote:
> On Fri, May 15, 2020 at 3:43 PM Gary Raposo <gary at raposo.ca> wrote:
>> On 2020-05-14 5:09 p.m., Bill Meek wrote:
>>> On 5/14/20 3:19 PM, Gary Raposo wrote:
>>> ...
>>>
>>> If I have a host value that doesn't match my recordings, then I get all
>>> recordings showing up as missing.
>>>
>>> Try printing the hosts value like this:
>>>
>>>      else:
>>>          with DB as c:
>>>              c.execute("""SELECT hostname FROM settings
>>>                           WHERE value='BackendServerIP'""")
>>>              hosts = [r[0] for r in c.fetchall()]
>>>              print('hosts=',hosts) # <---------------------------
>>>
>>> Look at some recordings. Press 'i' twice and see what the value of
>>> Recording Host: is set to.
>>>
>> Thanks for the suggestions, Bill. Still no luck.
>>
>> I checked the settings table and I do not have an entry for
>> BackendServerIP. I do have a valid/correct entry for MasterServerIP so
>> changed the code to reference MasterServerIP. No change.
>>
>> If I add the print statement you suggested, it's still showing None:
>> hosts= [None]
>>
>> Checking my recordings (pressing "i" twice) I can see that they are all
>> correctly tagged with odysseus as the hostname. MasterServerIP
>> references the correct IP address for odysseus and /etc/hosts matches.
>>
>> Looking at the query, it looks like they are pulling hostname from the
>> settings table for the entry associated with the
>> BackendServerIP/MasterServerIP. I hadn't really looked at it that
>> closely before and assumed they were pulling the hostname based on the
>> data field. Wouldn't you know it, hostname is set to NULL for that entry.
>>
>> I updated the settings table and set hostname = odysseus for
>> MasterServerIP + added an entry for BackendServerIP (just in case) and
>> now I've moved on to a whole different set of problems!
>>
>> Before, I was able to see all my recordings but they were listed as
>> "Recordings with missing files". Now I get no output and the following
>> errors:
>>
>> $ ./find_orphans.py
>> Traceback (most recent call last):
>>     File "./find_orphans.py", line 222, in <module>
>>       BE = MythBE(db=DB)
>>     File "/usr/lib/python3.7/site-packages/MythTV/mythproto.py", line 80,
>> in __init__
>>       self.hostname = self.db._gethostfromaddr(self.host)
>>     File "/usr/lib/python3.7/site-packages/MythTV/database.py", line
>> 1348, in _gethostfromaddr
>>       'BackendServerAddr', addr)
>> MythTV.exceptions.MythDBError: Could not find setting
>> 'BackendServerAddr' on host 'None'
>>
>> Not too sure what's going on. Looking at the settings table, I have
>> three entries: BackendServerIP, MasterServerIP, and BackendServerAddr.
>> All have data set to 10.10.10.20 and hostname = odysseus.
>>
>> I'm poking around now in mythproto.py and database.py but (again) my
>> lack of Python experience is making this a slow process.
>>
>> As always, any suggestions are welcome.
>>
>> Gary
>
> Gary
> MythTV v29 changed the behaviour for
> 'BackendServerAddr', 'BackendServerIP', 'BackendServerIP6'
> as described in ticket https://code.mythtv.org/trac/ticket/13024.
>
> In short:
> If someone explicitly wants a 'BackendServerIP' or 'BackendServerIP6'
> this must be entered in the database during the setup step.
> But 'BackendServerAddr' should be always in the database for each backend.
>
> The script 'find_orphans.py' iterates over all backends, therefore
> I kindly ask you to change every occurrence of
> 'BackendServerIP' to 'BackendServerAddr' in this script and try again.
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org

Thanks, everyone, for your help and suggestions. It seems to be working now.

Here's what I did (taking into account feedback from the last few 
replies to this thread):

- updated the settings table to revert the hostname field back to NULL 
for MasterServerIP
- deleted and rebuilt find_orphans.py from 
https://www.mythtv.org/wiki/Find_orphans.py (too many print statements 
and changes so I wanted to make sure I didn't introduce any errors myself)
- updated find_orphans.py to use BackendServerAddr not BackendServerIP
- ran mythutil --clearcache

find_orphans.py now runs as expected. The net of it seems to be the 
change to BackendServerAddr + running mythutil --clearcache for good 
measure.

Thanks again!
Gary