TV Service takes 5 minutes to start. Cannot stream to other PCs.

I have so many symptoms that I am wondering if I shouldn't just uninstall and wipe everything and start over. #4 below is the only showstopper, but #6 is major.

1) (not critical) I switched to Schedules Direct in December after IMDB stopped their TV Guide. Now TVService takes 5 minutes or more to start, which seems odd. I think my use / misues of the SchedulesDirect EPG plugin is correlated to some of these.

2) (unreliable) When i start a show to record, the TVServer tries various tuners a few times before actually starting a recording. This means it can take a long time to start a recording. If I have used up all but one tuner, it tries that tuner a few times, then will finally record. I can watch this behavior in the Manual Control page of SetupTV. (New problem since December.)



3) (annoying but workaround) Many times when streaming to my Kitchen computer, the first attempt to play a recording results in an error message like "unable to play 52F27D90" and this number changes. Simply trying it again would then play normally. (New problem since December.)

4) (failure) BUT NOW I cannot stream anything to the Kitchen or Bedroom. I get these same errors on the two streaming client PCs, but on the TV Server these files play properly. The same error "unable to play 7D8C7773" for example, but now it is persistent instead of clearing up on a second attempt. (New as of today.)

5) (system gets stuck 1-2 times a month) My HDHOMERUN Prime Tuners get stuck "busy" whenever recording problems occur (like disk full, or PC reboot), requiring a reboot of the Prime tuners. This has been a forever problem, but is quite annoying because what happens is that suddenly nothing is recorded without notice. The Tuners web admin say they are idle, and the HDHOMERUN TV App will play the 'locked' tuners fine, but MP still says they are busy. After I stop TVService, Power cycle the HDHOME rune tuners, then restart TV Service, it all works again. Why does MP think tuners are busy? I turned off my firewall a couple of years ago trying to fix this problem. (since day one)

6) (reduced capacity) When restarting TVService, not all tuners get recognized. This is a recent problem, but I cannot remember changing anything to cause this. Here tuner 8 is not recognized. Next restart of TVService, it will be a different one, or maybe two.



7) I notice that the "schedules" page never renders. Notice in the screenshot below, it says Schedules, but is still showing the Manual Control page. I ran mysqlcheck mptvdb --auto-repair -e -u root -p and it completed saying everything was OK. (New since December). I don't need this Schedules page, but wonder if this is not a symptom of something bigger.



8) (cosmetic) SetupTV crashes 90% of the time I use the Stop Service button. It does stop the service, but crashes and I have to re-run it. Sometimes it never opens when I start the App, but I think that is correlated to when the TVService is still "starting" (which now takes at least 5 minutes). (been happening for a year, but not day one).

9) (minor) TV channels are a mess after switching to SchedulesDirect. I must have done something wrong, because I keep getting "unknown" new channels populated. Is the SchedulesDirect EPG Client the best choice for EPG on Cox cable channels in the US? I thought it was going to eliminate all the text editing I used to do with the WEB EPG Grabber. The SchedulesDirect updates seem to keep up, but several channels say "No Data" in the guide. I don't think everything is synchronizing and I don't fully understand how that works to debug it myself.

10) My wife hoards recordings and I don't expect this forum to help. Needless to say I have 5 USB drives on a USB3.0 card. I record onto 4 different disks and sometimes move files (and use "database import" and "remove invalid files" to clean up the database). Is there a better way to span disks? This is tedious.

If there are fixes to all this, with #4 and #6 being a priority, I will try them. If I should uninstall MP1 and TV Server and start with a clean install, I will do that too. I would like guidance on what EPG to use and how to populate channels (HDHOMERUN PRIME import? Scan? SchedulesDIrect populate?)

thanks for any assistance!
Jamie

 

Log in or Sign up to hide all adverts.

This is helpful. How do I examine the schedule list? Is there a GUI for this? The Schedules page of SetupTV won't render. Inside MP GUI I see a list of programs in the Schedules menu. How would I tell if any one is invalid?

Can I use MS Access to examine tables in the database?

Thanks
Jamie

 

For fun, I learned about and downloaded MYSQL workbench and opened the schedules table directly. What makes a schedule entry invalid is not obvious to me, but the last entry sure looks different! idParentSchedule is -1 for all except for Wisdom of the crowd which is 12582.


Can I just delete this row and see what happens?

UPDATE: never mind, there are others with large numbers in this column. I need guidance on where to look and what to look for.

 

I exported the schedules table. I also exported the entire database, but not sure you want that!

 

YAY! Running a query was easy, I pasted your text and ran it in MySQL Workbench, with this result of three bad entries. :






I deleted these three entries, clicked Apply to run the delete script, and now I can stream to my other clients without error. I can now stop and restart the service without the long delays.

At the moment, I can only seem to use two tuners, and new recordings seem to have to restart 3 times before they remain recordings. This is what I observer watching the Manual Control list.

Thanks for the help!!!
Jamie

 

I do believe that you solved 1,3,4 and 7.

2,5,6 and 8 are still there even after reinstalling the patch. I did this patch once a long time ago, assumed it was merged in subsequent updates. I just power cycled my tuners, and restarted the service and started several shows recording in the attached. Every show tried several tuners before recording, according to what I see in the Manual Control page.