search

ChuckPa / PlexDBRepair

Database repair utility for Plex Media Server databases
Other
885 stars 43 forks source link

FAIL - not sure why #174

Closed jl94x4 closed 1 month ago

jl94x4 commented 1 month ago 

2024-10-03 22.26.26 - SQLite path:   '/mnt/nvme/docker/PlexPlexified/Library/Application Support/Plex Media Server/Plug-in Support/Databases/Plex SQLite'
2024-10-03 22.26.26 - Database path: '/mnt/nvme/docker/PlexPlexified/Library/Application Support/Plex Media Server/Plug-in Support/Databases'
2024-10-03 22.27.32 - Check   - FAIL - PMS runnning
2024-10-04 03.23.32 - Check   - Check com.plexapp.plugins.library.db - FAIL ()
2024-10-04 03.23.32 - Check   - Check com.plexapp.plugins.library.blobs.db - FAIL ()
2024-10-04 03.23.32 - Check   - FAIL
2024-10-04 03.23.38 - Check   - Check com.plexapp.plugins.library.db - FAIL ()
2024-10-04 03.23.38 - Check   - Check com.plexapp.plugins.library.blobs.db - FAIL ()
2024-10-04 03.23.38 - Check   - FAIL
2024-10-04 03.23.49 - Auto    - START
2024-10-04 03.23.49 - Check   - Check com.plexapp.plugins.library.db - FAIL ()
2024-10-04 03.23.49 - Check   - Check com.plexapp.plugins.library.blobs.db - FAIL ()
2024-10-04 03.23.49 - Check   - FAIL
2024-10-04 03.23.49 - Repair  - Cannot recover main database to './dbtmp/library.plexapp.sql-2024-10-04_03.23.49' - FAIL (139)
2024-10-04 03.23.49 - Repair  - FAIL
2024-10-04 03.23.49 - Auto    - FAIL
2024-10-04 03.24.01 - Vacuum  - Check com.plexapp.plugins.library.db - FAIL ()
2024-10-04 03.24.01 - Vacuum  - Check com.plexapp.plugins.library.blobs.db - FAIL ()
2024-10-04 03.24.01 - Vacuum  - Databases damaged.
2024-10-04 03.29.03 - Plex SQLite = '/mnt/nvme/docker/PlexPlexified/Library/Application Support/Plex Media Server/Plug-in Support/Databases/Plex SQLite'
2024-10-04 03.29.03 - Databases   = '/mnt/nvme/docker/PlexPlexified/Library/Application Support/Plex Media Server/Plug-in Support/Databases'
2024-10-04 03.29.03 - ============================================================
2024-10-04 03.29.03 - Session start: Host is User Defined
2024-10-04 03.29.03 - SQLite path:   '/mnt/nvme/docker/PlexPlexified/Library/Application Support/Plex Media Server/Plug-in Support/Databases/Plex SQLite'
2024-10-04 03.29.03 - Database path: '/mnt/nvme/docker/PlexPlexified/Library/Application Support/Plex Media Server/Plug-in Support/Databases'
2024-10-04 03.29.10 - Auto    - START
2024-10-04 03.29.10 - Check   - Check com.plexapp.plugins.library.db - FAIL ()
2024-10-04 03.29.10 - Check   - Check com.plexapp.plugins.library.blobs.db - FAIL ()
2024-10-04 03.29.10 - Check   - FAIL
2024-10-04 03.29.10 - Repair  - Cannot recover main database to './dbtmp/library.plexapp.sql-2024-10-04_03.29.10' - FAIL (139)
2024-10-04 03.29.10 - Repair  - FAIL
2024-10-04 03.29.10 - Auto    - FAIL
2024-10-04 03.29.23 - Check   - Check com.plexapp.plugins.library.db - FAIL ()
2024-10-04 03.29.23 - Check   - Check com.plexapp.plugins.library.blobs.db - FAIL ()
2024-10-04 03.29.23 - Check   - FAIL
2024-10-04 03.30.33 - Auto    - START
2024-10-04 03.30.33 - Check   - Check com.plexapp.plugins.library.db - FAIL ()
2024-10-04 03.30.33 - Check   - Check com.plexapp.plugins.library.blobs.db - FAIL ()
2024-10-04 03.30.33 - Check   - FAIL
2024-10-04 03.30.33 - Repair  - Cannot recover main database to './dbtmp/library.plexapp.sql-2024-10-04_03.30.32' - FAIL (139)
2024-10-04 03.30.33 - Repair  - FAIL
2024-10-04 03.30.33 - Auto    - FAIL
2024-10-04 03.31.33 - Plex SQLite = '/mnt/nvme/docker/PlexPlexified/Library/Application Support/Plex Media Server/Plug-in Support/Databases/Plex SQLite'
2024-10-04 03.31.33 - Databases   = '/mnt/nvme/docker/PlexPlexified/Library/Application Support/Plex Media Server/Plug-in Support/Databases'
2024-10-04 03.31.33 - ============================================================
2024-10-04 03.31.33 - Session start: Host is User Defined
2024-10-04 03.31.33 - SQLite path:   '/mnt/nvme/docker/PlexPlexified/Library/Application Support/Plex Media Server/Plug-in Support/Databases/Plex SQLite'
2024-10-04 03.31.33 - Database path: '/mnt/nvme/docker/PlexPlexified/Library/Application Support/Plex Media Server/Plug-in Support/Databases'
2024-10-04 03.31.37 - Check   - FAIL - PMS runnning
2024-10-04 03.31.47 - Auto    - START
2024-10-04 03.31.47 - Check   - Check com.plexapp.plugins.library.db - FAIL ()
2024-10-04 03.31.47 - Check   - Check com.plexapp.plugins.library.blobs.db - FAIL ()
2024-10-04 03.31.47 - Check   - FAIL
2024-10-04 03.31.47 - Repair  - Cannot recover main database to './dbtmp/library.plexapp.sql-2024-10-04_03.31.47' - FAIL (139)
2024-10-04 03.31.47 - Repair  - FAIL
2024-10-04 03.31.47 - Auto    - FAIL
2024-10-04 03.33.25 - Replace - Check com.plexapp.plugins.library.db - FAIL ()
2024-10-04 03.33.25 - Replace - Check com.plexapp.plugins.library.blobs.db - FAIL ()
2024-10-04 03.33.25 - Replace - Select candidate - FAIL
2024-10-04 03.33.46 - Prune   - START
2024-10-04 03.33.48 - Prune   - PASS
==================================================================================```
jl94x4 commented 1 month ago 


Automatic Check,Repair,Index started.

Checking the PMS databases
DCRT: Failed to open ldso
Check complete.  PMS main database is damaged.
DCRT: Failed to open ldso
Check complete.  PMS blobs database is damaged.

Exporting current databases using timestamp: 2024-10-04_03.35.57
Exporting Main DB
DCRT: Failed to open ldso
./DBRepair.sh: line 918: 2016798 Segmentation fault      "$PLEX_SQLITE" $CPPL.db ".output '$TMPDIR/library.plexapp.sql-$TimeStamp'" .dump
Error 139 from Plex SQLite while exporting com.plexapp.plugins.library.db
Could not successfully export the main database to repair it.  Please try restoring a backup.
Repair failed. Automatic mode cannot continue. Please repair with individual commands```
ChuckPa commented 1 month ago

Sounds like either/both LD_CONFIG and/or PATH weren't set in the shell launching.

The script will indirectly call ldso (load shared object) as "Plex SQLite" loads and initializes to get the libraries it needs.