Swapping out databases for testing the error no such column: library_sections.content_changed_at

[bpogue99]

Server Version#: 1.20+
Player Version#: any

Hello Plex! A few months back I posted about a problem in my database. I am using Ubuntu 20.04 with the latest PMS and my system runs well. That said, I have been unable to run Plex Media Scanner from the command line for several years due to a missing column, library_sections.content_changed_at. There are several posts about it as several users have experienced this error. I have not found a solution that works. From my understanding, this error is due to database upgrades that are missing. Since this server started in 2012 I suppose it is possible that I simply missed some of the updates by skipping releases of the server software. Other than not being able to run the media scanner from the command line, I have not noticed any other issues over the years. My users are happily enjoying access to my content.

With this in mind I want to test my setup by using a clean database. Something like this:

service plexmediaserver stop
cd /var/lib/plexmediaserver/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/
mv Databases Databases.org
mkdir Databases
chown plex:plex Databases
reinstall plex to get an empty database
add my largest library and let is finish a full scan

I would do these steps in reverse to get back to the original server.

What I want to avoid is ruining the existing setup. Thoughts or concerns or just random advice are all welcome. Is there any tool or script that the devs use that might fix the database? I dont mind sharing a sql dump with a few of the devs if there’s something they can do to scan or fix the database.

Here’s the error I’m trying to fix along with the previous articles

$ ./Plex\ Media\ Scanner --list
terminate called after throwing an instance of 'soci::soci_error'
  what():  sqlite3_statement_backend::prepare: no such column: library_sections.content_changed_at for SQL: select library_sections.id as 'library_sections_id', library_sections.library_id
as 'library_sections_library_id', library_sections.name as 'library_sections_name', library_sections.name_sort as 'library_sections_name_sort', library_sections.section_type as 'library_sections_section_type', library_sections.language as 'library_sections_language', library_sections.agent as 'library_sections_agent', library_sections.scanner as 'library_sections_scanner', library_sections.user_thumb_url as 'library_sections_user_thumb_url', library_sections.user_art_url as 'library_sections_user_art_url', library_sections.user_theme_music_url as 'library_sections_user_theme_music_url', library_sections.created_at as 'library_sections_created_at', library_sections.updated_at as 'library_sections_updated_at', library_sections.scanned_at as 'library_sections_scanned_at', library_sections.user_fields as 'library_sections_user_fields', library_sections.query_xml as 'library_sections_query_xml', library_sections.query_type as 'library_sections_query_type', library_sections.uuid as 'library_sections_uuid', library_sections.changed_at as 'library_sections_changed_at', library_sections.content_changed_at as 'library_sections_content_changed_at' from library_sections
****** PLEX MEDIA SCANNER CRASHED, CRASH REPORT WRITTEN: [7d2fcd99-56f2-d56b-40a670bc-69ba376d.zip|attachment]
Error in command line:the argument for option '--serverUuid' should follow immediately after the equal sign
Crash Uploader options (all are required):
  --directory arg       Directory to scan for crash reports
  --serverUuid arg      UUID of the server that crashed
  --userId arg          User that owns this product
  --platform arg        Platform string
  --platformVersion arg Platform version string
  --vendor arg          Vendor string
  --device arg          Device string
  --model arg           Device model string
  --sentryUrl arg       Sentry URL to upload to
  --sentryKey arg       Sentry Key for the project
  --version arg         Version of the product
  --allowRetries arg    Whether we will allow retries
Aborted (core dumped)

Plex Media Scanner - no such column: library_sections.content_changed_at

I built a brand new Ubuntu 20.04.4 LTS and installed PMS 1.19.4.2935… I then added 2 small libraries, each with 10 items, one called Movies, one called Shows. I then let them refresh the metadata until both libraries were done scanning. Running Plex Media Scanner from the command line generates nearly the same message, shown below, I’m already experiencing. I took the new database and dumped it to SQL… Inspecting the line that would create the missing column shows a mix of double-quotes and sin…

Plex 1.18 corrupted DB (Fix in thread)

