You could even copy your last yaml’s (autmotion, configuration, secrets, etc) straight from your SD card.
Then see where a fresh setup takes you, and copy/paste ‘missing’ stuff fro the old files into the new setup 
These lines tells us that there is some DB updates to handle and some of them take a long time to do, so have some patience too.
Your old setup is so old that there is no straight line for updates.
You’ll need to reset your Firefox to Default settings:
- On Windows you can do this by clicking the three horizontal dash marks in the upper right corner (underneath the “Close” button).
- Click “Help”
- Click “More Troubleshooting…”
- Click “Refresh Firefox” underneath ‘Give Firefox a tune up’
Let Firefox cycle, reopen Firefox and log into your local instance of Home Assistant.
Reseting to defaults does not helped me.
main bug is using dns-over-https. complete turn-of this feature and recheck. It is helped for me.
I think this approach will help you when your try to connect within local network using dns name (not ip).