Thank you Colin - I had found this post Upgrade from 7.9.6 LTS to 8.9.0 LTS failed - Get help / SonarQube - SonarSource Community
which pretty much said the same thing. I deleted that index and one other on the same table and was able to complete the upgrade without issue to 9.4.2