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

easywatcher

MP Donator
  • Premium Supporter
  • January 23, 2009
    83
    2
    Home Country
    Germany Germany
    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?
     

    easywatcher

    MP Donator
  • Premium Supporter
  • January 23, 2009
    83
    2
    Home Country
    Germany Germany
    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
     

    Attachments

    • epg.bak
      795 bytes

    Vasilich

    Portal Pro
    August 30, 2009
    3,394
    1,170
    Germany, Mayence
    Home Country
    Russian Federation Russian Federation
    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

    MP Donator
  • Premium Supporter
  • January 23, 2009
    83
    2
    Home Country
    Germany Germany
    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
     
    Last edited:

    Vasilich

    Portal Pro
    August 30, 2009
    3,394
    1,170
    Germany, Mayence
    Home Country
    Russian Federation Russian Federation
    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

    MP Donator
  • Premium Supporter
  • January 23, 2009
    83
    2
    Home Country
    Germany Germany
    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?

    :confused:
     

    easywatcher

    MP Donator
  • Premium Supporter
  • January 23, 2009
    83
    2
    Home Country
    Germany Germany
    ;) now including new logs.
    The logs are after I have started the repair of the database
     

    Vasilich

    Portal Pro
    August 30, 2009
    3,394
    1,170
    Germany, Mayence
    Home Country
    Russian Federation Russian Federation
    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.
     

    Users who are viewing this thread

    Top Bottom