Error 1 from Plex SQLite while importing

Plex Media Server
1

Server Version#: latest public on latest ubuntu. Everything updated and patched.

This is a new error I have not seen before while running @ChuckPa database tool. I usually run the tool, option 2, automatic repair/reindex, about once a month just to keep things running smoothly. The tool failed while running option 2. So, I did run option 3, resulting in a notification that the main db was damaged, and then ran option 5. I’m not opposed to manually loading up an export of the SQL and hunting this line down, but is that the right approach? Or is there a better way to resolve the error? There are no messages during the export, this only shows up during the import.

Plex is running, and streaming, transcoding, direct play, etc. just fine for the content that has been used in the past few weeks. So perhaps this is a single error specific to one item (hopefully).

Importing Main DB.
Runtime error near line 7087680: UNIQUE constraint failed: metadata_items.id (19)
Error 1 from Plex SQLite while importing from

2

@bpogue99

Your DB is damaged to the point where the indexes are duplicated.

Not a big deal.

  1. IGNORE constraint errors
  2. AUTO again

After you restart PMS, Rescan all the library sections

3

Worked like a charm!! Thanks for the assist again!! :star_struck:

4

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