Need help with Corrupted database

Plex Media Server NAS & Devices
,
1

I been having issues with a corrupted database for months now, but using binhex/arch-plexpass:1.40.2.8395-1-01 was working up until recently. It “does” still work, but the new gui on mobile requires the latest version, so I’m forced to update. I’m on unraid running the binhex-plexpass docker and have tried repairing the database multiple times. Below is my latest log file, but I still cant get the docker to load.

2025-04-02 18.56.04 - ============================================================
2025-04-02 18.56.04 - Session start: Host is BINHEX
2025-04-02 19.00.20 - Start/Stop feature not available
2025-04-02 19.12.20 - ============================================================
2025-04-02 19.12.20 - Session start: Host is BINHEX
2025-04-02 19.12.47 - Auto - START
2025-04-02 19.12.56 - Check - Check com.plexapp.plugins.library.db - PASS
2025-04-02 19.13.00 - Check - Check com.plexapp.plugins.library.blobs.db - PASS
2025-04-02 19.13.00 - Check - PASS
2025-04-02 19.14.50 - Repair - Export databases - PASS
2025-04-02 19.15.46 - Repair - Import - PASS
2025-04-02 19.15.54 - Repair - Verify main database - PASS (Size: 212MB/212MB).
2025-04-02 19.15.58 - Repair - Verify blobs database - PASS (Size: 303MB/303MB).
2025-04-02 19.15.58 - Making repaired databases active
2025-04-02 19.15.58 - Repair - Move files - PASS
2025-04-02 19.15.58 - Repair - PASS
2025-04-02 19.15.58 - Repair - PASS
2025-04-02 19.15.58 - Reindex - MakeBackup com.plexapp.plugins.library.db - PASS
2025-04-02 19.15.58 - Reindex - MakeBackup com.plexapp.plugins.library.blobs.db - PASS
2025-04-02 19.15.58 - Reindex - MakeBackup - PASS
2025-04-02 19.16.13 - Reindex - Reindex: com.plexapp.plugins.library.db - PASS
2025-04-02 19.16.19 - Reindex - Reindex: com.plexapp.plugins.library.blobs.db - PASS
2025-04-02 19.16.19 - Reindex - PASS
2025-04-02 19.16.19 - Reindex - PASS
2025-04-02 19.16.19 - Auto - COMPLETED
2025-04-02 19.18.02 - Exit - Delete temp files.
2025-04-02 19.18.03 - Session end. Wed Apr 2 19:18:03 EDT 2025
2025-04-02 19.18.03 - ============================================================

This is the error I’m getting in the plex logs when I boot the docker:

Error: Unable to set up server: sqlite3_statement_backend::prepare: ON CONFLICT clause does not match any PRIMARY KEY or UNIQUE constraint for SQL: INSERT INTO schema_migrations (version, rollback_sql, optimize_on_rollback) VALUES (:version, :sql, 0) ON CONFLICT(version) DO UPDATE SET rollback_sql=:sql, optimize_on_rollback=0 (N4soci10soci_errorE)

2

You might want to have a look at this helper.

1 Like
3

That looks like the log from @ChuckPa 's repair tool. Tagging him will get his attention.

4

You’re right, that’s already the output of the dbrepair tool. My bad.

5

It’s alright, you’ve had a long few days :joy:.
@knucklez09 hopefully help will come along soon.

1 Like
6

Strangely enough after all the repairs were sucessful and it still didnt work, I went back to binhex/arch-plexpass:1.40.2.8395-1-01 and everything loads fine. I also tried the official Plex container at the latest version, which loaded fine, then copied my db and blob file to it and I’m getting the same error.

7

This is a content error and more than my tool can address.

My tool corrects the physical DB at the SQLite structure level.
It is beyond what a shell script can do to verify which records belong or don’t belong in the DB and/or if those records have the right values in them.

Sorry.

8

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