Version 1.18.0.1944 Using Arch Linux, installed via AUR Up to date according to Public channel I’m running into this problem as well, but none of the suggestions seem to be working here. The error (shown at all steps): what(): sqlite3_statement_backend::prepare: no such column: library_sections.content_changed_at for SQL: select library_sections.id as 'library_sections_id', library_sections.library_id as 'library_sections_library_id', library_sections.name as 'library_sections_name', lib…

[bpogue99]

I created an Ubuntu 20.04 using the legacy iso. I patched it and updated it. I created links to my media shares. I then installed the latest PMS. During the setup I added a photo library of just pictures. The scan kicked off and added all of the images to the library. It is up, accessible, and appears to be working. So I dropped in to a shell and ran the media scanner. I still get the same error I’ve had before.

I don’t understand. This is a brand new install with a brand new database. I did not copy anything from the main server. At the top of the logs there is an initial copy of the database. Then there is a series of migrations. The logs show the migrations being run twice, notice the time stamps. Am I doing something that would cause this?

Sep 16, 2020 19:36:30.590 [0x7fd846cef180] DEBUG - Opening 20 database sessions to library (com.plexapp.plugins.library), SQLite 3.26.0, threadsafe=1
Sep 16, 2020 19:36:30.590 [0x7fd846cef180] DEBUG - Installing Library Database from ["/usr/lib/plexmediaserver/Resources/com.plexapp.plugins.library.db"] to ["/var/lib/plexmediaserver/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db"]
Sep 16, 2020 19:36:30.720 [0x7fd846cef180] DEBUG - Running migrations. (EPG 0)
Sep 16, 2020 19:36:30.720 [0x7fd846cef180] DEBUG - Running forward migration 20190130000000.

