This is a regression bug since 5.22.1. Just submitted PR to core, can you please try upgrading after applying patch? If the patch works it would be helpful to add your QA results on PR to help the PR to get merged in next release.
I was able to reproduce a similar symptom in a wp-demo configuration. Specifically, the upgrader activates the new, core-internal extension (sequentialcreditnotes), and the activation fired off a general system-flush, and the general system-flush raised an error while handling some data from another extension (civivolunteer). The problem only occurred with ...
On WordPress version, tried to upgrade from 5.21.2 to 5.24.0 twice and had the same issue. Freezes on: Executed: Upgrade DB to 5.24.alpha1: SQL Had to restore previous day's back up to bring database back. No error messages, just the freezing.
In step 5_15_alpha1 the field cacheKey must be renamed in cachekey. Is that done.
Try to update the fieldname if it is cacheKey.
CREATE INDEX index_all ON civicrm_prevnext_cache (cachekey, entity_id1, entity_id2, entity_table, is_selected)
If the table is empty, try dropping and recreating it, i.e.
SHOW CREATE TABLE civicrm_prevnext_cache;
Then copy the output to the clipboard.
Then DROP TABLE civicrm_prevnext_cache;
Then paste from the clipboard.
This is because your cms.root doesn't match properly with civicrm.root variable and you might be using variables in Resource url for 'CiviCRM Resource URL'.
You need to make sure paths are correct in your system
Check the Document root path in your apache or nginx config of site.
It should match exactly with the path of $civicrm_root and template_c path ...
I have updated the lines 824 en 825 in CRM/CORE/Resources.php with a dirty solution:
$map = ['bower_components' => str_replace('Joomla/Joomla','Joomla',rtrim(Civi::paths()->getUrl('[civicrm.bower]/.', 'absolute'), '/')),
'packages' => str_replace('Joomla/Joomla','Joomla',rtrim(Civi::paths()->getUrl('[civicrm.packages]/.', 'absolute'), '/')),
Do you have multi-lingual enabled? than try to rebuild the views to see if it resolves your problem
Missing column 'frontend_title' in ''civicrm_uf_field_de_DE" after upgrading to 5.1.2
Do you have DB logging enabled? than disabled and enable back again.
Else can you check the CiviCRM log/watchdog to get more details of DB error?