Recorder problems with MariaDB

Configuration
1

Hi all,

Didn’t find a lot of time to bring my HA projects forward lately and check in here often. However I want to change that again :slight_smile: and already have a problem I would like to ask you for support about.

To eliminate the need to change my SD card in regular intervals, I started the MariaDB that is integrated on my QNAP NAS and configured the recorder to use it. It seemed to work fine, however after a while it stopped working. I checked on the SQL server and it told me that the host was banned because of too many connection errors. Of course I can raise that limit on the SQL server to an insane high number, but it will still drop out when it reaches that number.

Are there any known problems with recorder / MariaDB ? If so, is there a fix? Should I maybe install another database server? Which one would be recommended?

2

Hm I recreated the whole DB and everything and it seemed to work for a while, but then again recording connection errors and lost connection (because of too many errors).

As a next step I finally disabled WiFi and connected my Home Assistant to a switch, will see if this helps.