Sep 16, 2020 19:36:30.720 [0x7fd846cef180] DEBUG - Running migrations. (EPG 0)
Sep 16, 2020 19:36:30.720 [0x7fd846cef180] DEBUG - Running forward migration 20190130000000.
Sep 16, 2020 19:36:30.854 [0x7fd846cef180] DEBUG - Completed forward migration 20190130000000.
Sep 16, 2020 19:36:30.854 [0x7fd846cef180] DEBUG - Running forward migration 20190201190600.
Sep 16, 2020 19:36:30.859 [0x7fd846cef180] DEBUG - Completed forward migration 20190201190600.
Sep 16, 2020 19:36:30.859 [0x7fd846cef180] DEBUG - Running forward migration 20190205190600.
Sep 16, 2020 19:36:30.973 [0x7fd846cef180] DEBUG - Completed forward migration 20190205190600.
Sep 16, 2020 19:36:30.973 [0x7fd846cef180] DEBUG - Running forward migration 20190215190600.
Sep 16, 2020 19:36:31.095 [0x7fd846cef180] DEBUG - Completed forward migration 20190215190600.
Sep 16, 2020 19:36:31.095 [0x7fd846cef180] DEBUG - Running forward migration 20190218032400.
Sep 16, 2020 19:36:31.100 [0x7fd846cef180] DEBUG - Completed forward migration 20190218032400.
Sep 16, 2020 19:36:31.100 [0x7fd846cef180] DEBUG - Running forward migration 20190316132700.
Sep 16, 2020 19:36:31.280 [0x7fd846cef180] DEBUG - Completed forward migration 20190316132700.
Sep 16, 2020 19:36:31.280 [0x7fd846cef180] DEBUG - Running forward migration 20190403100000.
Sep 16, 2020 19:36:31.286 [0x7fd846cef180] DEBUG - Completed forward migration 20190403100000.
Sep 16, 2020 19:36:31.286 [0x7fd846cef180] DEBUG - Running forward migration 20190501100000.
Sep 16, 2020 19:36:31.404 [0x7fd846cef180] DEBUG - Completed forward migration 20190501100000.
Sep 16, 2020 19:36:31.405 [0x7fd846cef180] DEBUG - Running forward migration 20190528190600.
Sep 16, 2020 19:36:31.413 [0x7fd846cef180] DEBUG - Completed forward migration 20190528190600.
Sep 16, 2020 19:36:31.413 [0x7fd846cef180] DEBUG - Running forward migration 20190520131301.
Sep 16, 2020 19:36:31.422 [0x7fd846cef180] DEBUG - Completed forward migration 20190520131301.
Sep 16, 2020 19:36:31.422 [0x7fd846cef180] DEBUG - Running forward migration 20190520131302.
Sep 16, 2020 19:36:31.430 [0x7fd846cef180] DEBUG - Completed forward migration 20190520131302.
Sep 16, 2020 19:36:31.430 [0x7fd846cef180] DEBUG - Running forward migration 20190520131303.
Sep 16, 2020 19:36:31.438 [0x7fd846cef180] DEBUG - Completed forward migration 20190520131303.
Sep 16, 2020 19:36:31.438 [0x7fd846cef180] DEBUG - Running forward migration 20190603140000.
Sep 16, 2020 19:36:31.447 [0x7fd846cef180] DEBUG - Completed forward migration 20190603140000.
Sep 16, 2020 19:36:31.447 [0x7fd846cef180] DEBUG - Running forward migration 20190612032400.
Sep 16, 2020 19:36:31.579 [0x7fd846cef180] DEBUG - Completed forward migration 20190612032400.
Sep 16, 2020 19:36:31.579 [0x7fd846cef180] DEBUG - Running forward migration 20190614032400.
Sep 16, 2020 19:36:31.709 [0x7fd846cef180] DEBUG - Completed forward migration 20190614032400.
Sep 16, 2020 19:36:31.710 [0x7fd846cef180] DEBUG - Running forward migration 20190708132500.
Sep 16, 2020 19:36:31.840 [0x7fd846cef180] DEBUG - Completed forward migration 20190708132500.
Sep 16, 2020 19:36:31.841 [0x7fd846cef180] DEBUG - Running forward migration 20190430032400.
Sep 16, 2020 19:36:31.850 [0x7fd846cef180] DEBUG - Completed forward migration 20190430032400.
Sep 16, 2020 19:36:31.850 [0x7fd846cef180] DEBUG - Running forward migration 20190111032400.
Sep 16, 2020 19:36:31.858 [0x7fd846cef180] DEBUG - Completed forward migration 20190111032400.
Sep 16, 2020 19:36:31.859 [0x7fd846cef180] DEBUG - Running forward migration 20190815130000.
Sep 16, 2020 19:36:31.984 [0x7fd846cef180] DEBUG - Completed forward migration 20190815130000.
Sep 16, 2020 19:36:31.984 [0x7fd846cef180] DEBUG - Running forward migration 20190912140000.
Sep 16, 2020 19:36:31.993 [0x7fd846cef180] DEBUG - Completed forward migration 20190912140000.
Sep 16, 2020 19:36:31.993 [0x7fd846cef180] DEBUG - Running forward migration 20180330131300.
Sep 16, 2020 19:36:32.127 [0x7fd846cef180] DEBUG - Completed forward migration 20180330131300.
Sep 16, 2020 19:36:32.127 [0x7fd846cef180] DEBUG - Running forward migration 20190801130200.
Sep 16, 2020 19:36:32.136 [0x7fd846cef180] DEBUG - Completed forward migration 20190801130200.
Sep 16, 2020 19:36:32.136 [0x7fd846cef180] DEBUG - Running forward migration 20190604032400.
Sep 16, 2020 19:36:32.326 [0x7fd846cef180] DEBUG - Completed forward migration 20190604032400.
Sep 16, 2020 19:36:32.326 [0x7fd846cef180] DEBUG - Running forward migration 20190919032400.
Sep 16, 2020 19:36:32.335 [0x7fd846cef180] DEBUG - Completed forward migration 20190919032400.
Sep 16, 2020 19:36:32.336 [0x7fd846cef180] DEBUG - Running forward migration 20190920032400.
Sep 16, 2020 19:36:32.476 [0x7fd846cef180] DEBUG - Completed forward migration 20190920032400.
Sep 16, 2020 19:36:32.476 [0x7fd846cef180] DEBUG - Running forward migration 20190616032400.
Sep 16, 2020 19:36:32.990 [0x7fd846cef180] DEBUG - Completed forward migration 20190616032400.
Sep 16, 2020 19:36:32.991 [0x7fd846cef180] DEBUG - Running forward migration 20191003131300.
Sep 16, 2020 19:36:33.031 [0x7fd846cef180] DEBUG - Completed forward migration 20191003131300.
Sep 16, 2020 19:36:33.031 [0x7fd846cef180] DEBUG - Running forward migration 20191213143300.
Sep 16, 2020 19:36:33.268 [0x7fd846cef180] DEBUG - Completed forward migration 20191213143300.
Sep 16, 2020 19:36:33.268 [0x7fd846cef180] DEBUG - Running forward migration 20200110143300.
Sep 16, 2020 19:36:33.493 [0x7fd846cef180] DEBUG - Completed forward migration 20200110143300.
Sep 16, 2020 19:36:33.493 [0x7fd846cef180] DEBUG - Running forward migration 20200114193300.
Sep 16, 2020 19:36:33.819 [0x7fd846cef180] DEBUG - Completed forward migration 20200114193300.
Sep 16, 2020 19:36:33.819 [0x7fd846cef180] DEBUG - Running forward migration 20200124193500.
Sep 16, 2020 19:36:34.085 [0x7fd846cef180] DEBUG - Completed forward migration 20200124193500.
Sep 16, 2020 19:36:34.085 [0x7fd846cef180] DEBUG - Running forward migration 20200131193503.
Sep 16, 2020 19:36:34.095 [0x7fd846cef180] DEBUG - Completed forward migration 20200131193503.
Sep 16, 2020 19:36:34.096 [0x7fd846cef180] DEBUG - Running forward migration 20191125131300.
Sep 16, 2020 19:36:34.104 [0x7fd846cef180] DEBUG - Completed forward migration 20191125131300.
Sep 16, 2020 19:36:34.104 [0x7fd846cef180] DEBUG - Running forward migration 20200224131300.
Sep 16, 2020 19:36:34.114 [0x7fd846cef180] DEBUG - Completed forward migration 20200224131300.
Sep 16, 2020 19:36:34.114 [0x7fd846cef180] DEBUG - Running forward migration 20200327131300.
Sep 16, 2020 19:36:34.276 [0x7fd846cef180] DEBUG - Completed forward migration 20200327131300.
Sep 16, 2020 19:36:34.276 [0x7fd846cef180] DEBUG - Running forward migration 20200401131300.
Sep 16, 2020 19:36:34.287 [0x7fd846cef180] DEBUG - Completed forward migration 20200401131300.
Sep 16, 2020 19:36:34.287 [0x7fd846cef180] DEBUG - Running forward migration 20200506172900.
Sep 16, 2020 19:36:34.297 [0x7fd846cef180] DEBUG - Completed forward migration 20200506172900.
Sep 16, 2020 19:36:34.298 [0x7fd846cef180] DEBUG - Running forward migration 20200515172900.
Sep 16, 2020 19:36:34.309 [0x7fd846cef180] DEBUG - Completed forward migration 20200515172900.
Sep 16, 2020 19:36:34.310 [0x7fd846cef180] DEBUG - Running forward migration 20200610150000.
Sep 16, 2020 19:36:34.322 [0x7fd846cef180] DEBUG - Completed forward migration 20200610150000.
Sep 16, 2020 19:36:34.322 [0x7fd846cef180] DEBUG - Running forward migration 20200615032400.
Sep 16, 2020 19:36:34.534 [0x7fd846cef180] DEBUG - Completed forward migration 20200615032400.
Sep 16, 2020 19:36:34.534 [0x7fd846cef180] DEBUG - Running forward migration 20200701090000.
Sep 16, 2020 19:36:34.543 [0x7fd846cef180] DEBUG - Completed forward migration 20200701090000.
Sep 16, 2020 19:36:34.543 [0x7fd846cef180] DEBUG - Running forward migration 20200728130000.
Sep 16, 2020 19:36:34.552 [0x7fd846cef180] DEBUG - Completed forward migration 20200728130000.
Sep 16, 2020 19:36:34.552 [0x7fd846cef180] DEBUG - Running forward migration 20200731130000.
Sep 16, 2020 19:36:34.560 [0x7fd846cef180] DEBUG - Completed forward migration 20200731130000.
Sep 16, 2020 19:36:34.576 [0x7fd846cef180] DEBUG - Running migrations. (EPG 0)
Sep 16, 2020 19:36:34.576 [0x7fd846cef180] DEBUG - Running forward migration 20190130000000.
Sep 16, 2020 19:36:34.631 [0x7fd846cef180] DEBUG - Completed forward migration 20190130000000.
Sep 16, 2020 19:36:34.631 [0x7fd846cef180] DEBUG - Running forward migration 20190201190600.
Sep 16, 2020 19:36:34.632 [0x7fd846cef180] DEBUG - Completed forward migration 20190201190600.
Sep 16, 2020 19:36:34.632 [0x7fd846cef180] DEBUG - Running forward migration 20190205190600.
Sep 16, 2020 19:36:34.641 [0x7fd846cef180] DEBUG - Completed forward migration 20190205190600.
Sep 16, 2020 19:36:34.641 [0x7fd846cef180] DEBUG - Running forward migration 20190215190600.
Sep 16, 2020 19:36:34.658 [0x7fd846cef180] DEBUG - Completed forward migration 20190215190600.
Sep 16, 2020 19:36:34.658 [0x7fd846cef180] DEBUG - Running forward migration 20190218032400.
Sep 16, 2020 19:36:34.659 [0x7fd846cef180] DEBUG - Completed forward migration 20190218032400.
Sep 16, 2020 19:36:34.659 [0x7fd846cef180] DEBUG - Running forward migration 20190316132700.
Sep 16, 2020 19:36:34.736 [0x7fd846cef180] DEBUG - Completed forward migration 20190316132700.
Sep 16, 2020 19:36:34.736 [0x7fd846cef180] DEBUG - Running forward migration 20190403100000.
Sep 16, 2020 19:36:34.738 [0x7fd846cef180] DEBUG - Completed forward migration 20190403100000.
Sep 16, 2020 19:36:34.738 [0x7fd846cef180] DEBUG - Running forward migration 20190501100000.
Sep 16, 2020 19:36:34.747 [0x7fd846cef180] DEBUG - Completed forward migration 20190501100000.
Sep 16, 2020 19:36:34.747 [0x7fd846cef180] DEBUG - Running forward migration 20190528190600.
Sep 16, 2020 19:36:34.748 [0x7fd846cef180] DEBUG - Completed forward migration 20190528190600.
Sep 16, 2020 19:36:34.748 [0x7fd846cef180] DEBUG - Running forward migration 20190520131301.
Sep 16, 2020 19:36:34.750 [0x7fd846cef180] DEBUG - Completed forward migration 20190520131301.
Sep 16, 2020 19:36:34.750 [0x7fd846cef180] DEBUG - Running forward migration 20190520131302.
Sep 16, 2020 19:36:34.751 [0x7fd846cef180] DEBUG - Completed forward migration 20190520131302.
Sep 16, 2020 19:36:34.751 [0x7fd846cef180] DEBUG - Running forward migration 20190520131303.
Sep 16, 2020 19:36:34.752 [0x7fd846cef180] DEBUG - Completed forward migration 20190520131303.
Sep 16, 2020 19:36:34.752 [0x7fd846cef180] DEBUG - Running forward migration 20190603140000.
Sep 16, 2020 19:36:34.754 [0x7fd846cef180] DEBUG - Completed forward migration 20190603140000.
Sep 16, 2020 19:36:34.754 [0x7fd846cef180] DEBUG - Running forward migration 20190612032400.
Sep 16, 2020 19:36:34.763 [0x7fd846cef180] DEBUG - Completed forward migration 20190612032400.
Sep 16, 2020 19:36:34.763 [0x7fd846cef180] DEBUG - Running forward migration 20190614032400.
Sep 16, 2020 19:36:34.775 [0x7fd846cef180] DEBUG - Completed forward migration 20190614032400.
Sep 16, 2020 19:36:34.776 [0x7fd846cef180] DEBUG - Running forward migration 20190708132500.
Sep 16, 2020 19:36:34.788 [0x7fd846cef180] DEBUG - Completed forward migration 20190708132500.
Sep 16, 2020 19:36:34.788 [0x7fd846cef180] DEBUG - Running forward migration 20190430032400.
Sep 16, 2020 19:36:34.790 [0x7fd846cef180] DEBUG - Completed forward migration 20190430032400.
Sep 16, 2020 19:36:34.790 [0x7fd846cef180] DEBUG - Running forward migration 20190111032400.
Sep 16, 2020 19:36:34.791 [0x7fd846cef180] DEBUG - Completed forward migration 20190111032400.
Sep 16, 2020 19:36:34.792 [0x7fd846cef180] DEBUG - Running forward migration 20190815130000.
Sep 16, 2020 19:36:34.800 [0x7fd846cef180] DEBUG - Completed forward migration 20190815130000.
Sep 16, 2020 19:36:34.801 [0x7fd846cef180] DEBUG - Running forward migration 20190912140000.
Sep 16, 2020 19:36:34.802 [0x7fd846cef180] DEBUG - Completed forward migration 20190912140000.
Sep 16, 2020 19:36:34.802 [0x7fd846cef180] DEBUG - Running forward migration 20180330131300.
Sep 16, 2020 19:36:34.816 [0x7fd846cef180] DEBUG - Completed forward migration 20180330131300.
Sep 16, 2020 19:36:34.816 [0x7fd846cef180] DEBUG - Running forward migration 20190801130200.
Sep 16, 2020 19:36:34.818 [0x7fd846cef180] DEBUG - Completed forward migration 20190801130200.
Sep 16, 2020 19:36:34.818 [0x7fd846cef180] DEBUG - Running forward migration 20190604032400.
Sep 16, 2020 19:36:34.891 [0x7fd846cef180] DEBUG - Completed forward migration 20190604032400.
Sep 16, 2020 19:36:34.891 [0x7fd846cef180] DEBUG - Running forward migration 20190919032400.
Sep 16, 2020 19:36:34.892 [0x7fd846cef180] DEBUG - Completed forward migration 20190919032400.
Sep 16, 2020 19:36:34.892 [0x7fd846cef180] DEBUG - Running forward migration 20190920032400.
Sep 16, 2020 19:36:34.905 [0x7fd846cef180] DEBUG - Completed forward migration 20190920032400.
Sep 16, 2020 19:36:34.906 [0x7fd846cef180] DEBUG - Running forward migration 20190616032400.
Sep 16, 2020 19:36:35.626 [0x7fd846cef180] DEBUG - Completed forward migration 20190616032400.
Sep 16, 2020 19:36:35.627 [0x7fd846cef180] DEBUG - Running forward migration 20191003131300.
Sep 16, 2020 19:36:35.709 [0x7fd846cef180] DEBUG - Completed forward migration 20191003131300.
Sep 16, 2020 19:36:35.709 [0x7fd846cef180] DEBUG - Running forward migration 20191213143300.
Sep 16, 2020 19:36:35.943 [0x7fd846cef180] DEBUG - Completed forward migration 20191213143300.
Sep 16, 2020 19:36:35.945 [0x7fd846cef180] DEBUG - Running forward migration 20200110143300.
Sep 16, 2020 19:36:36.051 [0x7fd846cef180] DEBUG - Completed forward migration 20200110143300.
Sep 16, 2020 19:36:36.051 [0x7fd846cef180] DEBUG - Running forward migration 20200114193300.
Sep 16, 2020 19:36:36.220 [0x7fd846cef180] DEBUG - Completed forward migration 20200114193300.
Sep 16, 2020 19:36:36.220 [0x7fd846cef180] DEBUG - Running forward migration 20200124193500.
Sep 16, 2020 19:36:36.293 [0x7fd846cef180] DEBUG - Completed forward migration 20200124193500.
Sep 16, 2020 19:36:36.293 [0x7fd846cef180] DEBUG - Running forward migration 20200131193503.
Sep 16, 2020 19:36:36.294 [0x7fd846cef180] DEBUG - Completed forward migration 20200131193503.
Sep 16, 2020 19:36:36.294 [0x7fd846cef180] DEBUG - Running forward migration 20191125131300.
Sep 16, 2020 19:36:36.295 [0x7fd846cef180] DEBUG - Completed forward migration 20191125131300.
Sep 16, 2020 19:36:36.295 [0x7fd846cef180] DEBUG - Running forward migration 20200224131300.
Sep 16, 2020 19:36:36.296 [0x7fd846cef180] DEBUG - Completed forward migration 20200224131300.
Sep 16, 2020 19:36:36.296 [0x7fd846cef180] DEBUG - Running forward migration 20200327131300.
Sep 16, 2020 19:36:36.310 [0x7fd846cef180] DEBUG - Completed forward migration 20200327131300.
Sep 16, 2020 19:36:36.310 [0x7fd846cef180] DEBUG - Running forward migration 20200401131300.
Sep 16, 2020 19:36:36.311 [0x7fd846cef180] DEBUG - Completed forward migration 20200401131300.
Sep 16, 2020 19:36:36.312 [0x7fd846cef180] DEBUG - Running forward migration 20200506172900.
Sep 16, 2020 19:36:36.313 [0x7fd846cef180] DEBUG - Completed forward migration 20200506172900.
Sep 16, 2020 19:36:36.313 [0x7fd846cef180] DEBUG - Running forward migration 20200515172900.
Sep 16, 2020 19:36:36.314 [0x7fd846cef180] DEBUG - Completed forward migration 20200515172900.
Sep 16, 2020 19:36:36.315 [0x7fd846cef180] DEBUG - Running forward migration 20200610150000.
Sep 16, 2020 19:36:36.316 [0x7fd846cef180] DEBUG - Completed forward migration 20200610150000.
Sep 16, 2020 19:36:36.316 [0x7fd846cef180] DEBUG - Running forward migration 20200615032400.
Sep 16, 2020 19:36:36.382 [0x7fd846cef180] DEBUG - Completed forward migration 20200615032400.
Sep 16, 2020 19:36:36.382 [0x7fd846cef180] DEBUG - Running forward migration 20200701090000.
Sep 16, 2020 19:36:36.383 [0x7fd846cef180] DEBUG - Completed forward migration 20200701090000.
Sep 16, 2020 19:36:36.384 [0x7fd846cef180] DEBUG - Running forward migration 20200728130000.
Sep 16, 2020 19:36:36.385 [0x7fd846cef180] DEBUG - Completed forward migration 20200728130000.
Sep 16, 2020 19:36:36.386 [0x7fd846cef180] DEBUG - Running forward migration 20200731130000.
Sep 16, 2020 19:36:36.387 [0x7fd846cef180] DEBUG - Completed forward migration 20200731130000.

