TV Server crashes on resume from hibernation (2 Viewers)

jmarc

MP Donator
  • Premium Supporter
  • August 21, 2008
    65
    9
    Home Country
    Australia Australia
    Hello team,

    Setup: MP 1.28 single seat on Win 10 pro x64, using MySQL database, wired NIC to router.
    The setup works fine until I put the computer on hibernate, then on resume TV server does not find MySQL and crashes. MySQL service is fine though.

    I can't just restart TV service as it's hung and need to restart the whole computer.

    It looks like TV service can't find my local IP address 192.168.1.70 (fixed DHCP lease) on resume. I tried to fix this by adding the DisableDHCPMediaSense=1 option in registry, to no avail.

    I finally fixed it by changing 192.168.1.70 to 127.0.0.1 in DefaultProvider name="MySQL" connectionString="Server=127.0.0.1 in gentle.config

    Not a big deal now that it's working as expected but it's more a workaround than a fix. Anyone has experienced the same issue?

    Log with comments is attached.

    Thanks!
     

    Attachments

    • TVService.log
      11.4 KB

    doskabouter

    Development Group
  • Team MediaPortal
  • September 27, 2009
    4,150
    2,399
    Nuenen
    Home Country
    Netherlands Netherlands
    Well I don't really agree that putting 127.0.0.1 is a "workaround", I think its a correct fix (for probably not all needed networking stuff fully operational after a resume).
    That being said, I don't really have a different solution, sleep/resume is quite nasty to do correctly
     

    azzuro

    Test Group
  • Team MediaPortal
  • May 10, 2007
    9,891
    5,549
    France - IDF
    Home Country
    France France
    hello, you can use also localhost as IP adress, or the Computer Name.
    define your IP is not good, your problem is maybe related than your server can't reach the IP before starting MySQL DB and TVservice.
     

    jmarc

    MP Donator
  • Premium Supporter
  • August 21, 2008
    65
    9
    Home Country
    Australia Australia
    Thanks both. I'll look into it. Maybe using a static IP address instead of a fixed DHCP assignment would also work. I just don't like using static IP addresses on my network.

    There is something odd though: the TV service crashes straight away on computer resume because it can't find the MySQL server although there should be a 30 seconds timeout. Any idea?

    [2021-10-30 17:26:44,758] [Log ] [PowerEventThread] [INFO ] - Tvservice stopped due to an unhandled app domain exception Error: DatabaseUnavailableUnclassified Gentle.Common.GentleException: The database backend (provider MySQL) could not be reached.
    Check the connection string: Server=192.168.1.70;Database=MpTvDb;User ID=root;Password=MediaPortal;charset=utf8;Connection Timeout=30; ---> MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> System.Exception: Exception of type 'System.Exception' was thrown. at MySql.Data.MySqlClient.NativeDriver.Open()

    Cheers,

    JM
     

    Users who are viewing this thread

    Similar threads

    What exactly does setting the IP address to a blank in the Server table do? Is the IP address no longer stored in the Server table so it accommodates IP address changes? The reason I am asking is that I have two subnets here. The subnet1 network is where this box will normally reside and the other, subnet2 network is where the other...
    What exactly does setting the IP address to a blank in the Server table do? Is the IP address no longer stored in the Server table...
    Was using MediaPortal 1.16 approximately 3 years ago on an old C2Duo E6850 w Win7 Enterprise and 4GB RAM. I stopped using...
    Replies
    5
    Views
    2K
    Hi CyberSimian, I have concluded the same thing. Disabled "Show last active module when resuming" and go to TV after starting up in the Home screen. Would be nice if it could start on TV (if that's where MP was when put to sleep), just like my older Panasonic PVR. But this workaround is reasonable. I will add that sometimes, even...
    Hi CyberSimian, I have concluded the same thing. Disabled "Show last active module when resuming" and go to TV after starting up...
    Hello, I have MP 1.22 freshly installed on a Windows 10 x64, Ver 1903. This was an upgrade from WIndows 10 x32. When I setup the...
    Replies
    2
    Views
    4K
    I tried upgrading to 1.17 but still had the same problem. No joy trying to blast signals to the set top box after resume from S3, but S1 works fine. I guess I'll have to wait for my USB-UIRT to arrive.
    I tried upgrading to 1.17 but still had the same problem. No joy trying to blast signals to the set top box after resume from S3...
    I've seen two other threads for this issue, but both have been inactive for years without a solution. When my computer wakes from...
    Replies
    6
    Views
    1K
    I thinks this is the first time I've installed MP on all my machines without a single IO error 32. Good work guys, thanks!
    I thinks this is the first time I've installed MP on all my machines without a single IO error 32. Good work guys, thanks!
    We have just released MediaPortal 1.26 - Winter is coming... Highlights of this release Bugfixes: [MP1-5031] - Fix Invalid File...
    Replies
    1
    Views
    2K
    Pre Releases are provided as a way for the community to test and give feedback on all the exciting things we have lined up for the next release. We allocate about one month for Pre Release testing. In that time we will only fix bugs, after which comes the final release! Highlights of this release Bugfixes: [MP1-5031] - Fix Invalid...
    Pre Releases are provided as a way for the community to test and give feedback on all the exciting things we have lined up for the...
    Pre Releases are provided as a way for the community to test and give feedback on all the exciting things we have lined up for the...
    Replies
    0
    Views
    2K
    Top Bottom