Server Version#: anything >1.23.2.4656
Player Version#: Newest
I have an issue on Fedora29. I am stuck at version 1.23.2.4656, any attempts to update beyond this point result in service start failure.
LOGS
Nov 26, 2021 17:08:44.238 [0x7fb05db1fb38] INFO - Plex Media Server v1.24.5.5173-8dcc73a59 - Fedora PC x86_64 - build: linux-x86_64 redhat - GMT -05:00
Nov 26, 2021 17:08:44.238 [0x7fb05db1fb38] INFO - Linux version: 29 (Server Edition), language: en-US
Nov 26, 2021 17:08:44.238 [0x7fb05db1fb38] INFO - Processor Intel(R) Core™ i7-7700 CPU @ 3.60GHz
Nov 26, 2021 17:08:44.238 [0x7fb05db1fb38] INFO - Compiler is - Clang 11.0.1 (https://plex.tv e0c29d5827bc4eaaa2ceb882cbeed224b0960173)
Nov 26, 2021 17:08:44.238 [0x7fb05db1fb38] INFO - /usr/lib/plexmediaserver/Plex Media Server
Nov 26, 2021 17:08:44.267 [0x7fb06115c6e8] ERROR - SQLITE3:0x80000001, 11, database corruption at line 81887 of [1b256d97b5]
Nov 26, 2021 17:08:44.267 [0x7fb06115c6e8] ERROR - SQLITE3:0x80000001, 11, statement aborts at 11: [SELECT media_item_id, media_streams.extra_data FROM media_streams join media_items on media_items.id=media_streams.media_item_id where media_streams.extra_data like ‘%colorTrc%’ and me
Nov 26, 2021 17:08:44.267 [0x7fb06115c6e8] ERROR - Exception inside transaction (inside=1) (…/Library/DatabaseMigrations.cpp:237): sqlite3_statement_backend::loadRS: database disk image is malformed
Nov 26, 2021 17:08:44.268 [0x7fb06115c6e8] ERROR - Exception thrown during migrations, aborting: sqlite3_statement_backend::loadRS: database disk image is malformed
Nov 26, 2021 17:08:44.291 [0x7fb06115c6e8] ERROR - SQLITE3:0x80000001, 1, no such table: activities in “update activities set finished_at=started_at where finished_at is null”
Nov 26, 2021 17:08:44.291 [0x7fb06115c6e8] ERROR - Database corruption: sqlite3_statement_backend::prepare: no such table: activities for SQL: update activities set finished_at=started_at where finished_at is null
What needs to be done for me to update plexmediaserver???
Do I need to update my OS to newer version? According to the docs, it supports Fedora27+ so I should be good. And I’m not going to take down my system for a day or more to update the OS if it won’t fix the issue.
Do I need to update sqlite? if so which version?
Obviously something has changed since I can simply downgrade back to 1.23.2.4656 and it starts without any issues, every single time.
I’ve tried with the following versions. All fail in the same way…
1.23.5.4801
1.24.1.4931
1.24.5.5173