-
-
Notifications
You must be signed in to change notification settings - Fork 32.7k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Recorder still locking up even after update to 2024.8.0 #123348
Comments
Same for me |
same for me. |
A restart temporarily fixes it for me until the next day still in 2024.8. So I stay on 2024.8 but disabled auto pruge again until fixed. |
Hey there @home-assistant/core, mind taking a look at this issue as it has been labeled with an integration ( Code owner commandsCode owners of
(message by CodeOwnersMention) recorder documentation |
The safest way is to do a backup, than extract all the You can share to my dropbox as [email protected] or gdrive as [email protected] |
Will get this ready and reply soon. Is there any compromise to my account(s) / security by handing this over? |
Unless you are storing passwords in the state machine (HA goes out of the way to prevent this in code reviews), the most worrisome thing in the database is likely GPS coordinates (likely the same as every app on your phone with location permissions) |
The file has been uploaded and shared. |
I'll take a look after lunch. I'm working on getting a new aiohttp release done right now. |
It looks like it attempted to rebuild the table in database 4x and failed every time. The foreign key Before I start trying to figure out why the table rebuild failed, can you confirm how much free disk space you have? |
|
Its likely unable to rebuild the table because its running out of disk space. To do a table rebuild, it has to create a temporary copy, and than replace the original table. |
I'll load it up after lunch and make sure it does try to rebuild it again. You should have an error every time you startup in the log that it fails to migrate. I take it you don't so there might be something else wrong as well. |
@bdraco sent an email with my db too which is affected by the issue. thanks |
My core-log gives the following error:
|
Might be a different problem. Its not really possible to know without examining the database. |
@bdraco my database is very large now, more than 46GB (configured for 10 days), it does not lock the recorder, but apparently it does not pack. I still trying to understand. I don´t know if my database fits in this case about failed migrations. I have found that states_attributes is very large, with lot of data that are not used, maybe this big size I and others are having is related to this table contents. I found tha recorder have a way to remove attributes,
but apparently its only available for integrations, not for user configuration. Making this configurable is on the roadmap ? |
Same problem. From 2024.7.2 on i have no reporter anymore. So i set the Value "recorder: |
If you have the issue, please share your database using the instructions above #123348 (comment) If you don't want to share your database, please don't post me too comments as they notify everyone on this issue. Instead give the issue a 👍 in the opening text above. |
See the email. Curious what it could be. |
Good news. Its also the same issue
#123388 is ready for review now so hopefully we can get it sorted in 2024.8.1 be sure to check https://www.home-assistant.io/integrations/recorder/#disk-space-requirements before updating |
How can we tell when this will be pushed to the next update? |
You can watch the milestone https://github.com/home-assistant/core/milestone/685 The date may change but its currently scheduled for today |
Please be sure your system meets the disk space requirements before updating to 2024.8.1 https://www.home-assistant.io/integrations/recorder/#disk-space-requirements As there are multiple issue threads going, and your comments will likely be missed otherwise, please continue at https://community.home-assistant.io/t/psa-2024-7-recorder-problems/746428 |
The problem
My recorder has been locking up ever since the updates in 2024.7. I am now on 2024.8.0, and the issue still persists. Every night at 4:11 AM, it will lock up. Entities no longer get any history saved, and the

home-assistant_v2.db
file no longer updates. If I turn off purging, or setpurge_keep_days
to something really far out, the issue is avoided temporarily. It is 4:39 AM as I type this, and my DB file has not updated since 4:11 AM:Nothing in this post fixed my issue: https://community.home-assistant.io/t/psa-2024-7-recorder-problems/746428/155
I did not have any of the mentioned integrations installed like others had.
I am adding 20 minutes worth of logs from
home-assistant.log
at [4:00 AM to 4:20 AM].What version of Home Assistant Core has the issue?
2024.8.0
What was the last working version of Home Assistant Core?
2024.6
What type of installation are you running?
Home Assistant OS
Integration causing the issue
No response
Link to integration documentation on our website
No response
Diagnostics information
No response
Example YAML snippet
No response
Anything in the logs that might be useful for us?
Additional information
I am willing to provide my DB (privately) to someone who can look into / fix the issue, but it is rather large.
The text was updated successfully, but these errors were encountered: