Custom Data Grabber including Sky UK Channel/EPG Grabber (3 Viewers)

[sorrowuk]

DJBlu any ideas how to stop this :

My tvservice has been crashing the last few days.
I got this from the log
If I am correct the tvservice stopped due to what I have highlighted in bold ?

It crashed when it was updating the sky epg using your grabber

2012-05-08 06:57:43.727538 [(28)]: Tvservice stopped due to an unhandled app domain exception Error: StatementErrorUnclassified
Gentle.Common.GentleException: select p.* from Program p inner join Channel c on c.idChannel = p.idChannel where ((EndTime > '2012-05-08 06:57:13' and EndTime < '2012-05-09 06:57:13') or (StartTime >= '2012-05-08 06:57:13' and StartTime <= '2012-05-09 06:57:13') or (StartTime <= '2012-05-08 06:57:13' and EndTime >= '2012-05-09 06:57:13')) and c.visibleInGuide = 1 order by startTime ---> 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 TvDatabase.TvBusinessLayer.GetPrograms(DateTime startTime, DateTime endTime)
at Sky_UK_Channel_and_EPG_Grabber.SkyGrabber.UpdateEPG()
at Sky_UK_Channel_and_EPG_Grabber.SkyGrabber.UpdateDataBase(Boolean err, String errormessage)
at Custom_Data_Grabber.CustomDataGRabber.ProcessPackets(String Filename)
at Custom_Data_Grabber.CustomDataGRabber.GrabData1(Object[] ChannelID1)
at Custom_Data_Grabber.CustomDataGRabber._Lambda$__1(Object a0)
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart(Object obj)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)

Now it seems to be to do with my mysql database . So what is there I can do. It seems to be to do with timeout.
How can I increase the timeout ?
Also for any other issues, if something like this ever happens how can I get the TVService to restart automatically instead of me manually having to restart it ??

As sometimes I don't notice or I am away and recordings won't start because tvservice has crashed and is not running
Thanks

 

[psykix]

See my post on your other thread about how to get it to restart...

 

[SimondusMaximus]

Thanks for your help DJBlu. Think I'll leave coding and git merging to the people who know what they're doing....

Of course the ideal solution would be to get your excellent patches into the next official MP realease!

Cheers!
Si

 

[spacemanc]

Uploaded setup files for 1.2.3

You can install these over your 1.2.2 installations.

If you wish to use the TBS tuning then you are going to have to merge and build yourselves. I have pushed the changes to git so you can do this.

I'm on 1.2.2 and wan't to upgrade to 1.2.3. On the first page there are two 'Setup-MediaPortal-CustomData-SeriesLink-git-1.2.3.250.zip'files - is there any difference between them? Also how do I go about merging the TBS tuning? I have no idea what 'git' is, so is it straightforward?

 

[rich76]

DJ Blu,
I have been using the files Setup-MediaPortal-git-1.2.3.250 and Setup-TvEngine-git-1.2.3.250 on the 1st page for a while now and will admit it seems very stable but 1 thing I noticed in the my error logs is

2012-05-18 15:31:48.572435 [ERROR][MPMain(1)]: TvPlugin and TvServer don't have the same version.
TvServer Version: 1.2.3.0
TvPlugin Version: 1.2.0-250-g6ba9361-EXP_Series_Link_Recording

Is the correct?

I also noticed in tv server config it shows version 1.2.3.0 and mediaportal it shows 1.2.3.250

As I said I don't think its causing any issues just wondered why it was showing as different versions.

Rich

 

[DJBlu]

The versions are incorrect, I'll be sorting it out when I get time.

It won't affect the running of your system.

 

[DJBlu]

Uploaded setup files for 1.2.3

You can install these over your 1.2.2 installations.

If you wish to use the TBS tuning then you are going to have to merge and build yourselves. I have pushed the changes to git so you can do this.

I'm on 1.2.2 and wan't to upgrade to 1.2.3. On the first page there are two 'Setup-MediaPortal-CustomData-SeriesLink-git-1.2.3.250.zip'files - is there any difference between them? Also how do I go about merging the TBS tuning? I have no idea what 'git' is, so is it straightforward?

One is TV-Server and one is MediaPortal you need both,

You can install them over the top of a 1.2.2 installation. Make sure you install the Mediaportal patch then the TVServer patch.

I would leave the merge of the TBS if you aren't comfortable with it. If you want to try then take a look on google for the following

Git.
Tortoise Git.
Microsoft Visual Studio.

 

[rich76]

No it's not affecting anything that I can tell anyway.
1.3 alpha should be out in the next couple of weeks so probably not worth trying to fix this and just wait till 1.3 alpha is out.
Thanks for the explanation though, just thought I'd mention it incase I was installing the wrong files

Rich

 

[Sam Woods]

Hi,
This is an awesome addon by the way, no idea what I'd do without it. Many thanks DJBlu!

First time I used it I had no problems at all but have just formatted and am having a slight issue:
Not all channels are being mapped / sorted into the right channels. I've tried re-grabbing a few times,, even under different regions and the log often differs (even when no settings have been changed) but certain channels still never appear. For example Sky Sports F1 HD is never mapped or added to any categories.

Any help appreciated!

 

[DJBlu]

Hi,
This is an awesome addon by the way, no idea what I'd do without it. Many thanks DJBlu!

First time I used it I had no problems at all but have just formatted and am having a slight issue:
Not all channels are being mapped / sorted into the right channels. I've tried re-grabbing a few times,, even under different regions and the log often differs (even when no settings have been changed) but certain channels still never appear. For example Sky Sports F1 HD is never mapped or added to any categories.

Any help appreciated!

Easy one this.

Probs all the DVB-S2 HD channels aren't mapped.

Make sure you have the DVB-S2 selected for the card. It is in the Card settings. Where you select what satellite the card is capable of seeing.