My TV Guide is no longer updating. It stops at 1% and occasionally gets up to 10%. I have tried rebuilding the server from scratch with the same results.
Plex Version 1.15.1.710
My OS is Windows 10 x64
i3-6100
16GB memory
500GB SSD 750 EVO
5x 3TB storage spaces with parity
There is currently an issue with the EPG provider
Please see the https://status.plex.tv/incidents/c311q3bz7vhs web page
Update? This has not been working for at least 2 days… Without a guide my Plex Pass w/Live TV = useless. Suggestion to make Live TV work without a guide so it can be used to at least watch a channel? Seems like common sense.
Is there an update on this by any chance?
This has been solved an update from PLEX would of been nice
The Incident Report page does have the update.
Is there any further update to the issue of no TV Guide? Have you had any response from the EPG provider.
Should be working now…
Mine still has no TV guide it is attempting to update but is on 0%. Am I meant to do anything.
I seem to be trapped in this loop. I don’t have a TV guide but I am told the issue has been resolved. If there are no special instructions and the system should be working how can I escalate it to try to get a resolution. I paid for the service primarily to watch and record TV and I cant do either (using Plex).
Michael Flaherty
Try removing and then re-adding the DVR.
if we say it is solved but you still have a problem, then the only option is provide fresh logs covering the time of the refresh failure. If the problem has come back, it would need to be looked into. Until there is evidence to show that there is an error and what it is, there is nothing to investigate
https://support.plex.tv/articles/201643703-reporting-issues-with-plex-media-server/
https://support.plex.tv/articles/200250417-plex-media-server-log-files/
Hi
Thanks for your support. I have attached a couple of logs because I do not seem to be able to resolve the issue. When I open Plex it immediately tries to update the TV guide but does not. I have deleted the DVR and reinstalled it . Even if I disconnect the DVR Plex still tries to update the guide. On one occasion when I deleted the DVR I received an error message that there was a problem trying to remove the DVR. I disconnected the DVR and ran the problem solving option thinking that it would be removed in the reset. Similarly I uninstalled and reinstalled plex with the same result. I hope the logs can help with a solution. It seems to my logic that Plex remembers the DVR and reloads it. I almost need a version of Plex before Plex Pass to try to get a fresh start.
Michael Flaherty
The fist email I sent bounced because it was too big. I tried again and now am sending each separately.
Hi
Thanks for your support. I have attached a couple of logs because I do not seem to be able to resolve the issue. When I open Plex it immediately tries to update the TV guide but does not. I have deleted the DVR and reinstalled it . Even if I disconnect the DVR Plex still tries to update the guide. On one occasion when I deleted the DVR I received an error message that there was a problem trying to remove the DVR. I disconnected the DVR and ran the problem solving option thinking that it would be removed in the reset. Similarly I uninstalled and reinstalled plex with the same result. I hope the logs can help with a solution. It seems to my logic that Plex remembers the DVR and reloads it. I almost need a version of Plex before Plex Pass to try to get a fresh start.
Michael Flaherty
The fist email I sent bounced because it was too big. I tried again and now am sending each separately.
Michael Flaherty
Plex Media Server Logs_2019-03-17_13-13-10.zip (3.92 MB)
There appears to be DB corruption in the EPG database
Mar 17, 2019 11:44:45.923 [16232] DEBUG - Opening 10 database sessions to library (tv.plex.providers.epg.eyeq:2), SQLite 3.26.0, threadsafe=1
Mar 17, 2019 11:44:45.931 [16232] INFO - SQLITE3:0x72edae4d, 283, recovered 348 frames from WAL file C:\Users\flahe\AppData\Local\Plex Media Server\Plug-in Support\Databases\tv.plex.providers.epg.eyeq-57df6ae0-006f-4a64-979c-ad20494a7082.db-wal
Mar 17, 2019 11:44:45.964 [16232] ERROR - SQLITE3:0x72edae4d, 11, database corruption at line 79051 of [bf8c1b2b7a]
Mar 17, 2019 11:44:45.964 [16232] ERROR - SQLITE3:0x72edae4d, 11, statement aborts at 14: [SELECT level, idx, end_block FROM 'main'.'fts4_metadata_titles_segdir' WHERE level BETWEEN ? AND ? ORDER BY level DESC, idx ASC] database disk image is malformed
Mar 17, 2019 11:44:45.964 [16232] ERROR - SQLITE3:0x72edae4d, 11, statement aborts at 164: [update metadata_items set guid=? where id=?] database disk image is malformed
Mar 17, 2019 11:44:45.964 [16232] ERROR - Exception inside transaction (inside=1) (..\Library\DatabaseMigrations.cpp:204): sqlite3_statement_backend::loadOne: database disk image is malformed
Mar 17, 2019 11:44:45.965 [16232] ERROR - Exception thrown during migrations, aborting: sqlite3_statement_backend::loadOne: database disk image is malformed
Shut down Plex Media Server
Then delete files starting with this name
tv.plex.providers.epg.eyeq-57df6ae0-006f-4a64-979c-ad20494a7082.db
(there may be .db. .db-shm and .db-wal files)
Directory Path
C:\Users\flahe\AppData\Local\Plex Media Server\Plug-in Support\Databases\
After deleting the database files, restart the server and the EPG refresh will use a new database
Hi
Many thanks for your help and patience. I followed the instructions and all seems to be back to normal. I have set plex to record a TV show and that will be the final test. As an aside, previously when I asked Plex to show me movies to be broadcast (from the dropdown menu) it provided information including a graphic for the movie and portraits of the main actors. Both these are now just blank. It is not critical but more pleasant with the graphics. If it is a setting could you let me know. Once again thank you for your help and I am glad the support matched a very good product.
Michael Flaherty
Did the Guide Refresh complete to 100% ? You could do another manual guide refresh and then collect the logs on completion
Are you referring to these screens. Clicking on the title of the episode on the Grid view
Hi
You were right. The Guide seems to stop updating in the 60 percent range. I ran the guide refresh and also downloaded an update to the software and ran a second refresh. I have attached the log from today.
Michael Flaherty
Thanks for the log. It actually reached near the end in this last manual refresh but then aborted.
Mar 22, 2019 17:48:46.269 [14588] DEBUG - EPG[eyeq]: Step 15/16 (2019-03-29T00:00Z) (network: 1008.1 sec, database: 136.9 sec total: 1145.0 sec)
Mar 22, 2019 17:48:46.269 [14588] DEBUG - Activity: updated activity 4fc85fe0-d0b7-4a25-af88-c2594ee635b8 - completed 93% - Refreshing guide data
Mar 22, 2019 17:48:46.269 [14588] DEBUG - Activity: updated activity 4fc85fe0-d0b7-4a25-af88-c2594ee635b8 - completed 93% - Refreshing guide data
Mar 22, 2019 17:48:46.270 [14588] WARN - EPG[eyeq]: Failed to load EPG.
Mar 22, 2019 17:48:46.733 [14588] DEBUG - EPG[eyeq]: Total time to load EPG was 1145.5 (HTTP details cached 90.5%, CloudFlare grid cached: 0.0%, 0 HTTP errors)
Edited - see next post
Sorry - i have looked again to see the sequence of requests and the reason it failed at 17:48:46 was because you cancelled the refresh
This was the sequence
At 17:29:41 you started a manual full guide refresh
Mar 22, 2019 17:29:41.120 [14736] DEBUG - Request: [127.0.0.1:51209 (Loopback)] POST /livetv/dvrs/2/reloadGuide (7 live) GZIP Signed-in Token (Michael Flaherty)
Mar 22, 2019 17:29:41.122 [9192] DEBUG - Completed: [127.0.0.1:51209] 200 POST /livetv/dvrs/2/reloadGuide (7 live) GZIP 2ms 298 bytes (pipelined: 14)
The refresh started at this time
Mar 22, 2019 17:29:41.121 [14736] DEBUG - Activity: registered new activity 4fc85fe0-d0b7-4a25-af88-c2594ee635b8 - Refreshing guide data
Mar 22, 2019 17:29:41.121 [14736] DEBUG - Activity: updated activity 4fc85fe0-d0b7-4a25-af88-c2594ee635b8 - completed 0% - Refreshing guide data
It reached 88% at 17:47:56
Mar 22, 2019 17:46:52.509 [14588] DEBUG - Activity: updated activity 4fc85fe0-d0b7-4a25-af88-c2594ee635b8 - completed 87% - Refreshing guide data
Mar 22, 2019 17:47:56.723 [14588] DEBUG - Activity: updated activity 4fc85fe0-d0b7-4a25-af88-c2594ee635b8 - completed 88% - Refreshing guide data
It must have appeared stuck to you at this point - but it was not
It was busy doing the refresh when you gave up and cancelled it
Mar 22, 2019 17:48:18.603 [14588] DEBUG - EyeQ: Adding episode (S1 E1843) 'Millionaire Hot Seat' (901059198-2E5AE362FB9FD3B7FF07C74F2FE42004)
Mar 22, 2019 17:48:18.608 [14588] DEBUG - EyeQ: Adding episode (S1 E1843) 'Millionaire Hot Seat' (901059198-2E5AE362FB9FD3B7FF07C74F2FE42004)
Mar 22, 2019 17:48:18.610 [14588] DEBUG - EyeQ: Adding episode (S1 E1843) 'Millionaire Hot Seat' (901059198-2E5AE362FB9FD3B7FF07C74F2FE42004)
Mar 22, 2019 17:48:19.791 [14588] DEBUG - EyeQ: Adding episode (S10 E4) 'Adventure Time' (901059144-CE76AA02AC35ED64E5EFDFCDC48A4591)
Mar 22, 2019 17:48:20.584 [14588] ERROR - EyeQ: Falling back to air date for Volumz / (2019-03-29)
Mar 22, 2019 17:48:20.585 [14588] DEBUG - EyeQ: Adding episode (S-1 E-1) 'Volumz' (901059284-7B5BD3F55EB74AA22806112BE57A520D)
At 17:48:22 you killed it when it was still refreshing - slowly
Mar 22, 2019 17:48:22.083 [13164] DEBUG - Request: [127.0.0.1:53897 (Loopback)] DELETE /livetv/dvrs/2/reloadGuide (5 live) GZIP Signed-in Token (Michael Flaherty)
As this request to cancel the refresh came in, the actual refresh was progressing further !
Mar 22, 2019 17:48:33.421 [14588] DEBUG - Activity: updated activity 4fc85fe0-d0b7-4a25-af88-c2594ee635b8 - completed 87% - Refreshing guide data
Mar 22, 2019 17:48:33.430 [14588] ERROR - EyeQ: Falling back to air date for Boyband Friday / (2019-03-29)
Mar 22, 2019 17:48:33.430 [14588] DEBUG - EyeQ: Adding episode (S-1 E-1) 'Boyband Friday' (901113963-6BC46363A869CF94E722AD1161183BF6)
Mar 22, 2019 17:48:34.294 [14588] DEBUG - Activity: updated activity 4fc85fe0-d0b7-4a25-af88-c2594ee635b8 - completed 88% - Refreshing guide data
Mar 22, 2019 17:48:36.231 [14588] ERROR - EyeQ: Couldn't get season and episode, or air date for item 901113707-5C67EC716E4161CA3AFB17D4D3D68835
Mar 22, 2019 17:48:39.150 [14588] ERROR - EyeQ: Falling back to air date for Teenage Fairytale Dropouts / Telltale Report Card (2019-03-29)
Mar 22, 2019 17:48:39.150 [14588] DEBUG - EyeQ: Adding episode (S-1 E-1) 'Teenage Fairytale Dropouts' (901113714-CAB720D2E8F5D06282FB60BE143B9504)
Mar 22, 2019 17:48:40.642 [14588] DEBUG - Activity: updated activity 4fc85fe0-d0b7-4a25-af88-c2594ee635b8 - completed 89% - Refreshing guide data
Your cancellation managed to stop it when it got to 93% and that was the reason for the error that i mentioned earlier
So suggest let it complete. It is like windows updates. Sometimes you think it is stuck but later it actually progresses
