Reply to thread

Message

<blockquote data-quote="Kevin Bell" data-source="post: 1138656" data-attributes="member: 152838">I think I've found the log: I've pasted it here:<a href="http://pastebin.com/UnTd2sMP" target="_blank">http://pastebin.com/UnTd2sMP</a>Looking at the end it seems to throw errors something about a Deadlock:[2015-06-05 20:17:00,692] [Log&nbsp; &nbsp; ] [WebEPGImporter] [INFO ] - WebEPG: Writing Channel: BBC TWO[2015-06-05 20:17:00,703] [Log&nbsp; &nbsp; ] [WebEPGImporter] [ERROR] - plugin:webepg import failed[2015-06-05 20:17:00,733] [Log&nbsp; &nbsp; ] [WebEPGImporter] [ERROR] - Exception&nbsp;&nbsp; :Error: StatementErrorUnclassifiedGentle.Common.GentleException: delete from Program where idChannel = ?idChannel and endTime &lt; '2015-06-04 20:17:00'; ---&gt; MySql.Data.MySqlClient.MySqlException: Deadlock found when trying to get lock; try restarting transaction&nbsp;&nbsp; at MySql.Data.MySqlClient.MySqlStream.OpenPacket()&nbsp;&nbsp; at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64&amp; affectedRows, Int64&amp; lastInsertId)&nbsp;&nbsp; at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()&nbsp;&nbsp; at MySql.Data.MySqlClient.MySqlDataReader.NextResult()&nbsp;&nbsp; at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)&nbsp;&nbsp; at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()&nbsp;&nbsp; at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)&nbsp;&nbsp; --- End of inner exception stack trace ---&nbsp;&nbsp; at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)&nbsp;&nbsp; at Gentle.Framework.PersistenceBroker.Execute(SqlStatement stmt, IDbConnection dbConnection, IDbTransaction dbTransaction)&nbsp;&nbsp; at TvDatabase.TvBusinessLayer.RemoveOldPrograms(Int32 idChannel)&nbsp;&nbsp; at MediaPortal.WebEPG.DatabaseEPGDataSink.MediaPortal.WebEPG.IEpgDataSink.EndChannelPrograms(String id, String name)&nbsp;&nbsp; at MediaPortal.EPG.WebEPG.Import()&nbsp;&nbsp; at TvEngine.WebEPGImport.ThreadFunctionImportTVGuide(Object aparam)MySql.Data.MySqlClient.MySqlException (0x80004005): Deadlock found when trying to get lock; try restarting transaction&nbsp;&nbsp; at MySql.Data.MySqlClient.MySqlStream.OpenPacket()&nbsp;&nbsp; at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64&amp; affectedRows, Int64&amp; lastInsertId)&nbsp;&nbsp; at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()&nbsp;&nbsp; at MySql.Data.MySqlClient.MySqlDataReader.NextResult()&nbsp;&nbsp; at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)&nbsp;&nbsp; at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()&nbsp;&nbsp; at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)[2015-06-05 20:17:00,761] [Log&nbsp; &nbsp; ] [WebEPGImporter] [INFO ] - plugin:webepg import done[2015-06-05 20:17:00,858] [Log&nbsp; &nbsp; ] [SQL EPG importer] [DEBUG] - BusinessLayer: Inserted 334 programs to the databaseIs there anyway I can reset the system?</blockquote>

[QUOTE="Kevin Bell, post: 1138656, member: 152838"] I think I've found the log: I've pasted it here: [URL]http://pastebin.com/UnTd2sMP[/URL] Looking at the end it seems to throw errors something about a Deadlock: [2015-06-05 20:17:00,692] [Log ] [WebEPGImporter] [INFO ] - WebEPG: Writing Channel: BBC TWO [2015-06-05 20:17:00,703] [Log ] [WebEPGImporter] [ERROR] - plugin:webepg import failed [2015-06-05 20:17:00,733] [Log ] [WebEPGImporter] [ERROR] - Exception :Error: StatementErrorUnclassified Gentle.Common.GentleException: delete from Program where idChannel = ?idChannel and endTime < '2015-06-04 20:17:00'; ---> 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) [2015-06-05 20:17:00,761] [Log ] [WebEPGImporter] [INFO ] - plugin:webepg import done [2015-06-05 20:17:00,858] [Log ] [SQL EPG importer] [DEBUG] - BusinessLayer: Inserted 334 programs to the database Is there anyway I can reset the system? [/QUOTE]

Verification