Unable to set up server error after upgrade to latest on UNRAID/DOCKER

Plex Media Server NAS & Devices
1

Server Version#: 1.32.8.7639-fb6452ebf
Player Version#:

I’ve been running fine using the official plex docker image 1.30.0.6486-629d58034 on unraid server. I have tried several times to update the image to the latest. Every time I do it will try to start and fail with:
Error: Unable to set up server: sqlite3_statement_backend::prepare: no such table: metadata_agent_providers for SQL: update metadata_agent_providers set online = 0 (N4soci10soci_errorE)

I’ve tried repairing the database. Nothing I’ve done will work. The only way I can get it working is to replace the db files with a backup and run 1.30.0.6486-629d58034.

What am I doing wrong? Or is there a way to export my database, install a fresh version, and re-import? I just don’t want to be stuck on 1.30.0.6486 forever.

2

Update to a version in the middle first like 1.32.5

3

Thanks for the reply. I was able to move up to 1.32.0.6973-a787c5a8e, but as soon as I tried to update to 1.32.1.6999-91e1e2e2c I get the error. That is the next version listed on the docker page.

4

~I have the same issue, did you find any workaround ?~

I used GitHub - ChuckPa/PlexDBRepair: Database repair utility for Plex Media Server databases on the DB with my old version of plex running (and stopped during the repair)

Plex restarted with the old version and I upgraded after that. The issue seems to have been resovled.

Here the output of my script autorepair

Automatic Check,Repair,Index started.                                                                                                                                                                                                                                                       
                                                                                                                                                                                                                                                                                            
Checking the PMS databases                                                                                                                                                                                                                                                                  
Check complete.  PMS main database is damaged.                                                                                                                                                                                                                                              
Check complete.  PMS blobs database is OK.                                                                                                                                                                                                                                                  
                                                                                                                                                                                                                                                                                            
Exporting current databases using timestamp: 2024-03-12_15.40.27                                                                                                                                                                                                                            
Exporting Main DB                                                                                                                                                                                                                                                                           
Exporting Blobs DB                                                                                                                                                                                                                                                                          
Successfully exported the main and blobs databases.  Proceeding to import into new databases.                                                                                                                                                                                               
Importing Main DB.                                                                                                                                                                                                                                                                          
Importing Blobs DB.                                                                                                                                                                                                                                                                         
Successfully imported databases.                                                                                                                                                                                                                                                            
Verifying databases integrity after importing.                                                                                                                                                                                                                                              
Verification complete.  PMS main database is OK.                                                                                                                                                                                                                                            
Verification complete.  PMS blobs database is OK.                                                                                                                                                                                                                                           
Saving current databases with '-BACKUP-2024-03-12_15.40.27'                                                                                                                                                                                                                                 
Making repaired databases active                                                                                                                                                                                                                                                            
Repair complete. Please check your library settings and contents for completeness.                                                                                                                                                                                                          
Recommend:  Scan Files and Refresh all metadata for each library section.                                                                                                                                                                                                                   
                                                                                                                                                                                                                                                                                            
Backing up of databases                                                                                                                                                                                                                                                                     
Backup current databases with '-BACKUP-2024-03-12_15.44.40' timestamp.                                                                                                                                                                                                                      
Reindexing main database                                                                                                                                                                                                                                                                    
Reindexing main database successful.                                                                                                                                                                                                                                                        
Reindexing blobs database                                                                                                                                                                                                                                                                   
Reindexing blobs database successful.                                                                                                                                                                                                                                                       
Reindex complete.                                                                                                                                                                                                                                                                           
Automatic Check, Repair/optimize, & Index successful.

Took some time to complete as My libraries are somewhat big.

5

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