Plex agents not downloading the artist poster and background images

Plex Media Server Metadata & Adding Files
1

Hi,
It’s more than a month, the Plex agents are unable to download the artist and background images for my music library. All agents are enabled and my media are named (folders and files) based on the Plex website recommendation.
I spent a lot of time searching the internet and this forum without any good solution to this issue. I hope someone out there will help me to fix this problem.

Thank you.

Server Version#: 1.16.6.1592
Web Client Version#: 3.108.2
QNAP NAS: QTS TS-453 Pro version 4.4.1.1031

Plex Media Server Logs_2019-08-31_21-38-09.zip (7.8 MB)

2

Unfortunately your database is corrupt.

Aug 31, 2019 21:34:52.377 [0x7f0ac56fb700] ERROR - SQLITE3:(nil), 11, database corruption at line 64757 of [bf8c1b2b7a]
Aug 31, 2019 21:34:52.377 [0x7f0ac56fb700] ERROR - SQLITE3:(nil), 11, database corruption at line 64798 of [bf8c1b2b7a]
Aug 31, 2019 21:34:52.377 [0x7f0ac56fb700] ERROR - SQLITE3:(nil), 11, statement aborts at 163: [select media_items.id as 'media_items_id', media_items.library_section_id as 'media_items_library_section_id', media_items.section_location_id as 'media_items_section_location_id', me
Aug 31, 2019 21:34:52.423 [0x7f0ac56fb700] ERROR - Soci Exception handled: sqlite3_statement_backend::loadRS: database disk image is malformed
Aug 31, 2019 21:28:48.387 [0x7f0ac5cd7700] ERROR - SQLITE3:(nil), 11, database corruption at line 64757 of [bf8c1b2b7a]
Aug 31, 2019 21:28:48.387 [0x7f0ac5cd7700] ERROR - SQLITE3:(nil), 11, database corruption at line 64798 of [bf8c1b2b7a]
Aug 31, 2019 21:28:48.387 [0x7f0ac5cd7700] ERROR - SQLITE3:(nil), 11, statement aborts at 49: [select metadata_items.id as 'metadata_items_id', metadata_items.metadata_type as 'metadata_items_metadata_type', metadata_items.title as 'metadata_items_title', metadata_items.parent_i
Aug 31, 2019 21:28:48.388 [0x7f0ac5cd7700] ERROR - Soci Exception handled: sqlite3_statement_backend::loadRS: database disk image is malformed
Aug 31, 2019 21:28:48.487 [0x7f0ac6b7d700] ERROR - SQLITE3:(nil), 11, database corruption at line 64757 of [bf8c1b2b7a]
Aug 31, 2019 21:28:48.487 [0x7f0ac6b7d700] ERROR - SQLITE3:(nil), 11, database corruption at line 64798 of [bf8c1b2b7a]
Aug 31, 2019 21:28:48.487 [0x7f0ac6b7d700] ERROR - SQLITE3:(nil), 11, statement aborts at 49: [select metadata_items.id as 'metadata_items_id', metadata_items.metadata_type as 'metadata_items_metadata_type', metadata_items.title as 'metadata_items_title', metadata_items.parent_i
Aug 31, 2019 21:28:48.487 [0x7f0ac6b7d700] ERROR - Soci Exception handled: sqlite3_statement_backend::loadRS: database disk image is malformed
Aug 31, 2019 21:28:48.598 [0x7f0ac4e31700] ERROR - SQLITE3:(nil), 11, database corruption at line 64757 of [bf8c1b2b7a]
Aug 31, 2019 21:28:48.599 [0x7f0ac4e31700] ERROR - SQLITE3:(nil), 11, database corruption at line 64798 of [bf8c1b2b7a]
Aug 31, 2019 21:28:48.599 [0x7f0ac4e31700] ERROR - SQLITE3:(nil), 11, statement aborts at 49: [select metadata_items.id as 'metadata_items_id', metadata_items.metadata_type as 'metadata_items_metadata_type', metadata_items.title as 'metadata_items_title', metadata_items.parent_i
Aug 31, 2019 21:28:48.599 [0x7f0ac4e31700] ERROR - Soci Exception handled: sqlite3_statement_backend::loadRS: database disk image is malformed
Aug 31, 2019 21:24:46.731 [0x7f0a7f447700] ERROR - SQLITE3:(nil), 11, database corruption at line 64757 of [bf8c1b2b7a]
Aug 31, 2019 21:24:46.731 [0x7f0a7f447700] ERROR - SQLITE3:(nil), 11, database corruption at line 64798 of [bf8c1b2b7a]
Aug 31, 2019 21:24:46.731 [0x7f0a7f447700] ERROR - SQLITE3:(nil), 11, statement aborts at 163: [select media_items.id as 'media_items_id', media_items.library_section_id as 'media_items_library_section_id', media_items.section_location_id as 'media_items_section_location_id', me
Aug 31, 2019 21:24:46.733 [0x7f0a7f447700] ERROR - Soci Exception handled: sqlite3_statement_backend::loadRS: database disk image is malformed
Aug 31, 2019 21:25:36.149 [0x7f0b05ad6700] ERROR - SQLITE3:(nil), 11, database corruption at line 64757 of [bf8c1b2b7a]
Aug 31, 2019 21:25:36.149 [0x7f0b05ad6700] ERROR - SQLITE3:(nil), 11, database corruption at line 64798 of [bf8c1b2b7a]
Aug 31, 2019 21:25:36.149 [0x7f0b05ad6700] ERROR - SQLITE3:(nil), 11, statement aborts at 59: [select metadata_items.id as 'metadata_items_id', metadata_items.metadata_type as 'metadata_items_metadata_type', metadata_items.title as 'metadata_items_title', metadata_items.parent_i
Aug 31, 2019 21:25:36.150 [0x7f0b05ad6700] ERROR - Soci Exception handled: sqlite3_statement_backend::loadRS: database disk image is malformed
Aug 31, 2019 21:25:36.256 [0x7f0b05ad6700] ERROR - SQLITE3:(nil), 11, database corruption at line 64757 of [bf8c1b2b7a]
Aug 31, 2019 21:25:36.256 [0x7f0b05ad6700] ERROR - SQLITE3:(nil), 11, database corruption at line 64798 of [bf8c1b2b7a]
Aug 31, 2019 21:25:36.256 [0x7f0b05ad6700] ERROR - SQLITE3:(nil), 11, statement aborts at 59: [select metadata_items.id as 'metadata_items_id', metadata_items.metadata_type as 'metadata_items_metadata_type', metadata_items.title as 'metadata_items_title', metadata_items.parent_i
Aug 31, 2019 21:25:36.257 [0x7f0b05ad6700] ERROR - Soci Exception handled: sqlite3_statement_backend::loadRS: database disk image is malformed
Aug 31, 2019 21:25:36.287 [0x7f0ad511f700] ERROR - SQLITE3:(nil), 11, database corruption at line 64757 of [bf8c1b2b7a]
Aug 31, 2019 21:25:36.287 [0x7f0ad511f700] ERROR - SQLITE3:(nil), 11, database corruption at line 64798 of [bf8c1b2b7a]
Aug 31, 2019 21:25:36.287 [0x7f0ad511f700] ERROR - SQLITE3:(nil), 11, statement aborts at 59: [select metadata_items.id as 'metadata_items_id', metadata_items.metadata_type as 'metadata_items_metadata_type', metadata_items.title as 'metadata_items_title', metadata_items.parent_i
Aug 31, 2019 21:25:36.287 [0x7f0ad511f700] ERROR - Soci Exception handled: sqlite3_statement_backend::loadRS: database disk image is malformed
Aug 31, 2019 21:25:36.629 [0x7f0a7f735700] ERROR - SQLITE3:(nil), 11, database corruption at line 64757 of [bf8c1b2b7a]
Aug 31, 2019 21:25:36.629 [0x7f0a7f735700] ERROR - SQLITE3:(nil), 11, database corruption at line 64798 of [bf8c1b2b7a]
Aug 31, 2019 21:25:36.629 [0x7f0a7f735700] ERROR - SQLITE3:(nil), 11, statement aborts at 59: [select metadata_items.id as 'metadata_items_id', metadata_items.metadata_type as 'metadata_items_metadata_type', metadata_items.title as 'metadata_items_title', metadata_items.parent_i
Aug 31, 2019 21:25:36.630 [0x7f0a7f735700] ERROR - Soci Exception handled: sqlite3_statement_backend::loadRS: database disk image is malformed

https://support.plex.tv/articles/201100678-repair-a-corrupt-database/

3

Thank you for your quick reply,

Unfortunately I see a lot of corruption in Plex database. I didn’t notice anything to raise any question about these corruptions, Plex was functioning as normal except the metadata issue.
You provided me with a link to repair the database, but I don’t know how to browse to this file in Qnap NAS and witch tool should I use to access it.

Thank you.

4

Hi,

Usual location is as follow:
/share/CACHEDEV1_DATA/.qpkg/PlexMediaServer/Library/Plex Media Server/Plug-in Support/Databases

where CACHEDEV1_DATA is the QNAP volume PLEX has been installed to.

I use WinSCP to access QNAP via SSH https://winscp.net/eng/download.php
although any other SSH access tool will do the trick.

You may allow SSH access to QNAP via its Control Panel, under Net Services Telnet/SSH

1 Like
5

Maybe the plexteam could update the article to include instructions/or link to QNAS FAQ.

6

Thank you for the information about the tool, I downloaded the winSCP and went to Plex database. The problem is, there are too many files, I’m not sure to be honest with you witch one to repair, maybe you could lead me to the right file.

winSCP-Plex_Database_Folder
winSCP-Plex_Database_Folder.PNG558×710 44.7 KB

Thank you.

7

com.plexapp.plugins.library.db is the database that is currently inuse.
com.plexapp.plugins.library.db-xxxx-xx-xx are your backups.
Do not simple delete the inuse database and rename the backup to com.plexapp.plugins.library.db.

COPY the backup file then rename to com.plexapp.plugins.library.db.

WOW, your dlna file is huge. Do you use dlna?

Oh, btw, exit plex before you start restoring!!

8

No I don’t use dlna, I don’t remember when it was built, I have to check if I can get rid of it.

Thank you.

9

Then I’d say, disable(uncheck) it. Settings>DLNA>Enable the DLNA server

10

Yes, I just check it the Plex setting and I found DLNA is enabled.

11

Might as well disable. The dnla database is 4x bigger than your plex database, lol.

12

Do you mean to delete the dnla database from plex media server ?

13

No… Just disable it in settings.

14

I don’t see how to disable it in the dnla setting.

dlna_setting
dlna_setting833×600 464 KB

15

5c9e5e73ee366ff89f2c330835c571b288b452b0_2_690x497

It’s disabled(or how you want to look at it, not enabled)

16

Yes I see it’s disable, but this is for DLNA server not about its database, that the way I understood it .

17

Same thing.
My dlna has been disabled the moment I installed pms and logged in a PlexHome.
I can fit my dnla database on one of these suckers…
d4c

But that is neither here nor there. Has no importance on your issue. I just saw how big it was(there’s a joke in there).

18

But back on topic.
Were you able to restore your plex database?

19

I download the SQLite tool but I didn’t installed it, I will try this tomorrow and I will let you know if it’s OK.

Thank you.

20

SQLite tool? For what is that going to be used for? Are you planing on repairing?
Never-mind. Just looking at your screenshot again.
Your plex databases are real old. You may need to do a repair.

Be sure plex is set to backup your databases
Settings>Sceduled Tasks>>Backup database every three days
EDIT: After the restore. No need for plex to backup corrupt databases.