Reply to thread

Message

<blockquote data-quote="alister" data-source="post: 1092901" data-attributes="member: 104434">Mediaportal 1.8 on q6600 8GB Ram c: SSD&nbsp; clean Win7 sp1 install&nbsp;using radiotimes as source I get a WebEPG hang &quot;Writing Channel&quot;SetupTV.log[2014-07-24 15:12:43,702] [Log&nbsp; ] [WebEPGImporter] [INFO ] - WebEPG: Writing Channel: 5*[2014-07-24 15:12:45,512] [Log&nbsp; ] [WebEPGImporter] [ERROR] - plugin:webepg import failed[2014-07-24 15:12:45,512] [Log&nbsp; ] [WebEPGImporter] [ERROR] - Exception&nbsp; :Error: StatementErrorUnclassifiedGentle.Common.GentleException: delete from Program where idChannel = ?idChannel and endTime &lt; '2014-07-23 15:12:43'; ---&gt; MySql.Data.MySqlClient.MySqlException: Deadlock found when trying to get lock; try restarting transaction&nbsp; at MySql.Data.MySqlClient.MySqlStream.OpenPacket()&nbsp; at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64&amp; affectedRows, Int64&amp; lastInsertId)&nbsp; at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()&nbsp; at MySql.Data.MySqlClient.MySqlDataReader.NextResult()&nbsp; at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)&nbsp; at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()&nbsp; at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)&nbsp; --- End of inner exception stack trace ---&nbsp; at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)&nbsp; at Gentle.Framework.PersistenceBroker.Execute(SqlStatement stmt, IDbConnection dbConnection, IDbTransaction dbTransaction)&nbsp; at TvDatabase.TvBusinessLayer.RemoveOldPrograms(Int32 idChannel)&nbsp; at MediaPortal.WebEPG.DatabaseEPGDataSink.MediaPortal.WebEPG.IEpgDataSink.EndChannelPrograms(String id, String name)&nbsp; at MediaPortal.EPG.WebEPG.Import()&nbsp; at TvEngine.WebEPGImport.ThreadFunctionImportTVGuide(Object aparam)MySql.Data.MySqlClient.MySqlException (0x80004005): Deadlock found when trying to get lock; try restarting transaction&nbsp; at MySql.Data.MySqlClient.MySqlStream.OpenPacket()&nbsp; at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64&amp; affectedRows, Int64&amp; lastInsertId)&nbsp; at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()&nbsp; at MySql.Data.MySqlClient.MySqlDataReader.NextResult()&nbsp; at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)&nbsp; at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()&nbsp; at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)Has happened with 5* ITV2 DMAX+1 and&nbsp; 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</blockquote>

[QUOTE="alister, post: 1092901, member: 104434"] 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 [/QUOTE]

Verification