Unable to check databases for errors (collation sequence error)

Plex Media Server
,
1

Server Version#: 1.22.3.4392
Player Version#: N/A

I have a script which regularly checks my Plex databases for errors and then back them up, as per the commands found at the Plex Support Article “Repair a Corrupt Database”.

This has worked fine for a few years now, but all of a sudden I’m getting an error:

sqlite3 com.plexapp.plugins.library.db “PRAGMA integrity_check”
Error: no such collation sequence: icu_root

Any ideas?

Thanks,
Jonathan

2

I’m having the same problem, the plex migrations is claiming that my db file is corrupt, and search has stopped working, but I can’t follow the guide because of this error.

If I dump and try to restore the database, I get:

Error: near line 358606: no such collation sequence: icu_root

But everything seems okay after the dump/restore so far. It could successfully run the migrations that was missing when plex started. YMMV.

3

I’m having the same issue. The logs showed corruption so I followed the steps to repair the corruption. I tried to restore from the dump but get the error:

Error: near line 393100: no such collation sequence: icu_root

4

You’ll need to use the internal sqlite.

5

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