Hey guys, i have been trying to set up hassio with a hosted mysql db on a hostgator hosting plan that i own.
I have managed to do it with this configuration:
recorder:
db_url: mysql://dbusername:[email protected]:port/dbname?charset=utf8
purge_interval: 0
but, although it connects and creates the tables, after a while i am getting a spam of similar messages to the following one:
2018-08-10 10:56:09 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (_mysql_exceptions.OperationalError) (2013, 'Lost connection to MySQL server during query') [SQL: 'INSERT INTO events ...] (Background on this error at: http://sqlalche.me/e/e3q8)
2018-08-10 10:56:09 ERROR (Recorder) [homeassistant.components.recorder] Error in database connectivity: (_mysql_exceptions.OperationalError) (2013, 'Lost connection to MySQL server during query') [SQL: 'INSERT INTO events ...] (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
Any ideas as to where i should look? im clueless
edit: i have contacted my hosting provider, asking them to increase wait_timeout
and max_allowed_packet
but they refused ^^