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...
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...