Mariadb recorder purge foreign key errors

Agreed sounds like the problem is gone.

Though I did run into a few issues during the upgrade since I was previously running version 0.117 on a venv

Had an issue with: hass-nabucasa, see: Upgrade to 0.118 error

Fixed it by reverting to my backup and by first running:

pip install --upgrade hass-nabucasa

Second issue was the following:

Failed config
  homeassistant.packages.media_player.roku:
    - Package media_player setup failed. Component roku cannot be merged. Expected a dict.
    - automation: [source /home/homeassistant/.homeassistant/packages/media_player.yaml:134]
        - action: [source /home/homeassistant/.homeassistant/packages/media_player.yaml:140]

Changed the configuration:

roku:
  - host: 192.168.4.135
for
roku:
  host: 192.168.4.135

Got the following message:

WARNING:homeassistant.components.roku:The 'roku' option is deprecated, please remove it from your configuration

Ok, I get it … I guess it is time to remove that configuration. So overall all is good.

How this this purge thing works? I just updated from 0.117 to 2020.12.1 and to OS5.8. When does HA checks purge_keep_days:?

recorder:
  db_url: !secret MySQL_login
  purge_keep_days: 25
  exclude:
    domains:
     - group
     - automation
     - camera
     - media_player
     - scene
     - script
    entities:
     - sun.sun
     - sensor.date_time

Everyday at 04:12AM.