MariaDB stopped saving history

Abruzzi04 · February 26, 2023, 4:03pm

Good afternoon… I’m using mariadb to save my history, and today around 12:30 UTC, it stopped saving. When I restart HA, it updates the database once and stops again.

Logger: homeassistant.components.recorder.util
Source: components/recorder/util.py:577
Integration: Recorder (documentation, issues)
First occurred: 15:33:12 (1 occurrences)
Last logged: 15:33:12

Ended unfinished session (id=696 from 2023-02-26 14:26:58)

I have this error in the logs that I don’t know if it’s related.

someone can help me? Thanks

checking12 · February 26, 2023, 4:20pm

Is your db still healthy? Can you login with sql tool?

Abruzzi04 · February 26, 2023, 4:45pm

mwav3 · February 26, 2023, 6:36pm

Did you upgrade recently? Not sure how youre running mariadb but There was a breaking change in the Feb release that caused older versions of mariadb to stop working.

checking12 · February 26, 2023, 7:56pm

10.6.10 should be fine. Does phpadmin function still with data querying too?

Abruzzi04 · March 12, 2023, 3:07pm

I stopped the mariadb server and turned it back on and it was fine. never happened to me. thanks