[mythtv-users] "Migrated" recordings from 0.24 won't stream via HLS

[Thomas Pontoppidan]

2012/5/31 Michael T. Dean <mtdean at thirdcontact.com>

> On 05/31/2012 01:33 AM, Thomas Pontoppidan wrote:
>
>> 2012/5/30 Michael T. Dean
>>
>>> On 05/30/2012 03:03 AM, Thomas Pontoppidan wrote:
>>>
>>>> 2012/5/29 Michael T. Dean
>>>>
>>>>  On 05/29/2012 03:36 AM, Thomas Pontoppidan wrote:
>>>>
>>>>>  During this weekend I finally chose to reinstall my backend - moving
>>>>>
>>>>>> During this weekend I finally chose to reinstall my backend - moving
>>>>>> from
>>>>>> an old Fedora install to MythBuntu. For different reasons I decided to
>>>>>> go
>>>>>> against recommendations and not move the entire database. I only
>>>>>> transferred my recordings following this guide
>>>>>> http://www.mythpvr.com/mythtv/****tips/migrate-recordings.html<http://www.mythpvr.com/mythtv/**tips/migrate-recordings.html>
>>>>>> .
>>>>>>
>>>>> Yes.  Google should be kicked off the Internet for allowing that
>>>>> ancient,
>>>>> outdated, incorrect, can-corrupt-the-db-data (as it can completely
>>>>> break
>>>>> your character encoding) post to be #1.
>>>>>
>>>>>  Well, I won't blame Google - after all it was my decision to not
>>>> follow
>>>> official directions:-)
>>>>
>>>>>  From a normal frontend the recordings are playing fine, but HLS
>>>>>> doesn't
>>>>>> seem to work - I try to stream to Torc for IOS, but the "prepare
>>>>>> stream"
>>>>>> stays at 0%. If I make a new recording it streams fine so I'm guessing
>>>>>> some
>>>>>> new fields in the recordings table are missing? Is there any way to
>>>>>> add
>>>>>> the
>>>>>> missing info (if my assumption is correct) to the database?
>>>>>>
>>>>> Best solution is to do a proper restore of your complete pre-upgrade
>>>>> database and let MythTV Do The Right Thing.
>>>>>
>>>> Looking back that is probably what I *should* have done, but I am not
>>>> sure
>>>> I'm up for that now - I spent most of a day setting up the new database,
>>>> mostly because I wasn't satisfied with the old setup (non-standard
>>>> keybindings,
>>>>
>>>>  can be reset to defaults by going into mythfrontend
>>> Utilities/Setup|Edit
>>> Keys, then using MENU to select "Reset All Keys to Defaults" (
>>> http://www.gossamer-threads.****com/lists/mythtv/commits/****
>>> 487153#487153<http://www.**gossamer-threads.com/lists/**
>>> mythtv/commits/487153#487153<http://www.gossamer-threads.com/lists/mythtv/commits/487153#487153>>)
>>> on any frontend whose key bindings you want to reset.
>>>
>>>
>>>  bad tuner setup,
>>>>
>>>>  which could have been reset/cleared by using mythtv-setup to do a
>>> "Delete
>>> all capture cards"
>>>
>>>> flawed channel lists etc.).
>>>>
>>>>  and a "Delete all video sources" (not "Delete all video sources on
>>> <hostname>").
>>>
>>>  Going back would
>>>> require me to do it all over again:-)
>>>>
>>>>  But would make the rest of your system function properly--and without
>>> any
>>> concerns over the integrity of your database schema or data.
>>>
>>>  If you decide you want to waste hours re-configuring everything for no
>>>>> benefit, at least do a proper partial restore:
>>>>> http://www.mythtv.org/wiki/**Database_Backup_and_Restore#**
>>>>> Partial_restore_of_a_backup<http://www.mythtv.org/wiki/Database_Backup_and_Restore#Partial_restore_of_a_backup>(and take note of
>>>>> http://www.mythtv.org/wiki/**Database_Backup_and_Restore#**
>>>>> Partial_restore_when_**upgrading_MythTV<http://www.mythtv.org/wiki/Database_Backup_and_Restore#Partial_restore_when_upgrading_MythTV>
>>>>> ).
>>>>>
>>>>  I already did reconfigure the entire setup and according to the links I
>>>> would need to do some preparation on the old setup - obviously not
>>>> possible
>>>> now that the system is already upgraded:-(
>>>>
>>>> Guess I will have a closer look at the tables while I consider the
>>>> "complete restore" option:-(
>>>>
>>>>  Right, I'm suggesting you either do a full restore--and then use MythTV
>>> tools to clean up what you don't like--or start over with a supported
>>> partial restore.  I can't guarantee that HLS would work with your old
>>> recordings if you do the partial restore using the restore script, but at
>>> that point, I'd be motivated to help debug the issues, since I wouldn't
>>> have any reason to assume your DB is corrupt.
>>>
>>
>> Thanks for your input - I will definitely use the proper procedure next
>> time! But this time I just can't imagine starting over after all the work
>> I've done:-)
>>
>> Anyway, problem seems to be solved: I found a difference in paths in the
>> "livestream" table during HLS streaming - for new recordings it pointed to
>> the recording's real location while the old recording entry would point to
>> "myth:@"host-from-the-old-**setup"/"file". After updating the hostname
>> in the
>> recordings table and restarting mythbackend streaming works fine!
>>
>
> Meaning you changed your host name and didn't update your MythTV setup:
>
> http://www.mythtv.org/wiki/**Database_Backup_and_Restore#**
> Change_the_hostname_of_a_**MythTV_frontend_or_backend<http://www.mythtv.org/wiki/Database_Backup_and_Restore#Change_the_hostname_of_a_MythTV_frontend_or_backend>
>
> If you're comfortable believing that everything else--data and schema--in
> your current DB is good and there's no other brokenness (other than the
> loss of non-re-creatable information due to the broken procedure you
> followed for the partial restore) and/or that you can figure out and fix
> all the problems that crop up in the future (and you believe that doing so
> will take less time than doing a full restore of the pre-upgrade DB backup,
> changing hostname (as above), Delete All Capture Cards, Delete All Video
> Sources, creating new cards and video sources, connecting inputs, and
> scanning channels, then resetting key bindings in mythfrontend...), I
> suppose I'm comfortable letting you run with your
> not-as-good-as-it-should-be database.  :)  (Just saying that you won't have
> the option to go back to your pre-upgrade database backup for long, so now
> is the only opportunity...)
>

I am comfortable believing that everything besides the migrated data is
good - after all, everything else is configured from scratch and the old
recordings will eventually be deleted.

I do get you subtle hint, but under the circumstances I would rather run
with my not-as-godd-as-it-should-be database than develop a
not-as-good-as-it-should-be relationship with my better half by spending
more time on the upgrade;-)

Thanks again!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20120601/ee37cf34/attachment.html>