Home assistant database locked again

is that a click on more-info in Ha? or is this some other tool. My more-info screens never go past a day…?

It’s from the History page.

ah, well, that’s beyond reach in my 2 instances, and has been so for as long as I can remember…

After installation of MariaDB database may I delete home-assistant_v2.db file in /config ?

Yes you can.

Can you share a link about how to change database from the default to mariadb on a raspberry pi3?

Ok but i need to register myself in the mariadb site or do i need only that config?

If you are using Hassio just install the addon.

Still on hassbian !

It is in the docs.

I got this problem on my small installation of HassOS (Raspberry 4 with external USB 3.0 drive).

Switching to MariaDB solved* the issue and dramatically increased performance and UI responsiveness. In the Raspberry, at least.
12/feb/2021: The issue was probably the slow disk. In the end I discarded the Raspberry, switched to a HASSOS VM, and MariaDB is no longer needed.

That’s actually very fine. The more the database can store in memory, the quicker it works. It has a configured upper limit.

If you keep reading…

I am a little confused about how to configure mariadb database inside configuration.yaml in the recorder section. Can you share your configuration about this?

I can. See MariadB in docker issue - unconnected user unauthenticated host

1 Like