qss integration failed to configure after homeassitant upgrade to 2024.12.0

[gco33]

Describe the bug
qss integration failed to configure after homeassitant upgrade to 2024.12.0
exact message in log is "Setup failed for custom integration 'qss': Requirements for qss not found: ['questdb>=1.2,<2.0']."

To Reproduce
Once homeassistant have been upgraded and restarted, notification is raised with message above

Expected behavior
qss should start without error after upgrade

Exact version of each module of homeassistant :

Interface utilisateur (in french) is User interface

[FeHJa]

I see the following line in the logs:

2024-12-05 13:22:28.609 ERROR (SyncWorker_0) [homeassistant.util.package] Unable to install package questdb>=1.2,<2.0: × Failed to download and build 'questdb==1.2.0'
╰─▶ Build backend failed to determine requirements with 'build_wheel()'
2024-12-05 13:22:31.569 ERROR (MainThread) [homeassistant.setup] Setup failed for custom integration 'qss': Requirements for qss not found: ['questdb>=1.2,<2.0'].

[antst]

Yes, this is bug which everyone with supervised 2024.12.0 will experience.
Tried to dig this issue couple of days ago, and it all boils down to very strange error of being unable to load cpython shared library, when pip is trying to install 'questdb>=1.2,<2.0'. (I tried 1.2, 2.0, 2.0.x - all the same)
I've found only two similar issue in the google history, both miss resolutions.

[antst]

But, technically, this is not QSS issue, but rather issue of building python questdb client (https://github.com/questdb/py-questdb-client) with python setup which comes with home assistant core.

[antst]

I created issue on HA core repo, where we need to work on resolution.
home-assistant/core#132398

[gco33]

thanks a lot for investigation

[antst]

OK, why it does not build on new HA core I sorted out.
But, aside issue with /tmp on HA core, there are ton of issues with questdb module.

1. versions bellow 2.0.3 has bugs in build system. so pip will not build and install them "as is", unless some fixed applied.
2. even if fixes applied, it need Rust compiler to build. While there is no problem with build of 2.0.x versions . 1.2.0 has some other problems with rust. And current extension works with 1.2.0 only.

So, outcome:
Either some will upgrade this component to be able to work with 2.0.3 (but then still building of questb on the fly by HA Core would require installed Rust compiler and fixed permission of /tmp) or someone takes car of generation of pre-built wheel for environment we have in new HA Core. Or ideally, someone update compinent to use 2.0.3 questdb package and generate wheel :)

To be honest, I have ZERO experience with wheels etc.

[antst]

OK, #53 updates qss to use lates questdb python client. Client which can be built by pip (assuming /tmp is not mounted with "noexec" and rust compiler "cargo" is installed on the host.
In case of hass core it is simple matter of

mount -t tmpfs -o rw,nosuid,nodev,relatime tmpfs /tmp
apk add cargo
pip install -v questdb==2.0.3

I will also talk to questdb people to provide prebuilt wheel for this particular combination of python and musl. But, before wheel is available, functionality already can be restored with couple of extra command above

[FeHJa]

Thank you @antst, works for me.