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