Sqlite3 error after update to 1.43.4.10903

Plex Media Server
1

Server Version#: 1.43.4.10903

After after upgrading the docker container to 1.43.4.10903 the server will no longer start and show the following error on the console:
Error: Unable to set up server: sqlite3_statement_backend::prepare: no such table: spellfix_metadata_titles for SQL: delete from spellfix_metadata_titles (N4soci10soci_errorE)

Had the same issue 2 weeks ago on the plexpass beta image but chucked it up to being beta. As the normal pms-docker:latest image now also upgraded it happened again.
Moving back to plexinc/pms-docker:1.43.3.10896-cb3ebc72d plex still starts and works fine.
Following https://support.plex.tv/articles/repair-a-corrupted-database/ didn’t resolve the issue. ChuckPa’s DBRepair script could also not resolve it (although as i understand FTS repair is currently disabled)

2

That error points to an existing issue in your database, and the migration in 1.43.4 is only exposing it. That table should exist, if it doesn’t then you can try and create it using the Plex SQLite command line tool (using the steps from https://support.plex.tv/articles/repair-a-corrupted-database/)

Always ensure that the server is not running when making changes to the database and have a backup of it before continuing.

Once in the sqlite command line, use the following command:

CREATE VIRTUAL TABLE spellfix_metadata_titles USING spellfix1;

then

.quit

Then try to start PMS again. If you still have issues let me know and provide a server logs.

3

Same issue with 1.43.4 for me. I tried the SQLite fixes and the command you recommended, but still getting:

Error: Unable to set up server: sqlite3_statement_backend::prepare: table fts4_metadata_titles_icu already exists for SQL: CREATE VIRTUAL TABLE fts4_metadata_titles_icu USING fts4(title, title_sort, original_title, tokenize=collating ‘root@colStrength=primary;colAlternate=shifted’) (N4soci10soci_errorE)
Stopping Plex Media Server.
kill: usage: kill [-s sigspec | -n signum | -sigspec] pid | jobspec … or kill -l [sigspec]
Starting Plex Media Server.

Reverting back to 1.43.3 continues to work.