WebEPG Deadlocks UK (1 Viewer)

[alister]

Mediaportal 1.8 on q6600 8GB Ram c: SSD clean Win7 sp1 install

using radiotimes as source I get a WebEPG hang "Writing Channel"

SetupTV.log

[2014-07-24 15:12:43,702] [Log ] [WebEPGImporter] [INFO ] - WebEPG: Writing Channel: 5*
[2014-07-24 15:12:45,512] [Log ] [WebEPGImporter] [ERROR] - plugin:webepg import failed
[2014-07-24 15:12:45,512] [Log ] [WebEPGImporter] [ERROR] - Exception :Error: StatementErrorUnclassified
Gentle.Common.GentleException: delete from Program where idChannel = ?idChannel and endTime < '2014-07-23 15:12:43'; ---> MySql.Data.MySqlClient.MySqlException: Deadlock found when trying to get lock; try restarting transaction
at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)
--- End of inner exception stack trace ---
at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)
at Gentle.Framework.PersistenceBroker.Execute(SqlStatement stmt, IDbConnection dbConnection, IDbTransaction dbTransaction)
at TvDatabase.TvBusinessLayer.RemoveOldPrograms(Int32 idChannel)
at MediaPortal.WebEPG.DatabaseEPGDataSink.MediaPortal.WebEPG.IEpgDataSink.EndChannelPrograms(String id, String name)
at MediaPortal.EPG.WebEPG.Import()
at TvEngine.WebEPGImport.ThreadFunctionImportTVGuide(Object aparam)MySql.Data.MySqlClient.MySqlException (0x80004005): Deadlock found when trying to get lock; try restarting transaction
at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)

Has happened with 5* ITV2 DMAX+1 and Discovery if I move these in webepg.xml to end i.e. separate them from 5USA / ITV3 / ITV4 Discovery +1 it appears to run fine

 

[JJDoherty]

Hi @alister, you might want to have a look at this, which is an updated version of the WebEPG plugin kindly provided by @Tony Wall.

 

[alister]

Hi @alister, you might want to have a look at this, which is an updated version of the WebEPG plugin kindly provided by @Tony Wall.

Thanks, but I'm using 1.8 (dll version is 1.8 - 22/06/14) so I should have this update (1.7 20/04/14)?

also I'm using radiotimes not mydigiguide as source - the source works just not with 5* then 5USA (5* what a great name for a channel, using a wildcard)

I rebuilt the PC from ground up (software wise) when I installed 1.8 (as I'd done 1.4,1.5,1.6,1.7 and thought I'd like it clean)

 

[JJDoherty]

Ah right @alister, fair enough, you should have the latest version so. After that I am a bit stumped. I do know that @Tony Wall is working on updating the plugin further so it may be something that will be resolved in the future but at least you do have a current work around.

 

[SwissBuster]

I had the same isse - it would hang when writing to BBC 4 HD. Like you I am grabbing radiotimes data. I removed this channel from the Webepg listing, then re-entered it, and it seems to work now.

My issue with webepg is that gettting data for German or Swiss channels is extremely slow. But I won't hijack your thread.