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 Talk
Can't get program guide to update
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="mm1352000" data-source="post: 1157875" data-attributes="member: 82144"><p>Patrick, I honestly have no idea what the problem is or what has caused it. The only suspicious thing I can see in your Windows system event log are repeated entries like this:</p><p>"10/10/2015 5:31:13 PM";"EventLog";"(0)";"Error";"The previous system shutdown at 11:06:29 AM on 10/10/2015 was unexpected.";"2147489656"</p><p>"09/10/2015 5:11:29 PM";"EventLog";"(0)";"Error";"The previous system shutdown at 12:02:21 PM on 09/10/2015 was unexpected.";"2147489656"</p><p>"28/09/2015 5:44:31 PM";"EventLog";"(0)";"Error";"The previous system shutdown at 2:53:16 PM on 28/09/2015 was unexpected.";"2147489656"</p><p>etc.</p><p></p><p>The latest entry (from 10 Oct) seems to coincide with the first instance of the SD plugin update failure that I can see in tvserver_TVService.5.log:</p><p>[2015-10-10 17:34:16,648] [Log ] [TVService] [INFO ] - TV Service: Plugin: SchedulesDirect EPG Client failed to start</p><p>[2015-10-10 17:34:16,742] [Log ] [TVService] [ERROR] - 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></p><p>This MySQL error seems to be reflected in the Windows application event log:</p><p>"10/10/2015 5:34:16 PM";"MySQL";"(0)";"Error";"D:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Sort aborted: Query execution was interrupted For more information, see Help and Support Center at <a href="http://www.mysql.com" target="_blank">http://www.mysql.com</a>. ";"3221225572"</p><p></p><p>If I look back to what TV Server was doing prior to the "unexpected system shutdown", it seems that the SD plugin may have been smack bang in the middle of an EPG update:</p><p>[2015-10-10 10:51:09,637] [Log ] [SchedulesDirect EPG Client] [INFO ] - Sucessfully processed 1038 of 756 channels</p><p>[2015-10-10 10:51:09,638] [Log ] [SchedulesDirect EPG Client] [INFO ] - Starting processing of 51647 schedule entries</p><p>[2015-10-10 10:53:29,799] [Log ] [SchedulesDirect EPG Client] [INFO ] - SD-TvDb: Could not find series match: American Hustle renamed American Hustle</p><p></p><p>So my best guess is that the unexpected shutdown did/has/had caused some corruption to the MySQL database, and MySQL's inability to resolve/workaround/handle the corruption is the reason for the EPG update failures.</p><p></p><p>I'm not able to tell you what caused the unexpected shutdown, but if I were you I would investigate that as a high priority. It seems to be happening very frequently. Every time it happens is a chance for file loss/corruption...</p></blockquote><p></p>
[QUOTE="mm1352000, post: 1157875, member: 82144"] Patrick, I honestly have no idea what the problem is or what has caused it. The only suspicious thing I can see in your Windows system event log are repeated entries like this: "10/10/2015 5:31:13 PM";"EventLog";"(0)";"Error";"The previous system shutdown at 11:06:29 AM on 10/10/2015 was unexpected.";"2147489656" "09/10/2015 5:11:29 PM";"EventLog";"(0)";"Error";"The previous system shutdown at 12:02:21 PM on 09/10/2015 was unexpected.";"2147489656" "28/09/2015 5:44:31 PM";"EventLog";"(0)";"Error";"The previous system shutdown at 2:53:16 PM on 28/09/2015 was unexpected.";"2147489656" etc. The latest entry (from 10 Oct) seems to coincide with the first instance of the SD plugin update failure that I can see in tvserver_TVService.5.log: [2015-10-10 17:34:16,648] [Log ] [TVService] [INFO ] - TV Service: Plugin: SchedulesDirect EPG Client failed to start [2015-10-10 17:34:16,742] [Log ] [TVService] [ERROR] - 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. This MySQL error seems to be reflected in the Windows application event log: "10/10/2015 5:34:16 PM";"MySQL";"(0)";"Error";"D:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Sort aborted: Query execution was interrupted For more information, see Help and Support Center at [URL]http://www.mysql.com[/URL]. ";"3221225572" If I look back to what TV Server was doing prior to the "unexpected system shutdown", it seems that the SD plugin may have been smack bang in the middle of an EPG update: [2015-10-10 10:51:09,637] [Log ] [SchedulesDirect EPG Client] [INFO ] - Sucessfully processed 1038 of 756 channels [2015-10-10 10:51:09,638] [Log ] [SchedulesDirect EPG Client] [INFO ] - Starting processing of 51647 schedule entries [2015-10-10 10:53:29,799] [Log ] [SchedulesDirect EPG Client] [INFO ] - SD-TvDb: Could not find series match: American Hustle renamed American Hustle So my best guess is that the unexpected shutdown did/has/had caused some corruption to the MySQL database, and MySQL's inability to resolve/workaround/handle the corruption is the reason for the EPG update failures. I'm not able to tell you what caused the unexpected shutdown, but if I were you I would investigate that as a high priority. It seems to be happening very frequently. Every time it happens is a chance for file loss/corruption... [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
MediaPortal 1 Talk
Can't get program guide to update
Contact us
RSS
Top
Bottom