core: SQL / MariaDB error on table

Home Assistant release with the issue: 0.86.4 (latest at the moment of issue) Last working Home Assistant release (if known): n/k Operating environment (Hass.io/Docker/Windows/etc.): Debian / venv / Python 3.6.8 Component/platform: mariadb / recorder

Description of problem: Error shows up unexpected (no issue with work of HA or no action done by users)

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

Traceback (if applicable):

Error executing query SELECT table_schema "homeassistant", Round(Sum(data_length + index_length) / 1024 / 1024, 0) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: (MySQLdb._exceptions.OperationalError) (2006, 'MySQL server has gone away') [SQL: 'SELECT table_schema "homeassistant", Round(Sum(data_length + index_length) / 1024 / 1024, 0) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;'] (Background on this error at: http://sqlalche.me/e/e3q8)

Additional information: Have it on a fresh system-install (was doing reinstallation) with latest Python 3.6.

About this issue

  • Original URL
  • State: closed
  • Created 5 years ago
  • Comments: 21 (21 by maintainers)

Most upvoted comments

Well I’m on 0.90 and lately didn’t see any database errors. Could have been solved with other issues which may caused unstable HA.

I’ll put new issue if situation will happen again.