addons: MariaDB does not recover from HASS.io backup

@Spirituss commented on Aug 22, 2019, 8:19 PM UTC:

Home Assistant release with the issue:

Home Assistant 0.97.2

Last working Home Assistant release (if known): Unknown (but it definitely worked earlier).

Operating environment (Hass.io/Docker/Windows/etc.):

Hass.io/Docker/Raspbian Buster

Component/platform:

MariaDB add-on used as record/history component.

Description of problem: After recovery from Hass.io snapshot MariaDB doesn’t work any more. The only way to force it to work is to uninstall the add-on and install it again with the same settings. Of course, in this case you lose your DB and history.

Problem-relevant configuration.yaml entries and (fill out even if it seems unimportant):

recorder: 
  db_url: mysql://hass:password@192.168.xxx.xxx/homeassistant?charset=utf8
  purge_interval: 7
  purge_keep_days: 7

Traceback (if applicable):

Additional information: It works fine on one of earlier version of hass.io.

This issue was moved by frenck from home-assistant/home-assistant#26152.

About this issue

  • Original URL
  • State: closed
  • Created 5 years ago
  • Reactions: 1
  • Comments: 25 (7 by maintainers)

Most upvoted comments

Thank you. I have seen that my database wasn’t limited. It was very big. Looked like that this was the root cause. It’s working now.