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/hellfire/Library/Application Support/Plex Media Server/Crash Reports/1.22.3.4523-daae39438/PLEX MEDIA SCANNER/2846483-7fa8-f624-391fc8e-232487a.dmp
Aborted
[hellfire:/usr/lib/plexmediaserver]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
[hellfire:/usr/lib/plexmediaserver]
Server Version#: 1.22.3.4523
Linux Version#:Ubuntu 18.04.5 LTs
I don’t actually have an Ubuntu instance in front of me; my suggestions were based on some common guesses that might apply.
Did you install Plex from a package? I believe the Plex package for Ubuntu would typically run as a ~plex user, which would also typically own the files.
Can you share a bit more about your system, such as the path to the DB files owned by root:root?
well, Plex is everywhere…
I scanned for the Preference.xml file and found them here:
/var/lib/plexmediaserver/Library/Application Support/Plex Media Server/Preferences.xml
/home/hellfire/Preferences.xml
/home/hellfire/Library/Application Support/Plex Media Server/Preferences.xml
the path $PLEX_HOME/Library/Application Support/Plex Media Server/ don’t exist,I guess that $PLEX_HOME isn’t set, the installer probably never set it, and I have no idea how…
the Plex server has been running for at least 2 years without any issues, I have however never before tried to execute any terminal commands before…
if I’m not mistaken, upon the first installation it was installed on plex:plex, but nowadays the updates are runned by Webmin.
The installer sets all the environment variables.
All the required varibles are contained in /lib/systemd/system/plexmediaserver.service with exception of $HOME. $HOME provided by /etc/passwd.
That’s correct, that’s what my system says, but your guides points to $PLEX_HOME/Library/Application Support/Plex Media Server/ and $PLEX_HOME don’t exist…
but my issue might be because the Plex installation is own by root, not plex.
do I have to reinstall everything or is there anyway to reset the owner? and what do I need to reset?
… amongst other… I always thought $PLEX_HOME was a variable, but that’s not the main issue that I’m having now, now it’s about the crashing media scanner…
I’m pretty sure Webmin doesn’t repackage Plex, and that the normal Ubuntu install details - of which Chuck is the expert - are still correct.
I think there are files in multiple locations because Plex has been started as a different user, without the environment set up.
Can you share the output of ls -la "/var/lib/plexmediaserver/Library/Application Support/Plex Media Server/" and ls -la "/usr/lib/plexmediaserver/"
Let’s change directions slightly. What’s your end goal? What do you want to accomplish from the CLI? Sometimes there are easier/better ways to interact with Plex.
