Can not play any video files local or remote. Play back error. Also lost tv on homepage,

Plex Media Server Desktops & Laptops
1

Server Version#: 1.30.2.6563
Player Version#:
<If providing server logs please do NO
Plex Media Server Logs_2023-01-28_17-55-14.zip (3.9 MB)
T turn on verbose logging>
Plex Media Server Logs_2023-01-30_07-28-05.zip (3.7 MB)

2

I also recently updated my server, and now I can’t play over Apple TV

3

From Plex Media Server.log:

Jan 30, 2023 07:24:12.068 [11820] ERROR - SQLITE3:0x7ff741875d20, 11, database corruption at line 88814 of [1b256d97b5]
Jan 30, 2023 07:24:12.068 [11820] ERROR - SQLITE3:0x7ff741875d20, 11, statement aborts at 8: [update taggings set created_at = iif(typeof(created_at) in ('integer', 'real'), created_at, strftime('%s', created_at, 'utc'))] database disk image is malformed
Jan 30, 2023 07:24:12.071 [11820] ERROR - Exception inside transaction (inside=1) (E:\jenkins\server\4153676204\Library\DatabaseMigrations.cpp:289): sqlite3_statement_backend::loadOne: database disk image is malformed
Jan 30, 2023 07:24:12.075 [11820] ERROR - Exception thrown during migrations, aborting: sqlite3_statement_backend::loadOne: database disk image is malformed

@golgo17

The database in your Plex Media Server is corrupt.

Download and run the DB Repair Utility.

This is the Windows version of the utility. Unlike the Linux version, it does not have any command line options.

  1. Download & decompress the zip file.
  2. Stop Plex Media Server
  3. Run DBRepair-WinDev.bat
  4. Start Plex Media Server

After using the utility, see if your media will play OK. If not , pull another set of log files and upload to the thread. There are other options, such as restoring from a backup.

Example output (from PMS on my Win10 PC):

14:09:11.13 --  ====== Session begins. (Mon 01/30/2023) ======
14:09:11.36 --  Exporting Main DB
14:09:26.63 --  Exporting Blobs DB
14:09:26.79 --  Exporting Complete.
14:09:26.79 --  Creating Main DB
14:09:30.26 --  Verifying Main DB
14:09:31.33 --  Main DB verification check is: ok
14:09:31.33 --  Main DB verification successful.
14:09:31.33 --  Creating Blobs DB
14:09:31.39 --  Verifying Blobs DB
14:09:31.44 --  Blobs DB verification check is: ok
14:09:31.44 --  Blobs DB verification successful.
14:09:31.44 --  Import and verification complete.
14:09:31.44 --  Reindexing Main DB
14:09:32.41 --  Reindexing Blobs DB
14:09:32.46 --  Reindexing complete.
14:09:32.46 --  Moving current DBs to DBTMP and making new databases active
        1 file(s) moved.
        1 file(s) moved.
        1 file(s) moved.
        1 file(s) moved.
14:09:32.48 --  Database repair/rebuild/reindex completed.
14:09:32.48 --  ====== Session completed. ======
4

bat file never got past exporting main db
Plex Media Server Logs_2023-01-30_16-33-14.zip (2.4 MB)

5

Then the db is still corrupt.

Give the script time to run, at least several minutes. The system I used is not my main server, and has a very small database (52 MB), so the utility ran very quickly. You should be able to see the disk activity in Windows Task Manager.

If it still does not run, here’s other options:

  1. Manually repair the database
    Go through all the steps, including the low level recovery.

  2. Restore the database from a backup
    Note that the backup might be corrupt as well. You’ll need to check the Plex Media Server.log file for errors that mention corruption or malformed.

  3. If repair or restore does not work, you can delete the database.
    Delete everything in the Databases directory (%LOCALAPPDATA%\Plex Media Server\Plug-in Support\Databases) Reference: Where is the Plex Media Server data directory located?
    This is almost like starting over. You will have to re-create your libraries and re-share them with any friends. Your media files are not touched.


EDIT: Task Manager screenshot while DB Repair Utility is running.

task manager
task manager774×250 15.1 KB

6

now plex will not start, cant open database error. Is their a way to totally erase plex and start over?

7

corrupt database - plex media server was unable to open its media database

8

I used the guide to uninstall. Installed fresh, same thing, database corrupted…

9

This will completely remove Plex from your system: Uninstall Plex Media Server

You may first want to try just removing the database files:

  1. Stop Plex Plex Media Server
  2. Navigate to %LOCALAPPDATA%\Plex Media Server\Plug-in Support
  3. Rename Databases to Databases.old (or anything other than Databases).
  4. Start Plex Media Server

That will start Plex Media Server with a new database. You can re-create your libraries, re-share with others, etc.

10

Renaming databases allowed plex to start, setting up file links now. Thank you for the expert support.

11

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