In-memory SQLite database is not supported for dictionary value @ data['recorder']['db_url']

Configuration
1

Hi

I have been using an in memory solution for the home assistant recorder, and ever since the latest update the logging has completely stopped working and when i attempted to restart HA I received the following message;

The system cannot restart because the configuration is not valid: Invalid config for [recorder]: In-memory SQLite database is not supported for dictionary value @ data['recorder']['db_url']. Got 'sqlite:///:memory:'. (See /config/configuration.yaml, line 18).

I use in-memory for the simple reason that I do not have a hard drive connected (nor am I interested in in this as a solution at all) and want to prevent the lifespan of the SD card being dramatically reduced with extraneous writes.

Is there any way to fix the in-memory logging so it behaves like before? or alternatively disable the recorder completely or send its output to null?

thanks

1 Like
2

You can remove it completely by removing this from your configuration.yaml:

recorder:

If you don’t see that in your configuration.yaml file you are using default config. This has to be removed and ALL the integrations you do want to use need to be added to your configuration.yaml file individually.

Or you could just run with a good quality SD card. I ran with one for years without issue and the quantity of database writes have been significantly improved since then. Use one of these automatic backup services to automatically backup off the card and you are protected: https://www.home-assistant.io/common-tasks/os#copying-your-backups-to-another-location

1 Like