home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Support
Electronic Program Guide
No guide info added due to a MYSQL deadlock
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="doskabouter" data-source="post: 1253169" data-attributes="member: 98267"><p>Hi,</p><p></p><p>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...</p><p></p><p>Sometimes I have a lot of info missing in my tv-guide.</p><p>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)</p><p>This is after quite a number of successfull channels, and after that error no other channels are added.</p><p></p><p>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.</p><p>The combination of nothing new and a bunch of programs still in the epg-table seems to trigger this deadlock.</p><p></p><p>Is anyone else having this kind of issues?</p><p>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.</p><p>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.</p><p>Let me know what you think...</p></blockquote><p></p>
[QUOTE="doskabouter, post: 1253169, member: 98267"] 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... [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
Electronic Program Guide
No guide info added due to a MYSQL deadlock
Contact us
RSS
Top
Bottom