Recorder on my Home Assistant system has been down (no history available) ever since my first upgrade to 2024.9.x (first 2024.9.0, now on 2024.9.2). It seems to be in a schema update loop. I see the following sequence of errors repeating every day or two:
The specific detailed error in “Error executing query” is:
sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1206, 'The total number of locks exceeds the lock table size')
[SQL: ALTER TABLE states MODIFY state_id BIGINT NOT NULL AUTO_INCREMENT]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
Also for the modify column error:
sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1206, 'The total number of locks exceeds the lock table size')
[SQL: ALTER TABLE states MODIFY state_id BIGINT NOT NULL AUTO_INCREMENT]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
It probably doesn’t help that my recorder database is around 50 GB 
.
Any advice? I REALLY like my recorder stats and would be crushed if I lost them all.
