# Sonic Analysis Makes No Progress (Not Working) **URL:** \ **Category:** Plex Labs\ **Tags:** server-mac, plexamp\ **Created:** [August 25, 2021, 4:11am UTC](https://forums.plex.tv/t/sonic-analysis-makes-no-progress-not-working/738689 "2021-08-25T04:11:48Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![infinitejelly](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/infinitejelly/32/194981_2.png) [@infinitejelly](https://forums.plex.tv/u/infinitejelly)\ **Post date:** [August 25, 2021, 4:11am UTC](https://forums.plex.tv/t/sonic-analysis-makes-no-progress-not-working/738689/1 "2021-08-25T04:11:48Z")
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](https://app.plex.tv/) (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”. ![Screen Shot 2021-08-24 at 11.49.43 PM](https://global.discourse-cdn.com/plex/original/3X/3/9/391568c316a2bb4a0bbae7208f23031ef8a35af6.png) 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… ---
**Author:** ![Shockrift1986](https://avatars.discourse-cdn.com/v4/letter/s/54ee81/32.png) [@Shockrift1986](https://forums.plex.tv/u/Shockrift1986)\ **Post date:** [August 25, 2021, 4:26am UTC](https://forums.plex.tv/t/sonic-analysis-makes-no-progress-not-working/738689/2 "2021-08-25T04:26:14Z")
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 ---
**Author:** ![elan](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/elan/32/5_2.png) [@elan](https://forums.plex.tv/u/elan)\ **Post date:** [August 25, 2021, 5:16am UTC](https://forums.plex.tv/t/sonic-analysis-makes-no-progress-not-working/738689/3 "2021-08-25T05:16:17Z")
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] ---
**Author:** ![infinitejelly](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/infinitejelly/32/194981_2.png) [@infinitejelly](https://forums.plex.tv/u/infinitejelly)\ **Post date:** [August 25, 2021, 2:33pm UTC](https://forums.plex.tv/t/sonic-analysis-makes-no-progress-not-working/738689/4 "2021-08-25T14:33:45Z")
Unfortunately this resulted in the same behavior but thanks for the suggestion! ---
**Author:** ![blackzwe](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/blackzwe/32/237058_2.png) [@blackzwe](https://forums.plex.tv/u/blackzwe)\ **Post date:** [August 25, 2021, 2:42pm UTC](https://forums.plex.tv/t/sonic-analysis-makes-no-progress-not-working/738689/5 "2021-08-25T14:42:45Z")
Might also be worthwhile going through this thread and observing what others have been experiencing. > [@Sonic Analysis - has processed 6 albums in 40 minutes](https://forums.plex.tv/t/sonic-analysis-has-processed-6-albums-in-40-minutes/735992): > > 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](https://forums.plex.tv/uploads/short-url/sI8JtUVldTAE9sWTLlrXHWauyvp.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. ---
**Author:** ![elan](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/elan/32/5_2.png) [@elan](https://forums.plex.tv/u/elan)\ **Post date:** [August 25, 2021, 6:14pm UTC](https://forums.plex.tv/t/sonic-analysis-makes-no-progress-not-working/738689/6 "2021-08-25T18:14:26Z")
> [@infinitejelly](#): > > Unfortunately this resulted in the same behavior but thanks for the suggestion! Then please follow my suggestion and request for logs. ---
**Author:** ![elan](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/elan/32/5_2.png) [@elan](https://forums.plex.tv/u/elan)\ **Post date:** [August 25, 2021, 8:51pm UTC](https://forums.plex.tv/t/sonic-analysis-makes-no-progress-not-working/738689/8 "2021-08-25T20:51:02Z")
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. ---
**Author:** ![infinitejelly](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/infinitejelly/32/194981_2.png) [@infinitejelly](https://forums.plex.tv/u/infinitejelly)\ **Post date:** [August 27, 2021, 12:51am UTC](https://forums.plex.tv/t/sonic-analysis-makes-no-progress-not-working/738689/9 "2021-08-27T00:51:23Z")
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](https://forums.plex.tv/uploads/short-url/4lUipYmhjJ7OmGQi3aSfDzbn1N0.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). ---
**Author:** ![elan](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/elan/32/5_2.png) [@elan](https://forums.plex.tv/u/elan)\ **Post date:** [August 27, 2021, 7:55am UTC](https://forums.plex.tv/t/sonic-analysis-makes-no-progress-not-working/738689/10 "2021-08-27T07:55:30Z")
```auto 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. ---
**Author:** ![elan](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/elan/32/5_2.png) [@elan](https://forums.plex.tv/u/elan)\ **Post date:** [August 27, 2021, 7:58am UTC](https://forums.plex.tv/t/sonic-analysis-makes-no-progress-not-working/738689/11 "2021-08-27T07:58:18Z")
Your blobs table (in `com.plexapp.plugins.library.blobs.db`) can be fixed by the following SQL if you’re so inclined: ```auto ALTER TABLE 'blobs' add 'linked_guid' varchar(255); CREATE UNIQUE INDEX 'index_blobs_on_linked_type_linked_guid' ON 'blobs' ('linked_type', 'linked_guid'); ``` ---
**Author:** ![infinitejelly](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/infinitejelly/32/194981_2.png) [@infinitejelly](https://forums.plex.tv/u/infinitejelly)\ **Post date:** [August 27, 2021, 7:18pm UTC](https://forums.plex.tv/t/sonic-analysis-makes-no-progress-not-working/738689/12 "2021-08-27T19:18:36Z")
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!! ---
**Author:** ![michicago](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/michicago/32/20925_2.png) [@michicago](https://forums.plex.tv/u/michicago)\ **Post date:** [August 28, 2021, 5:09am UTC](https://forums.plex.tv/t/sonic-analysis-makes-no-progress-not-working/738689/13 "2021-08-28T05:09:33Z")
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](https://forums.plex.tv/t/sonic-analysis-reached-60-now-will-not-resume/738956/3): > > 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… Thanks! ---
**Author:** ![elan](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/elan/32/5_2.png) [@elan](https://forums.plex.tv/u/elan)\ **Post date:** [August 28, 2021, 5:56am UTC](https://forums.plex.tv/t/sonic-analysis-makes-no-progress-not-working/738689/14 "2021-08-28T05:56:51Z")
Follow my instructions here ~ [Sonic Analysis Makes No Progress (Not Working) - #3 by elan](https://forums.plex.tv/t/sonic-analysis-makes-no-progress-not-working/738689/3) ---
**Author:** ![infinitejelly](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/infinitejelly/32/194981_2.png) [@infinitejelly](https://forums.plex.tv/u/infinitejelly)\ **Post date:** [August 28, 2021, 1:43pm UTC](https://forums.plex.tv/t/sonic-analysis-makes-no-progress-not-working/738689/15 "2021-08-28T13:43:00Z")
> [@elan](#): > > com.plexapp.plugins.library.blobs.db Unfortunately this did not work. The column seems to already exist. Maybe a permissions issue…? ```auto ➜ 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 ``` ![Screen Shot 2021-08-28 at 8.41.37 AM](https://global.discourse-cdn.com/plex/original/3X/7/2/7292915ab8300ae891bcc7777de2835caa7f027a.jpeg) ---
**Author:** ![elan](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/elan/32/5_2.png) [@elan](https://forums.plex.tv/u/elan)\ **Post date:** [August 28, 2021, 9:04pm UTC](https://forums.plex.tv/t/sonic-analysis-makes-no-progress-not-working/738689/16 "2021-08-28T21:04:14Z")
Hmm… definitely back up your database before trying this, but you can try the following in your blobs database: ```auto delete from schema_migrations where version='20200327131300' ``` Then start the media server and it _should_ run a migration to create the blob type column. ---
**Author:** ![infinitejelly](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/infinitejelly/32/194981_2.png) [@infinitejelly](https://forums.plex.tv/u/infinitejelly)\ **Post date:** [August 29, 2021, 2:38pm UTC](https://forums.plex.tv/t/sonic-analysis-makes-no-progress-not-working/738689/17 "2021-08-29T14:38:55Z")
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! ---
**Author:** ![michicago](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/michicago/32/20925_2.png) [@michicago](https://forums.plex.tv/u/michicago)\ **Post date:** [August 30, 2021, 1:52am UTC](https://forums.plex.tv/t/sonic-analysis-makes-no-progress-not-working/738689/18 "2021-08-30T01:52:11Z")
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+). ![image](https://global.discourse-cdn.com/plex/original/3X/7/f/7ff5a5c55467f2fd189c5b98946185ef05a0ea5a.png) I appreciate any help! [Plex Media Server Logs\_2021-08-29\_21-47-35.zip](https://forums.plex.tv/uploads/short-url/ys7CcYqUL9rlT2XZWOtf62KJOWd.zip) (2.2 MB) ---
**Author:** ![elan](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/elan/32/5_2.png) [@elan](https://forums.plex.tv/u/elan)\ **Post date:** [August 30, 2021, 2:08am UTC](https://forums.plex.tv/t/sonic-analysis-makes-no-progress-not-working/738689/19 "2021-08-30T02:08:54Z")
```auto 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. ---
**Author:** ![sjsoukup](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/sjsoukup/32/198506_2.png) [@sjsoukup](https://forums.plex.tv/u/sjsoukup)\ **Post date:** [August 31, 2021, 5:27am UTC](https://forums.plex.tv/t/sonic-analysis-makes-no-progress-not-working/738689/20 "2021-08-31T05:27:18Z")
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 ---
**Author:** ![kegbeach](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/kegbeach/32/216116_2.png) [@kegbeach](https://forums.plex.tv/u/kegbeach)\ **Post date:** [August 31, 2021, 5:44am UTC](https://forums.plex.tv/t/sonic-analysis-makes-no-progress-not-working/738689/21 "2021-08-31T05:44:09Z")
You’ll know if it’s doing something because your CPU will be pegged at about 50% load. [Next page](https://forums.plex.tv/t/sonic-analysis-makes-no-progress-not-working/738689.md?page=2)