ERROR - SQLITE - Gracenote DB Corrupt

Plex Media Server Desktops & Laptops
1

I do not have a Music library, so why are these warnings here in the logs and should I be worried?

$ tail /var/lib/plexmediaserver/Library/Application\ Support/Plex\ Media\ Server/Logs/Plex\ Media\ Server.log
Apr 30, 2019 18:49:11.624 [0x7f2591ffb700] ERROR - SQLITE3:(nil), 11, statement aborts at 12: [DROP TABLE IF EXISTS ldata_2_wc1;] database disk image is malformed
Apr 30, 2019 18:49:11.624 [0x7f2591ffb700] ERROR - Gracenote: Music locale error -1870658241 (CorruptDB: A database disk image is malformed.)
Apr 30, 2019 18:49:11.969 [0x7f2591ffb700] ERROR - SQLITE3:(nil), 11, database corruption at line 64757 of [bf8c1b2b7a]
Apr 30, 2019 18:49:11.969 [0x7f2591ffb700] ERROR - SQLITE3:(nil), 11, database corruption at line 64798 of [bf8c1b2b7a]
Apr 30, 2019 18:49:11.969 [0x7f2591ffb700] ERROR - SQLITE3:(nil), 11, statement aborts at 12: [DROP TABLE IF EXISTS ldata_2_wc1;] database disk image is malformed
Apr 30, 2019 18:49:11.969 [0x7f2591ffb700] ERROR - Gracenote: Music locale error -1870658241 (CorruptDB: A database disk image is malformed.)
Apr 30, 2019 18:49:12.285 [0x7f2591ffb700] ERROR - SQLITE3:(nil), 11, database corruption at line 64757 of [bf8c1b2b7a]
Apr 30, 2019 18:49:12.285 [0x7f2591ffb700] ERROR - SQLITE3:(nil), 11, database corruption at line 64798 of [bf8c1b2b7a]
Apr 30, 2019 18:49:12.285 [0x7f2591ffb700] ERROR - SQLITE3:(nil), 11, statement aborts at 12: [DROP TABLE IF EXISTS ldata_2_wc1;] database disk image is malformed
Apr 30, 2019 18:49:12.285 [0x7f2591ffb700] ERROR - Gracenote: Music locale error -1870658241 (CorruptDB: A database disk image is malformed.)

Server Version#: 1.15.5.994
Player Version#: N/A

Thanks,

Paully

2

For now no need to worry, but if you decide to create a premium music library, you may run into issues. You can just delete the Gracenote DB file and it will recreate itself.

1 Like
3

Thanks, how do I delete the specific Gracenote DB file, and presumably I have to stop PMS first?

4 
sudo systemctl stop plexmediaserver
cd "/var/lib/plexmediaserver/Libary/Application Support/Plex Media Server/Plug-in Support/Databases"
ls

now, as root (sudo) you can delete the gracenote database files.

5

I beg to differ.

cd "/var/lib/plexmediaserver/Libary/Application Support/Plex Media Server/Cache"

has the Gracenote DB.
all 3 files with file names gn_?????.gdb

6

Thanks Otto. My mistake.

7

I’m confused, so do I stop PMS then move those 3 gdb files somewhere else, then start PMS and the errors in the log file should go away?

8

They should go away. These files are being slowly regenerated over the next few hours.

Unless the errors are not coming from this Gracenote database…
You didn’t show enough of your logs above for identification of the particular file.

9

Hi Otto. Did what you and the others said. Also researched other posts. But i still get the "Gracenote: Music locale error " error.

I set the proper flags in Agents.
I repaired the database.
I stopped/rebooted the server.
… … …
(I am running windows.)

Still getting these errors every 30 seconds (the three errors I get repeatedly are listed at the end) and pretty much delays all other processing.

Any idea/suggestions greatly appreciated.

Thanks.

=======================================

Gracenote: Music locale error -1870659452 (The client timed out or was disconnected waiting for a response from the Server - often this indicates there is something keeping the SDK from reaching Gracenote’s servers - like proxy or firewall settings.)

SQLITE3:0x7dce85f6, 14, os_win.c:45632: (2) winOpen(C:\Users\robi\AppData\Local\Plex Media Server\Cache\gn_lists.gdb) - The system cannot find the file specified.

SQLITE3:0x7dce85f6, 14, cannot open file at line 45633 of [bf8c1b2b7a]

10

Gracenote-related features and Premium Music library are currently impaired in their functionality.
A replacement for Gracenote is developed and will be released in a few weeks.

14

Thanks much Otto for the quick reply. Keep up the great work…

A quick question, if I may: Saw announcement. I use the “free” server (not “Premium”), latest version (1.16.3.1402). Would July 1 changes impact how I currently use Plex since I do not have Premium?

Thanks again, Otto!

15

No, not at all.
The error messages are also inconsequential. They only appear because Gracenote has been disabled, but not removed completely yet. They will disappear in PMS 1.16.4

1 Like
16

THANK YOU, Otto!!

17

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