I followed the process outlined in the blog post about upgrading to HassOS. I made sure I was on the latest Hass.io update before creating my snapshot pre-upgrade.
Now, none of my database-based stuff works. I have this error in the front end:
I use MariaDB and InfluxDB add-ons. The configuration.yaml for those components haven’t changed. I’ve double-checked them against my Git repo. The add-ons are running green, their configs were properly restored as well.
I see an error in the home-assistant.log about a problem during connection setup involving MySQL, “Lost connection to MySQL server a ‘handshake: reading initial communication packet’” and it provides a URL for more info. The URL it references states this:
Exception raised for errors that are related to the database’s operation and not necessarily under the control of the programmer, e.g. an unexpected disconnect occurs, the data source name is not found, a transaction could not be processed, a memory allocation error occurred during processing, etc.
This error is a DBAPI Error and originates from the database driver (DBAPI), not SQLAlchemy itself.
The OperationalError is the most common (but not the only) error class used by drivers in the context of the database connection being dropped, or not being able to connect to the database. For tips on how to deal with this, see the section Dealing with Disconnects.
Why is none of this stuff working all of a sudden and what can I do?
