home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
MediaPortal 1 Plugins
Schedules Direct US/Canadian/Mexico EPG Plugin (Updated August 2010)
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="mattjcurry" data-source="post: 965262" data-attributes="member: 116338"><p>Hello,</p><p> </p><p>I just started having issues with this plugin a few days ago It has been running solid for me for about 6 months otherwise.</p><p> </p><p>Error in tv.log:</p><p>[code]2013-02-10 21:26:36.243835 [TVService(6)]: TV Service: Load plugins</p><p>2013-02-10 21:26:36.256835 [TVService(6)]: PluginManager: Loaded ComSkipLauncher version:1.0.2.0 author:and-81</p><p>2013-02-10 21:26:36.260836 [TVService(6)]: PluginManager: Loaded ConflictsManager version:1.0.0.1 author:Broceliande</p><p>2013-02-10 21:26:36.262836 [TVService(6)]: PluginManager: Loaded MPExtended PowerScheduler plugin version:0.5.1 author:MPExtended Developers</p><p>2013-02-10 21:26:36.269836 [TVService(6)]: PluginManager: Loaded Power Scheduler version:0.1.0.0 author:micheloe</p><p>2013-02-10 21:26:36.272836 [TVService(6)]: PluginManager: Loaded SchedulesDirect EPG Client version:1.2.3.2 author:Patrick</p><p>2013-02-10 21:26:36.284837 [TVService(6)]: PluginManager: Loaded ServerBlaster version:1.1.1.0 author:joboehl with ralphy mods</p><p>2013-02-10 21:26:36.290837 [TVService(6)]: PluginManager: Loaded TV Movie EPG import version:1.0.3.0 author:rtv</p><p>2013-02-10 21:26:36.296838 [TVService(6)]: PluginManager: Loaded WebEPG version:1.0.0.0 author:Arion_p - James</p><p>2013-02-10 21:26:36.299838 [TVService(6)]: PluginManager: Loaded XmlTv version:1.0.0.0 author:Frodo</p><p>2013-02-10 21:26:36.299838 [TVService(6)]: TV Service: Plugins loaded</p><p>2013-02-10 21:26:36.300838 [TVService(6)]: TV Service: Plugin: ComSkipLauncher started</p><p>2013-02-10 21:26:36.300838 [TVService(6)]: plugin: ComSkipLauncher start</p><p>2013-02-10 21:26:36.303838 [TVService(6)]: TV Service: Plugin: ConflictsManager disabled</p><p>2013-02-10 21:26:36.303838 [TVService(6)]: TV Service: Plugin: MPExtended PowerScheduler plugin disabled</p><p>2013-02-10 21:26:36.304838 [TVService(6)]: TV Service: Plugin: Power Scheduler disabled</p><p>2013-02-10 21:26:36.304838 [TVService(6)]: TV Service: Plugin: SchedulesDirect EPG Client started</p><p>2013-02-10 21:26:36.305838 [TVService(6)]: SchedulesDirect EPG Client: version 1.2.3 starting</p><p>2013-02-10 21:27:06.324555 [TVService(6)]: TV Service: Plugin: SchedulesDirect EPG Client failed to start</p><p>2013-02-10 21:27:06.332556 [TVService(6)]: TV Service: Plugin: ServerBlaster disabled</p><p>2013-02-10 21:27:06.335556 [TVService(6)]: TV Service: Plugin: TV Movie EPG import disabled</p><p>2013-02-10 21:27:06.338556 [TVService(6)]: TV Service: Plugin: WebEPG disabled</p><p>2013-02-10 21:27:06.340556 [TVService(6)]: TV Service: Plugin: XmlTv disabled</p><p>2013-02-10 21:27:06.340556 [TVService(6)]: TV Service: Plugins started[/code]</p><p> </p><p>The only indication I can see is in error.log for the TV server.</p><p> </p><p>[code]2013-02-10 21:26:32.405615 [TVService(6)]: TvService OnStart failed : System.Threading.ThreadAbortException: Thread was being aborted.</p><p> at System.Threading.Thread.SleepInternal(Int32 millisecondsTimeout)</p><p> at TvService.TvServiceThread.OnStart()</p><p>2013-02-10 21:27:06.326555 [TVService(6)]: Exception :Error: StatementErrorUnclassified</p><p>Gentle.Common.GentleException: select idProgram, idChannel, startTime, endTime, title, description, genre, state, originalAirDate, seriesNum, episodeNum, episodePart, episodeName, starRating, classification, parentalRating from Program order by endTime desc limit 1 offset 0; ---> MySql.Data.MySqlClient.MySqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.</p><p> at MySql.Data.MySqlClient.MySqlDataReader.NextResult()</p><p> at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)</p><p> at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)</p><p> at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()</p><p> at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)</p><p> --- End of inner exception stack trace ---</p><p> at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)</p><p> at Gentle.Framework.PersistenceBroker.Execute(SqlStatement stmt, IDbConnection dbConnection, IDbTransaction dbTransaction)</p><p> at Gentle.Framework.SqlStatement.Execute()</p><p> at SchedulesDirect.Plugin.SchedulesDirectPluginTVE3.GetLastProgramEntry()</p><p> at SchedulesDirect.Plugin.SchedulesDirectPluginTVE3.TvEngine.ITvServerPlugin.Start(IController controller)</p><p> at TvService.TvServiceThread.StartPlugins()MySql.Data.MySqlClient.MySqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.</p><p> at MySql.Data.MySqlClient.MySqlDataReader.NextResult()</p><p> at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)</p><p> at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)</p><p> at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()</p><p> at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)</p><p>[/code]</p><p> </p><p>any advice anyone could offer would be great. Thanks.</p><p> </p><p>________</p><p>SOLUTION:</p><p>It seems that the bad sql was from the schedulesdirect plugin to determine the last end time of programs in the EPG.</p><p> </p><p>The solve was to open a mysql prompt and truncate the program table. Then since it was empty, I added a reverse index on the endTime column. It seems to me that it would be better to optimize the program to not run a query that does a full table scan without an index.</p><p> </p><p>thanks,</p><p>Matt</p></blockquote><p></p>
[QUOTE="mattjcurry, post: 965262, member: 116338"] Hello, I just started having issues with this plugin a few days ago It has been running solid for me for about 6 months otherwise. Error in tv.log: [code]2013-02-10 21:26:36.243835 [TVService(6)]: TV Service: Load plugins 2013-02-10 21:26:36.256835 [TVService(6)]: PluginManager: Loaded ComSkipLauncher version:1.0.2.0 author:and-81 2013-02-10 21:26:36.260836 [TVService(6)]: PluginManager: Loaded ConflictsManager version:1.0.0.1 author:Broceliande 2013-02-10 21:26:36.262836 [TVService(6)]: PluginManager: Loaded MPExtended PowerScheduler plugin version:0.5.1 author:MPExtended Developers 2013-02-10 21:26:36.269836 [TVService(6)]: PluginManager: Loaded Power Scheduler version:0.1.0.0 author:micheloe 2013-02-10 21:26:36.272836 [TVService(6)]: PluginManager: Loaded SchedulesDirect EPG Client version:1.2.3.2 author:Patrick 2013-02-10 21:26:36.284837 [TVService(6)]: PluginManager: Loaded ServerBlaster version:1.1.1.0 author:joboehl with ralphy mods 2013-02-10 21:26:36.290837 [TVService(6)]: PluginManager: Loaded TV Movie EPG import version:1.0.3.0 author:rtv 2013-02-10 21:26:36.296838 [TVService(6)]: PluginManager: Loaded WebEPG version:1.0.0.0 author:Arion_p - James 2013-02-10 21:26:36.299838 [TVService(6)]: PluginManager: Loaded XmlTv version:1.0.0.0 author:Frodo 2013-02-10 21:26:36.299838 [TVService(6)]: TV Service: Plugins loaded 2013-02-10 21:26:36.300838 [TVService(6)]: TV Service: Plugin: ComSkipLauncher started 2013-02-10 21:26:36.300838 [TVService(6)]: plugin: ComSkipLauncher start 2013-02-10 21:26:36.303838 [TVService(6)]: TV Service: Plugin: ConflictsManager disabled 2013-02-10 21:26:36.303838 [TVService(6)]: TV Service: Plugin: MPExtended PowerScheduler plugin disabled 2013-02-10 21:26:36.304838 [TVService(6)]: TV Service: Plugin: Power Scheduler disabled 2013-02-10 21:26:36.304838 [TVService(6)]: TV Service: Plugin: SchedulesDirect EPG Client started 2013-02-10 21:26:36.305838 [TVService(6)]: SchedulesDirect EPG Client: version 1.2.3 starting 2013-02-10 21:27:06.324555 [TVService(6)]: TV Service: Plugin: SchedulesDirect EPG Client failed to start 2013-02-10 21:27:06.332556 [TVService(6)]: TV Service: Plugin: ServerBlaster disabled 2013-02-10 21:27:06.335556 [TVService(6)]: TV Service: Plugin: TV Movie EPG import disabled 2013-02-10 21:27:06.338556 [TVService(6)]: TV Service: Plugin: WebEPG disabled 2013-02-10 21:27:06.340556 [TVService(6)]: TV Service: Plugin: XmlTv disabled 2013-02-10 21:27:06.340556 [TVService(6)]: TV Service: Plugins started[/code] The only indication I can see is in error.log for the TV server. [code]2013-02-10 21:26:32.405615 [TVService(6)]: TvService OnStart failed : System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.SleepInternal(Int32 millisecondsTimeout) at TvService.TvServiceThread.OnStart() 2013-02-10 21:27:06.326555 [TVService(6)]: Exception :Error: StatementErrorUnclassified Gentle.Common.GentleException: select idProgram, idChannel, startTime, endTime, title, description, genre, state, originalAirDate, seriesNum, episodeNum, episodePart, episodeName, starRating, classification, parentalRating from Program order by endTime desc limit 1 offset 0; ---> MySql.Data.MySqlClient.MySqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() 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 Gentle.Framework.SqlStatement.Execute() at SchedulesDirect.Plugin.SchedulesDirectPluginTVE3.GetLastProgramEntry() at SchedulesDirect.Plugin.SchedulesDirectPluginTVE3.TvEngine.ITvServerPlugin.Start(IController controller) at TvService.TvServiceThread.StartPlugins()MySql.Data.MySqlClient.MySqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr) [/code] any advice anyone could offer would be great. Thanks. ________ SOLUTION: It seems that the bad sql was from the schedulesdirect plugin to determine the last end time of programs in the EPG. The solve was to open a mysql prompt and truncate the program table. Then since it was empty, I added a reverse index on the endTime column. It seems to me that it would be better to optimize the program to not run a query that does a full table scan without an index. thanks, Matt [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
MediaPortal 1 Plugins
Schedules Direct US/Canadian/Mexico EPG Plugin (Updated August 2010)
Contact us
RSS
Top
Bottom
