2022.7: A stunning performance

e-raser · July 6, 2022, 9:31pm

Interestingly, together

the first time after the Check Home Assistant configuration Addon has been deprecated and
was accidentally run automatically,

it gives errors for the first timer ever since using it.

Ignore? Inception bomb?


[22:57:10] INFO: Installed Home Assistant 2022.7.0
[22:57:10] INFO: Making a copy of your configuration for checking...
[22:57:35] INFO: Checking your configuration against this version...
[23:08:00] ERROR: The configuration check did not pass!
[23:08:00] ERROR: See the output below for more details.
Testing configuration at /tmp/config
INFO:homeassistant.helpers.storage:Migrating core.entity_registry storage from 1.6 to 1.7
  
  × Building wheel for numpy (pyproject.toml) did not run successfully.
  │ exit code: 1
  ╰─> [258 lines of output]
      Running from numpy source directory.
      setup.py:86: DeprecationWarning:
      
        `numpy.distutils` is deprecated since NumPy 1.23.0, as a result
        of the deprecation of `distutils` itself. It will be removed for
        Python >= 3.12. For older Python versions it will remain present.
        It is recommended to use `setuptools < 60.0` for those Python versions.
        For more details, see:
          https://numpy.org/devdocs/reference/distutils_status_migration.html
s6-rc: info: service legacy-services: stopping
s6-rc: info: service legacy-services successfully stopped
s6-rc: info: service legacy-cont-init: stopping
s6-rc: info: service legacy-cont-init successfully stopped
s6-rc: info: service fix-attrs: stopping
s6-rc: info: service fix-attrs successfully stopped
s6-rc: info: service s6rc-oneshot-runner: stopping
s6-rc: info: service s6rc-oneshot-runner successfully stopped

bkr1969 · July 6, 2022, 9:32pm

So before I update, let me be sure I’m reading this correctly. Leviton switches will no longer work at all? 80% of my light switches are Leviton. Surely someone out there can make these work.

Wait…after reading more it only affects Bluetooth devices. Mine are all WIFI.

So I hit “SKIP” on this update and now can’t see it to install. How do I get it back? (HA Blue - ODROID)

jgosnell · July 6, 2022, 9:36pm

Having an issue with MySQL immediately after upgrade to 2022.7. This is not allowing Recorder, History, Logbook, or Energy integrations to start.

Logger: homeassistant.components.recorder.core
Source: components/recorder/core.py:1070
Integration: recorder (documentation, issues)
First occurred: 4:29:25 PM (10 occurrences)
Last logged: 4:29:52 PM

