Hello Everybody,
I’ve got more than 60 sql sensors running with the standard sql integration connected to local MariaDB addon.
Everything running rock solid from months, but after upgrading to 2024.3.0 most of them become randomly unavailable after a reboot.
Logs are reporting:
Error executing query XXXXXXX (MySQLdb.OperationalError) (1040, 'Too many connections') (Background on this error at: https://sqlalche.me/e/20/e3q8)
I am running Home Assistant Operating System on a Raspberry4.
I suspect some has changed in the 2024.3.0 release during the loading of the integration that MariaDB can handle.
Reverting back to 2024.2 fixed the issue, but of course I want to keep my installation updated like every one of us.
Just for information I’ve disabled polling for all entities from this integration and just update them once an hour because I don’t need them updated very often.
Is anybody else facing this issue?
I think there is something to be corrected in the core-code to make this integration working just fine like before to limit the simultaneous queries on the db.
Any comment or help appreciated.
Regards.