/usr/lib/plexmediaserver/Plex\ Media\ Scanner --list

terminate called after throwing an instance of 'soci::soci_error'
  what():  sqlite3_statement_backend::prepare: no such column: library_sections.content_changed_at for SQL: select library_sections.id as 'library_sections_id', library_sections.library_id
as 'library_sections_library_id', library_sections.name as 'library_sections_name', library_sections.name_sort as 'library_sections_name_sort', library_sections.section_type as 'library_sections_section_type', library_sections.language as 'library_sections_language', library_sections.agent as 'library_sections_agent', library_sections.scanner as 'library_sections_scanner', library_sections.user_thumb_url as 'library_sections_user_thumb_url', library_sections.user_art_url as 'library_sections_user_art_url', library_sections.user_theme_music_url as 'library_sections_user_theme_music_url', library_sections.created_at as 'library_sections_created_at', library_sections.updated_at as 'library_sections_updated_at', library_sections.scanned_at as 'library_sections_scanned_at', library_sections.user_fields as 'library_sections_user_fields', library_sections.query_xml as 'library_sections_query_xml', library_sections.query_type as 'library_sections_query_type', library_sections.uuid as 'library_sections_uuid', library_sections.changed_at as 'library_sections_changed_at', library_sections.content_changed_at as 'library_sections_content_changed_at' from library_sections
****** PLEX MEDIA SCANNER CRASHED, CRASH REPORT WRITTEN: /home/plex/Library/Application Support/Plex Media Server/Crash Reports/1.20.1.3252-a78fef9a9/PLEX MEDIA SCANNER/7550126e-226d-9291-25d30835-5d489153.dmp
Aborted (core dumped)

