WebEPG stuck (1 Viewer)

[Kevin Bell]

Hi,

I've set up a MediaPortal backend and trying to get WebEPG to work - it seems to have got stuck.

I'm using Kodi as a front end, I've set WebEPG to download 14 days of guide.

When I look at the EPG in Kodi, I can see that the first channel (BBC 1) has about 14 days, but all the others after that from BBC2 down have only 6 or so.

When I look at the WebEPG plugin it states in status:

Total Channels Imported: 1
Total Programs imported: 329
Grab Status: Writing channel BBC 2

Its been stuck on writing channel BBC 2 for 21 hours.

Is there any way to find out whats going on?

Thanks
Kevin.

 

[Edalex]

Yes. You should look at logs. If it can't write channel database could be corrupted. Or many other reasons which could be investigated by reading Mediaportal (not Kodi) logs. Kodi logs should be investigated on kodi forums

 

[Kevin Bell]

Do you know where I can find the logs and which one to look at?

 

[Edalex]

Yes, TV Server logs are in ProgramData\Team MEdiaPortal\MediaPortal TV Server\log folder for win7 and in the same folder in Documents and Setting\All Users Application data for XP.
Probably tv.log or any error logs will help

 

[Kevin Bell]

I think I've found the log: I've pasted it here:

http://pastebin.com/UnTd2sMP

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?

 

[Edalex]

I want to ask @mm1352000 's opinion.
If it's failing on specific channel it could be not database failure but problem with your WebEPG grabber file i.e. site was changes somehow and you're getting invalid data which couldn't be inserted in database. Look,
[2015-06-05 20:17:00,656] [Log ] [WebEPGImporter] [INFO ] - WebEPG: Program Count (313) < Listing Count (330) - Discard Count (15), possible template error
I see you're using
[2015-06-05 20:16:54,925] [Log ] [WebEPGImporter] [INFO ] - WebEPG: Opening GB\1-xmltv_radiotimes_com.xml
[2015-06-05 20:16:54,926] [Log ] [WebEPGImporter] [INFO ] - WebEPG: Version: 2.0.4
I wonder what grabbers are using by others in Britain? I remember @lisag is from here maybe she could help.

 

[LJG]

Hi, I can't really help, sorry, I have used MP TVServer and WebEPG previously, but had some issues with a lack of channel availability and not great quality data from the channels that are available (specifically no season / episode numbers).

I now use Argus TV with a combination of XMLTV GUI / RadioTimes and OTA DVB EPG.

 

[mm1352000]

I want to ask mm1352000 's opinion.

I have no opinion without seeing the TV service log to know how the TV service was using the DB at the time... and what version of MySQL is used, etc.

 

[Kevin Bell]

I found these two TV Service Error Logs:

http://pastebin.com/GiDz5sWq

http://pastebin.com/ULfVNBQQ

This is the TV Serive Log:

http://chopapp.com/#xki1yrh6

 

[Kevin Bell]

Well I've really stuck with this... Is there anyway I can reset the whole guide - i.e. delete the database and redownload it?

Also, are there any alternatives to WebEPG that i can look at?

Thanks.