Tuner service isn’t shutting down, it’s simply not finding my Quad HD tuner. WinTV still sees the tuner and works just fine but plex does not see it at all. I let it search for over an hour.
Plex Version 1.22.0.4163
Is wintv application shut down when Plex Media Server is used to and DVR setup attempted ? Another application accessing the DVR could lock out Plex Media Server access to the DVR
Please run with debug logging enabled and get logs for the problem
see https://support.plex.tv/articles/201643703-reporting-issues-with-plex-media-server/
With debug logging already enabled, please restart the server to make sure we get fresh logs set created.
When the problem arises - note down the time and capture the logs zip and screenshot
For logs download - see https://support.plex.tv/articles/200250417-plex-media-server-log-files/
Please confirm that WinTV application is not running when Plex Media Server is running and attempting to use the DVR
Thanks
Hello,
Yes winTV is shutdown and has since been removed when trying to add my Quad HD Tuners again. They use to work fine. I have included the logs and a screenshot of the tuner add screen.
I have also just uninstalled and deleted the drivers for the tuners, restarted, then reinstalled the driver and tuner.Plex Media Server Logs_2021-04-02_06-24-12.zip (1.2 MB)
You have database corruption to fix before you can get anywhere.
Apr 02, 2021 06:17:31.802 [14744] DEBUG - Opening 10 database sessions to library (tv.plex.providers.epg.cloud:5), SQLite 3.26.0, threadsafe=1
Apr 02, 2021 06:17:31.805 [14744] ERROR - SQLITE3:0x855ebd85, 11, database corruption at line 65066 of [bf8c1b2b7a]
Apr 02, 2021 06:17:31.805 [14744] ERROR - SQLITE3:0x855ebd85, 11, statement aborts at 8: [] database disk image is malformed
Apr 02, 2021 06:17:31.805 [14744] ERROR - SQLITE3:0x855ebd85, 11, database disk image is malformed in "PRAGMA cache_size=2000"
Apr 02, 2021 06:17:31.805 [14744] ERROR - EPG[cloud]: Exception initializing EPG DB ~ sqlite3_statement_backend::prepare: database disk image is malformed for SQL: PRAGMA cache_size=2000
Apr 02, 2021 06:17:31.805 [14744] ERROR - Couldn't delete the file "C:\Users\edwar\AppData\Local\Plex Media Server\Plug-in Support\Databases\tv.plex.providers.epg.cloud-72314866-7e12-411f-a69e-9f70ddd42862.db": The process cannot access the file because it is being used by another process
Apr 02, 2021 06:17:31.805 [14744] ERROR - Couldn't delete the file "C:\Users\edwar\AppData\Local\Plex Media Server\Plug-in Support\Databases\tv.plex.providers.epg.cloud-72314866-7e12-411f-a69e-9f70ddd42862.db-shm": The process cannot access the file because it is being used by another process
Apr 02, 2021 06:17:31.806 [14744] ERROR - Couldn't delete the file "C:\Users\edwar\AppData\Local\Plex Media Server\Plug-in Support\Databases\tv.plex.providers.epg.cloud-72314866-7e12-411f-a69e-9f70ddd42862.db-wal": The process cannot access the file because it is being used by another process
Apr 02, 2021 06:17:31.806 [14744] DEBUG - Opening 10 database sessions to library (tv.plex.providers.epg.cloud:5), SQLite 3.26.0, threadsafe=1
Apr 02, 2021 06:17:31.808 [14744] ERROR - SQLITE3:0x855ebd85, 11, database corruption at line 65066 of [bf8c1b2b7a]
Apr 02, 2021 06:17:31.808 [14744] ERROR - SQLITE3:0x855ebd85, 11, statement aborts at 8: [] database disk image is malformed
Apr 02, 2021 06:17:31.808 [14744] ERROR - SQLITE3:0x855ebd85, 11, database disk image is malformed in "PRAGMA cache_size=2000"
1 Like
How to I fix the corruption? I don’t understand what any of that means.
I deleted those 3 files it said it could not delete because plex was using them. Now, all of a sudden, my Tuners are showing up again.
As for those other issues, how do I fix SQL issues?
The Repair Database instructions need to be updated so I won’t point you there. Plenty of topics on the matter.
Restart Plex and watch the logs to see if there are more SQL errors. You should have stopped Plex before deleting those files.
I did stop plex before deleting.
Which file did you look at for those SQL errors?
Always best to look at Windows Task Manager and see if any Plex processes are still running - Only the Plex Update Service.exe should remain running after shutdown. For others wait till they close down or force terminate the processes
We do not expect users to need to repair the EPG database - it gets recreated from scratch on Guide Refresh. And with database corruptions for the EPG database is so rare, there is no justification to do major development work to better handle corruptions
The SQL errors are in the Plex Media Server.x.log and Plex Media Server.log - of course some SQL errors are expected and happen when db schemas get updated - but the corruption is fairly unique -
Apr 02, 2021 06:10:53.907 [13740] ERROR - SQLITE3:0xc391f629, 11, database corruption at line 65066 of [bf8c1b2b7a]
Apr 02, 2021 06:10:53.907 [13740] ERROR - SQLITE3:0xc391f629, 11, statement aborts at 8: [] database disk image is malformed
All processes for Plex were shutdown before I went and deleted those 3 files.
My tuners are now showing up but now my EPG is not loading. It keeps giving a failure.
I uninstalled and reinstalled PMS but this didn’t not seem to help. EPG successfully updated once and has not been able to update since then.
I did notice after I reinstalled PMS, most settings and all user account were still there. I had to remap all of my libraries and redownload all thumbnails/metadata for my libraries though.
if the files are locked when all processes are not running - then one would need tools such as OpenedFilesView - View opened/locked files in your system (sharing violation issues) (nirsoft.net) to see what has the lock on the files - if you come across this type of issue again
lets get fresh Plex Media Server logs - please make sure you run with debug logging enabled
Any disk issues ? Disk errors would show up in windows system event log through Event Viewer
Any automatic file backups tool that runs all the time and may be attempting to backup files?
Sorry for the delay. Here is a fresh log from just a few minutes ago.
There are no disk issues currently. I did have to image a disk to a new one as it was dying but had not yet failed. I use Crystal Disk to monitor my drives.
Plex Media Server Logs_2021-04-09_11-11-03.zip (2.9 MB)
Thanks for the new logs
You are running two instances of Plex Media Server.exe in parallel - one as a service or scheduled task and the other as a normal user logged in process - the default for auto start on login
Anything can happen when you do that and results indeterminate and there will file locks / corruptions
If you run as a service, you must disable the auto start on login
Better still, use a tool that already exists PMS As a Service and is used by many users (including myself) - see PMS as a service - General / Tips, Tricks & How-Tos - Plex Forum
and if you have multiple user accounts in windows - then look at the update to the registry here PMS as a service - #4 by sa2000 which ensures the Plex Media Server.exe is not autostarted in the windows account used for the PMS install
SA2000,
I really appreciate your help. I read through most of that forum feed. I’m still a little lost and now the original issue of TV Tuners not showing up is back. I have included a new set of logs pulled this morning after making the following changes.
- Stopped all Plex services through Task Manager.
- Installed Plex Media Server as a Service.
- Made the Registry edit for current user to NOT auto start PMS.
- restarted PMS with PMS as a Service Tray Icon.
Now my TV Tuners are not showing up again.
Also, do I now need to remove the scheduled task of starting PMS? I had done this so that when my computer, which is our only computer in the house, automatically turns on, Plex would be running so that my wife or kids could use Plex while I’m at work.Plex Media Server Logs_2021-04-13_09-00-00.zip (1.6 MB)
SA2000,
I got the Tuner issue fixed. It was the same thing as before, system could not delete or overwrite the previous EPG files. Any ideas on why that is happening?
You were not very careful.
I can see the following
- Plex Media Server.exe running as scheduled task up to 08:44:32
- Plex Media Server.exe running normally not as scheduled task up to 08:37:11
- PMS As Service started Plex Media Server at 08:39:17 - this was when you had a scheduled task process still running (up to 08:44:32)
So here we had it running as service through the PMS As Service wrapper I mentioned as well as your own scheduled task or service
May be this did not work for your scheduled task or however you ran it as a service
- Stopped all Plex services through Task Manager.
You would need to delete your scheduled task as well as stopping Plex related processes
So if you managed to delete the EPG db files and get them recreated after 08:44:32 - then should be ok going forward
Do you use multiple windows user accounts on the PC?
Yes, there are multiple windows users accounts. Generally only 1 is used.
EPG did update correctly once I deleted those files again.
I have removed the scheduled task for starting plex when the computer automatically turns on.
I had this issue worked out prior to the latest updates by removing the win tv app, as that app had the control over the tuner. Now I have the same issue again. I do work with computers, but I am no expert to be sure. Has Plex released anything on this so I can actually use what they say is supported? I have rolled back to 1.19.5.3112 and still does not work
If you care to upgrade Plex Media Server from 1.19.5 to the current public or beta version and get debug logs of the problem, i can have a look at the logs
Current public release is 1.22.3.4523-d0ce30438
Current beta release is 1.23.1.4528-c0513eb4c
See https://plex.tv/downloads
For debug logging - to be enabled beforehand and server restarted to get fresh logs - see
Reporting issues with Plex Media Server | Plex Support
https://support.plex.tv/articles/200250417-plex-media-server-log-files/
Go through DVR setup in Server Settings after relaunching Plex Media Server - or better a reboot of windows
and then collect screenshots and server logs zip when the issue arises
I have had this issue a few times and, for me at least it has occurred when the channel bandwidth has been re-ordered. I needed to delete my hauppauge channel listing and re-scan in the hauppage apps (Hauppauge | How to rescan for TV channels in WinTV) then re-scan in Plex. You don’t need the DOS command. You should have a shorcut to Advanced Options in the Haupauge start menu with a shortcut and the top one is to empty. It auto launches step 2 for re-scanning.
After that drop your current DVR in Plex and re-add and all is good.
The most recent though, I needed to delete and re-add the device within P.lex
