PMS db corrupted - running in BINHEX docker on Unraid

I’m not undestanding.

Did you install on Ubuntu from the SNAP package?

sudo snap list

PRETTY_NAME=“Ubuntu 22.04.2 LTS”
NAME=“Ubuntu”
VERSION_ID=“22.04”
VERSION=“22.04.2 LTS (Jammy Jellyfish)”
VERSION_CODENAME=jammy

EDITED:

sudo snap list

?

no, did dpkg -i .pkg

sudo snap list
[sudo] password for mediaserver:
sudo: snap: command not found

pdkg -i .pkg ???

dpkg -l | grep -i plexm

mediaserver@mediaserver:~$ dpkg -l | grep -i plexm
ii plexmediaserver 1.32.4.7195-7c8f9d3b6 amd64 Plex organizes all of your personal media so you can easily access and enjoy it.

I thought you asked me how I installed Plex.

sudo dpkg -i plexmediaserver_1.32.4.7195-7c8f9d3b6_amd64.deb

That’s what I was trying to figure out.

Give me a moment.

There’s no way it will fail to detect PMS on Ubuntu if /var/lib/plexmediaserver exists

[chuck@lizum ~.2001]$ dpkg -l | grep plexm
ii  plexmediaserver                            1.32.2.7100-248a2daf0               amd64        Plex organizes all of your personal media so you can easily access and enjoy it.
[chuck@lizum ~.2002]$ sudo git/chuck/PlexDBRepair/DBRepair.sh 
 
 
 
      Plex Media Server Database Repair Utility (Ubuntu 20.04.6 LTS)
                       Version v1.0.8
 

Select

  1 - 'stop'      - Stop PMS
  2 - 'automatic' - database check, repair/optimize, and reindex in one step.
  3 - 'check'     - Perform integrity check of database
  4 - 'vacuum'    - Remove empty space from database
  5 - 'repair'    - Repair/Optimize  databases
  6 - 'reindex'   - Rebuild database database indexes
  7 - 'start'     - Start PMS

  8 - 'import'    - Import watch history from another database independent of Plex. (risky)
  9 - 'replace'   - Replace current databases with newest usable backup copy (interactive)
 10 - 'show'      - Show logfile
 11 - 'status'    - Report status of PMS (run-state and databases)
 12 - 'undo'      - Undo last successful command

 99 - 'quit'      - Quit immediately.  Keep all temporary files.
      'exit'      - Exit with cleanup options.

Enter command # -or- command name (4 char min) : 
1 Like

I will reinstall plex over my previous version.
Works now. Thank you.
For some reason, /var/lib/plexmediaserver was not found.

Don’t shutdown PMS while doing first-level Optimization ?
how do I do that ? what option is it ?

If you have PMS optimize itself – it must be running (obviously).

Now that you have things recognized again.

From within the tool

  1. Stop PMS
  2. Auto
  3. Start
  4. Exit

should I ignore this ?
channel 4: open failed: connect failed: Connection refused
a few of them

root@mediaserver:/home/mediaserver/PlexDBRepair# ./DBRepair.sh



      Plex Media Server Database Repair Utility (Ubuntu 22.04.2 LTS)
                       Version v1.0.8


Select

  1 - 'stop'      - Stop PMS
  2 - 'automatic' - database check, repair/optimize, and reindex in one step.
  3 - 'check'     - Perform integrity check of database
  4 - 'vacuum'    - Remove empty space from database
  5 - 'repair'    - Repair/Optimize  databases
  6 - 'reindex'   - Rebuild database database indexes
  7 - 'start'     - Start PMS

  8 - 'import'    - Import watch history from another database independent of Plex. (risky)
  9 - 'replace'   - Replace current databases with newest usable backup copy (interactive)
 10 - 'show'      - Show logfile
 11 - 'status'    - Report status of PMS (run-state and databases)
 12 - 'undo'      - Undo last successful command

 99 - 'quit'      - Quit immediately.  Keep all temporary files.
      'exit'      - Exit with cleanup options.

Enter command # -or- command name (4 char min) : 1

Stopping PMS.
Stopped PMS.

