Updated plex to 1.40.2.8395, plex will no longer start, database errors

Plex Media Server
1

Server Version#: 1.40.2.8395
Player Version#: N/A
Plex Media Server.log (551.6 KB)

Attached are the logs. I ran an update this morning, I noticed that the service is running, I can connect to the web service, but the plex service itself is unavailable.

Some history, I recently migrated this from a docker container running in unraid to a lxc container in proxmox. It has been running for around 10 days before running an OS update this morning.
I have run through all the steps in https://support.plex.tv/articles/repair-a-corrupted-database/

I noticed in the logs I am getting this error:
ERROR - SQLITE3:0x80000001, 1299, abort at 37 in [update play_queue_generators set created_at = iif(typeof(created_at) in (‘integer’, ‘real’), created_at, strftime(‘%s’, created_at, ‘utc’)),updated_at = iif(typeof(updated_at) in (‘integer’, ‘real’), updated_at, strftime(‘%s’, updated_at, ‘utc’))]: NOT NULL constraint failed: play_queue_generators.created_at
ERROR - Exception inside transaction (inside=1) (/home/runner/actions-runner/_work/plex-media-server/plex-media-server/Library/DatabaseMigrations.cpp:293): sqlite3_statement_backend::loadOne: NOT NULL constraint failed: play_queue_generators.created_at

I am kind of at a loss about this. Any tips or tricks I should try?

2

PMS 1.40.x will expose more DB errors than previous versions.

The quick solution to this:

  1. Use my DB tool to
    – Launch tool as root
    – Stop PMS
    – set “IGNORE” mode on
    – Automatic DB repair/optimize
    – set back to “Honor” mode
    – Start PMS
    – Stay in the tool.

  2. Now check your system / logs

  3. Repair is not guaranteed in these cases as there is duplication.
    Something could get dropped. Hopefully it’s the shorter playlist if it is.

Recommend reviewing the README (documentation) first.

3

You are the man! I spent a good chunk of today working on this.

Before you responded I also rolled back to 1.40.1.8227. I am going to stick with this version for now.

4

Are the errors gone ?

5

Last night I seen a new updated posted on my Server but it was in use. This morning nobody is using the server now I don’t see the update was it taken down?

6

Download it from (plex.tv) sign in and install manually after quitting the Server app

https://www.plex.tv/

7

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.