Updating from 1.8 to 1.9 failed - "Invalid file handle 32" - dead system

Discussion in 'Installation, configuration support' started by StarWup, October 4, 2014.

  1. StarWup

    StarWup Portal Pro

    Joined:
    April 7, 2011
    Messages:
    113
    Likes Received:
    4
    Ratings:
    +5 / 1
    Home Country:
    Germany Germany
    Show System Specs
    Hi guys,

    the upgrade from 1.8 to 1.9 on my Win 8.1 x64 machine failed. Got the "Invalid file handle 32" error while installing MySQL v5.6. I don't remember if I selected MySQL v5.6 in the selection list for update or not - however the installer downloaded and ran the update setup for MySQL. By the way: I noticed that my MySQL already was v5.6. (from a earlier update to MP 1.8, I assume.). The installer threw up the "Invalid file handle 32" error (and did not or not fully install MySQL). After that the MP installer seemed to install the remaining components (MP 1.9 itself, TV Service 1.9, TV Client 1.9) but was ready in 5 seconds and did not update anything. After that MySQL was dead and so was MP, of course.
    From a Windows point of view the MySQL service didn't start anymore and wrote error 1067 to the event log.
    Since I know the admin user and the password I tried to repair the MySQL installation manually (there's missing something like "reinstall MySQL" from the MP installer menu).
    It turned out that this is a huge task. The native MySQL v5.6 installer wasn't able to complete the configuration for the DB server and threw up the "Invalid file handle 32" error, too. After that he caused a exception and was ended. Next step would have been to completly remove the MySQL application folder and reinstall MySQL from the scratch. But instead of diving deeper into the MySQL documentation I decided to restore Windows 8.1 to a previous working system restore point. If that doesn't help I'll do a complete image restore from a backup.
    And I'm sorry but no, I will not upload log files since the Invalid file handle 32 error is known at least since MP v1.8 and the bug fix (to copy the font to the installer dir) does not seem to make any change and was more a guess than a verified solution.



    Regards,
    Sven
     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. mm1352000
    • Team MediaPortal

    mm1352000 Development Group

    Joined:
    September 1, 2008
    Messages:
    21,541
    Likes Received:
    4,752
    Ratings:
    +8,221 / 17
    Home Country:
    New Zealand New Zealand
    Hello Sven

    You say this "invalid file handle" error is known, but I've never heard of it. If you assume you have the same issue as somebody else, refuse to provide log files to prove it, and don't even bother to link to a thread with a similar issue then I'm sorry but I can't help you.

    Good luck!
    mm
     
  4. HomeY
    • Team MediaPortal

    HomeY Test Group

    Joined:
    February 23, 2008
    Messages:
    6,460
    Likes Received:
    2,627
    Gender:
    Male
    Occupation:
    Network Engineer
    Location:
    ::1
    Ratings:
    +4,737 / 16
    Home Country:
    Netherlands Netherlands
    Show System Specs
  5. StarWup

    StarWup Portal Pro

    Joined:
    April 7, 2011
    Messages:
    113
    Likes Received:
    4
    Ratings:
    +5 / 1
    Home Country:
    Germany Germany
    Show System Specs
    Someone reported it here https://forum.team-mediaportal.com/threads/invalid-file-handle-32-and-sql-start-error.126631/
    but apparently he had nothing to lose and simply reinstalled everything including MySQL.
    In this case I will not reinstall anything in the risk of losing everything. I speak from personal experience while using MP for some time ;-)
    As I told yesterday I restored to a System Restore Point before the update and everything works fine again.

    My HTPC is a Win8.1 x64 machine and it's sole purpose is running MP in a single seat setup. Since this is my productive system, I've decided not to experiment with the system. So I never change anything on this machine without thinking twice. I even deactivated Windows Update (and some other application specific updates) to make sure the system doesn't change without notice. I backup daily. I do not install beta's oder preview releases. I stay on the safe side.
    So everything that's going on with MP on this machine is stock and absolutely not customized. This machine is the result of installing a MP update now and then. Maybe you can imagine my anger when simply running the installer for MP 1.9 crashed the MySQL service and left MP dead without any interference....
     
  6. HomeY
    • Team MediaPortal

    HomeY Test Group

    Joined:
    February 23, 2008
    Messages:
    6,460
    Likes Received:
    2,627
    Gender:
    Male
    Occupation:
    Network Engineer
    Location:
    ::1
    Ratings:
    +4,737 / 16
    Home Country:
    Netherlands Netherlands
    Show System Specs
    If you make a backup, you shouldn't lose anything. Since you have a working installation restored, you can simply use the export function of the TV Server to export your settings. As an alternative you could use the BackupSettings plugin to make the backup of both client & server installs.
     
    • Agree Agree x 1
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!