I just updated graded to
Home Assistant core: 2024.8.0 from 2024.6.4
I just updated and discovered that my database is upgrading and none of my sensors are recording anything new,
I have looked in the logs to see if I can find any reference to see what is happening and I can’t see any Realtime logs.
is there anyway I can see the logs in Realtime ?
WallyR
August 9, 2024, 11:50pm
2
It is listed as a breaking change.
Beautiful new badges for your dashboards, control Home Assistant with a local AI using Ollama, update your Matter device, manage KNX via the UI, goodbye services, hello actions! And much more!
This can cause the database upgrade to take longer than usual, depending on the size of your database.
Please be patient and let the upgrade process finish. Do not interrupt the upgrade process, as this can lead to a corrupted database.
Yeah, but it can take days and longer - on big databases (it has a reason that some migrated to mariab) it won’t even finish and crashes because of low standard values for e.g. innodb buffer sizes…
Here’s a github issue for that with some possible solutions:
opened 09:42AM - 05 Aug 24 UTC
integration: recorder
database: mariadb
### The problem
After the upgrade to 2024.8.0 beta 1 HA core is upgrading dat… abase schema on my MariaDB instance from v43 to v44.
It runs 11 hours already and just 28% is done for BIGINT column change.
<img width="1551" alt="obraz" src="https://github.com/user-attachments/assets/9e026bd0-bee3-4007-a3cb-e1d07f6af5d1">
Seems this is the change ongoing:
https://github.com/home-assistant/core/pull/121025
Is there any way to speed up the process?
My database sits on QNAP NAS RAID 10 disks which are not slow, but it would take another 2 days to finish the process.
Also, my "states" table is 215 M of rows.
<img width="387" alt="obraz" src="https://github.com/user-attachments/assets/45a6848b-070a-4881-8899-c00a00487941">
### What version of Home Assistant Core has the issue?
core-2024.8.0b1
### What was the last working version of Home Assistant Core?
core-2024.7.4
### What type of installation are you running?
Home Assistant OS
### Integration causing the issue
database / recorder
### 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?
```txt
2024-08-05 10:00:45.897 INFO (Recorder) [homeassistant.components.recorder.migration] Upgrading recorder db schema to version 44
2024-08-05 10:00:46.015 WARNING (Recorder) [homeassistant.components.recorder.migration] Modifying columns data_id, event_type_id in table events. Note: this can take several minutes on large databases and slow machines. Please be patient!
2024-08-05 10:00:46.526 WARNING (Recorder) [homeassistant.components.recorder.migration] Modifying columns event_id, old_state_id, attributes_id, metadata_id in table states. Note: this can take several minutes on large databases and slow machines. Please be patient!
```
### Additional information
_No response_