Open ivercellino opened 4 months ago
Hey there @gjohansson-st, @dougiteixeira, mind taking a look at this issue as it has been labeled with an integration (sql
) you are listed as a code owner for? Thanks!
(message by CodeOwnersMention)
sql documentation sql source (message by IssueLinks)
Is the MariaDB the add on or something you are running yourself?
Is the official MariaDB addon
I have a similar issue. I set up a sensor that should report the DB size. This is not updated at all.
Couldn't connect using mysql://:@core-mariadb/homeassistant?charset=utf8 DB_URL: (MySQLdb.OperationalError) (2002, "Can't connect to server on 'core-mariadb' (115)") (Background on this error at: https://sqlalche.me/e/20/e3q8)
The problem
I have more than 60 sql sensors configured with the standard sql integrations connected to a MariaDB running locally. After upgrade to 2024.3.0 most of them have become unvailable right from the startup in a random way. Sometimes reloading helps, sometimes not. Reverted back to 2024.2.5 and everything is fine again.
So obviuosly something is not running smoth with db connections in this release.
What version of Home Assistant Core has the issue?
2024.3.0
What was the last working version of Home Assistant Core?
2024.2.5
What type of installation are you running?
Home Assistant OS
Integration causing the issue
SQL
Link to integration documentation on our website
No response
Diagnostics information
No response
Example YAML snippet
No response
Anything in the logs that might be useful for us?
Additional information
No response