Plexamp search not showing any results (database disk image is malformed)

Plex Media Server
1

Server Version#: 4.147.1
Player (PlexAmp) Version#: 4.12.4

Here is my plex media server log and DBRepair log.

Plex Media Server.log (424.3 KB)

DBRepair.log (8.5 KB)

Hi all,

I am having a hard time understanding why my database is malformed. I did run ChuckPa his DBrepair and all seems to go great (see logs atttached). I did scan library files again, I did refreshed my metadata. I followed all steps to make sure my database is “repaired”. Everything seems to be working fine on the frontend side, but only searching for music in my Plexamp application is not working. As you see in the debug log part here:

Part of my debug log:

Oct 05, 2025 15:58:38.976 [23120213539640] DEBUG - Completed: [192.168.10.215:55777] 200 GET /playQueues/2082?window=16&center=100396 (9 live) #264cc4 TLS GZIP 62ms 10112 bytes (pipelined: 1)

Oct 05, 2025 15:58:40.095 [23119951182648] DEBUG - Request: [192.168.10.215:55769 (WAN)] GET /hubs/search?query=Gh&excludeFields=summary&limit=4&includeCollections=1&contentDirectoryID=1&includeFields=thumbBlurHash (8 live) #264ccb TLS GZIP Signed-in Token (wfhuizen)

Oct 05, 2025 15:58:40.102 [23119951182648] ERROR - [Req#264ccb] SQLITE3:0x80000001, 267, statement aborts at 13: [select metadata_items.id from metadata_items  join fts4_metadata_titles_icu on metadata_items.id=fts4_metadata_titles_icu.rowid  join metadata_item_accounts on metadata_item_accounts.metadata_item_id=metadata_items.id  where fts4_metadata_titles_icu.title match 'Gh*'  and metadata_items.metadata_type=15 and metadata_item_accounts.account_id=1  order by  metadata_items.`index` desc, metadata_items.title_sort collate icu_root asc limit 5 offset 0] database disk image is malformed

Oct 05, 2025 15:58:40.103 [23119951182648] ERROR - Got exception from request handler: sqlite3_statement_backend::loadRS: database disk image is malformed

Oct 05, 2025 15:58:40.104 [23120215649080] DEBUG - Completed: [192.168.10.215:55769] 500 GET /hubs/search?query=Gh&excludeFields=summary&limit=4&includeCollections=1&contentDirectoryID=1&includeFields=thumbBlurHash (8 live) #264ccb TLS GZIP 8ms 405 bytes (pipelined: 4)

Oct 05, 2025 15:58:41.328 [23119979244344] DEBUG - Request: [192.168.10.215:55769 (WAN)] GET /hubs/search?query=Ghostface&excludeFields=summary&limit=4&includeCollections=1&contentDirectoryID=1&includeFields=thumbBlurHash (8 live) #264cd2 TLS GZIP Signed-in Token (wfhuizen)

Oct 05, 2025 15:58:41.330 [23119979244344] ERROR - [Req#264cd2] SQLITE3:0x80000001, 267, statement aborts at 13: [select metadata_items.id from metadata_items  join fts4_metadata_titles_icu on metadata_items.id=fts4_metadata_titles_icu.rowid  join metadata_item_accounts on metadata_item_accounts.metadata_item_id=metadata_items.id  where fts4_metadata_titles_icu.title match 'Ghostface*'  and metadata_items.metadata_type=15 and metadata_item_accounts.account_id=1  order by  metadata_items.`index` desc, metadata_items.title_sort collate icu_root asc limit 5 offset 0] database disk image is malformed

Oct 05, 2025 15:58:41.330 [23119979244344] ERROR - Got exception from request handler: sqlite3_statement_backend::loadRS: database disk image is malformed

Do you guys have any idea what I can do to fix this? Thanks in advance!

2

@ChuckPA user requesting DBRepair help (Docker)
Not sure if he has office hours on the weekend though :slight_smile:

3

With GitHub - ChuckPa/DBRepair: Database repair utility for Plex Media Server databases what options have you tried, and how old are the backups plex auto creates?

4

Thanks for your reply. I tried automatic, check, vacuum and prune. I have backups from July still.

5

Sounds like your database was corrupted in July, and DBRepair is unable to repair it. I would use DBRepair’s replace option to use a backup then.

6

That could be an option, but that means that I will lose playlists I created after July and all my rated music.

7

Are you still getting malformed messages in the log after using DBRepair on the current DB?

Let’s hope you can at least screenshot your playlists and recreate them after restoring the July DB. Maybe you could Advanced Filter a library by items with a rating and screenshot those too. It’s possible you could get AI to help you write python code that extracts your Playlists to a few PLS files using the Plex API.

9

Yes I do get malformed messages. When the container starts, these errors appear in my logs:

Oct 06, 2025 07:08:52.593 [23359268539192] ERROR - [DatabaseFixups/29DatabaseFixupsSyncCollections] SQLITE3:0x80000001, 267, statement aborts at 178: [update metadata_items set extra_data=? where metadata_type=? and library_section_id=? and id=?] database disk image is malformed
Oct 06, 2025 07:08:52.593 [23359268539192] ERROR - [DatabaseFixups/29DatabaseFixupsSyncCollections] Exception inside transaction (inside=1) (/home/runner/_work/plex-media-server/plex-media-server/Library/MetadataCollection.cpp:522): sqlite3_statement_backend::loadOne: database disk image is malformed
Oct 06, 2025 07:08:52.593 [23359268539192] ERROR - [DatabaseFixups/29DatabaseFixupsSyncCollections] Fixup threw an exception: sqlite3_statement_backend::loadOne: database disk image is malformed
Oct 06, 2025 07:08:52.593 [23359268539192] DEBUG - [DatabaseFixups/29DatabaseFixupsSyncCollections] Fixup completed
Oct 06, 2025 07:08:52.593 [23359268539192] DEBUG - [DatabaseFixups/31DatabaseFixupsCleanupActivities] Executing fixup
10

I would agree you’re in a place where you have to restore a sane backup database.
Take your time. Ask questions if you have 'em.

11

Thank you so much for your support Nibbles. I will start with your advice: building a Python script.

1 Like
12

This is a content error.

DBRepair can’t fix these. DBRepair only can fix structural (SQLite) errors.

13

Does that mean that I can fix the error by adjusting the data in the database?