Sonic analysis stuck on 6 albums forever + several issues on the log file

This tells us that your iNotify table is full. You need to correct that by following this guide:

After correcting the iNotify table issue, most of the other issues you noted should resolve themselves.

If you have persistent error messages (WARN - [MusicAnalysis] Analysis had wrong number of dimensions) for certain albums/tracks, then I would suggest that you re-encode/re-download those tracks (using different sources) as there appears to be some missing data from your current files.