[ChuckPa]

May I have the full log ZIP set please?

It’s impossible to diagnose from a snippet

[bpogue99]

Thank you for your time. These are the logs from the very first run.

Plex Media Server Logs_2020-09-16_19-58-42.zip (737.6 KB)

[bpogue99]

Is there a way to get a list of all the items in the libraries without using the Plex Media Scanner? While viewing my movie library I tried to view the source, hoping to find all the movies in that code, but the whole list is not in the page as it updates based on how you scroll the screen.

Just trying to help, so I did a couple more tests. Normally when I build out the server I’ve been using this approach:

curl https://downloads.plex.tv/plex-keys/PlexSign.key | sudo apt-key add -
echo deb https://downloads.plex.tv/repo/deb public main | sudo tee /etc/apt/sources.list.d/plexmediaserver.list
sudo apt-get -y update
sudo apt-get -y install plexmediaserver

I thought maybe this issue is related to how I do the install of the app, or maybe even my Plex account is somehow causing it, so I built another brand new installation and this time downloaded the deb package and installed using dpkg. I claimed the server and setup a library with 100 photos using a new non-plexpass account. The photos are in a folder on the plex server so that they are not sourced from across the network.

sudo dpkg -i plexmediaserver_1.20.1.3252-a78fef9a9_amd64.deb

