Arch Linux

Description:

With home-assistant 1:2023.6.2-1, a lot of modules aren't present in the python venv, and it prevents home-assistant from starting some services. Errors like these are seen in /var/log/hass/home-assistant.log:

2023-06-19 12:44:52.676 ERROR (Recorder) [homeassistant.components.recorder.core] Error during connection setup: No module named 'psycopg2' (retrying in 3 seconds)
Traceback (most recent call last):
File "/var/lib/hass/.venv/lib/python3.11/site-packages/homeassistant/components/recorder/core.py", line 924, in _setup_recorder
self._setup_connection()
File "/var/lib/hass/.venv/lib/python3.11/site-packages/homeassistant/components/recorder/core.py", line 1393, in _setup_connection
self.engine = create_engine(self.db_url, **kwargs, future=True)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "<string>", line 2, in create_engine
File "/var/lib/hass/.venv/lib/python3.11/site-packages/sqlalchemy/util/deprecations.py", line 283, in warned
return fn(*args, **kwargs) # type: ignore[no-any-return]
^^^^^^^^^^^^^^^^^^^
File "/var/lib/hass/.venv/lib/python3.11/site-packages/sqlalchemy/engine/create.py", line 601, in create_engine
dbapi = dbapi_meth(**dbapi_args)
^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/hass/.venv/lib/python3.11/site-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 669, in import_dbapi
import psycopg2

I'm mostly putting this ^ here so it's searchable. Here is a full log with all the errors:

https://gist.githubusercontent.com/synthead/bac4a94cecf91a9a9e73009263f7f293/raw/64f165da8ab3977b1f60a5775434bdfb4bca0fb7/gistfile1.txt

I might have a few extra integrations that require more python libs. Even if this is the case, in HA fashion, these libs should be fetched and added to the venv when necessary :)

Additional info:
* home-assistant 1:2023.6.2-1
* python 3.11.3-2

Steps to reproduce:
1. Install home-assistant 1:2023.6.2-1 and python 3.11.3-2.
2. (possibly install the MQTT integration, a problematic integration I'm using)
3. Observe that there are missing python libs and that the MQTT integration doesn't start.