I am noticing a lot of lost connection errors in log connecting to an external mysql server. Is it because of my host provider (Bluehost)?
Error:
Database connection invalidated: (MySQLdb._exceptions.OperationalError) (2013, ‘Lost connection to MySQL server during query’) [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id, context_parent_id) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)] [parameters: (‘call_service’, ‘{“domain”: “persistent_notification”, “service”: “dismiss”, “service_data”: {“notification_id”: “config_entry_discovery”}}’, ‘LOCAL’, datetime.datetime(2020, 10, 28, 23, 16, 57, 310524, tzinfo=datetime.timezone.utc), datetime.datetime(2020, 10, 28, 23, 16, 57, 310524, tzinfo=datetime.timezone.utc), ‘38936e51d212513bb2d1d9084f21d000’, None, None)] (Background on this error at: Error Messages — SQLAlchemy 1.3 Documentation). (retrying in 3 seconds)
config file:
recorder:
db_url: !secret MySQL_login
purge_keep_days: 20
exclude:
domains:
- group
- automation
- camera
- media_player
- scene
- script
entities:
- sun.sun
- sensor.date_time
secret file:
MySQL_login: 'mysql://jtoybgmhlmyz_hass:IajUUUUJ4}~ZBBBBJ&@666.666.666.666:3333/jtoybgmhlmyz_hass?charset=utf8'