Reply to thread

Message

<blockquote data-quote="mm1352000" data-source="post: 1098948" data-attributes="member: 82144">Same error as earlier with CSPAN 3 HD:[collapse][2014-09-07 00:42:43,132] [Log&nbsp; ] [WebEPGImporter] [INFO ] - WebEPG: Writing Channel: HBO Family West HD[2014-09-07 00:42:43,461] [Log&nbsp; ] [WebEPGImporter] [ERROR] - plugin:webepg import failed[2014-09-07 00:42:43,462] [Log&nbsp; ] [WebEPGImporter] [ERROR] - Exception&nbsp; :Error: StatementErrorUnclassifiedGentle.Common.GentleException: delete from Program where idChannel = ?idChannel and endTime &lt; '2014-09-06 00:42: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)[/collapse]Close MP.Make sure you're not trying to run two imports at the same time.If those two things don't help I don't know what else will.</blockquote>

[QUOTE="mm1352000, post: 1098948, member: 82144"] Same error as earlier with CSPAN 3 HD: [collapse] [2014-09-07 00:42:43,132] [Log ] [WebEPGImporter] [INFO ] - WebEPG: Writing Channel: HBO Family West HD [2014-09-07 00:42:43,461] [Log ] [WebEPGImporter] [ERROR] - plugin:webepg import failed [2014-09-07 00:42:43,462] [Log ] [WebEPGImporter] [ERROR] - Exception :Error: StatementErrorUnclassified Gentle.Common.GentleException: delete from Program where idChannel = ?idChannel and endTime < '2014-09-06 00:42: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)[/collapse] Close MP. Make sure you're not trying to run two imports at the same time. If those two things don't help I don't know what else will. [/QUOTE]

Verification