Select

  1 - 'stop'      - Stop PMS
  2 - 'automatic' - database check, repair/optimize, and reindex in one step.
  3 - 'check'     - Perform integrity check of database
  4 - 'vacuum'    - Remove empty space from database
  5 - 'repair'    - Repair/Optimize  databases
  6 - 'reindex'   - Rebuild database database indexes
  7 - 'start'     - Start PMS

  8 - 'import'    - Import watch history from another database independent of Plex. (risky)
  9 - 'replace'   - Replace current databases with newest usable backup copy (interactive)
 10 - 'show'      - Show logfile
 11 - 'status'    - Report status of PMS (run-state and databases)
 12 - 'undo'      - Undo last successful command

 99 - 'quit'      - Quit immediately.  Keep all temporary files.
      'exit'      - Exit with cleanup options.

Enter command # -or- command name (4 char min) : 2

Automatic Check,Repair,Index started.

Checking the PMS databases
Check complete.  PMS main database is OK.
Check complete.  PMS blobs database is OK.

Exporting current databases using timestamp: 2023-06-17_23.42.22
Exporting Main DB
Exporting Blobs DB
channel 3: open failed: connect failed: Connection refused
channel 4: open failed: connect failed: Connection refused
Successfully exported the main and blobs databases.  Proceeding to import into new databases.
Importing Main DB.
channel 3: open failed: connect failed: Connection refused
channel 3: open failed: connect failed: Connection refused
channel 3: open failed: connect failed: Connection refused
channel 4: open failed: connect failed: Connection refused
Importing Blobs DB.
channel 3: open failed: connect failed: Connection refused
channel 4: open failed: connect failed: Connection refused
Successfully imported databases.
Verifying databases integrity after importing.
Verification complete.  PMS main database is OK.
Verification complete.  PMS blobs database is OK.
Saving current databases with '-BACKUP-2023-06-17_23.42.22'
Making repaired databases active
Repair complete. Please check your library settings and contents for completeness.
Recommend:  Scan Files and Refresh all metadata for each library section.

Backing up of databases
Backup current databases with '-BACKUP-2023-06-17_23.44.12' timestamp.
Reindexing main database
Reindexing main database successful.
Reindexing blobs database
Reindexing blobs database successful.
Reindex complete.
Automatic Check, Repair/optimize, & Index successful.

Select

  1 - 'stop'      - Stop PMS
  2 - 'automatic' - database check, repair/optimize, and reindex in one step.
  3 - 'check'     - Perform integrity check of database
  4 - 'vacuum'    - Remove empty space from database
  5 - 'repair'    - Repair/Optimize  databases
  6 - 'reindex'   - Rebuild database database indexes
  7 - 'start'     - Start PMS

  8 - 'import'    - Import watch history from another database independent of Plex. (risky)
  9 - 'replace'   - Replace current databases with newest usable backup copy (interactive)
 10 - 'show'      - Show logfile
 11 - 'status'    - Report status of PMS (run-state and databases)
 12 - 'undo'      - Undo last successful command

 99 - 'quit'      - Quit immediately.  Keep all temporary files.
      'exit'      - Exit with cleanup options.

Enter command # -or- command name (4 char min) : 7

Starting PMS.
Started PMS

Select

  1 - 'stop'      - Stop PMS
  2 - 'automatic' - database check, repair/optimize, and reindex in one step.
  3 - 'check'     - Perform integrity check of database
  4 - 'vacuum'    - Remove empty space from database
  5 - 'repair'    - Repair/Optimize  databases
  6 - 'reindex'   - Rebuild database database indexes
  7 - 'start'     - Start PMS

  8 - 'import'    - Import watch history from another database independent of Plex. (risky)
  9 - 'replace'   - Replace current databases with newest usable backup copy (interactive)
 10 - 'show'      - Show logfile
 11 - 'status'    - Report status of PMS (run-state and databases)
 12 - 'undo'      - Undo last successful command

 99 - 'quit'      - Quit immediately.  Keep all temporary files.
      'exit'      - Exit with cleanup options.

Running Plex behind a proxy.

The tool does not care about a proxy.
It only cares about console connectivity to you (the command line).

So these connection failed are fine?

You did a port forward/tunnel as you connected to the command line?

ssh -L 

Channel 3 and 4 are used for SSH tunnel / port forwarding inside the SSH connection.
(common when SSH to a remote PMS host AND forwarding port 32400)

yes I did

Then don’t worry about it.

Thank you so much, I really appreciate it.

anytime!

(you happened to catch me still awake & folding laundry. hahaha)