Corrupt library that refuses to repair

Plex Media Server
1

Hello All,
I am having trouble with my TV library and it seems to be similarly related to this forum post:

my issue is that when I try to load my TV library I get “There was an unexpected error loading this library Please visit our forums if you continue to experience problems”
and in my logs I find

Aug 15, 2020 01:36:53.783 [0x7f18affff700] ERROR - Unknown metadata type: folder
Aug 15, 2020 01:36:53.784 [0x7f18affff700] DEBUG - Setting container serialization range to [50, 129] (total=-1)
Aug 15, 2020 01:36:53.787 [0x7f18affff700] ERROR - Soci Exception handled: Cannot convert data to std::tm.
Aug 15, 2020 01:36:53.788 [0x7f19290a6700] DEBUG - Completed: [*.*.*.*:60078] 500 GET /library/sections/2/all?type=2&includeCollections=1&includeExternalMedia=1&includeAdvanced=1&includeMeta=1 (15 live) TLS GZIP Page 50-129 4ms 484 bytes (pipelined: 6)

I am taking a look at my sqlite DB and unfortunately I am not finding any bad dates in metadata_items, but I am a bit rusty on my sql. I have used a few queries all similar to SELECT id, library_section_id, parent_id, metadata_type, title, title_sort, original_title, originally_available_at FROM metadata_items WHERE library_section_id = 2 AND originally_available_at NOT NULL or NOT LIKE but I am having trouble finding anything, and with thousands of records its difficult to sort out.

Is there any direction someone can give me? I have already attempted the standard database repair but with no improvement.
Thank you in advance.

2

Do you have a backup of the DB you can restore?

3

have you tried to restore one of the backups? https://support.plex.tv/articles/202485658-restore-a-database-backed-up-via-scheduled-tasks/

4

Thanks, I am not sure why I didn’t think of this.
I will try this and let you know how it goes.

5

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