MP1-4341 Add possibility to Deploy Tool to upgrade MySQL dB (1 Viewer)

Sebastiii

Development Group
  • Team MediaPortal
  • November 12, 2007
    16,434
    10,256
    France
    France France
    Country flag
    • Thread starter
    • Moderator
    • #41
    All seems to have gone ok but on the first startup of the client it took a long time to get beyond the initialization screen...
    The client log is filled with
    [2014-02-08 09:28:00,327] [Log ] [MPMain ] [DEBUG] - D3D FullRender: MP focus

    Sorry for the zip files but someone / somehow I can only upload a single file at a time again.
    btw: the 5.6 DB looks good from what I see
    I can confirm this issue (happen randomly) i will provide a fix for it :)
     

    elliottmc

    Retired Team Member
  • Premium Supporter
  • August 7, 2005
    14,927
    6,061
    Cardiff, UK
    United Kingdom United Kingdom
    Country flag
    All seems to have gone ok but on the first startup of the client it took a long time to get beyond the initialization screen...
    The client log is filled with
    [2014-02-08 09:28:00,327] [Log ] [MPMain ] [DEBUG] - D3D FullRender: MP focus

    Sorry for the zip files but someone / somehow I can only upload a single file at a time again.
    btw: the 5.6 DB looks good from what I see

    Logs show

    Code:
    [2014-02-08 09:22:31,528] [Log  ] [SetupTv  ] [INFO ] - SetupDatabaseForm: Added dependency for TvService - MySQL56
    [2014-02-08 09:22:31,528] [Log  ] [SetupTv  ] [INFO ] - ---- check if database needs to be updated/created ----
    [2014-02-08 09:22:31,538] [Log  ] [SetupTv  ] [INFO ] - ---- upgrade database schema ----
    but the new code has

    Log.Info("- database upgraded to schema version " + version);

    so I think it was fair to say that the database was not updated.

    Now the question is whether it needed to be.

    How can we check if the database is already using InnoDB ?

    @breese - did you do a clean install with 1.6.0, or any of the test builds with MySQL 5.6 ?[/code]
     

    breese

    Retired Team Member
  • Premium Supporter
  • July 11, 2011
    3,903
    769
    61
    Arlington Heights, Illinois
    United States of America United States of America
    Country flag
    I did a clean install about a week ago with one of the test builds
    I am including the install log from the last clean install and a zip export of my current database file
    Should give you all the info you need on how the DB is installed
     

    Attachments

    elliottmc

    Retired Team Member
  • Premium Supporter
  • August 7, 2005
    14,927
    6,061
    Cardiff, UK
    United Kingdom United Kingdom
    Country flag
    I did a clean install about a week ago with one of the test builds
    I am including the install log from the last clean install and a zip export of my current database file
    Should give you all the info you need on how the DB is installed
    Someone else will need to check your database, but if you did a clean install with one of my test builds in the last few weeks, you are already using InnoDB, so there is no need for this to do anything. However, this is still useful testing that it does exactly what it is supposed to do.
     

    breese

    Retired Team Member
  • Premium Supporter
  • July 11, 2011
    3,903
    769
    61
    Arlington Heights, Illinois
    United States of America United States of America
    Country flag
    Each time I restart my server, the TV Service logs an error in Windows System Events
    I have restarted my server 3 times and each time this is logged
    I cannot find any error listed in the MP logs

    ID: 7043
    The TVService service did not shut down properly after receiving a preshutdown control.
     

    michael_t

    Portal Pro
    November 30, 2008
    1,258
    813
    Germany Germany
    Each time I restart my server, the TV Service logs an error in Windows System Events
    I have restarted my server 3 times and each time this is logged
    I cannot find any error listed in the MP logs

    ID: 7043
    The TVService service did not shut down properly after receiving a preshutdown control.
    This is a known issue (MP1-3172 TVService ignores shutdown). It is already fixed but the fix is not implemented in MP 1.7 (pre-release) because of TV Server code freeze.

    Michael
     

    elliottmc

    Retired Team Member
  • Premium Supporter
  • August 7, 2005
    14,927
    6,061
    Cardiff, UK
    United Kingdom United Kingdom
    Country flag
    Each time I restart my server, the TV Service logs an error in Windows System Events
    I have restarted my server 3 times and each time this is logged
    I cannot find any error listed in the MP logs

    ID: 7043
    The TVService service did not shut down properly after receiving a preshutdown control.
    This is a known issue (MP1-3172 TVService ignores shutdown). It is already fixed but the fix is not implemented in MP 1.7 (pre-release) because of TV Server code freeze.

    Michael

    If we get a Jira and GIT branch to fix this problem in TVE35, then we can include it in the next release. If you can do this, we can potentially have this fix in 1.7.0.
     

    Sebastiii

    Development Group
  • Team MediaPortal
  • November 12, 2007
    16,434
    10,256
    France
    France France
    Country flag
    • Thread starter
    • Moderator
    • #48
    TVE35 will not be impacted because previous fix that 3172 solve for TVE3 was not ported.
    But still, surely the same root of issue exist on TVE35 (need confirmation). So could be nice to have a branch + Jira for tve35 :)
     

    michael_t

    Portal Pro
    November 30, 2008
    1,258
    813
    Germany Germany
    Each time I restart my server, the TV Service logs an error in Windows System Events
    I have restarted my server 3 times and each time this is logged
    I cannot find any error listed in the MP logs

    ID: 7043
    The TVService service did not shut down properly after receiving a preshutdown control.
    This is a known issue (MP1-3172 TVService ignores shutdown). It is already fixed but the fix is not implemented in MP 1.7 (pre-release) because of TV Server code freeze.

    Michael

    If we get a Jira and GIT branch to fix this problem in TVE35, then we can include it in the next release. If you can do this, we can potentially have this fix in 1.7.0.
    Here you are: TVLIB-73 TvService ignores shutdown

    Michael
     

    Users Who Are Viewing This Thread (Users: 0, Guests: 1)

    OP Similar threads Forum Replies Date
    C Hauppauge HVR-1265 -- does it work with MP1? MediaPortal 1 Talk 1
    ajs MP2Web - MP1 compatibility MediaPortal 1 20
    T MadVR + LAV Filters, Perfect in MPC-BE, Bad in MP1 MediaPortal 1 Talk 13
    P MP2: US user, OTA - can NOT get SchedulesDirect plugin to work on MP1 or MP2 --> how do I get OTA schedule? General 5
    framug [solved] Some changes/fix in MP1 configuration client and server Submit: code patches (MediaPortal/TV-Server/etc.) 14
    S TV-Server MP1 - Automatic search doesn't work Installation, configuration support 2
    C Streaming/transcoding MP2 vs MP1? General 4
    ajs [fixed] 5015: Improving the MP1 installer, providing nicer GUI :) MediaPortal 1 138
    C Streaming to clients over Wifi. MP1 or MP2? Newcomers Forum 0
    S Shortcuts MP1 My Recorded & TV Guide General 10
    azzuro [WiP] MP1-4999 - Big changes with many related change at once by Sebastiii MediaPortal 1 12
    ajs [Help Us!] MP1 X64 Version MediaPortal 1 20
    joecrow How about a Launcher plugin for MP1? MediaPortal 1 6
    wizard123 [solved] MP1 Build help MediaPortal 1 21
    ajs [News] MediaPortal 1 - 1.24 Released! News and Announcements 3
    CyberSimian [fixed] MP1-4990 : Improve horizontal scrolling in the EPG MediaPortal 1 10
    azzuro [WiP] MP1-5019: Replace MySQL with MariaDB MediaPortal 1 40
    catalpa Umsteiger von MP1: Schwierigkeiten Allgemeines Support- und Diskussionsforum 17
    CyberSimian [solved] MP1-4976 Built-in skin variables for current date MediaPortal 1 8
    rbo [solved] Umsteiger MP1 zu MP2 Allgemeines Support- und Diskussionsforum 67
    azzuro [Info] MP2 TVE inside MP1 repo MediaPortal 2 12
    G MP1 TV Server "failed to upgrade the database" using MS Sql Server Installation, configuration support 3
    lisag Can I get MP1 to open in the Recorded TV screen? MediaPortal 1 Talk 2
    M MP1 stops responding after Starting Plugins General Support 14
    R Problem with MP1 and WifiRemote Skins and Plugins Installer (MPEI) 8
    Similar threads

























    Top Bottom