After migration to mariadb external database
I have this error
2023-02-07 00:07:27.104 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (pymysql.err.IntegrityError) (1451, ‘Cannot delete or update a parent row: a foreign key constraint fails (homeassistant
.statistics
, CONSTRAINT statistics_ibfk_1
FOREIGN KEY (metadata_id
) REFERENCES statistics_meta
(id
) ON DELETE CASCADE)’)
[SQL: DELETE FROM statistics_meta WHERE statistics_meta.statistic_id IN (%(statistic_id_1_1)s)]
[parameters: {‘statistic_id_1_1’: ‘recorder.db_test’}]
(Background on this error at: Error Messages — SQLAlchemy 1.4 Documentation)
2023-02-07 00:07:27.178 ERROR (Recorder) [homeassistant.components.recorder.statistics] Error when validating DB schema: (pymysql.err.IntegrityError) (1451, ‘Cannot delete or update a parent row: a foreign key constraint fails (homeassistant
.statistics
, CONSTRAINT statistics_ibfk_1
FOREIGN KEY (metadata_id
) REFERENCES statistics_meta
(id
) ON DELETE CASCADE)’)
[SQL: DELETE FROM statistics_meta WHERE statistics_meta.statistic_id IN (%(statistic_id_1_1)s)]
[parameters: {‘statistic_id_1_1’: ‘recorder.db_test’}]
What is 'recorder.db_test?