No guide info added due to a MYSQL deadlock

Discussion in 'Electronic Program Guide' started by doskabouter, February 3, 2019.

  1. doskabouter
    • Premium Supporter

    doskabouter Community Plugin Dev

    Joined:
    September 27, 2009
    Messages:
    2,769
    Likes Received:
    735
    Location:
    Nuenen
    Ratings:
    +1,085 / 1
    Home Country:
    Netherlands Netherlands
    Show System Specs
    Hi,

    Not sure if this is better put in the WEBEPG section (because that's the plugin that is acting up) but over here it might get somewhat more attention...



    Sometimes I have a lot of info missing in my tv-guide.
    Checking the logs, it is because Mysql runs into a deadlock ( MySql.Data.MySqlClient.MySqlException: Deadlock found when trying to get lock; try restarting transaction)
    This is after quite a number of successfull channels, and after that error no other channels are added.

    I more or less found the cause of it, it happens when the provider (tvgids.tv in this case) suddenly decides to not have programdata for a given channel anymore.
    The combination of nothing new and a bunch of programs still in the epg-table seems to trigger this deadlock.

    Is anyone else having this kind of issues?
    Of course it's better to fix this problem, but I already checked the code and (apart from deadlocks in general to be difficult to fix) it seem to be not trivial to fix this.
    If I'm the only one having these kind of issues I tend to go and delete the programs from the offending channel and hope it doesn't happen too often, but if it would benefit others too I might take a stab at fixing the root-cause.
    Let me know what you think...
     

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!