Server Version#: 1.32.8.7639
Trying to upgrade to 1.40.0.7998. I’ve tried the previous 1.40 as well, same issue.
I think the most relevant part of the log is:
ERROR - Exception inside transaction (inside=1) (/home/runner/actions-runner/_work/plex-media-server/plex-media-server/Library/DatabaseMigrations.cpp:292): Null value not allowed for this type
Feb 18, 2024 16:40:37.804 [139979171199632] ERROR - Exception thrown during migrations, aborting: Null value not allowed for this type
This error seems benign, though I could easily be wrong:
ERROR - SQLITE3:0x80000001, 1, duplicate column name: slug in "ALTER TABLE 'metadata_items' ADD 'slug' varchar(255)"
And then there is this error which seems to be real:
ERROR - [DatabaseFixups] SQLITE3:0x80000001, 1, no such column: metadata_items.slug in "select media_items.id as 'media_items_id', media_items.library_section_id as 'media_items_library_section_id', media_items.section_location_id as ....
More errors continue after the above.
I’ve compared the DB schema with a fresh 1.32.8.7639 and they are the same. It seems like it has something to do with the contents of the database and the error doesn’t have enough information for me to narrow it down.
I have attached a GREP -A2 -B2 -i error
upg-error.txt (486.5 KB)
of the log after starting/installing 1.40
I’ve also already gone through https://support.plex.tv/articles/repair-a-corrupted-database/ and made sure to dump/restore the DB to rule that out.
Sorry for a new thread but I can’t tell if this is the same as existing threads because all they do is upload logs and say “ITS NOT WORKING” without actual errors in the posting.
