New Files Not Being Added to Plex Library on iMac – Database Integrity Issues

[x1ao4]

Hello everyone,

I’m running Plex Media Server version 1.41.9.9961 on an iMac, and today I discovered that my music library is no longer recognizing new files. Any newly added music files are not being detected or added to the library during a scan.

I ran a database integrity check on com.plexapp.plugins.library.db using PRAGMA integrity_check; and encountered some errors. I then tried to repair the database, but during the repair process, I ran into the following errors:

Runtime error near line 4129468: UNIQUE constraint failed: fts4_metadata_titles_icu_segdir.level, fts4_metadata_titles_icu_segdir.idx (19)
Runtime error near line 4129469: UNIQUE constraint failed: fts4_metadata_titles_icu_segdir.level, fts4_metadata_titles_icu_segdir.idx (19)
Runtime error near line 4129470: UNIQUE constraint failed: fts4_metadata_titles_icu_segdir.level, fts4_metadata_titles_icu_segdir.idx (19)

Despite these errors, the repair seemed to complete successfully. After the repair, both com.plexapp.plugins.library.db and com.plexapp.plugins.library.blobs.db now return ok for PRAGMA integrity_check;.

However, new files are still not being added. Existing files that have already been added to the library can be accessed and played normally, but none of the new files are being recognized. It seems like all libraries are unable to detect new files.

For directories that already exist in the library, the Alerts page sometimes shows that new items were created, but these new items never appear in the library. Newly added directories are not recognized during scanning—Plex seems to think that certain directories or files do not exist.

I tried restoring a previous backup, but it also seems to have issues—using the backup directly prevents Plex from starting. Right now, my Plex library cannot add new files at all, and I’m concerned about losing my existing metadata.

Has anyone encountered this issue? How can I fix this without losing my current library metadata?

Note: I want to emphasize that this is not a file naming or folder structure issue. All my files and directories strictly follow Plex’s official guidelines. Please rule out this as a cause—I am certain that the problem is caused by the database.

Another issue is that I am currently unable to search my own media library in Plex. The search results only show content from other libraries I have access to or content provided by Plex, but none of my own media appears. This might be related to the previously reported database index errors.

[x1ao4]

The issue might be related to IntroEditorForPlex, because I previously ran IntroEditorForPlex once. At that time, I didn’t make any changes—just ran the container—but afterwards, the database seemed to have problems: new movies could not be added. I also tried to repair the database then, but it didn’t resolve the issue, so I restored the database from a backup, which fixed the problem.

A few days ago, I ran IntroEditorForPlex again without making any modifications. At the time, I didn’t notice any issues, but now the problem has recurred.

[x1ao4]

I upgraded the server to version 1.42.1.10060. Now, one of my TV libraries can detect new files during a scan, but two other TV libraries and a music library still cannot scan newly added files or detect file changes. For example, if I delete files from an existing directory, a scan does not recognize that the files were removed. When new files are added to a directory that is already in the library, the Alerts section shows that an item was created, but the new item does not appear in the library itself. In addition, I still cannot search the contents of my own media libraries.

[x1ao4]

Alright, I’ve restored the server using a previous backup, and now everything is back to normal with no issues. It would be even better if the backup frequency and retention count could be customized, as three days feels a bit too long.