Database corruption

Plex Media Server
1

Server Version#: 1.32.0.6973
Player Version#: 4.100.1

Hello
I’m using PLEX for years now and for the first time I have to post a topic about my particular problem:

Recently I’ve switched my server from a 2011 Mac mini to a I7 2018 one,
I followed the transfer method on Plex website, Everything went fine except for some movies not playing. In fact I only managed to find 4 over about 6700 movies. I suspect more are affected.
When I run console I get the [Req#1f5b] SQLITE3:(nil), 11, database corruption at line 84326 of [a29f994989] red message.
I’ve tried to repair my database with Plex SQLite following instructions in the page :

https://support.plex.tv/articles/repair-a-corrupted-database/

I don’t know if I did everything well but I still have the same issue on the same movies.

I’m despaired, could someone provide some help please?

You can found PLEX log below. If any other file is needed for analysis, I will be happy to send it

Plex Media Server.4.log (10.0 MB)
Plex Media Server.3.log (10.0 MB)
Plex Media Server.2.log (7.3 MB)
Plex Media Server.1.log (269.8 KB)
Plex Media Server.log (499.8 KB)
Plex Media Server.5.log (10.0 MB)

2

You’ve still got database corruption:

Apr 25, 2023 20:58:03.143 [0x70000f1bd000] ERROR - [Req#685] SQLITE3:(nil), 11, database corruption at line 84326 of [a29f994989]
...
Apr 25, 2023 20:58:03.143 [0x70000f1bd000] ERROR - [Req#685] SQLITE3:(nil), 11, statement aborts at 34: [select taggings.id, count(*) as taggings_count from tags   join taggings on taggings.tag_id=tags.id   join taggings as related on taggings.tag_id=related.tag_id   join metadata_items on metadata_items.id=related.metadata_item_id  where taggings.metadata_item_id=? and metadata_items.library_section_id=?  and tags.tag != ''  group by taggings.id;] database disk image is malformed
Apr 25, 2023 20:58:03.144 [0x70000f1bd000] ERROR - Got exception from request handler: sqlite3_statement_backend::loadRS: database disk image is malformed

That’s going to need to be dealt with before you try to fix anything else. You may want to give @ChuckPa’s excellent DBRepair.sh script a shot.

If the database cannot be repaired, your best bet would be to restore your most recent good backup.

3

Thank you for your quick reply.
i will try ChuckPa’s utility

I’ve removed the movies from my library Cleaned db and emptied bundles then I’ve put them back.
Now the movies are playing only on my Shield Pro 2019.
Same error on playstation 5, Apple TV4K and Plex for Mac.
Console still showing red db error message.

4

Thank you for Chuck Pa’s utility
Repair worked
It’s now playing perfect on Shield Pro
And Apple TV
On PLEX for Mac app it takes long (about 20 to 30 sec) beforg starting movie
On PlayStation 5 I still have the same error message
No specific error message on console at that time
Unable to play those 6 specific movies. All other movies plays perfect

Same issue on PLEX for iPhone

Any issue why it does work on specific platforms and not on others?

Anyway thanks for the good help

5

Maybe try deleting cache and codec folders?

6

Cache deleted on PS5 and iOS (I should have think about it earlier)
Now playing perfect on all platforms

Thank you everyone for the help

Shout out to ChuckPa for his wondeful utility

1 Like
7

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