PMS 1.15.8.11198 permission issue on QNAP TVS 471

Plex Media Server NAS & Devices
1

Server Version#:4 4.1.0949
Player Version#:1.16.0.1226

Hello, I am currently facing an issue with PMS permission to media directory in my QNAP, this problem happened only after updating it to version 1.15 and I thought about downloading and updating it to 1.16 (beta) with no luck ! There seems to be a problem accessing the directory and Plex became so unresponsive.

Any idea how to fix this issue ?

2

Since PMS on QNAP runs as root (admin) it’s 100% not a permission problem, so logs in debug mode would be helpfull

3

Can you please advise how I download logs and upload it here ?

4

Since you don’t have access to settings, I recommend installing this:

Then in the share created, make a zip of the logs directory

5

I do have an access to setting on PMS, can you take me through how to download it ?

6

Sorry, mixed up with another thread :wink:

Look here:

logs
logs842×594 449 KB

7

Check the logsPlex Media Server Logs_2019-06-15_18-30-49.zip (2.6 MB)

8

First of all, you are using a beta of QTS!

Jun 15, 2019 16:53:48.486 [0x7f3794d84700] INFO - Linux version: QTS 4.4.1.0949, language: en-US

Above is not supported by Plex!

Secondly, you have a broken database!

Jun 15, 2019 16:53:51.530 [0x7f3739fc5700] ERROR - SQLITE3:(nil), 267, statement aborts at 171: [update metadata_items set extra_data=? where metadata_type=? and library_section_id=? and `index`=?] database disk image is malformed
Jun 15, 2019 16:53:51.530 [0x7f3739fc5700] ERROR - Exception inside transaction (inside=1) (../Library/MetadataCollection.cpp:236): sqlite3_statement_backend::loadOne: database disk image is malformed
Jun 15, 2019 16:53:51.531 [0x7f3739fc5700] ERROR - Fixup 29DatabaseFixupsSyncCollections threw an exception: sqlite3_statement_backend::loadOne: database disk image is malformed

Suggest you try and restore a database from the scheduled tasks:

https://support.plex.tv/articles/202485658-restore-a-database-backed-up-via-scheduled-tasks/

9

Ok I’ll updated the QTS now and I’ll follow the broken database issue and update you

1 Like
10

How could I access the QNAP file system using GUI I am not so familiar with the SSH and I am using MacOS X, I went through the article you shared but for me it was rocket science.

Please advise me, and what happen if it uninstall Plex and install again will you recommend this ?

Thanks a lot

11

Install the plugin I mentioned a few posts ago.
There you’ll have a share, that you can access from your Mac

Doing that, would delete any shares you have, as well as all info about your medias, watched status etc. so not recommended unless a restore fails

1 Like
12

Thanks a million, I installed the plug-in you highlighted and now I could access Plex share files.

I’ll go through the steps and see how it goes :blush:

13

I follow the steps you highlighted and seems to have the same situation :sweat_smile:

Here the log:
Plex Media Server Logs_2019-06-16_08-54-24.zip (2.4 MB)

Any Suggestions, really thanks for your support

14

Database still broken, so if you did restore an old one, the one you restored was also broken :frowning:

Try with the oldest you have, and if that doesn’t help, try:

And if that also fails, you’ll have to reinstall :frowning:

15

Just let me clarify what I did;

I made a copy from the corrupted database alongside with _shm and _wal after moving them out from the database folder under Plex Media Server as you can see in screen attached;

46%20AM
46%20AM943×530 156 KB

And then rename it as per the instruction and run Plex service again, I feel like what I did was wrong ?:sweat_smile:

16

Huh…

You now have two files named com.plexapp.plugins.library.db ?

Try this:

  1. Power down PMS
  2. Make a copy of the following files:
    com.plexapp.plugins.library.db, com.plexapp.plugins.library.db-shm, com.plexapp.plugins.library.db-wal
  3. Move the backup files away from PMS folder structure
  4. Delete the original 3 files
  5. Make a copy of the file named: com.plexapp.plugins.library.db-2018-09-02
  6. Rename that copy to com.plexapp.plugins.library.db
  7. start PMS again

And note, that for some reason, your backup is very old!
(Normally, a backup is made every 3 days)
Verify afterwards, that your scheduled job for backups is enabled!
See: https://support.plex.tv/articles/202197488-scheduled-server-maintenance/

17

Thanks a lot now it working.

I also checked the scheduled job for backups and it’s enabled already but don’t know why the backup is so old, check the below screen;

05%20PM
05%20PM943×530 130 KB

Thanks a million, you really made my day :heart_eyes:

1 Like
18

Uncheck it, restart PMS, check it again…
Wait 4 days, and check if backup’s are been made again.
Most likely, it was failing due to a bad database

1 Like
19

You are amazing :star_struck:.

I’ll do it, and really can’t express how I am thankful to your effort

1 Like
20

Is the scheduled backup working again?

1 Like