Plex database tables missing - search broken

Plex Media Server Desktops & Laptops
1

Hi,

My search stopped working a couple of days ago
Going into the console gives me the error below

Server Version#: Version 1.22.1.4228
Player Version#: Chrome Web 4.53.0

Level Error

Thread 4544
Message
SQLITE3:0xa715ffe5, 1, no such table: fts4_metadata_titles_icu in "select distinct metadata_items.id from metadata_items join fts4_metadata_titles_icu on metadata_items.id=fts4_metadata_titles_icu.rowid join metadata_item_accounts

Thread 11120
Message
Soci Exception handled: sqlite3_statement_backend::prepare: no such table: fts4_metadata_titles_icu for SQL: select distinct metadata_items.id from metadata_items join fts4_metadata_titles_icu on metadata_items.id=fts4_metadata_titles_icu.rowid join metadata_item_accounts on metadata_item_accounts.metadata_item_id=metadata_items.id where fts4_metadata_titles_icu.title match ‘Star*’ and metadata_items.metadata_type=15 and metadata_item_accounts.account_id=1 order by metadata_items.index desc, metadata_items.title_sort collate icu_root asc limit 3

Any help would be appreciated

2

The version number you cited above is for the web app, not the server.

Did you interrupt the startup of Plex server after installing version 1.22.1 perhaps?
Which server version is installed now?

4

Sorry,
Server version: 1.22.1.4.4228-724c56e62
I did not purposefully interrupt it. don’t know if that is what happened.

5

If you can, downgrade the server to version 1.22.0
start the server at let it run for a few minutes
reboot the machine
then upgrade to 1.22.1 again.

Make sure to uninstall (or at least disable) any software of the likes of “Registry Optimizer”, “Uninstaller”, “privacy cleaner” etc. or you might lose your plex data during the process.

Verify that there is plenty of free space on the storage volume where plex is storing its metadata (default: C:)

6

I have 100gb free space
I will try downgrade and then upgrade again.
Thanks for the quick response.

7

The first startup after updating to 1.22.1 can take quite a long time. Be prepared and don’t interrupt it.

8

I have downgraded to 1.22.0.
and search is working again!
Scared to upgrade 1.22.1 :slight_smile:
Thanks for your help

9

Auto upgraded to the latest version

Version 1.22.2.4282

broke the search again.
same error
Soci Exception handled: sqlite3_statement_backend::prepare: no such table: fts4_metadata_titles_icu for SQL: select distinct metadata_items.id from metadata_items join fts4_metadata_titles_icu on metadata_items.id=fts4_metadata_titles_icu.rowid join metadata_item_accounts on metadata_item_accounts.metadata_item_id=metadata_items.id where fts4_metadata_titles_icu.title match ‘Taskmaster*’ and metadata_items.metadata_type=15 and metadata_item_accounts.account_id=1 order by metadata_items.index desc, metadata_items.title_sort collate icu_root asc limit 30

10

Try downgrading again to 1.22.0
Then perform the repair procedure: Repair a Corrupt Database | Plex Support

11

If that doesn’t work, please share some log files. Thanks!

12

No luck.
I can uninstall, reinstall the old version. search works.
As soon as I upgrade, repair, or uninstall and install new version, search does not work.
I tried to repair database (as specified in the above link), this just corrupts the database and I have to manually restore
I’ve attached the logs.Plex Media Server Logs_2021-04-09_12-16-09.zip (401.7 KB)

13

Im having this exact same problem. You are not alone @charldk :smiley:

14

Apologies if I am on a different platform, but I am having the same issue - plexmediaserver-plexpass-1.22.2.4282 on TrueNAS-12.0-U3.

The database did not give me any errors, but I tried repairing it anyway but no success.

I am not sure how to downgrade the version of the package on freebsd.

15

Does anyone else have logs? I’d like to see if it is the same underlying issue.

16

Plex Media Server Logs_2021-04-22_21-59-14.zip (4.2 MB)

had some permission troubles generating the logs tmp folder that I have resolved so ignore the logs parts regarding that.

17

Same issue here with anything above 1.22.0. Keep getting the icu_root error in the logs. after about 8 hours the app crashes and sends bug reports out to plex.

18

Having the same issue here as well.

19

I have updated to 1.22.3.4392 and the issue has disappeared

20

i’m having the same issue, I am on Ubuntu Docker, Version 1.22.3.4392-d7c624def, and search is not working:

Apr 26, 2021 09:04:31.292 [0x7f811affd700] Debug — Request: [192.168.1.234:58004 (Subnet)] GET /hubs/search?includeCollections=1&includeExternalMedia=1&sectionId=&query=mortal (11 live) TLS GZIP Signed-in Token (revenghost)
Apr 26, 2021 09:04:31.295 [0x7f811affd700] Error — SQLITE3:(nil), 1, no such table: fts4_metadata_titles_icu in "select distinct metadata_items.id from metadata_items join fts4_metadata_titles_icu on metadata_items.id=fts4_metadata_titles_icu.rowid join metadata_item_accounts
Apr 26, 2021 09:04:31.296 [0x7f811affd700] Error — Soci Exception handled: sqlite3_statement_backend::prepare: no such table: fts4_metadata_titles_icu for SQL: select distinct metadata_items.id from metadata_items join fts4_metadata_titles_icu on metadata_items.id=fts4_metadata_titles_icu.rowid join metadata_item_accounts on metadata_item_accounts.metadata_item_id=metadata_items.id where fts4_metadata_titles_icu.title match ‘Mortal*’ and metadata_items.metadata_type=15 and metadata_item_accounts.account_id=1 order by metadata_items.index desc, metadata_items.title_sort collate icu_root asc limit 3
Apr 26, 2021 09:04:31.297 [0x7f8168af3700] Debug — Completed: [192.168.1.234:58004] 500 GET /hubs/search?includeCollections=1&includeExternalMedia=1&sectionId=&query=mortal (11 live) TLS GZIP 4ms 530 bytes (pipelined: 4)

21

Just for anybody else with the issue, I changed docker

FROM: image: plexinc/pms-docker:public

TO: image: plexinc/pms-docker:1.21.4.4079-1b7748a7b

Basically getting away from version 1.22, now my search is working again

UPDATE: just like lctr01, changing to 1.22.3.4392 fixed it
docker line:
image: plexinc/pms-docker:1.22.3.4392-d7c624def