Plex doesn't recognizes my new medias anymore

Plex Media Server
21

@tholelosan

Thank you for the updated logs.

I did find the problem. Your database is damaged.

Feb 27, 2022 20:23:18.074 [0x7f71387e8b38] DEBUG - Doing expensive tags write for 'Kita Alexander' because something changed.
Feb 27, 2022 20:23:18.075 [0x7f71387e8b38] ERROR - SQLITE3:0x80000001, 11, database corruption at line 81887 of [1b256d97b5]
Feb 27, 2022 20:23:18.075 [0x7f71387e8b38] ERROR - SQLITE3:0x80000001, 11, statement aborts at 11: [SELECT idx, start_block, leaves_end_block, end_block, root FROM 'main'.'fts4_metadata_titles_icu_segdir' WHERE level = ? ORDER BY idx ASC] database disk image is malformed
Feb 27, 2022 20:23:18.075 [0x7f71387e8b38] ERROR - SQLITE3:0x80000001, 11, statement aborts at 60: [insert into tags (parent_id,metadata_item_id,tag,key,tag_type,tag_value,user_thumb_url,user_art_url,user_music_url,created_at,updated_at,extra_data) values (:tags_parent_id,:tags_metad

Please look in PlexMediaServer/AppData/Plex Media Server/Plug-in Support/Databases

See how many com.plexapp.plugins.library.db backups you have.

The key here will be going back as far as possible and swapping the backup to take the place of the main.

22

I found this files in the folder.
Which of these backups should I use? And which is the main one?

Capture d’écran 2022-03-01 à 22.54.59
Capture d’écran 2022-03-01 à 22.54.59974×513 81.7 KB

23

That’s strange, I have the exact same problem that @tholelosan

My database has also been damaged recently.

24

@ChuckPa please, can i have some help to find which of these backups I need to use? And which one is the main? How can I swap them?

25

@tholelosan

There is no “best method” for trial-and-error selection.

I prefer to go as far back in time as I can and then update that older one (which is painless)

The general procedure:

  1. Stop Plex
  2. remove the com.plexapp.plugins.library.db-wal and com.plexapp.plugins.library.db-shm if they still exist.
  3. rename com.plexapp.plugins.library.db. Add a -original to the end of the name
  4. copy the older backup and make its name com.plexapp.plugins.library.db
    – Copy the file to a different folder somewhere (some machines require this technique)
    – Rename it in that other folder
    – Move the renamed file back
  5. Start PMS
  6. Scan files & Refresh all metadata for each section
26

Perfect it works, thanks

27

Having now confirmed it all works, remove the -original (damaged) DB file. :slight_smile: