Server Version#: 1.22.2.4282
Player Version#: N/A
When trying to check the database integrity I am receiving a collation sequence error.
sqlite3 com.plexapp.plugins.library.db “PRAGMA integrity_check”
Error: no such collation sequence: icu_root
Is this a known issue or something that I can mitigate?
tom80H
April 14, 2021, 9:14pm
2
You might want to take a look at this thread and use the SQLite3 version shipped with Plex. Also make sure your server isn’t running when you do the integrity check on your database.
If I may help here?
To invoke the resident SQLite3 module.
"/usr/lib/plexmediaserver/Plex Media Server" --sqlite
If you wish to go further in to Plex Media Server/Plug-in Support/Databases to save typing of the path, that’s fine.
[/share/CACHEDEV3_DATA/.qpkg/PlexMediaServer] # ./Plex\ Media\ Server --sqlite
SQLite version 3.26.0 2018-12-01 12:34:55
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite>
Y…
system
Closed
July 13, 2021, 9:14pm
3
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.