Sonic Analysis Makes No Progress (Not Working)

[infinitejelly]

I am running the latest version of Plex Media Server for Mac (version 1.24.1.4931) and loading Plex via the hosted web app (app.plex.tv). My media files are stored on a Synology NAS connected to the Mac via a network bridge.

I am trying to get Sonic Analysis performed on my music library but despite many days, no progress has been made. I have 4745 albums in my library. The status under “Activity” simply shows “Processing 4745 albums”.

Looking through the debug logs and the console there is no indication that Sonic Analysis is running at all. I believe you are supposed to be able to filter by “[MusicAnalysis]” to monitor the progress of this operation, but no instances of this exist in my logs.

Has anyone else experienced the same? I’m bummed out because I was really looking forward to this feature returning…

[Shockrift1986]

Just a stab at this as my library did something similar.

1. set sonic analysis to run as a scheduled task (likely already done)
2. optimize your library (this will flush cache, remove old bundles, etc. usually once a week)
3. restart plex application to flush ram.
   it should start after a while. it says relatively nothing about what particular album it’s working on (unless you enable debug logs) but there’s no way to manually trigger it aside from changing the scheduled task maintenance window.

good luck

[elan]

I would instead recommend:

1. Change it to analyze after adding new content.
2. Run a scan, cancel it immediately.
3. When you see the “Processing X albums” status, wait for 15 minutes or so, and then zip up your logs via the web diagnostics option.
4. Upload loads here [PLEASE DO NOT ENABLE VERBOSE LOGGING]

[infinitejelly]

Unfortunately this resulted in the same behavior but thanks for the suggestion!

[blackzwe]

Might also be worthwhile going through this thread and observing what others have been experiencing.

Sonic Analysis - has processed 6 albums in 40 minutes

Server Version#:1.24.0.4930 Player Version#: This can’t be right. At this rate - it will take… EIGHTY THREE DAYS to complete sonic scanning? My Plex computer isn’t new - but it’s a 6 core processor with 16 GB of RAM. Fast enough that this shouldn’t take until Christmas. What do I do? This CAN’T BE RIGHT.Plex Media Server Logs_2021-08-12_19-11-04.zip (7.3 MB)

We have since determined how processor intensive the analysis is, if you have a less powerful processor, it takes a while.

[elan]

@infinitejelly

Unfortunately this resulted in the same behavior but thanks for the suggestion!

Then please follow my suggestion and request for logs.

[elan]

There is no indication of any sonic analysis occurring. When you grabbed the logs, you were in the middle of a TV scan, so it appears that there are no music scans in the logs.

[infinitejelly]

Sorry about that. Here’s another clean attempt at recreating the steps you’ve recommended:

Plex Media Server Logs_2021-08-26_14-47-52.zip (4.2 MB)

The Music scan starts, then is cancelled. Then after a while later Sonic Analysis begins. But it never makes any progress (have waited over 24 hours at one point). And on a few occasions I have seen two identical Sonic Analysis processes under the Activity tab in Plex (both stuck with no progress made).

[elan]

Aug 26, 2021 14:26:52.007 [0x305ebf000] ERROR - [MusicAnalysis] SQLITE3:(nil), 1, no such column: blob_type in "select id from blobs where linked_type=? and linked_id=? and blob_type=?"
Aug 26, 2021 14:26:52.007 [0x305ebf000] ERROR - [MusicAnalysis] Exception inside transaction (inside=1) (/data/jenkins/server/1784943550/Library/BlobDatabase.cpp:65): sqlite3_statement_backend::prepare: no such column: blob_type for SQL: select id from blobs where linked_type=? and linked_id=? and blob_type=?

Fascinating, did you ever run a beta/weird version of the server? Your database schema appears to be out of whack.

[elan]

Your blobs table (in com.plexapp.plugins.library.blobs.db) can be fixed by the following SQL if you’re so inclined:

ALTER TABLE 'blobs' add 'linked_guid' varchar(255);
CREATE UNIQUE INDEX 'index_blobs_on_linked_type_linked_guid' ON 'blobs' ('linked_type', 'linked_guid');

[infinitejelly]

I have been on the beta channel for updates for a few years now but nothing outside of that. I’ll try your suggestion. Thanks!!

[michicago]

Any chance I can get your help on my similar issue? My SA has been stuck in for 2 days now and I’m out of ideas to try. I can’t figure out how to scrap it and just start it over, either.

Sonic Analysis Reached ~60% Now Will Not Resume

Rolled back to the previous version and the exact same sequence happens, just with different thread ID’s. I don’t know what to do now… [image]

Thanks!

[elan]

Follow my instructions here ~ Sonic Analysis Makes No Progress (Not Working) - #3 by elan

[infinitejelly]

@elan

com.plexapp.plugins.library.blobs.db

Unfortunately this did not work. The column seems to already exist. Maybe a permissions issue…?

➜  Databases /Applications/Plex\ Media\ Server.app/Contents/MacOS/Plex\ SQLite com.plexapp.plugins.library.db "ALTER TABLE 'blobs' add 'linked_guid' varchar(255); CREATE UNIQUE INDEX 'index_blobs_on_linked_type_linked_guid' ON 'blobs' ('linked_type', 'linked_guid');"
Error: duplicate column name: linked_guid

[elan]

Hmm… definitely back up your database before trying this, but you can try the following in your blobs database:

delete from schema_migrations where version='20200327131300'

Then start the media server and it should run a migration to create the blob type column.

[infinitejelly]

Looks like this has resulted in many more errors about the database being corrupted. I’ll have to attempt a repair of the database. Hopefully I can start over but somehow migrate over the watched status of everything. Thanks for your help!

[michicago]

Here are the log files - there is no progress made on this anymore, it starts at 2388 albums and never advances (the original number was 6,000+).

I appreciate any help!

Plex Media Server Logs_2021-08-29_21-47-35.zip (2.2 MB)

[elan]

Aug 29, 2021 21:35:20.196 [14592] DEBUG - MusicAnaysis: Analyzing 2388 albums in section 9.
Aug 29, 2021 21:35:20.196 [14592] DEBUG - Activity: updated activity ac0d93cc-745e-4464-a0e9-35c37eec51b3 - completed 0.0% - Sonic Analysis
Aug 29, 2021 21:35:20.204 [14592] ERROR - Thread: Uncaught exception running async task which was spawned by thread 4684: Cannot convert data to std::tm.

I’m not 100% sure what that error is related to, I’m asking around.

[sjsoukup]

Please advise how we can verify the SOnic Analysis IS or IS NOT working in the background even before its completed as I know it can day days depending on server CPU and server uptime etc… but I want to know its actuallyt doing somethingf. is there a file that is created on a file path that I can check to know its working or what? I turned it on but now what?..
please advise as if it takes days to complete we dont want to wait and then be dissapointed when it did nothing and we didnt have a chance to know with a warning or email or notice somehow to fix something

thanks

[kegbeach]

You’ll know if it’s doing something because your CPU will be pegged at about 50% load.