[solved] WebEPG suddenly is stopping on Grab status: Writing Channel... (1 Viewer)

[easywatcher]

All EPGs are gone. When starting "Grab now!" button in the TV Server Configuration the grabbing process is starting. But after the first channel it is stopping with: Grab status: Writing channel...
There it is staying forever or until I press Grab now again.

I tried:
- changing the file where EPG gets written to. -> no change
- deleting the mapping for the first channel -> it takes the second with same result
- chaning the mapping for the first channel -> no change
I also cannot find a tvguide.xml file anywhere

Anybody had this problem before?

 

[Vasilich]

logs?

 

[easywatcher]

Hi thanks for sending a response to my question. You are someone from the core team. I shall be honored.

I hope epg.log is the one you need.
I enabled DVB EPG this morning. I hoped to have some EPG at least. Not sure that has resulted in a wrong picture in the epg.log. That is why I added epg.bak

 

[Vasilich]

1.

2012-10-08 10:01:40.066952 [(7)]: dvb:dvb ready.EPG 137 channels
2012-10-08 10:01:42.119069 [(7)]: Epg: card:5 received epg for 136 channels
2012-10-08 10:01:42.131070 [EPG Update thread(5)]: Epg: card:5 Updating database with new programs
2012-10-08 10:01:42.140071 [EPG Update thread(5)]: IdleEpgGrabber: channel 3sat HD is not configured to grab epg.
2012-10-08 10:01:42.151071 [EPG Update thread(5)]: IdleEpgGrabber: channel KiKA HD is not configured to grab epg.
2012-10-08 10:01:42.161072 [EPG Update thread(5)]: IdleEpgGrabber: channel ZDFinfo HD is not configured to grab epg.
2012-10-08 10:01:42.172073 [EPG Update thread(5)]: IdleEpgGrabber: channel ZDF HD is not configured to grab epg.
2012-10-08 10:01:42.182073 [EPG Update thread(5)]: IdleEpgGrabber: channel zdf_neo HD is not configured to grab epg.
......

and so on. You need to enable EPG grabbing for those channels that you want to get EPG for
http://wiki.team-mediaportal.com/1_...ver_Configuration/05_DVB_EPG/1_TV_EPG_Grabber

Surely all this is for DVB EPG.

2. iF you want us to check problems with your WebEPG - then post full logs
http://wiki.team-mediaportal.com/1_MEDIAPORTAL_1/16_Support/3_Forums/2_Log_Files

 

[easywatcher]

Hi Vasilich,
sorry for the delay. I was on a business trip with no access to my MP.

First I disabled the DVB EGP. I did switch it on only for interim until WebEPG is working again. But obviously it did not work as well. Doesn't matter. I prefer Web EPG anyway.

Then I followed the description of Debugging. Started the debug mode for core mediaportal. Afterwards I started TV Server and WebEPG grabbing.

Hope that will give you a insight to the problem.

Easywatcher

 

[Vasilich]

2012-10-12 20:53:53.431970 [WebEPGImporter(8)]: WebEPG: Guide, Program Info: 20121026050000 / 20121026053000 - BBC World News
2012-10-12 20:53:53.440971 [WebEPGImporter(8)]: WebEPG: Guide, Program Info: 20121026053000 / 20121026060000 - HARDtalk
2012-10-12 20:53:53.448971 [WebEPGImporter(8)]: WebEPG: Guide, Program Info: 20121026060000 / 20121026063000 - BBC News
2012-10-12 20:53:53.456972 [WebEPGImporter(8)]: WebEPG: Guide, Program Info: 20121026063000 / 20121026064500 - World Business Report
2012-10-12 20:53:53.462972 [WebEPGImporter(8)]: WebEPG: Guide, Program Info: 20121026064500 / 20121026070000 - BBC News
2012-10-12 20:53:53.462972 [WebEPGImporter(8)]: WebEPG: Program Count (533), Listing Count (554), Discard Count (19)
2012-10-12 20:53:53.463972 [WebEPGImporter(8)]: WebEPG: Program Count (533) < Listing Count (554) - Discard Count (19), possible template error
2012-10-12 20:53:53.469972 [WebEPGImporter(8)]: WebEPG: Writing Channel: BBC 1 W Mids
2012-10-12 20:53:53.499974 [WebEPGImporter(8)]: plugin:webepg import done

these strings show that WebEPG parser itself is working

2012-10-12 20:54:02.803506 [scheduler thread(15)]: scheduler: SchedulerWorker inner exception Error: DeveloperErrorUnclassified
Gentle.Common.GentleException: The columns idProgram, idChannel, startTime, endTime, title, description, genre, state, originalAirDate, seriesNum, episodeNum, episodePart, episodeName, starRating, classification, parentalRating in table Program do not exist.
bei Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
bei Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
bei Gentle.Common.Check.Fail(Error error, Object[] args)
bei Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)
bei Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)
bei Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)
bei Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)
bei Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)
bei TvDatabase.Channel.GetProgramAt(DateTime date, String title)
bei TvService.Scheduler.IsTimeToRecordEveryTimeOnThisChannel(Schedule schedule, DateTime currentTime)
bei TvService.Scheduler.IsTimeToRecord(Schedule schedule, DateTime currentTime, RecordingDetail& newRecording)
bei TvService.Scheduler.StartAnyDueRecordings()
bei TvService.Scheduler.DoScheduleWork()
bei TvService.Scheduler.SchedulerWorker()

you have a lot of these strings, that looks for me like you have crashed Program table in your DB. Try to repair it like described here:
https://forum.team-mediaportal.com/threads/uknown-error-occurred.112535/#post-915988

 

[easywatcher]

And it is working again

Thank you so much Vasilich!!!!!!!!!!!!!!

 

[easywatcher]

Hi again,
the workaround is working fine. I even created a batch file for it. (Only I don't know how to add the MySql passsword entering into a batch file)

Nevertheless it is a workaround. And from time to time my TV entries disappear. So I wonder wheter there is a final solution for this?

 

[easywatcher]

now including new logs.
The logs are after I have started the repair of the database

 

[Vasilich]

2012-11-12 07:30:48.937438 [scheduler thread(5)]: scheduler: SchedulerWorker inner 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 where title = ?title and idChannel = ?idChannel and endTime > ?endTime and startTime <= ?startTime order by startTime asc limit 1 offset 0; ---> MySql.Data.MySqlClient.MySqlException: Table '.\mptvdb\program' is marked as crashed and should be repaired

if you often get this kind of errors, then it is time to clear why your SQL tables are crashing so often. Possibilities and solutions:
1. you have problems with HDD - replace HDD
2. you have reset/hard powered off HTPC while SQL engine tried to write something in DB - in this case i can only recommend the solution i currently use - batch file in autostart that automatically repair SQL DB on windows start. Other possibility is to switch to transaction-based SQL engine (in case of MySQL it is InnoDB instead of currently used MyISAM), but this will not happen in 1.3 as it requires long-period testing. It was though already spoken in core team about, so the chances are big that 1.4 will be switched to InnoDB and won't suffer from this problem.