DVR no longer recording and cannot watch live TV from tuner. Get various errors

Live TV & DVR
1

This has been going on for several months and I just haven’t had the bandwidth to seek help.

All recordings seem to fail. Live TV isn’t visible. I have storage space on the external drive that Plex is directed to record to.

I can watch personally created or “old” content from my library just fine. That content is stored on the same hard drive that the recorded TV is stored on/recorded to.

Trying to watch Live TV from the tuner (via a Chrombeook web interface) gives this error: Playback Error: Could not tune channel

Trying to play ~“recently” recorded - 3mo ago - content gives this error. Playback Error: Please check that the file exists and the necessary drive is mounted.

Server Version#: Version 1.32.8.7639
Player Version#: various - android app, web interface, Shield TV-based app
Tuner Make/Model: HDHomeRun CONNECT
Guide/Lineup name: Local Broadcast Listings (200 channels) (not sure if this is what’s being asked for)
Using XMLTV?: ?
Channel number/Name: KTVU Fox 2.1, NBC 11.1,
<If providing server logs please do NOT turn on verbose logging, only debug logging should be enabled>

Here are logs from the webplayer. Not sure if this is the right source, if it’s too much, or too little.

[
{
“type”: “info”,
“host”: “app.plex.tv”,
“userAgent”: “Mozilla/5.0 (X11; CrOS x86_64 13904.41.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.81 Safari/537.36”,
“browser”: {
“platformVersion”: “13904.41”,
“id”: “chrome”,
“name”: “Chrome”,
“version”: “91.0”,
“webkit”: true,
“platform”: “Chrome OS”,
“platformID”: “chromeos”,
“platformModifierKey”: “ctrl”
},
“version”: “4.120.1”,
“username”: “shaharPP”,
“cloudUrl”: [
{
“scheme”: “https”,
“address”: “clients.plex.tv”,
“uri”: “https://clients.plex.tv”,
“testState”: “untested”,
“isBundled”: false,
“isFallback”: false,
“relay”: false,
“isUntested”: true,
“isPending”: false,
“isConnected”: false,
“isUnauthorized”: false,
“isUnavailable”: false,
“isFailed”: false,
“isAborted”: false,
“isLoopback”: false,
“isPrivate”: false,
“isHttps”: true,
“isSecure”: true,
“isPlexDirect”: false,
“sources”: [
{
“id”: “internal”
}
]
}
]
},
{
“type”: “log:message”,
“level”: 4,
“message”: “[UserManager] autoLogin false”,
“time”: “2023-12-16T18:42:42.583Z”
},
{
“type”: “log:message”,
“level”: 4,
“message”: “[Sources] Initializing…”,
“time”: “2023-12-16T18:42:42.914Z”
},
{
“type”: “log:message”,
“level”: 4,
“message”: “[Sources] Finished initialization”,
“time”: “2023-12-16T18:42:42.915Z”
},
{
“type”: “log:message”,
“level”: 4,
“message”: “[Servers] Initializing…”,
“time”: “2023-12-16T18:42:42.916Z”
},
{
“type”: “log:message”,
“level”: 4,
“message”: “[Servers] Initialize server with token, SHIELD 2, 7d1f4e0b6e3dd014728cb39f4dacf0e18cf7fbb6, https://2601-0646-9500-0394-01bc-8d62-cd65-bc62.4f23f774175643c3927e5d3f13607222.plex.direct:32400, https://2601-0646-9500-0394-a561-e900-219a-8da2.4f23f774175643c3927e5d3f13607222.plex.direct:32400, https://2601-0646-9500-0394-d437-ee76-3d80-7842.4f23f774175643c3927e5d3f13607222.plex.direct:32400, https://2601-0646-9500-0394-14d3-665f-f77f-865f.4f23f774175643c3927e5d3f13607222.plex.direct:32400, https://2601-0646-9500-0394-f081-a1a7-c61e-29e7.4f23f774175643c3927e5d3f13607222.plex.direct:32400, https://192-168-86-250.4f23f774175643c3927e5d3f13607222.plex.direct:32400, https://2601-0646-9500-0394-d8ed-fe83-8240-a7ef.4f23f774175643c3927e5d3f13607222.plex.direct:32400”,
“time”: “2023-12-16T18:42:42.954Z”
},
{
“type”: “log:message”,
“level”: 4,
“message”: “[Servers] Waiting for initial servers = plex.tv”,
“time”: “2023-12-16T18:42:42.956Z”
},
{
“type”: “log:message”,
“level”: 4,
“message”: “[Primary Server] Waiting to set the primary server”,
“time”: “2023-12-16T18:42:42.969Z”
},
{
“type”: “log:message”,
“level”: 4,
“message”: “[Primary Server] Waiting for the last primary server, 7d1f4e0b6e3dd014728cb39f4dacf0e18cf7fbb6, to connect”,
“time”: “2023-12-16T18:42:42.970Z”
},
{
“type”: “log:message”,
“level”: 4,
“message”: “[Commands] Executing testServerConnection”,
“time”: “2023-12-16T18:42:42.972Z”
},
{
“type”: “log:message”,
“level”: 4,
“message”: “[Commands] Executing testServerConnection”,
“time”: “2023-12-16T18:42:42.973Z”
},
{
“type”: “log:message”,
“level”: 4,
“message”: “[Commands] Executing testServerConnection”,
“time”: “2023-12-16T18:42:42.974Z”
},
{
“type”: “log:message”,
“level”: 4,
“message”: “[Commands] Executing testServerConnection”,
“time”: “2023-12-16T18:42:42.974Z”
},
{
“type”: “log:message”,
“level”: 4,
“message”: “[Commands] Executing testServerConnection”,
“time”: “2023-12-16T18:42:42.975Z”
},
{
“type”: “log:message”,
“level”: 4,
“message”: “[Commands] Executing testServerConnection”,
“time”: “2023-12-16T18:42:42.976Z”
},
{
“type”: “log:message”,
“level”: 4,
“message”: “[Commands] Executing testServerConnection”,
“time”: “2023-12-16T18:42:42.977Z”
},
{
“type”: “log:message”,
“level”: 4,
“message”: “[Commands] Executing testServerConnection”,
“time”: “2023-12-16T18:42:42.977Z”
},
{
“type”: “log:message”,
“level”: 1,
“message”: “[Companion] No companion found”,
“time”: “2023-12-16T18:42:42.978Z”
},
{
“type”: “log:message”,
“level”: 4,
“message”: “[Servers] Finished initialization”,
“time”: “2023-12-16T18:42:42.979Z”
},
{
“type”: “ajax”,
“url”: “/desktop/translations/en.json”,
“status”: 200,
“responseLength”: 2,
“time”: “2023-12-16T18:42:43.078Z”
},
{
“type”: “log:message”,
“level”: 4,
“message”: “[Connections] Testing connection for SHIELD 2 at https://2601-0646-9500-0394-01bc-8d62-cd65-bc62.4f23f774175643c3927e5d3f13607222.plex.direct:32400/media/providers”,
“time”: “2023-12-16T18:42:43.092Z”
},
{
“type”: “log:message”,
“level”: 4,
“message”: “[Connections] Testing connection for SHIELD 2 at https://2601-0646-9500-0394-a561-e900-219a-8da2.4f23f774175643c3927e5d3f13607222.plex.direct:32400/media/providers”,
“time”: “2023-12-16T18:42:43.100Z”
},
{
“type”: “log:message”,
“level”: 4,
“message”: “[Connections] Testing connection for SHIELD 2 at https://2601-0646-9500-0394-d437-ee76-3d80-7842.4f23f774175643c3927e5d3f13607222.plex.direct:32400/media/providers”,
“time”: “2023-12-16T18:42:43.108Z”
},
{
“type”: “log:message”,
“level”: 4,
“message”: “[Connections] Testing connection for SHIELD 2 at https://2601-0646-9500-0394-14d3-665f-f77f-865f.4f23f774175643c3927e5d3f13607222.plex.direct:32400/media/providers”,
“time”: “2023-12-16T18:42:43.115Z”
},
{
“type”: “log:message”,
“level”: 4,
“message”: “[Connections] Testing connection for SHIELD 2 at https://2601-0646-9500-0394-f081-a1a7-c61e-29e7.4f23f774175643c3927e5d3f13607222.plex.direct:32400/media/providers”,
“time”: “2023-12-16T18:42:43.128Z”
}
]

2

Plex Media Server Logs_2023-12-17_09-46-26.zip (3.2 MB)

I did a Shield unplug … HDHomerun reboot … Shield plug back in cycle this morning, and then captured logs per the instructions on the “Help me help you” pinned post. Hoping this helps in diagnosis. Thank you in advance!!!

3

It looks like your Plex Server database instance is corrupt. I’m seeing the following after Plex Server starts a Live TV grab from your tuner:

Dec 17, 2023 09:43:51.588 [217066622144] ERROR - [Req#2158/Grabber/5fc76b247c6557002efc77f6-5fc705e47c6557002ee1e761-sd2tbehsrowra60drdyfgff5] SQLITE3:0x1, 11, database corruption at line 68825 of [a29f994989]
Dec 17, 2023 09:43:51.588 [217066622144] ERROR - [Req#2158/Grabber/5fc76b247c6557002efc77f6-5fc705e47c6557002ee1e761-sd2tbehsrowra60drdyfgff5] SQLITE3:0x1, 11, database corruption at line 68975 of [a29f994989]
Dec 17, 2023 09:43:51.588 [217066622144] ERROR - [Req#2158/Grabber/5fc76b247c6557002efc77f6-5fc705e47c6557002ee1e761-sd2tbehsrowra60drdyfgff5] SQLITE3:0x1, 11, statement aborts at 7: [SELECT coalesce((SELECT max(blockid) FROM 'main'.'fts4_metadata_titles_icu_segments') + 1, 1)] database disk image is malformed
Dec 17, 2023 09:43:51.590 [217066622144] ERROR - [Req#2158/Grabber/5fc76b247c6557002efc77f6-5fc705e47c6557002ee1e761-sd2tbehsrowra60drdyfgff5] Failed to commit transaction (/data/jenkins/server/1270223651/Library/MetadataItem.cpp:1131) (tries=1): Cannot commit transaction. database disk image is malformed

Normally I would point you at this article for how to restore a backup or repair the database, but I’m not a Shield user. Perhaps someone else with a Shield background can jump in?

Based on some paths I’m seeing, do you have your Plex data directory on an external drive, or possibly a network share? I know that some people have experienced issues with the data directory (or transcode directory) being on a network drive due to latency/performance issues.

4

Thanks for the investigation.
I’m not certain* where the plex data directory is. I DO have a 2TB external HDD plugged into the Shield. All of my media is on that external drive. No network shares are (should be) in play.

*the language used within the sheild/plex environment in and around storage isn’t always clear to me.

5

Is there anyone with Shield experience that can help with restoring a database backup, or doing a repair?

An external HDD should be fine, and I can say that if you haven’t changed any of the defaults then the Plex database directory should be as specified in this article (there is a section for the shield.) You may want to try to restore a backup of your database as specified in this article. Unfortunately I don’t have any shield specific knowledge at all, so I’m hoping someone with more platform specific knowledge can jump in.

6

Odd that the article on database repair doesn’t show the approach for Shield servers.

Anybody have insight how to perform database repairs on the Shield?

  • Windows (32-bit): "C:\Program Files (x86)\Plex\Plex Media Server\Plex SQLite.exe"
  • macOS: "/Applications/Plex Media Server.app/Contents/MacOS/Plex SQLite"
  • Linux (desktop): "/usr/lib/plexmediaserver/Plex SQLite"
  • QNAP: "/share/CACHEDEV1_DATA/.qpkg/PlexMediaServer/Plex SQLite"
  • Synology (DSM 6): "/var/packages/Plex Media Server/target/Plex SQLite"
  • Synology (DSM 7): "/var/packages/PlexMediaServer/target/Plex SQLite"
7

Given I have some “must record” items coming up - Go 49ers and Warriors - I decided to nuke the server and start fresh.

1 Like
8

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.