Issues after upgrade to core-2021.7.4 HELP!

I have no idea what caused this, just upgraded now I’m seeing a ton of errors also Logbook and history do not load.
The first error says this:
Invalid config
The following integrations and platforms could not be set up:

  • history
  • logbook
  • default_config
    Please check your config and logs.

Below are a few error logs:

Logger: homeassistant.components.recorder
Source: components/recorder/init.py:939
Integration: recorder (documentation, issues)
First occurred: 9:18:48 PM (10 occurrences)
Last logged: 9:24:30 PM

Error during connection setup to mysql://homeassistant:PASSWORD@core-mariadb/homeassistant?charset=utf8mb4: (MySQLdb._exceptions.OperationalError) (2005, “Unknown MySQL server host ‘PARTIALPASSWORD@core-mariadb’ (-3)”) (Background on this error at: http://sqlalche.me/e/14/e3q8) (retrying in 3 seconds)
Traceback (most recent call last):
File “/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py”, line 3212, in _wrap_pool_connect
return fn()
File “/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py”, line 301, in connect
return _ConnectionFairy._checkout(self)
File “/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py”, line 761, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File “/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py”, line 419, in checkout
rec = pool._do_get()
File “/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/impl.py”, line 145, in do_get
self.dec_overflow()
File “/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py”, line 70, in exit
compat.raise
(
File “/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py”, line 207, in raise

raise exception
File “/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/impl.py”, line 142, in _do_get
return self._create_connection()
File “/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py”, line 247, in _create_connection
return _ConnectionRecord(self)
File “/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py”, line 362, in init
self.__connect()
File “/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py”, line 605, in connect
pool.logger.debug(“Error on connect(): %s”, e)
File “/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py”, line 70, in exit
compat.raise
(
File “/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py”, line 207, in raise

raise exception
File “/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py”, line 599, in __connect
connection = pool._invoke_creator(self)
File “/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/create.py”, line 578, in connect
return dialect.connect(*cargs, **cparams)
File “/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py”, line 584, in connect
return self.dbapi.connect(*cargs, **cparams)
File “/usr/local/lib/python3.9/site-packages/MySQLdb/init.py”, line 130, in Connect
return Connection(*args, **kwargs)
File “/usr/local/lib/python3.9/site-packages/MySQLdb/connections.py”, line 185, in init
super().init(*args, **kwargs2)
MySQLdb._exceptions.OperationalError: (2005, “Unknown MySQL server host ‘#V!ax@core-mariadb’ (-3)”)

Read the breaking change about using @ symbols in your database username and password.

Screenshot 2021-08-02 at 14-18-10 2021 7 A new entity, trigger IDs and script debugging

Note: this is not the the @ in the URL, someone:password@somewhere... it applies only if the @ symbol is inside your username or password.

Thank you good sir! Saved me from ripping my hair out. I need to read those breaking changes a little more carefully! Once I just got rid of my “@” in my password away it went!

1 Like