Sadly, the failure is still there. Attached are the logs for this test.

plex:/usr/lib/plexmediaserver$ sudo ./Plex\ Media\ Scanner --list
terminate called after throwing an instance of 'soci::soci_error'
  what():  sqlite3_statement_backend::prepare: no such column: library_sections.content_changed_at for SQL: select library_sections.id as 'library_sections_id', library_sections.library_id
as 'library_sections_library_id', library_sections.name as 'library_sections_name', library_sections.name_sort as 'library_sections_name_sort', library_sections.section_type as 'library_sections_section_type', library_sections.language as 'library_sections_language', library_sections.agent as 'library_sections_agent', library_sections.scanner as 'library_sections_scanner', library_sections.user_thumb_url as 'library_sections_user_thumb_url', library_sections.user_art_url as 'library_sections_user_art_url', library_sections.user_theme_music_url as 'library_sections_user_theme_music_url', library_sections.created_at as 'library_sections_created_at', library_sections.updated_at as 'library_sections_updated_at', library_sections.scanned_at as 'library_sections_scanned_at', library_sections.user_fields as 'library_sections_user_fields', library_sections.query_xml as 'library_sections_query_xml', library_sections.query_type as 'library_sections_query_type', library_sections.uuid as 'library_sections_uuid', library_sections.changed_at as 'library_sections_changed_at', library_sections.content_changed_at as 'library_sections_content_changed_at' from library_sections
****** PLEX MEDIA SCANNER CRASHED, CRASH REPORT WRITTEN: /root/Library/Application Support/Plex Media Server/Crash Reports/1.20.1.3252-a78fef9a9/PLEX MEDIA SCANNER/43d9ea20-e159-c08a-51a2f26d-0a41501d.dmp
Error in command line:the argument for option '--serverUuid' should follow immediately after the equal sign
Crash Uploader options (all are required):
  --directory arg       Directory to scan for crash reports
  --serverUuid arg      UUID of the server that crashed
  --userId arg          User that owns this product
  --platform arg        Platform string
  --platformVersion arg Platform version string
  --vendor arg          Vendor string
  --device arg          Device string
  --model arg           Device model string
  --sentryUrl arg       Sentry URL to upload to
  --sentryKey arg       Sentry Key for the project
  --version arg         Version of the product
  --allowRetries arg    Whether we will allow retries
Aborted

Plex Media Server Logs_2020-09-19_19-31-20.zip (146.6 KB)