Guys, if anyone could help me, I would really appreciate it. I’ve had HA for years, with dozens of devices.
But now, and I’ve been doing this for 8 days, this happens: HA works very well and suddenly I don’t have access to the panels (node red, file editor, terminal, etc), I can’t reboot or perform more advanced functions or automations and I lose the devices mqtt. I turn it off and on again and it goes well for a few hours and it happens again. I’ve already restored several snaps and always the same.
I think the problem has to do with the broken connection to the DB (I had the HA one and I installed MariaDB but it still crashes).
I have HA OS running on Rasp4 with SSD. The most relevant error I think will be this:
Logger: homeassistant.components.recorder.core Source: components/recorder/core.py:649 Integration: Recorder First occurred: 6:17:38 AM (1 occurrences) Last logged: 6:17:38 AM Database connection invalidated: Error executing query: (MySQLdb.OperationalError) (2013, ‘Lost connection to MySQL server during query’) (Background on this error at: Error Messages — SQLAlchemy 1.4 Documentation). (retrying in 3 seconds)