Error during connection setup: (MySQLdb.OperationalError) (1045, 'Plugin caching_sha2_password could not be loaded: Error loading shared library /usr/lib/mariadb/plugin/caching_sha2_password.so: No such file or directory') (Background on this error at: https://sqlalche.me/e/14/e3q8) (retrying in 3 seconds)
Traceback (most recent call last):
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3280, in _wrap_pool_connect
    return fn()
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 310, in connect
    return _ConnectionFairy._checkout(self)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 868, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 476, in checkout
    rec = pool._do_get()
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 145, in _do_get
    with util.safe_reraise():
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
    compat.raise_(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
    raise exception
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 143, in _do_get
    return self._create_connection()
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 256, in _create_connection
    return _ConnectionRecord(self)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 371, in __init__
    self.__connect()
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 665, in __connect
    with util.safe_reraise():
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
    compat.raise_(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
    raise exception
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 661, in __connect
    self.dbapi_connection = connection = pool._invoke_creator(self)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 590, in connect
    return dialect.connect(*cargs, **cparams)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 597, in connect
    return self.dbapi.connect(*cargs, **cparams)
  File "/usr/local/lib/python3.10/site-packages/MySQLdb/__init__.py", line 123, in Connect
    return Connection(*args, **kwargs)
  File "/usr/local/lib/python3.10/site-packages/MySQLdb/connections.py", line 185, in __init__
    super().__init__(*args, **kwargs2)
MySQLdb.OperationalError: (1045, 'Plugin caching_sha2_password could not be loaded: Error loading shared library /usr/lib/mariadb/plugin/caching_sha2_password.so: No such file or directory')

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 630, in _setup_recorder
    self._setup_connection()
  File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 1070, in _setup_connection
    Base.metadata.create_all(self.engine)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/schema.py", line 4916, in create_all
    bind._run_ddl_visitor(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/future/engine.py", line 341, in _run_ddl_visitor
    with self.begin() as conn:
  File "/usr/local/lib/python3.10/contextlib.py", line 135, in __enter__
    return next(self.gen)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/future/engine.py", line 379, in begin
    with self.connect() as conn:
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/future/engine.py", line 406, in connect
    return super(Engine, self).connect()
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3234, in connect
    return self._connection_cls(self, close_with_result=close_with_result)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 96, in __init__
    else engine.raw_connection()
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3313, in raw_connection
    return self._wrap_pool_connect(self.pool.connect, _connection)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3283, in _wrap_pool_connect
    Connection._handle_dbapi_exception_noconnection(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2117, in _handle_dbapi_exception_noconnection
    util.raise_(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
    raise exception
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3280, in _wrap_pool_connect
    return fn()
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 310, in connect
    return _ConnectionFairy._checkout(self)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 868, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 476, in checkout
    rec = pool._do_get()
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 145, in _do_get
    with util.safe_reraise():
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
    compat.raise_(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
    raise exception
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 143, in _do_get
    return self._create_connection()
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 256, in _create_connection
    return _ConnectionRecord(self)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 371, in __init__
    self.__connect()
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 665, in __connect
    with util.safe_reraise():
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
    compat.raise_(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
    raise exception
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 661, in __connect
    self.dbapi_connection = connection = pool._invoke_creator(self)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 590, in connect
    return dialect.connect(*cargs, **cparams)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 597, in connect
    return self.dbapi.connect(*cargs, **cparams)
  File "/usr/local/lib/python3.10/site-packages/MySQLdb/__init__.py", line 123, in Connect
    return Connection(*args, **kwargs)
  File "/usr/local/lib/python3.10/site-packages/MySQLdb/connections.py", line 185, in __init__
    super().__init__(*args, **kwargs2)
sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1045, 'Plugin caching_sha2_password could not be loaded: Error loading shared library /usr/lib/mariadb/plugin/caching_sha2_password.so: No such file or directory')
(Background on this error at: https://sqlalche.me/e/14/e3q8)

Draghmar · July 6, 2022, 9:40pm

Happy to see Aqara FP1 officially supported!

Anyone have one and could confirm how it works with ZHA? Is it limited somehow or are most of the options available? I wanted to buy one, but first I wanted to know if and how it’s gonna work, as it’s quite expensive piece of hardware…

zsarnett · July 6, 2022, 9:43pm

Go to Settings → System → Updates

bkr1969 · July 6, 2022, 9:44pm

No. It wasn’t there after being skipped. I was able to clear the skipped version via the services though. Thanks!

zsarnett · July 6, 2022, 9:44pm

You can show skipped in the over flow menu in the updates page.

tom_l · July 6, 2022, 9:46pm

AKA “The meatball menu icon” (three dots top right).

knicknackery · July 6, 2022, 9:57pm

What is preventing Sonoff from having a ‘real’ integration vs a ‘HACS’? These last few releases have been pretty painful, and AlexxIT is getting swamped for asks.

Danny2100 · July 6, 2022, 9:59pm

I have 2 they work with zha.

Gav_in · July 6, 2022, 10:05pm

Think they might be two separate issues …solutions for both in this thread

dtliddle · July 6, 2022, 10:29pm

I have the same issue jgosnell

ZyberSE · July 6, 2022, 10:33pm

All my SensorPush temperature sensors switched from C to F after I upgraded to 2022.7. Is this some breaking change the integration needs to handle or is there some configuration I could do on my end that’s not related to the integrations itself?

evlo · July 6, 2022, 10:39pm

After running

sudo docker pull homeassistant/home-assistant
sudo docker restart homeassistant

Should it say Home Assistant Core 2022.6.6 or Home Assistant Core 2022.7 in settings?

tom_l · July 6, 2022, 10:55pm

It should say core-2022.7.0

Where are you seeing that in Settings?

Have you cleared your web browser cache?

Have you checked that you have actually updated?

ryingg · July 6, 2022, 11:05pm

I’m having issues with OpenWeatherMap onecall_hourly because the weather.openweathermap entity is no longer available after updating to 2022.7. onecall_daily works, and it doesn’t seem to be an issue with API rates or OpenWeatherMap because an older backup still works.

Looks like there’s an open issue here https://github.com/home-assistant/core/issues/74527

moto2000 · July 6, 2022, 11:10pm

Thanks for the great update! It was nice to see that this thread wasn’t bombed with complaints within the first 4 hours of release.

jgosnell · July 6, 2022, 11:22pm

I fixed it for now by following the instructions in this Stack Overflow thread.
MySQL Native Password Mode
Post 110 in particular.

PeteRage · July 6, 2022, 11:33pm

Getting multiple reports and have verified an integration I manage no longer works in 2022.7.0. It uses aiohttp to connect to local IP addresses of the devices and this connection fails. Any changes in the aiohttp layers that HA injects?


2022-07-06 15:58:21 ERROR (MainThread) [custom_components.lennoxs30.config_flow] Code [11] Reference [400] [login Client Connector Error - failed due host not reachable url [https://192.168.100.71/Endpoints/homeassistant/Connect]]

Vendo232 · July 6, 2022, 11:41pm

after the update Im forced to re-authenticate my NEST integration and after going through all to the end when Im asked to give access to HA for my Thermostat I get this error.