see https://gist.github.com/dlangille/81ba2803d16da044ed00de471fddf860

gistfile1.txt

Well, this doesn't seem to have run to completion.

homeassistant@homeassistant:~ $ time /srv/homeassistant/bin/hass
Home Assistant only supports Linux, OSX and Windows using WSL
        0.99 real         0.76 user         0.06 sys
homeassistant@homeassistant:~ $ time /srv/homeassistant/bin/hass --ignore-os-check
2022-08-23 23:01:18.660 ERROR (MainThread) [root] Uncaught exception
Traceback (most recent call last):
  File "/srv/homeassistant/bin/hass", line 8, in <module>
    sys.exit(main())
  File "/srv/homeassistant/lib/python3.9/site-packages/homeassistant/__main__.py", line 191, in main
    exit_code = runner.run(runtime_conf)
  File "/srv/homeassistant/lib/python3.9/site-packages/homeassistant/runner.py", line 119, in run
    return loop.run_until_complete(setup_and_run_hass(runtime_config))
  File "/usr/local/lib/python3.9/asyncio/base_events.py", line 647, in run_until_complete
    return future.result()
  File "/srv/homeassistant/lib/python3.9/site-packages/homeassistant/runner.py", line 101, in setup_and_run_hass
    hass = await bootstrap.async_setup_hass(runtime_config)
  File "/srv/homeassistant/lib/python3.9/site-packages/homeassistant/bootstrap.py", line 143, in async_setup_hass
    await async_from_config_dict(config_dict, hass) is not None
  File "/srv/homeassistant/lib/python3.9/site-packages/homeassistant/bootstrap.py", line 256, in async_from_config_dict
    await _async_set_up_integrations(hass, config)
  File "/srv/homeassistant/lib/python3.9/site-packages/homeassistant/bootstrap.py", line 532, in _async_set_up_integrations
    recorder.async_initialize_recorder(hass)
  File "/srv/homeassistant/lib/python3.9/site-packages/homeassistant/helpers/recorder.py", line 22, in async_initialize_recorder
    from homeassistant.components.recorder import const, models
  File "/srv/homeassistant/lib/python3.9/site-packages/homeassistant/components/recorder/__init__.py", line 23, in <module>
    from . import statistics, websocket_api
  File "/srv/homeassistant/lib/python3.9/site-packages/homeassistant/components/recorder/statistics.py", line 17, in <module>
    from sqlalchemy import bindparam, func, lambda_stmt, select
ModuleNotFoundError: No module named 'sqlalchemy'
        8.23 real         4.93 user         0.56 sys
homeassistant@homeassistant:~ $ pkg search sqlalchemy
homeassistant@homeassistant:~ $ pip install sqlalchemy
Defaulting to user installation because normal site-packages is not writeable
Collecting sqlalchemy
  Downloading SQLAlchemy-1.4.40.tar.gz (8.3 MB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 8.3/8.3 MB 22.2 MB/s eta 0:00:00
  Preparing metadata (setup.py) ... done
Collecting greenlet!=0.4.17
  Using cached greenlet-1.1.2.tar.gz (91 kB)
  Preparing metadata (setup.py) ... done
Using legacy 'setup.py install' for sqlalchemy, since package 'wheel' is not installed.
Using legacy 'setup.py install' for greenlet, since package 'wheel' is not installed.
Installing collected packages: greenlet, sqlalchemy
  Running setup.py install for greenlet ... done
  Running setup.py install for sqlalchemy ... done
Successfully installed greenlet-1.1.2 sqlalchemy-1.4.40
homeassistant@homeassistant:~ $ time /srv/homeassistant/bin/hass --ignore-os-check
        1.21 real         1.03 user         0.18 sys
homeassistant@homeassistant:~ $ /srv/homeassistant/bin/hass --ignore-os-check
homeassistant@homeassistant:~ $