Constant Reproduce-able Data Crashes

Plex Media Server Desktops & Laptops
1

Server Version#: 1.18.1.1973

I’ve been dealing with this issue for about last 3 days and trying to google for solutions and some helped but ultimately i’m not able to figure out the root cause; but I have some conditions that can reproduce the issue every time.

Nearly on a schedule the database will crash after about 15-20 minutes AFTER libraries rescan for new files. So adding files, removing, or telling plex to scan causes the issue.

I have rebuilt my libraries 3 times now, and repaired the database roughly 20-30 times now. I can effectively recover myself back in 5 minutes but once the curroption stars; about 5 minutes afterwards no one can connect and all libraries drop off.

I first thought maybe this had something to do with special characters in file names and folders(Such as #, or ; ) so began removing them and trying to rebuild database on new file names. That… Somewhat worked to make it less frequent. My thinking was a few recently added shows like Steins;Gate may have been causing like… Column separators to be mal-aligned and plex was not able to deal with them fully.

I’m running a new unraid server whatever is latest.

Oddly enough; if I time it correctly I can repair; boot server, run a scan and if I set a timer for 10 minutes, hit optimize database, take PMS offline, repair that file, then reboot it I can be “stable” until it needs to rescan again; and at least now new content is indexed.

Type of errors i’m seeing

Actual Corruption

Nov 03, 2019 21:00:31.251 [0x14677b1f8700] ERROR - SQLITE3:(nil), 11, database corruption at line 64873 of [bf8c1b2b7a]
Nov 03, 2019 21:00:31.251 [0x14677b1f8700] ERROR - SQLITE3:(nil), 11, statement aborts at 2701: [analyze] database disk image is malformed

Is there any special characters that should not be used or avoided?

Also getting other weird errors like below

Nov 03, 2019 21:04:41.106 [0x14f191651700] ERROR - Error issuing curl_easy_perform(handle): 28

or

Nov 03, 2019 21:04:48.461 [0x14f1423f1700] ERROR - [PlexRelay] kex protocol error: type 7 seq 11
Nov 03, 2019 21:04:48.469 [0x14f1425f2700] ERROR - [PlexRelay] kex protocol error: type 7 seq 11
Nov 03, 2019 21:04:48.472 [0x14f141dee700] ERROR - [PlexRelay] kex protocol error: type 7 seq 11
Nov 03, 2019 21:04:48.493 [0x14f141bed700] ERROR - [PlexRelay] kex protocol error: type 7 seq 11

This shows up sometimes… Not sure why.

or

Nov 03, 2019 21:04:52.399 [0x14f1421f0700] ERROR - Unknown metadata type: folder

The unknown metadata type happens frequently and always has. I don’t tend to worry about it.

I’m at a a loss here.

I’ve rebuilt it, even cleared docker container entirely, deleted all files etc. I migrated from a nas to a custom unraid machine.

I’ve redone database entirely, to repaired database etc.

I’ve renamed hundreds of files, got rid of characters from other languages like Japanese in names, and I use SONAR that automatically names files as Show > Season 01 > S01E01 - episode title.

I’m not sure what to really do; I can just never add or do another scan again but… Plex will just eventually do that itself so that’s not really an option.

I’ll provide all log files upon request etc.

2

I’m not sure if this is related, but several folks were experiencing this issue back in the late May to June timeframe; it seems it was around this time they were upgrading from Unraid 6.6.7 to 6.7.0. Some potential solutions are discussed here:

There are also several other threads discussing it if you search “unraid database corruption” in the forums.

1 Like
3

I didn’t upgrade; I used to host plex on a nas and IIRC I was still running 1.61.

I didn’t transfer over old plex content either, I rebuilt it as new though files indexed are the same.

The only thing different would be 3 things.

  1. Updated from 1.6 to 1.81 technically for plex.

  2. Some libraries now index more than 1 folder.

For example

Anime/Anime TV/

TV Shows/

TV Shows includes TV Shows and Anime TV Folder, while Anime includes Anime folder. Some anime I wanted to show up in TV Shows, some I don’t, but for the Anime share everything shows up.

Added some new shows that had special characters like ; which I now removed.

4

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