mySQL problem after upgrade to HASS 0.85.1

1

Hi there,

could someone help me fixing this error?

2019-01-16 21:21:57 WARNING (Recorder) [homeassistant.components.recorder.migration] Database is about to upgrade. Schema version: 6
2019-01-16 21:21:57 INFO (Recorder) [homeassistant.components.recorder.migration] Upgrading recorder db schema to version 7
2019-01-16 21:21:57 INFO (Recorder) [homeassistant.components.recorder.migration] Adding index ix_states_entity_id to database. Note: this can take several minutes on large databases and slow computers. Please be patient!
2019-01-16 21:21:57 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (_mysql_exceptions.OperationalError) (1071, ‘Specified key was too long; max key length is 767 bytes’) [SQL: ‘CREATE INDEX ix_states_entity_id ON states (entity_id)’] (Background on this error at: Error Messages — SQLAlchemy 2.0 Documentation)
2019-01-16 21:21:57 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (_mysql_exceptions.OperationalError) (1071, ‘Specified key was too long; max key length is 767 bytes’) [SQL: ‘CREATE INDEX ix_states_entity_id ON states (entity_id)’] (Background on this error at: Error Messages — SQLAlchemy 2.0 Documentation) (retrying in 3 seconds)

With 0.82 I had no problems.

2

I would just drop the database and start fresh instead of fixing it. It’s easier than restoring an old version and troubleshooting.